0%

aiochclient-SQL语句注意事项末尾不要加分号

aiochclient SQL语句注意事项,末尾不要加分号
因为这个包会在后面拼接上 FORMAT TSVWithNamesAndTypes,然后导致 clickhouse 以为要执行多条语句

1
2
aiochclient.exceptions.ChClientError: Code: 62. DB::Exception: Syntax error (Multi-statements are not allowed): failed at position 229 (end of query): ; FORMAT TSVWithNamesAndTypes. . (SYNTAX_ERROR) (version 23.6.2.18 (official build))