REGEX String Leakage in 7.9 Bindings

Ignition
,
1

image
image1618×835 49.3 KB

Using 7.9.21, and a oracle 12 SQL Database, it seems that using a REGEX like clause causes this error in a binding and not in the database query browser.

After some testing i find that it is the "{1,2}" part if the REGEX that is causing this issue.

As I am using 7.9.21, which is old, I ASSUME that this is fix in 8.1.

Looking over the string i need to test for, here isn't a good way to do this comparison without the {1,2}

Any ideas to make this work?

2

Pass the regex string as a parameter in a named query or scripted "Prep" query.

1 Like
3

image
image1527×514 52.4 KB

I found a workaround for anyone who likes REGEX and it seems and it wont involve name querys

4

You should prefer named queries.

3 Likes