The following query is now impossible to run:
select * from my_table where label = 'AA|BB'
I took a look at the MySQL server log file and here is what server received from Squirrel SQL:
071206 12:06:29 182 Query SET OPTION SQL_SELECT_LIMIT=600
182 Query select * from my_table where label = 'AA
182 Query SET OPTION SQL_SELECT_LIMIT=DEFAULT
It seems that Squirrel SQL cuts the query before sending it to the MySQL server.
* the problem doesn't occur if Squirrel SQL is started without MySQL plugin loaded (version 0.33)
* the problem occurs with versions 2.6.1 and 2.6.2 of Squirrel SQL
* the problem doesn't occur with Squirrel SQL version 2.5 with MySQL plugin 0.33 loaded
* in all cases, I use the same JDBC driver (MySQL connector 5.0.5) but I don't think
Maybe this problem is related to bug #1837288 ( mysql bitwise operators don't work)