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 DATABASE information_schema return wrong SQL ENGINE=Memory() instead of ENGINE=Memory #34335

Closed
Slach opened this issue Feb 5, 2022 · 0 comments · Fixed by #34345
Assignees
Labels
minor Priority: minor potential bug To be reviewed by developers and confirmed/rejected.

Comments

@Slach
Copy link
Contributor

Slach commented Feb 5, 2022

Describe what's wrong
inconsistent behavior

SHOW CREATE DATABASE information_schema

returns the following SQL statement

CREATE DATABASE information_schema
ENGINE = Memory()

but when you try to run these queries

 DROP DATABASE information_schema;
 CREATE DATABASE information_schema
ENGINE = Memory()

It returns

Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Database engine Memory cannot have arguments. (BAD_ARGUMENTS)

Does it reproduce on recent release?
reproduced any version from 21.11+

@Slach Slach added the potential bug To be reviewed by developers and confirmed/rejected. label Feb 5, 2022
@alexey-milovidov alexey-milovidov added the minor Priority: minor label Feb 6, 2022
@alexey-milovidov alexey-milovidov self-assigned this Feb 6, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
minor Priority: minor potential bug To be reviewed by developers and confirmed/rejected.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants