mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
401ae95a60
Item_func_not_all::print() either uses Item_func::print() or directly invokes args[0]->print(). Thus the precedence should be either the one of Item_func or of args[0]. Item_allany_subselect::print() prints args[0], then a comparison op, then a subquery. That is, the precedence should be the one of a comparison.
57 lines
1.7 KiB
Text
57 lines
1.7 KiB
Text
--echo #
|
|
--echo # Bug#6726: NOT BETWEEN parse failure
|
|
--echo #
|
|
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;
|
|
|
|
--echo #
|
|
--echo # MDEV-13673 Bad result in view
|
|
--echo #
|
|
explain extended select (3-2)+1, (3/2)*1, 3-(2+1), 3/(2*1);
|
|
|
|
--echo #
|
|
--echo # MDEV-11784 View is created with invalid definition which causes ERROR 1241 (21000): Operand should contain 1 column(s)
|
|
--echo #
|
|
create table t1 (i int, j int);
|
|
insert t1 values (1,1),(2,2);
|
|
create view v1 as select (2, 3) not in (select i, j from t1);
|
|
select * from v1;
|
|
query_vertical show create view v1;
|
|
drop view v1;
|
|
drop table t1;
|
|
|
|
--echo #
|
|
--echo # MDEV-23656 view: removal of parentheses results in wrong result
|
|
--echo #
|
|
create table t1 (a int, b decimal(10,2));
|
|
insert into t1 values (1, 10.2);
|
|
create view v1 as select avg(b) / (2 + a) from t1;
|
|
query_vertical show create view v1;
|
|
drop view v1;
|
|
drop table t1;
|
|
|
|
--echo #
|
|
--echo # MDEV-17408 VIEW is incorrectly defined for a combination of = and BETWEEN
|
|
--echo #
|
|
create view v1 as select 1 like (now() between '2000-01-01' and '2012-12-12' );
|
|
query_vertical show create view v1;
|
|
drop view v1;
|
|
|
|
--echo #
|
|
--echo # MDEV-30082 View definition losing brackets changes semantics of the query and causes wrong result
|
|
--echo #
|
|
create table t1 (a varchar(1), b bool) engine=myisam;
|
|
insert into t1 values ('u',1),('s',1);
|
|
select * from t1 where t1.b in (t1.a <= all (select 'a'));
|
|
create view v as select * from t1 where t1.b in (t1.a <= all (select 'a'));
|
|
select * from v;
|
|
show create view v;
|
|
drop view v;
|
|
drop table t1;
|
|
|
|
--echo #
|
|
--echo # End of 10.3 results
|
|
--echo #
|