Create a structure test to detect and prevent duplicate indexes
Open, LowestPublic
Actions

Assigned To

None

Authored By

	scfc
	Mar 1 2017, 5:35 PM

Description

In the past I sometimes encountered indexes that are functionally duplicate in PostgreSQL; I'm not sure about the current status. https://github.com/pgexperts/pgx_scripts/tree/master/indexes has tests that could find those (OS licence).

Related Objects

Mentioned Here: T191231: RFC: Abstract schemas and schema changes

Event Timeline

scfc created this task.Mar 1 2017, 5:35 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 1 2017, 5:35 PM

scfc triaged this task as Lowest priority.Mar 1 2017, 5:37 PM

Krinkle moved this task from Untriaged to Schema changes on the MediaWiki-libs-Rdbms board.May 8 2017, 1:04 AM

Krinkle renamed this task from Create a test for duplicate indexes to Create a structure test to detect and prevent duplicate indexes.Jul 18 2019, 2:51 PM

Krinkle edited projects, added MediaWiki-Core-Tests; removed MediaWiki-libs-Rdbms.

Krinkle moved this task from Inbox to PHPUnit on the MediaWiki-Core-Tests board.

With the abstract schema (T191231) this could be done in DatabaseIntegrationTest with the data from the json and is no longer related to a postgres db to do the check.

Umherirrender unsubscribed.Aug 31 2022, 8:01 PM

Create a structure test to detect and prevent duplicate indexesOpen, LowestPublicActions

Description

Related Objects

Event Timeline

Create a structure test to detect and prevent duplicate indexes
Open, LowestPublic
Actions