ITADN

Support index column ordering with ASC/DESC

#586Closeddhleong 创建于 2025-07-27
bug
D
dhleongcommented
Reference: https://sqlite.org/lang_createindex.html and https://sqlite.org/syntax/indexed-column.html Expected: ```clojure {:create-index [:index-name [:table-name :column [:other-column :desc]]]} ``` to produce: ```sql CREATE INDEX "index-name" ON "table-name" ("column", "other-column" DESC) ``` Actual result: ```sql CREATE INDEX "index-name" ON "table-name" ("column", OTHER COLUMN("desc")) ``` I'm able to work around this for now using: ```clojure {:create-index [:index-name [:table-name :column [:raw [:entity :other-column] "DESC"]]]} ```
关闭于 2025-07-27 2 条评论