# # Test of different EXPLAIN's --disable_warnings drop table if exists t1; --enable_warnings create table t1 (id int not null, str char(10), unique(str)); explain select * from t1; insert into t1 values (1, null),(2, null),(3, "foo"),(4, "bar"); select * from t1 where str is null; select * from t1 where str="foo"; explain select * from t1 where str is null; explain select * from t1 where str="foo"; explain select * from t1 ignore key (str) where str="foo"; explain select * from t1 use key (str,str) where str="foo"; #The following should give errors --error 1176 explain select * from t1 use key (str,str,foo) where str="foo"; --error 1176 explain select * from t1 ignore key (str,str,foo) where str="foo"; drop table t1; explain select 1; create table t1 (a int not null); explain select count(*) from t1; insert into t1 values(1); explain select count(*) from t1; insert into t1 values(1); explain select count(*) from t1; drop table t1; # # Bug #3403 Wrong encoding in EXPLAIN SELECT output # set names koi8r; create table ��� (���0 int, ���1 int, key ���0 (���0), key ���01 (���0,���1)); insert into ��� (���0) values (1); insert into ��� (���0) values (2); explain select ���0 from ��� where ���0=1; drop table ���; set names latin1; # End of 4.1 tests # # Bug#15463: EXPLAIN SELECT..INTO hangs the client (QB, command line) # select 3 into @v1; explain select 3 into @v1; # # Bug#22331: Wrong WHERE in EXPLAIN EXTENDED when all expressions were # optimized away. # create table t1(f1 int, f2 int); insert into t1 values (1,1); create view v1 as select * from t1 where f1=1; explain extended select * from v1 where f2=1; explain extended select * from t1 where 0; explain extended select * from t1 where 1; explain extended select * from t1 having 0; explain extended select * from t1 having 1; drop table t1; # End of 5.0 tests.