search

stellio-hub / stellio-context-broker

Stellio is an NGSI-LD compatible context broker
https://stellio.readthedocs.io
Apache License 2.0
27 stars 10 forks source link

Simple quotes are not properly escaped when doing a regex query #1201

Closed bobeal closed 2 months ago

bobeal commented 4 months ago

It then raises an error in Stellio: 

java.lang.IllegalArgumentException: Sql cannot be parsed: unclosed quoted identifier (identifier opened at index 439) in statement: SELECT ...
bobeal commented 3 months ago

It can be reproduced with such a regex query: /ngsi-ld/v1/entities?q=includedParameters~="(?i).*température de l'eau.*"&type=Dataset