Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Why does Citus error with certain boolean constraints?

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?

like image 942
digi604 Avatar asked Mar 22 '26 06:03

digi604


1 Answers

instead of:

"t1"."dirty" = TRUE 

use:

"t1"."dirty" IS TRUE
like image 184
digi604 Avatar answered Mar 24 '26 20:03

digi604



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!