Support for NOT ILIKE

[klauck]

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]

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

[klauck]

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.