79 lines
2.3 KiB
Plaintext
79 lines
2.3 KiB
Plaintext
--disable_query_log
|
|
set @@session.explicit_defaults_for_timestamp=off;
|
|
--enable_query_log
|
|
#owner: link.zt
|
|
#owner group: sql1
|
|
# tags: optimizer, outline
|
|
|
|
--disable_warnings
|
|
drop table if exists test;
|
|
--enable_warnings
|
|
create table test(a int,b int primary key);
|
|
insert into test values(1,1);
|
|
insert into test values(1,2);
|
|
insert into test values(1,3);
|
|
insert into test values(1,4);
|
|
select * from test;
|
|
--replace_regex /Plan signature: [0-9]*/Plan signature/
|
|
--disable_result_log
|
|
explain select * from test;
|
|
desc select * from test;
|
|
describe select * from test;
|
|
--enable_result_log
|
|
--replace_regex /Plan signature: [0-9]*/Plan signature/
|
|
--disable_result_log
|
|
explain insert into test values(1,5);
|
|
desc insert into test values(1,5);
|
|
describe insert into test values(1,5);
|
|
--enable_result_log
|
|
--replace_regex /Plan signature: [0-9]*/Plan signature/
|
|
--disable_result_log
|
|
explain insert into test values(1,4);
|
|
desc insert into test values(1,4);
|
|
describe insert into test values(1,4);
|
|
--enable_result_log
|
|
--replace_regex /Plan signature: [0-9]*/Plan signature/
|
|
--disable_result_log
|
|
explain update test set a=2 where b=2;
|
|
desc update test set a=2 where b=2;
|
|
describe update test set a=2 where b=2;
|
|
--enable_result_log
|
|
--replace_regex /Plan signature: [0-9]*/Plan signature/
|
|
--disable_result_log
|
|
explain update test set b=2 where a=1;
|
|
desc update test set b=2 where a=1;
|
|
describe update test set b=2 where a=1;
|
|
--enable_result_log
|
|
--replace_regex /Plan signature: [0-9]*/Plan signature/
|
|
--disable_result_log
|
|
explain delete from test where b=5;
|
|
desc delete from test where b=5;
|
|
describe delete from test where b=5;
|
|
--enable_result_log
|
|
--error 1064
|
|
explain create table test(a int,b int primary key);
|
|
--error 1064
|
|
desc create table test(a int,b int primary key);
|
|
--error 1064
|
|
describe create table test(a int,b int primary key);
|
|
--error 1064
|
|
explain drop table test;
|
|
--error 1064
|
|
desc drop table test;
|
|
--error 1064
|
|
describe drop table test;
|
|
--enable_result_log
|
|
|
|
--disable_warnings
|
|
drop table if exists sd;
|
|
--enable_warnings
|
|
create table sd(a int);
|
|
insert into sd values(5),(4),(4),(3),(2),(2),(2),(1);
|
|
--disable_result_log
|
|
explain select @rownum := @rownum + 1 as row, @rank := IF(@prev_score!=a, @rownum, @rank) as rank, @prev_score := a as score from sd;
|
|
--enable_result_log
|
|
|
|
## test for cast mod for explain: bug#8454097
|
|
explain outline select 1 < '2009-12-17 06:03:17';
|
|
drop table sd;
|