blob: 68b038c089f9b1c0006adb1b0278230bcda0dd58 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
#
# Test of procedure analyse
#
drop table if exists t1,t2;
create table t1 (i int, j int);
insert into t1 values (1,2), (3,4), (5,6), (7,8);
select * from t1 procedure analyse();
create table t2 select * from t1 procedure analyse();
select * from t2;
drop table t1,t2;
EXPLAIN SELECT 1 FROM (SELECT 1) a PROCEDURE ANALYSE();
|
