Database Security. Database Auditing. Database Caching. Database Masking. Get it now

Fail to allow query pattern with special characters: greated than '>' and less than '>'

in

Dear sir/madam,

We are using GreenSQL latest version 1.0.0 released on Linux. We found problems that if we using GreenSQL Admin Management Console to manually allow query pattern which contains special characters: greated than '>' and less than '>'

The query pattern inserted to DB table "alert_group" is with '>' and '<'

e.g. select * from table1 where ? and id=? and time>= ? and time <= ?

But the query pattern inserted to DB table "query" is with '&gt ;' and '&lt ;' instead of '>' and '<'

e.g. select * from table1 where ? and id=? and time&gt ;= ? and time &lt ;= ?

Since the two query pattern in DB tables "alert_group" and "query" are different, this query pattern is always blocked in GreenSQL and fail to manually allow by Management Console.

Any solutions and suggestions for this problems? Please advise. Thanks!

Regards,
Yuki

Comments

Hello Yuki Thank you for

Hello Yuki

Thank you for reporting this bug. I have just committed fix to the subversion. Please check it and report if it works for you.

Thanks,
Yuli

Back to top