Clickhouse allow_deprecated_syntax_for_merge_tree

[mdsohelmia]

Clickhouse Version 23.5.2.7

2023/06/13 11:13:24 migrate run: failed to ensure DB version: code: 36, message: This syntax for *MergeTree engine is deprecated. Use extended storage definition syntax with ORDER BY/PRIMARY KEY clause. See also allow_deprecated_syntax_for_merge_tree setting.
exit status 1

[mfridman]

Relevant bit,

https://github.com/pressly/goose/blob/master/internal/dialect/dialectquery/clickhouse.go#L16-L17

although what does it mean for existing clickhouse instances that were created with the "old" query?

---

There's a few PR's from @iamluc @arunk-s related to clickhouse, so we should probably bump those and see if they also fix this issue:

#520
#530

[Tazoeur]

Hey, any news on this topic?

I just installed goose (v3.5.0), started a local clickhouse server (v25.1.5.31), and ran into the exact same issue with a goose clickhouse "tcp://default@127.0.0.1:9000" status

IIUC this problem is related to the goose management of its migrations table.
Is there any workaround that would not require having to manually build a patched version of goose?