summaryrefslogtreecommitdiff
path: root/mysql-test/r/heap.result
diff options
context:
space:
mode:
authorunknown <jimw@mysql.com>2005-08-05 13:19:48 -0700
committerunknown <jimw@mysql.com>2005-08-05 13:19:48 -0700
commitf82e2887bf5725a40688890ea7669be78198942d (patch)
tree434dd2a8c511c37b2a7507b2de53e24a4644ccdd /mysql-test/r/heap.result
parentd17c9b06926aaba7af4d4cae2e7914fd9db5ee9d (diff)
downloadmariadb-git-f82e2887bf5725a40688890ea7669be78198942d.tar.gz
Always report row type of 'Fixed' for MEMORY tables. (Bug #3094)
mysql-test/r/heap.result: Add new results mysql-test/t/heap.test: Add new regression test sql/ha_heap.h: Always report row type of Fixed for MEMORY tables
Diffstat (limited to 'mysql-test/r/heap.result')
-rw-r--r--mysql-test/r/heap.result7
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/heap.result b/mysql-test/r/heap.result
index b905dae3aba..4725ff6b814 100644
--- a/mysql-test/r/heap.result
+++ b/mysql-test/r/heap.result
@@ -701,3 +701,10 @@ insert into t1 values ("abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcd
insert into t1 values ("abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz");
ERROR 23000: Duplicate entry 'abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijkl' for key 1
drop table t1;
+create table t1 (c char(10)) engine=memory;
+create table t2 (c varchar(10)) engine=memory;
+show table status like 't_';
+Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
+t1 MEMORY 10 Fixed 0 11 0 720192 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL
+t2 MEMORY 10 Fixed 0 12 0 785664 0 0 NULL NULL NULL NULL latin1_swedish_ci NULL
+drop table t1, t2;