1--echo #
2--echo # Bug#6726: NOT BETWEEN parse failure
3--echo #
4create table t1 (a int, b int);
5insert into t1 values (1,2), (2,3), (3,4), (4,5);
6select * from t1 where a not between 1 and 2;
7select * from t1 where a not between 1 and 2 and b not between 3 and 4;
8drop table t1;
9
10--echo #
11--echo # MDEV-13673 Bad result in view
12--echo #
13explain extended select (3-2)+1, (3/2)*1, 3-(2+1), 3/(2*1);
14
15--echo #
16--echo # MDEV-11784 View is created with invalid definition which causes ERROR 1241 (21000): Operand should contain 1 column(s)
17--echo #
18create table t1 (i int, j int);
19insert t1 values (1,1),(2,2);
20create view v1 as select (2, 3) not in (select i, j from t1);
21select * from v1;
22query_vertical show create view v1;
23drop view v1;
24drop table t1;
25
26--echo #
27--echo # MDEV-23656 view: removal of parentheses results in wrong result
28--echo #
29create table t1 (a int, b decimal(10,2));
30insert into t1 values (1, 10.2);
31create view v1 as select avg(b) / (2 + a) from t1;
32query_vertical show create view v1;
33drop view v1;
34drop table t1;
35
36--echo #
37--echo # MDEV-17408 VIEW is incorrectly defined for a combination of = and BETWEEN
38--echo #
39create view v1 as select 1 like (now() between '2000-01-01' and '2012-12-12' );
40query_vertical show create view v1;
41drop view v1;
42