By: Tom Sydney Kerckhove <syd@cs-syd.eu>
Compare indices, not just columns, in the schema-equality check The schema-equality check in sqitch-persistent compared information_schema.columns only, so two databases with identical columns but divergent indices would compare as equal. That hid drift between sqitch deploy scripts and the application's runtime setUpIndices. Add Test.Syd.Sqitch.Schema.queryIndices reading pg_indexes (which gives indexdef capturing columns, ordering, uniqueness, and any partial-index predicate), and have runSqitchPersistentChecks compare both columns and indices on each side. Regression test: toy-sqitch-index-drift, where the sqitch deploy creates an index the persistent model doesn't. Confirmed that the test fails without the fix and passes with it.