| 1 |
--echo # |
| 2 |
--echo # MDEV-19162: anonymous derived tables part |
| 3 |
--echo # |
| 4 |
|
| 5 |
set @save_sql_mode=@@sql_mode; |
| 6 |
set session sql_mode=ORACLE; |
| 7 |
|
| 8 |
--disable_ps_protocol |
| 9 |
--enable_metadata |
| 10 |
SELECT * FROM (SELECT 1 FROM DUAL), (SELECT 2 FROM DUAL); |
| 11 |
--disable_metadata |
| 12 |
--enable_ps_protocol |
| 13 |
create table t1 (a int); |
| 14 |
insert into t1 values (2),(3); |
| 15 |
create table t2 (a int); |
| 16 |
insert into t2 values (2),(3); |
| 17 |
--disable_ps_protocol |
| 18 |
--enable_metadata |
| 19 |
select t1.a from t1, (select * from t2 where t2.a<= 2); |
| 20 |
select t1.a, b from t1, (select a as b from t2 where t2.a<= 2); |
| 21 |
select t1.a, b from t1, (select max(a) as b from t2); |
| 22 |
--disable_metadata |
| 23 |
--enable_ps_protocol |
| 24 |
explain extended |
| 25 |
select t1.a, b from t1, (select max(a) as b from t2); |
| 26 |
--error ER_BAD_FIELD_ERROR |
| 27 |
select * from (select tt.* from (select * from t1) as tt) where tt.a > 0; |
| 28 |
select * from (select tt.* from (select * from t1) as tt) where a > 0; |
| 29 |
|
| 30 |
create view v1 as select t1.a, b from t1, (select max(a) as b from t2); |
| 31 |
|
| 32 |
select * from v1; |
| 33 |
|
| 34 |
|
| 35 |
DELIMITER /; |
| 36 |
create procedure p1 |
| 37 |
as |
| 38 |
begin |
| 39 |
select t1.a, b from t1, (select max(a) as b from t2); |
| 40 |
end/ |
| 41 |
DELIMITER ;/ |
| 42 |
|
| 43 |
call p1; |
| 44 |
|
| 45 |
SET sql_mode=default; |
| 46 |
|
| 47 |
select * from v1; |
| 48 |
show create view v1; |
| 49 |
|
| 50 |
call p1; |
| 51 |
show create procedure p1; |
| 52 |
|
| 53 |
drop view v1; |
| 54 |
drop procedure p1; |
| 55 |
drop table t1,t2; |
| 56 |
set session sql_mode=@save_sql_mode; |