use of bitwise operators generate syntax error
Try: CREATE TABLE test(A INT UNSIGNED, B INT UNSIGNED);
Then: SELECT A | B FROM test;
This will generate an "Error: Unknown column 'A' in field list"
However, this works if one executes directly in the mysql CLI.
EG:
mysql> SELECT A | B FROM test;
Empty set (0.00 sec)
mysql>
This may be a mysql connector problem.
Using:
SQuirrel version: 2.6.1
Client PC: Ubuntu Linux 7.0.4 Desktop
Client connector: mysql-connector-java-5.0.3-bin.jar
Server PC: Ubuntu Linux 7.04 Server
Server mysql: 5.0.38
Logged In: YES
user_id=1287991
Originator: NO
This is a configuration issue. MySQL plugin has a configuration tab in Global Preferences which allows you to specify what character to use as the separator for stored procedures. '|' (pipe) was used as the default as there were examples available on the web of this usage. You could change it to "/" (to be like sqlplus in Oracle) or whatever other character or string you would like to use to separate stored procedures. It obviously cannot be ";" since you could have stored procedures with many ";" in them.
Rob