1#
2# Some special cases with empty tables
3#
4
5--disable_warnings
6drop table if exists t1;
7--enable_warnings
8
9create table t1 (nr int(5) not null auto_increment,b blob,str char(10), primary key (nr));
10select count(*) from t1;
11select * from t1;
12select * from t1 limit 0;
13show status like "Empty_queries";
14drop table t1;
15
16#
17# Accessing a non existing table should not increase Empty_queries
18#
19
20--error 1146
21select * from t2;
22show status like "Empty_queries";
23
24# End of 4.1 tests
25