sql dump schemata - page.page_no_title_convert should be removed
Closed, DeclinedPublic
Actions

Assigned To

Authored By

	wpmirrordev
	Jun 23 2015, 6:01 PM

Description

Problem

SQL dump files show the field: page.page_no_title_convert.
I think that this field was never a part of core. Even if it has once been a part of core, its function has been superseded by page_props.pp_propname.
Either way, the database schema in the sql dumps differs from maintenance/tables.sql.
See https://git.wikimedia.org/history/mediawiki%2Fcore.git/HEAD/maintenance%2Ftables.sql.

Requested action

Please remove this field from future sql dumps.

Related Objects

Mentioned Here: T86342: Dropping page.page_no_title_convert on wmf databases

Event Timeline

wpmirrordev created this task.Jun 23 2015, 6:01 PM

wpmirrordev assigned this task to ArielGlenn.

wpmirrordev raised the priority of this task from to Needs Triage.

wpmirrordev updated the task description. (Show Details)

wpmirrordev added a project: Datasets-General-or-Unknown.

wpmirrordev added a subscriber: wpmirrordev.

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 23 2015, 6:01 PM

A schema change is waiting: T86342
After dropping of the column in production the column will also be removed from the dumps, because the dumps just dumps all existing columns in the order of the tables.

The dumps represented the current state of the database, so it is possible to have other size or other order of columns due to outstanding database maintenance. This is not a problem in a relation database management system.

ArielGlenn moved this task from Backlog to Done on the Datasets-General-or-Unknown board.Jul 2 2018, 12:38 PM

sql dump schemata - page.page_no_title_convert should be removedClosed, DeclinedPublicActions

Description

Related Objects

Event Timeline

sql dump schemata - page.page_no_title_convert should be removed
Closed, DeclinedPublic
Actions