diff options
Diffstat (limited to 'mysql-test/r/temp_table.result')
| -rw-r--r-- | mysql-test/r/temp_table.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/temp_table.result b/mysql-test/r/temp_table.result index 82479504b10..ca5e6e1a32f 100644 --- a/mysql-test/r/temp_table.result +++ b/mysql-test/r/temp_table.result @@ -135,3 +135,14 @@ d c bar 2 foo 1 drop table t1, t2; +create temporary table t1 (a int); +insert into t1 values (4711); +select * from t1; +a +4711 +truncate t1; +insert into t1 values (42); +select * from t1; +a +42 +drop table t1; |