[Sqlrelay-discussion] case-insensitive router/filter settings

[John K. <kl...@gm...>]

I noticed that the pattern for a route/filter is case-sensitive...
That is, if you specify:

        <query pattern="^\s*select\s+.*"/>

then only something like "select x from y" will get through; doing
"SELECT x from y" will *not*.

Since the system uses PCRE, I tried the perl approach and did:

        <query pattern="(?i)^\s*select\s+.*"/>

This seems to fix it, so that "select" and "SELECT" both work nicely.
Just curious as to whether this is the intended way to do this?  Any
unforeseen gotchas?

Thanks,
JK