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

distributed hypertable: unexpected child node of Append or MergeAppend: 60 #3658

Closed
akuzm opened this issue Oct 6, 2021 · 0 comments · Fixed by #3918
Closed

distributed hypertable: unexpected child node of Append or MergeAppend: 60 #3658

akuzm opened this issue Oct 6, 2021 · 0 comments · Fixed by #3918

Comments

@akuzm
Copy link
Member

akuzm commented Oct 6, 2021

 timescaledb │ 2.5.0-dev │ public     │ Enables scalable inserts and complex queries for time-series data
 PostgreSQL 13.4 on x86_64-pc-linux-gnu, compiled by Ubuntu clang version 13.0.0-++20210924062554+d7b669b3a303-1~exp1~20210924163351.114, 64-bit


create table ttt(time timestamptz, series int, value float);
select create_distributed_hypertable('ttt', 'time', partitioning_column => 'series');
insert into ttt select now() + (interval '1 minute') * (random() * 10 + x), x, random() * x from generate_series(1, 1000) x;
explain select * from ttt where now() < now();
ERROR:  unexpected child node of Append or MergeAppend: 60

AsyncAppend can't handle a Result node that is generated on the remote side for a constant true/false qual.

Somewhat related to this one: #3598

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

Successfully merging a pull request may close this issue.

3 participants