go/go-clickhouse - go-clickhouse - Gitea: Git with a cup of tea

go/go-clickhouse

mirror of https://github.com/uptrace/go-clickhouse.git synced 2025-12-21 23:57:27 +02:00

Files

2 lines

127 B

Plaintext

Raw Permalink Normal View History

fix: move FINAL modifier to the right place (#52) The documentation (http://devdoc.net/database/ClickhouseDocs_19.4.1.3-docs/query_language/select/) says FINAL has to be placed right after the table name, before SAMPLE: SELECT [DISTINCT] expr_list [FROM [db.]table | (subquery) | table_function] [FINAL] [SAMPLE sample_coeff] At the moment it's appended to the end of the query which results in invalid queries being generated when there are WHERE, ORDER BY or any other clauses used.

2022-11-23 14:03:58 +03:00

SELECT "model"."id", "model"."string", "model"."bytes" FROM "models" AS "model" FINAL WHERE (id = 1) GROUP BY "id" ORDER BY id