LIKE implementation

[TheTanc]

QuestDB implements regex string match with the operators ~= and !~. However, LIKE is not implemented.

Describe the solution you'd like
Implement LIKE such that
column LIKE pattern becomes ~=(column, pattern)
NOT column LIKE pattern becomes !~(column, pattern)

[mick2004]

@TheTanc : I would like to work on this , Can I ?

[TheTanc]

Thanks a lot for offering @mick2004 . Of course! Feel free to have a go and let us know if you need any help.

[mick2004]

@TheTanc My understanding is that we need to write new function class derived from FunctionFactory and using ~= from within the new class.Let me know if that approach/understanding is correct ?

[bluestreak01]

Hey Mick, I would suggest to start with a static function that would match CharSequence instance to LIKE pattern, e.g.

public static boolean match(CharSequence value, LIKE) {
...
}

I would come up with an efficient algorithm first, then benchmark and optimise it.

The very last thing is to make this static function into something QuestDB SQL can invoke. That's the easy part.

[mick2004]

@bluestreak01 @TheTanc Is there a yammer group for this project ?

[TheTanc]

No yammer group I'm afraid, but you can find us on slack