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

Engine Mysql - where condition + Like #3011

Closed
pyhbka opened this issue Aug 31, 2018 · 2 comments
Closed

Engine Mysql - where condition + Like #3011

pyhbka opened this issue Aug 31, 2018 · 2 comments
Assignees
Labels
comp-foreign-db Integrations with other databases comp-mysql st-fixed

Comments

@pyhbka
Copy link

pyhbka commented Aug 31, 2018

Clickhouse query:
SELECT some_fields FROM my_table WHERE field = 123 AND field2 = 321 AND title LIKE '%title%'

Received exception from server (version 18.6.0):
Code: 1000. DB::Exception: Received from localhost:9000, 127.0.0.1. DB::Exception: mysqlxx::BadQuery: Operand should contain 1 column(s)

Mysql query log:
SELECT some_fields FROM my_table WHERE (field = 123, field2 = 321)

@pyhbka pyhbka changed the title Engine Mysql and Like Engine Mysql - where condition + Like Aug 31, 2018
@VadimPlh
Copy link
Contributor

#3182 #3168

@filimonov filimonov added the comp-foreign-db Integrations with other databases label Jun 11, 2019
@stale stale bot added the stale label Oct 20, 2019
@ClickHouse ClickHouse deleted a comment from stale bot Aug 8, 2020
@alexey-milovidov
Copy link
Member

Fixed in recent releases.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
comp-foreign-db Integrations with other databases comp-mysql st-fixed
Projects
None yet
Development

No branches or pull requests

4 participants