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

New connections to Clickhouse always use the default schema #1419

Closed
renecannao opened this issue Mar 17, 2018 · 1 comment
Closed

New connections to Clickhouse always use the default schema #1419

renecannao opened this issue Mar 17, 2018 · 1 comment
Assignees

Comments

@renecannao
Copy link
Contributor

New connections to Clickhouse always use the default schema.
USE schema command is processed successfully to change schema, but if the schemaname is specific only during connection phase it is ignored.

Example:

mysql -u clicku -pclickp -h 127.0.0.1 --database=mydb -P6090
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 452
Server version: 5.5.30 (ProxySQL ClickHouse Module)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from mytable limit 1;
ERROR 1148 (42000): DB::Exception: Table default.mytable doesn't exist.
@renecannao
Copy link
Contributor Author

Applied to both 1.4.8 and 2.0-lab

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant