diff options
Diffstat (limited to 'mysql-test/t/truncate.test')
| -rw-r--r-- | mysql-test/t/truncate.test | 26 |
1 files changed, 25 insertions, 1 deletions
diff --git a/mysql-test/t/truncate.test b/mysql-test/t/truncate.test index e995517cf1e..3acab9f56de 100644 --- a/mysql-test/t/truncate.test +++ b/mysql-test/t/truncate.test @@ -1,11 +1,35 @@ # # Test of truncate # +drop table if exists t1; create table t1 (a integer, b integer,c1 CHAR(10)); +insert into t1 (a) values (1),(2); truncate table t1; select count(*) from t1; insert into t1 values(1,2,"test"); select count(*) from t1; +delete from t1; +select * from t1; drop table t1; # The following should fail -!$1146 select count(*) from t1; +--error 1146 +select count(*) from t1; +create temporary table t1 (n int); +insert into t1 values (1),(2),(3); +truncate table t1; +select * from t1; +drop table t1; +--error 1146 +truncate non_existing_table; + +# +# test autoincrement with TRUNCATE +# + +create table t1 (a integer auto_increment primary key); +insert into t1 (a) values (NULL),(NULL); +truncate table t1; +insert into t1 (a) values (NULL),(NULL); +SELECT * from t1; +drop table t1; + |