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

SHOW CREATE QUOTA treats CURRENT as a name rather than a different clause #12495

Open
MyroTk opened this issue Jul 14, 2020 · 0 comments
Open
Assignees
Labels
bug Confirmed user-visible misbehaviour in official release comp-rbac Access control related

Comments

@MyroTk
Copy link
Contributor

MyroTk commented Jul 14, 2020

Describe the bug
SHOW CREATE QUOTA CURRENT does not show show create for the current quota, but rather sees CURRENT as the name of the quota and produces an exception.

How to reproduce
ClickHouse server version 20.6.1 revision 54436.
SHOW CREATE QUOTA CURRENT
SHOW CREATE QUOTA

Expected behavior
Both SHOW CREATE QUOTA CURRENT and SHOW CREATE QUOTA should return the same result.

Error message and/or stacktrace

ClickHouse client version 20.6.1.4066 (official build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 20.6.1 revision 54436.

clicktest :) SHOW CREATE QUOTA CURRENT

SHOW CREATE QUOTA CURRENT


Received exception from server (version 20.6.1):
Code: 199. DB::Exception: Received from localhost:9000. DB::Exception: There is no quota `CURRENT` in [disk, users.xml].

0 rows in set. Elapsed: 0.008 sec.

clicktest :) SHOW CREATE QUOTA

SHOW CREATE QUOTA

┌─CREATE QUOTA─────────────────────────────────────────────────────────────────────────┐
│ CREATE QUOTA default KEYED BY user_name FOR INTERVAL 1 hour TRACKING ONLY TO default │
└──────────────────────────────────────────────────────────────────────────────────────┘

1 rows in set. Elapsed: 0.005 sec.

clicktest :)
@MyroTk MyroTk added the bug Confirmed user-visible misbehaviour in official release label Jul 14, 2020
@alexey-milovidov alexey-milovidov added the comp-rbac Access control related label Jul 15, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Confirmed user-visible misbehaviour in official release comp-rbac Access control related
Projects
None yet
Development

No branches or pull requests

3 participants