search

substrait-io / substrait

A cross platform way to express data transformation, relational algebra, standardized record expression and plans.
https://substrait.io
Apache License 2.0
1.11k stars 147 forks source link

Add is not? bool comparison functions #614

Open bvolpato opened 3 months ago

bvolpato commented 3 months ago

Having the functions is true / is false / is not true / is not false would be really useful.

They are somewhat common functions: https://www.postgresql.org/docs/current/functions-comparison.html:

image

And we're having some problems using isthmus without them, because Calcite has some rules that explicitly convert CASE statements to IS TRUE (e.g., AggregateCaseToFilterRule), and we need to solve through extensions.

I plan to take a stab at this, but let me know if you have any comments / ideas.

westonpace commented 3 months ago

I agree these will be useful to have.