diff --git a/mysql-test/main/1st.result b/mysql-test/main/1st.result index f52a0218ced..65defd12b07 100644 --- a/mysql-test/main/1st.result +++ b/mysql-test/main/1st.result @@ -39,3 +39,10 @@ time_zone_transition time_zone_transition_type transaction_registry user +create table t1(a int); +explain extended select * from t1; +id select_type table type possible_keys key key_len ref rows filtered Extra +1 SIMPLE t1 system NULL NULL NULL NULL 0 0.00 Const row not found +Warnings: +Note 1003 select NULL AS `a` from `test`.`t1` +drop table t1; diff --git a/mysql-test/main/1st.test b/mysql-test/main/1st.test index 6b93efee944..709ec0f3c4c 100644 --- a/mysql-test/main/1st.test +++ b/mysql-test/main/1st.test @@ -3,3 +3,6 @@ # show databases; show tables in mysql; +create table t1(a int); +explain extended select * from t1; +drop table t1;