Debian Codegraph @

mysql-test/suite/compat/oracle/t/anonymous_derived.test

raw
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;