#780 (in 2.5.0) query page (parser) error

Latest_Git
fixed
1
2013-06-11
2003-03-08
Anonymous
No

SELECT 1 XOR 1;

silently fail returning 1

SELECT (1 XOR 1) AS pippo

fail with :
Colonna sconosciuta '1XOR1' in 'field list'
unknow column '1XOR1' in 'field list'

mysql> SELECT 1 XOR 1;
+---------+
| 1 XOR 1 |
+---------+
| 0 |
+---------+
1 row in set (0.00 sec)
is instead the right result, I use "mysql 4.0.5 gamma"

Francesco Riosa info@pnpitalia.it

regards

Discussion

  • Alexander M. Turek

    • labels: 447380 --> 509144
    • assigned_to: rabus --> nobody
     
  • Garvin Hicking

    Garvin Hicking - 2003-03-10
    • milestone: --> Latest_Git
    • labels: 509144 --> MySQL Parser
     
  • Marc Delisle

    Marc Delisle - 2003-03-11
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2003-03-11

    Logged In: YES
    user_id=210714

    Fixed, added XOR in the reserved words list of
    sqlparser.data.php

     
  • Marc Delisle

    Marc Delisle - 2003-03-11
    • priority: 5 --> 1
    • status: open --> open-fixed
     
  • Garvin Hicking

    Garvin Hicking - 2003-03-24
    • summary: query page (parser) error --> (in 2.5.0) query page (parser) error
     
  • Alexander M. Turek

    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks