You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In citus12.0.0/12.1.1/12.1.3, the following SQL script returns nothing.
SELECT NEXTVAL('test_seq')
FROM tbl_local l
LEFT JOIN tbl_ref r
USING (c2);
But in citus11.3.0, it will execute normally.
It feels strange.
Thank you for reading and discussion.
SQL script for this scenario:
create table tbl_local(c1 varchar(5) not null,c2 varchar not null);
create table tbl_ref(c1 varchar(5) not null,c2 varchar not null);
select create_reference_table('tbl_ref');
insert into tbl_local values('A', 'A1'),('B', 'B1'),('C', 'C1'),('D', 'D1');
insert into tbl_ref values('A', 'A1'),('B', 'B1'),('C', 'C1'),('D', 'D1');
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
In citus12.0.0/12.1.1/12.1.3, the following SQL script returns nothing.
SELECT NEXTVAL('test_seq')
FROM tbl_local l
LEFT JOIN tbl_ref r
USING (c2);
But in citus11.3.0, it will execute normally.
It feels strange.
Thank you for reading and discussion.
SQL script for this scenario:
create table tbl_local(c1 varchar(5) not null,c2 varchar not null);
create table tbl_ref(c1 varchar(5) not null,c2 varchar not null);
select create_reference_table('tbl_ref');
insert into tbl_local values('A', 'A1'),('B', 'B1'),('C', 'C1'),('D', 'D1');
insert into tbl_ref values('A', 'A1'),('B', 'B1'),('C', 'C1'),('D', 'D1');
create sequence test_seq;
Beta Was this translation helpful? Give feedback.
All reactions