Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Remove ODBC {escape '/'} escape sequence #413

Open
Segate-ekb opened this issue Nov 9, 2022 · 0 comments
Open

Remove ODBC {escape '/'} escape sequence #413

Segate-ekb opened this issue Nov 9, 2022 · 0 comments

Comments

@Segate-ekb
Copy link

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).

@Segate-ekb Segate-ekb changed the title Remove ODBC {fn...} escape sequence Remove ODBC {escape '/'} escape sequence Nov 9, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant