Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#587 mysql bitwise operators don't work

open
Rob Manning
5
2007-12-06
2007-11-23
sgrantham
No

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

Discussion

  • Rob Manning
    Rob Manning
    2007-12-06

    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

     
  • Rob Manning
    Rob Manning
    2007-12-06

    • assigned_to: nobody --> manningr