From 150cf58f8f4c08f3b2ab3baa80bcd1c25a3bbcbb 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/t/func_test.test | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'mysql-test/t/func_test.test') diff --git a/mysql-test/t/func_test.test b/mysql-test/t/func_test.test index eb506a58870..732cdc12cae 100644 --- a/mysql-test/t/func_test.test +++ b/mysql-test/t/func_test.test @@ -107,3 +107,12 @@ 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; + +# +# Bug#6726: NOT BETWEEN parse failure +# +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; +select * from t1 where a not between 1 and 2 and b not between 3 and 4; +drop table t1; -- cgit v1.2.1