You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
MySQL's REGEXP binary operator is not supported #107
SQLPage needs to parse your queries in order to know which parameters to extract from the user's request to pass to the database, and to implement SQLPage functions.
To do that, it uses a very powerful and versatile SQL parser: sqlparser-rs. It's the same parser that is used in InfluxDB and Apache DataFusion, among others.
However, it may happen that some syntax that is valid in one database is not supported by the parser. When this happens, you can open an issue here with an example failing query, and we will implement it upstream in sqlparser. In this case, I opened this issue.
Activity
lovasoa commentedon Oct 20, 2023
SQLPage needs to parse your queries in order to know which parameters to extract from the user's request to pass to the database, and to implement SQLPage functions.
To do that, it uses a very powerful and versatile SQL parser: sqlparser-rs. It's the same parser that is used in InfluxDB and Apache DataFusion, among others.
However, it may happen that some syntax that is valid in one database is not supported by the parser. When this happens, you can open an issue here with an example failing query, and we will implement it upstream in sqlparser. In this case, I opened this issue.
In the meantime, you can use the traditional function syntax for matching regular expressions:
instead of
[-]MySQL + REGEXP supported ?[/-][+]MySQL's `REGEXP` binary operator is not supported[/+]accforgithubtest commentedon Oct 21, 2023
Thanks for the suggestions and also raising the issue, will give this a spin ! Thank you.
lovasoa commentedon Oct 21, 2023
My patch to sqlparser-rs was merged, we'll soon have support for the
REGEXPoperator in sqlpage 🎊update sqlparser
lovasoa commentedon Nov 1, 2023
fix released in v0.15
accforgithubtest commentedon Nov 1, 2023
thanks @lovasoa ! Just tried this with latest version and it works !
update sqlparser