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