Why does Citus error with certain boolean constraints?

Question

If I run this query:

SELECT "t1"."id" FROM "session" AS t1 WHERE ("t1"."dirty" = TRUE) ORDER BY "t1"."id" LIMIT 1000;

I get the following error:

Error : ERROR:  unsupported clause type

This query works perfectly on a local table. Why is Citus raising an error when I use it on a distributed table?

score 4 · Answer 1 · answered Jul 23 '15 at 12:07

4

instead of:

"t1"."dirty" = TRUE

use:

"t1"."dirty" IS TRUE

answered Jul 23 '15 at 12:07

digi604

1

Yep, this is the workaround! We've merged a fix https://github.com/citusdata/citus/pull/388 which will get released with Citus 5.1 – num1 Apr 12 '16 at 07:59
Citus 5.1 is now out and includes the fix for this, but anyone on 5.0 or earlier can use this workaround (which should be accepted!) – jasonmp85 May 25 '16 at 22:01

score 0 · Answer 2 · answered Jan 19 '16 at 17:45

0

Why not just

WHERE t1.dirty

I mean, this is a boolean right?

answered Jan 19 '16 at 17:45

Andrew Wolfe

2 Answers2