Support for LIKE operator


Sebastian Iancu
December 30, 2020, 1:24 PM

I’ll change it

Pieter Bos
January 11, 2021, 1:03 PM

I’m a bit surprised by the choice of wildcard character. In SQL, this is usually ‘%', not ‘*’, but I guess it does not matter much. do we have a reason to use '*'?

Also do we have a reason to support both Like and matches {/regexp/}? Is like easier to optimize? case sensitivity?

Diego Bosca
January 11, 2021, 1:18 PM

I assume using % is because “select *”, but we don’t have that problem.

Like has limited expression power, surely not at the level of a regex

Pieter Bos
January 11, 2021, 1:31 PM

I spoke to the one implementing AQL, and he said just the wildcards is good to be able to optimize queries, much easier than regexps, so I guess this is good to have.

Sebastian Iancu
January 11, 2021, 8:30 PM

The first version was using %, but actually this feature was already implemented with * by a couple of AQL implementations, so we just formalize what it is being used out there. For details check discourse links to see what was discussed.


Sebastian Iancu


Affects versions