MATCHES function does not parse string variable

[mpomet]

OrientDB Version: 2.2.35

OS: linux alpine

Expected behavior

MATCHES work with all string

Actual behavior

MATCHES do not accept variable and throws Error parsing query

Steps to reproduce

SELECT title, '(.*)text(.*)' as myregex 
FROM Item 
WHERE "test text test" MATCHES myregex

MATCHES statement should evaluate parameters and compute them if they are strings.

[luigidellaquila]

Hi @mpomet

Thank you for reporting, I added support for any expression on the right, but I could do it only on v 3.0.x and following. Unfortunately I cannot backport the fix to v 2.2, as it still has the legacy SQL executor

Thanks

Luigi