Files
oceanbase/tools/deploy/mysql_test/t/empty_table.test
2023-11-15 11:44:44 +00:00

22 lines
406 B
Plaintext

--disable_query_log
set @@session.explicit_defaults_for_timestamp=off;
--enable_query_log
#owner: link.zt
#owner group: sql1
#
# Some special cases with empty tables
#
--disable_warnings
drop table if exists t1;
--enable_warnings
create table t1 (nr int ,b char(30),str char(10), primary key (nr));
select count(*) from t1;
select * from t1;
select * from t1 limit 0;
drop table t1;
# End of 4.1 tests