hyrise/sql-parser

Support for NOT ILIKE

klauck opened this issue · 2 comments

klauck commented

Inspecting the rail road diagram, I noticed that we support ILIKE but not NOT ILIKE.
ILIKE can be used instead of LIKE to make the operator case insensitive.
ILIKE is not in the SQL standard, but I think we should support both (ILIKe and NOT ILIKE) or none.

Note, ILIKE is not (yet) supported by Hyrise.

cdmh commented

I think NOT should be supported in front of any expression, and not specific to LIKE/ILIKE keywords, shouldn’t it?

klauck commented

Yes, NOT should and is already supported in front of any expression as unary operator.
However, ILIKE requires a value/attribute before and pattern after, and is, thus handled separately in the parser.

  • 👍1