diff options
Diffstat (limited to 'mysql-test/suite/heap/heap.result')
-rw-r--r-- | mysql-test/suite/heap/heap.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/suite/heap/heap.result b/mysql-test/suite/heap/heap.result index d2c9977e4bd..4b88eed4bfc 100644 --- a/mysql-test/suite/heap/heap.result +++ b/mysql-test/suite/heap/heap.result @@ -852,6 +852,14 @@ select data_length,index_length from information_schema.tables where table_schem data_length index_length 81024 121024 drop table t1; +CREATE TABLE t1 (id INT); +INSERT INTO t1 VALUES (1); +INSERT INTO t1 VALUES (2); +SET @@max_heap_table_size = 1024*1024*1024*20; +CREATE TEMPORARY TABLE tmp ENGINE=MEMORY +SELECT id FROM t1; +DROP TEMPORARY TABLE tmp; +drop table t1; CREATE TABLE t1 ( id int(11) NOT NULL AUTO_INCREMENT, color enum('GREEN', 'WHITE') DEFAULT NULL, |