7 messages in com.mysql.lists.bugsBUG: in SQL between expression
FromSent OnAttachments
Ocke Janssen19 Dec 2002 03:38 
Fabian Schmidt19 Dec 2002 03:59 
Ocke Janssen19 Dec 2002 04:11 
Sinisa Milivojevic19 Dec 2002 05:55 
Ocke Janssen19 Dec 2002 05:58 
Sinisa Milivojevic19 Dec 2002 07:00 
Sinisa Milivojevic19 Dec 2002 07:07 
Subject:BUG: in SQL between expression
From:Ocke Janssen (Ocke@sun.com)
Date:12/19/2002 03:38:29 AM
List:com.mysql.lists.bugs

Hi all,

How-to-repeat :

when executing a statement like

select id from table1 where ( id not between 2 and 3)

the result is different from

select id from table1 where ( not id between 2 and 3)

But that should be the case.

I'm using MySQL version 3.23.48-Max-log under Linux

Best regards,

Ocke