Support for LIKE operator

Activity

Show:
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.

Reporter

Sebastian Iancu

Components

Affects versions

Configure