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.

Sign up for GitHub

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

Jump to bottom

Create table with CTE not working in new version 21.2.2.8 #20187

Closed
stas-sl opened this issue Feb 7, 2021 · 3 comments · Fixed by #20211
Closed

Create table with CTE not working in new version 21.2.2.8 #20187

stas-sl opened this issue Feb 7, 2021 · 3 comments · Fixed by #20211
Labels
backward compatibility bug Confirmed user-visible misbehaviour in official release comp-sql General SQL support st-accepted The issue is in our backlog, ready to take

Comments

@stas-sl
Copy link

stas-sl commented Feb 7, 2021 •
edited
Loading

Just have updated CH to a new version 21.2.2.8 and suddenly the following statement stopped working

create table t engine = Memory as
with cte as (select * from numbers(10))
select * from cte

DB::Exception: Table default.cte doesn't exist.

Could you kindly revert the old behavior - I liked it.
@stas-sl stas-sl added the bug Confirmed user-visible misbehaviour in official release label Feb 7, 2021
@alexey-milovidov
Copy link
Member

@amosbird Could you please take a look?

@alexey-milovidov alexey-milovidov added the comp-sql General SQL support label Feb 7, 2021
@amosbird amosbird mentioned this issue Feb 8, 2021
Merged
@alexey-milovidov alexey-milovidov added the st-accepted The issue is in our backlog, ready to take label Feb 8, 2021
@stas-sl
Copy link
Author

stas-sl commented Feb 10, 2021

That was fast, thanks!

@bryantsai bryantsai mentioned this issue Apr 28, 2021
Closed
@DipalPrajapati DipalPrajapati mentioned this issue Jul 29, 2021
Closed
@DipalPrajapati
Copy link

Hi , I still face the issue in 4 node cluster. Please help. It was working earlier with 20.x.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
backward compatibility bug Confirmed user-visible misbehaviour in official release comp-sql General SQL support st-accepted The issue is in our backlog, ready to take
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Fix CTE in INSERT-SELECT amosbird/ClickHouse
4 participants
@filimonov @DipalPrajapati @stas-sl @alexey-milovidov