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
but, when I reproduce them without these two statements: SELECT create_distributed_table('t1', 'vkey'); and SELECT create_reference_table('t2'); , I got another RESULT, which is correct:
1 row returned
vkey | vkey
5 | null
especially, the following query returns a correct result in distributed version.
select * from (t2 full outer join t1 on(t2.vkey = t1.vkey ))
where TRUE;
1 row returned
vkey | vkey
5 | null
this bug happens in citus 12.3 and 12.5. Thanks a lot if someone could check it!
The text was updated successfully, but these errors were encountered:
duerwuyi
changed the title
INCORRECT result on a distributed table full outer join a reference table
INCORRECT result from a distributed table full outer join a reference table
Oct 5, 2024
RESULT:
32 rows returned
5 | null
5 | null
5 | null
... (32 rows)
but, when I reproduce them without these two statements: SELECT create_distributed_table('t1', 'vkey'); and SELECT create_reference_table('t2'); , I got another RESULT, which is correct:
1 row returned
vkey | vkey
5 | null
especially, the following query returns a correct result in distributed version.
1 row returned
vkey | vkey
5 | null
this bug happens in citus 12.3 and 12.5. Thanks a lot if someone could check it!
The text was updated successfully, but these errors were encountered: