From 18c21eb6db1043261c520f455c27bb6bc37f0529 Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 3 Feb 2005 23:08:43 +0000 Subject: Bug#6726 - failure to parse NOT BETWEEN Fix and test for parse bug mysql-test/r/func_test.result: Bug#6726 Test for parse bug mysql-test/t/func_test.test: Bug#6726 Test for parse bug sql/sql_yacc.yy: Bug#6726 Parser was confused by NOT in lookahead --- mysql-test/r/func_test.result | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'mysql-test/r/func_test.result') diff --git a/mysql-test/r/func_test.result b/mysql-test/r/func_test.result index 2815500b33e..32883921e70 100644 --- a/mysql-test/r/func_test.result +++ b/mysql-test/r/func_test.result @@ -183,3 +183,13 @@ select 5.1 mod 3, 5.1 mod -3, -5.1 mod 3, -5.1 mod -3; select 5 mod 3, 5 mod -3, -5 mod 3, -5 mod -3; 5 mod 3 5 mod -3 -5 mod 3 -5 mod -3 2 2 -2 -2 +create table t1 (a int, b int); +insert into t1 values (1,2), (2,3), (3,4), (4,5); +select * from t1 where a not between 1 and 2; +a b +3 4 +4 5 +select * from t1 where a not between 1 and 2 and b not between 3 and 4; +a b +4 5 +drop table t1; -- cgit v1.2.1