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