--- suite/heap/heap_memory_used.result +++ suite/heap/heap_memory_used.reject @@ -17,13 +17,13 @@ insert into t1 values(1); select data_length,index_length from information_schema.tables where table_schema="test" and table_name="t1"; data_length index_length -65504 131040 +32736 65504 drop table t1; CREATE TABLE t1 (a int, index(a)) engine=heap max_rows=15000; insert into t1 values(1); select data_length,index_length from information_schema.tables where table_schema="test" and table_name="t1"; data_length index_length -16352 32736 +16352 16352 drop table t1; create table t1 (c1 int, index(c1)) engine=heap max_rows=10000; insert into t1 select rand(100000000); @@ -39,17 +39,17 @@ insert into t1 select rand(100000000) from t1 limit 488; select data_length,index_length from information_schema.tables where table_schema="test" and table_name="t1"; data_length index_length -32704 32704 +16352 16352 insert into t1 select rand(100000000) from t1 limit 1; select data_length,index_length from information_schema.tables where table_schema="test" and table_name="t1"; data_length index_length -32704 32704 +16352 16352 insert into t1 select rand(100000000) from t1 limit 1000; select data_length,index_length from information_schema.tables where table_schema="test" and table_name="t1"; data_length index_length -49056 65408 +32704 32704 insert into t1 select rand(100000000) from t1; select data_length,index_length from information_schema.tables where table_schema="test" and table_name="t1"; data_length index_length -81760 114464 +49056 65408 drop table t1;