martinjw/dbschemareader

DatabaseIndex columns are not in the correct order

Closed this issue · 0 comments

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).