Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Minor
-
Resolution: Not a Bug
-
Affects Version/s: 10.5.13
-
Fix Version/s: N/A
-
Component/s: Data types, Server, Storage Engine - Aria
-
Labels:None
-
Environment:Linux
Description
The Aria storage engine is supposed to accept ROW_FORMAT=FIXED on tables that don't contain BLOB or TEXT fields; however it fails back to ROW_FORMAT=PAGE when a LONG datatype is present.
CREATE TABLE a (
foo INT NOT NULL
)
ENGINE=Aria ROW_FORMAT=FIXED;
CREATE TABLE b (
foo LONG NOT NULL
)
ENGINE=Aria ROW_FORMAT=FIXED;
SHOW TABLE STATUS;
^ Note the Row_format and Create_options fields