diff options
| author | sasha@mysql.sashanet.com <> | 2002-04-08 18:20:24 -0600 |
|---|---|---|
| committer | sasha@mysql.sashanet.com <> | 2002-04-08 18:20:24 -0600 |
| commit | d1962011073cf86956264283f6b2ef6d22fc9aaa (patch) | |
| tree | a29549e01f5f40479b43c1a0dc2f11c3c89c8f71 /mysql-test | |
| parent | 2472736698459c7bfb71763ed8b5e17b9799e06a (diff) | |
| download | mariadb-git-d1962011073cf86956264283f6b2ef6d22fc9aaa.tar.gz | |
fixed bug in truncating temp tables
fixed compilation problem on FreeBSD
added test for truncating temporary tables
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/truncate.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/truncate.test | 5 |
2 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/truncate.result b/mysql-test/r/truncate.result index 79471611638..e02797cc8e5 100644 --- a/mysql-test/r/truncate.result +++ b/mysql-test/r/truncate.result @@ -14,3 +14,9 @@ a b c1 drop table t1; select count(*) from t1; Table 'test.t1' doesn't exist +create temporary table t1 (n int); +insert into t1 values (1),(2),(3); +truncate table t1; +select * from t1; +n +drop table t1; diff --git a/mysql-test/t/truncate.test b/mysql-test/t/truncate.test index 2430682a93f..1729ddc586a 100644 --- a/mysql-test/t/truncate.test +++ b/mysql-test/t/truncate.test @@ -13,3 +13,8 @@ drop table t1; # The following should fail --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; |