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
An UPDATE on a distributed table with an equality on the distribution column and an AND FALSE predicate that is wrapped in a CTE that is used in an outer select errors out;
Here is a repro; the query should return 0 rows, but hits an error
CREATE TABLE citus_cte_repro (dist_key bigint NOT NULL, val int);
SELECT create_distributed_table('citus_cte_repro', 'dist_key');
INSERT INTO citus_cte_repro SELECT g, g FROM generate_series(1, 20) g;
WITH u AS (
UPDATE citus_cte_repro SET val = val
WHERE dist_key = 7 AND false
RETURNING dist_key
)
SELECT count(*) FROM u;
ERROR: could not find valid entry for shard 0
This issue is present in Citus 12.1, so not a recent regression.
An UPDATE on a distributed table with an equality on the distribution column and an
AND FALSEpredicate that is wrapped in a CTE that is used in an outer select errors out;Here is a repro; the query should return 0 rows, but hits an error
This issue is present in Citus 12.1, so not a recent regression.