Why 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 am getting the following error:

Error : ERROR:  unsupported clause type

      

This query works fine on a local table. Why does Citus throw an error when I use it on a distributed table?

+3


source to share


2 answers


instead:

"t1"."dirty" = TRUE 

      



using:

"t1"."dirty" IS TRUE

      

+4


source


Why not easy

WHERE t1.dirty

      



I mean, is that a logical right?

0


source







All Articles