diff options
Diffstat (limited to 'mysql-test/t/truncate.test')
| -rw-r--r-- | mysql-test/t/truncate.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/truncate.test b/mysql-test/t/truncate.test new file mode 100644 index 00000000000..39c13b028cc --- /dev/null +++ b/mysql-test/t/truncate.test @@ -0,0 +1,11 @@ +# +# Test of truncate +# +create table t1 (a integer, b integer,c1 CHAR(10)); +truncate t1; +select count(*) from t1; +insert into t1 values(1,2,"test"); +select count(*) from t1; +drop table t1; +# The following should fail +!$1146 select count(*) from t1; |