Create 'main' test directory and move 't' and 'r' there

1 files changed, 24 insertions, 0 deletions

diff --git a/mysql-test/main/empty_table.test b/mysql-test/main/empty_table.test
new file mode 100644
index 00000000000..754671868ba
--- /dev/null
+++ b/mysql-test/main/empty_table.test
@@ -0,0 +1,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