Bug #6726 server does not like WHERE <column> NOT BETWEEN ... any more
Submitted: 19 Nov 2004 19:06 Modified: 4 Feb 2005 0:02
Reporter: Matthias Leich Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1,5.0 OS:
Assigned to: Antony Curtis CPU Architecture:Any

[19 Nov 2004 19:06] Matthias Leich
Description:
I have a statement which worked on my daily refreshed source distribution 
until beginning of this week. Now it gets
ERROR 42000: You have an error in your SQL syntax .....

The statement contains a
WHERE <column> NOT BETWEEN <first val> AND <second val>

Please have a look into the attached file.

My environment:
   - Intel PC with Linux(SuSE 9.1)
   - MySQL compiled from source
        Version 5.0 ChangeSet@1.1667, 2004-11-18
        Version 4.1ChangeSet@1.2092.1.39, 2004-11-19 

How to repeat:
How to repeat:
Please use my attached test file ml12.test , copy it to mysql-test/t
  ./mysql-test-run ml12
[19 Nov 2004 19:09] Matthias Leich
test case

Attachment: ml12.test (application/octet-stream, text), 459 bytes.

[19 Nov 2004 22:20] MySQL Verification Team
Verified on latest BK 5.0 source tree due to view uses.
[22 Nov 2004 17:01] Antony Curtis
Cannot reproduce fault on MySQL 4.x
[21 Dec 2004 12:35] Ingo Strüwing
I take the review, though I'm still not in the list. I look at:
bk commit - 5.0 tree (antony:1.1677) BUG#6726
Date: Mon, 22 Nov 2004 17:06:05 GMT
[21 Dec 2004 14:33] Ingo Strüwing
The patch is OK to push. I agree that 4.1.9 was not affected by the bug.
[4 Feb 2005 0:02] Antony Curtis
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html