analyse.test 574 Bytes
Newer Older
1 2 3 4
#
# Test of procedure analyse
#

5
--disable_warnings
unknown's avatar
unknown committed
6
drop table if exists t1,t2;
7
--enable_warnings
8 9
create table t1 (i int, j int, empty_string char(10), bool char(1), d date);
insert into t1 values (1,2,"","Y","2002-03-03"), (3,4,"","N","2002-03-04"), (5,6,"","Y","2002-03-04"), (7,8,"","N","2002-03-05");
unknown's avatar
unknown committed
10
select count(*) from t1 procedure analyse();
11
select * from t1 procedure analyse();
12
select * from t1 procedure analyse(2);
13 14 15
create table t2 select * from t1 procedure analyse();
select * from t2;
drop table t1,t2;
unknown's avatar
unknown committed
16

17
EXPLAIN SELECT 1 FROM (SELECT 1) a PROCEDURE ANALYSE();