Maniphest T383776

Enforce rejection of "boolean" in abstract DB schema
Open, Needs TriagePublic
Actions

Assigned To

None

Authored By

	Daimona
	Jan 15 2025, 2:09 PM

Tags

Referenced Files

None

Subscribers

Description

The "boolean" type must not be used in abstract schema for postgres compatibility (T257755#6863029). This was originally enforced by the abstract schema validation. However, it got excluded in r817361 for BC/historical reasons, and never added back. It would be nice to fix this. Maybe even just printing a warning (while still succeeding) for the time being.

Related Objects

Mentioned In: T383778: The `growthexperiments_mentor_mentee.gemm_mentee_is_active` DB column usees the "boolean" type, which is not supported with postgres
T381759: Add "event_is_test_event" field to "campaign_events" table
Mentioned Here: T257755: Changing the PostgreSQL MediaWiki schema to use BYTEA where MySQL uses VARBINARY / VARCHAR BINARY would break SQL queries

Event Timeline

Daimona created this task.Jan 15 2025, 2:09 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 15 2025, 2:09 PM

Daimona mentioned this in T381759: Add "event_is_test_event" field to "campaign_events" table.Jan 15 2025, 2:35 PM

ashley awarded a token.Jan 15 2025, 3:15 PM

Daimona mentioned this in T383778: The `growthexperiments_mentor_mentee.gemm_mentee_is_active` DB column usees the "boolean" type, which is not supported with postgres.Jan 17 2025, 2:38 PM

Urbanecm_WMF awarded a token.Jan 17 2025, 3:20 PM

Urbanecm_WMF subscribed.

Krinkle moved this task from Untriaged to Wiring for MediaWiki on the MediaWiki-libs-Rdbms board.Feb 12 2025, 7:51 PM