Changes between Initial Version and Version 1 of Ticket #35311


Ignore:
Timestamp:
Mar 16, 2024, 3:39:14 AM (8 months ago)
Author:
Pierre Juhen
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #35311 – Description

    initial v1  
    1414SQLMIGRATE generates a wrong code :
    1515
    16 ''CREATE INDEX "name_gin_trgm_title_affaire" ON "affaires_affaire" USING gin ((LOWER("title")));''
     16''CREATE INDEX "name_gin_trgm_title_affaire" ON "affaires_affaire" USING gin ((LOWER("title"), name=gin_trgm_ops));''
    1717
    1818Instead of (too many parenthesis) :
    1919
    20 ''CREATE INDEX "name_gin_trgm_title_affaire" ON "affaires_affaire" USING gin (LOWER("title"));''
     20''CREATE INDEX "name_gin_trgm_title_affaire" ON "affaires_affaire" USING gin (LOWER("title"),  name=gin_trgm_ops);''
    2121
    2222There is a manual workaround, but its annoying.
Back to Top