[MDEV-3065] LP:789138 - Tables are created as Fixed if KEY_BLOCK_SIZE is specified in mysql-55-eb-blobs Created: 2011-05-27  Updated: 2012-10-04  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: Philip Stoev (Inactive) Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug789138.xml    

 Description   

Specifying KEY_BLOCK_SIZE causes the heap tables to be created with Row_format = Fixed. The same CREATE TABLE but without KEY_BLOCK_SIZE results in a Dynamic table:

CREATE TABLE t2 ( f1 varchar(128) ) engine=memory row_format=dynamic KEY_BLOCK_SIZE=1024;

MySQL [test]> show table status like '%t2%'\G

                                                      • 1. row ***************************
                                                        Name: t2
                                                        Engine: MEMORY
                                                        Version: 10
                                                        Row_format: Fixed
                                                        Rows: 0
                                                        Avg_row_length: 130
                                                        Data_length: 0
                                                        Max_data_length: 1057472910
                                                        Index_length: 0
                                                        Data_free: 0
                                                        Auto_increment: NULL
                                                        Create_time: NULL
                                                        Update_time: NULL
                                                        Check_time: NULL
                                                        Collation: latin1_swedish_ci
                                                        Checksum: NULL
                                                        Create_options: row_format=DYNAMIC KEY_BLOCK_SIZE=1024
                                                        Comment:


 Comments   
Comment by Rasmus Johansson (Inactive) [ 2011-06-06 ]

Launchpad bug id: 789138

Generated at Thu Feb 08 06:46:05 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.