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

PostgreSQL wire protocol: allow driver-specific queries. #12476

Open
dmitriy-myz opened this issue Jul 13, 2020 · 0 comments
Open

PostgreSQL wire protocol: allow driver-specific queries. #12476

dmitriy-myz opened this issue Jul 13, 2020 · 0 comments
Labels

Comments

@dmitriy-myz
Copy link
Contributor

Use case
We trying to use postgreSQL wire protocol. As driver we use skunk (not JDBC).
Problem is: it sends queries like:

UNLISTEN *;
RESET ALL

which of course Clickhouse don't understand.

Describe the solution you'd like
Allow some driver-specific queries?

Describe alternatives you've considered
As alternative we will try to use Recycler.minimal in driver (not tested yet)

Additional context

2020.07.13 18:29:35.717838 [ 29827 ] {} <Error> PostgreSQLHandler: DB::Exception: Syntax error: failed at position 1: UNLISTEN *. Expected one of: ALTER query, Query with output, ALTER PROFILE, SHOW PRIVILEGES query, TRUNCATE, KILL, KILL QUERY query, ALTER ROLE, SELECT subquery, DESCRIBE query, SHOW GRANTS, SHOW CREATE, WATCH, SHOW PROCESSLIST query, ALTER POLICY, ALTER USER, CREATE VIEW query, CHECK TABLE, SET ROLE, SELECT query, SELECT, CREATE USER, REVOKE, CREATE DICTIONARY, CREATE PROFILE, SET ROLE DEFAULT, ALTER SETTINGS PROFILE, SYSTEM, ALTER LIVE VIEW, SHOW ACCESS, DROP query, OPTIMIZE query, RENAME TABLE, DROP access entity query, USE, SHOW, DETACH, DESC, SET, OPTIMIZE TABLE, CREATE ROW POLICY, SET DEFAULT ROLE, CREATE POLICY, ALTER ROW POLICY, INSERT query, INSERT INTO, GRANT, RENAME query, SHOW GRANTS query, SHOW PRIVILEGES, DROP, CREATE LIVE VIEW query, SYSTEM query, EXISTS, SHOW PROCESSLIST, ALTER QUOTA, CREATE QUOTA, list of elements, CREATE DATABASE query, SET query, Query, CREATE, WITH, EXCHANGE TABLES, EXISTS or SHOW CREATE query, WATCH query, CREATE ROLE, CREATE SETTINGS PROFILE, SHOW ACCESS query, SHOW CREATE QUOTA query, USE query, ATTACH, ALTER TABLE, DESCRIBE, ShowAccessEntitiesQuery, GRANT or REVOKE query, SELECT query, possibly with UNION, SELECT query, subquery, possibly with UNION, CREATE SETTINGS PROFILE or ALTER SETTINGS PROFILE query, CREATE QUOTA or ALTER QUOTA query, CREATE ROW POLICY or ALTER ROW POLICY query, SHOW [TEMPORARY] TABLES|DATABASES|CLUSTERS|CLUSTER 'name' [[NOT] LIKE 'str'] [LIMIT expr], CREATE ROLE or ALTER ROLE query, SET ROLE or SET DEFAULT ROLE query, CREATE USER or ALTER USER query, CREATE TABLE or ATTACH TABLE query

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

No branches or pull requests

1 participant