DatabaseIndex columns are not in the correct order
Closed this issue · 0 comments
Arnagos commented
DatabaseIndex columns are not in the correct order
Index SQL (generated by DB):
CREATE INDEX IF NOT EXISTS "Punchclock__Person_FirstName_LastName_idx"
ON public."Punchclock__Person" USING btree
("FirstName" COLLATE pg_catalog."default" ASC NULLS LAST, "LastName" COLLATE pg_catalog."default" ASC NULLS LAST)
TABLESPACE pg_default;
Based on the order defined in the SQL the column order should be FirstName, LastName but the order in the DatabaseIndex loaded from the db is LastName, FirstName (Also happens in MSSQL).