You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
ODBC driver version Release 1.2.1.20220905 Context: queries are generated from 1C enterprise.
Some {escape '/'} ODBC secape sequences are let as it by ODBC driver, so ClickHouse server issues a SQL error. Sample:
Error ODBC. SQLSTATE: HY000
Descripion: HTTP status code: 400
Received error:
Code: 62. DB::Exception: Syntax error: failed at position 429 ('{') (line 27, col 37): {escape '/'}) OR (T1.Comment LIKE '%test%' {escape '/'}) OR (T1.Computer LIKE '%test%' {escape '/'}) OR (T1.Data LIKE '%test%' {escape '/'}) OR (T1.DataPresenta. Expected one of: token, DoubleColon, MOD, DIV, NOT, BETWEEN, LIKE, ILIKE, NOT LIKE, NOT ILIKE, IN, NOT IN, GLOBAL IN, GLOBAL NOT IN, IS, AND, OR, QuestionMark, alias, AS, Comma. (SYNTAX_ERROR) (version 22.9.3.18 (official bui
The {escape '/'} should at least be removed by ODBC driver (the targetted function is well known and supported by ClickHouse server).
The text was updated successfully, but these errors were encountered:
Segate-ekb
changed the title
Remove ODBC {fn...} escape sequence
Remove ODBC {escape '/'} escape sequence
Nov 9, 2022
ODBC driver version Release 1.2.1.20220905
Context: queries are generated from 1C enterprise.
Some {escape '/'} ODBC secape sequences are let as it by ODBC driver, so ClickHouse server issues a SQL error.
Sample:
The {escape '/'} should at least be removed by ODBC driver (the targetted function is well known and supported by ClickHouse server).
The text was updated successfully, but these errors were encountered: