WL#3627: Add new field flags and ensure they work
Affects: Server-6.0
—
Status: Complete
Part of work for On-line Add Column for MySQL Cluster (WL 3348 + WL 1190)
Introduce possibility to set:
COLUMN_FORMAT {FIXED|DYNAMIC|DEFAULT}
(default DYNAMIC)
STORAGE {DISK|MEMORY}
(Default dependent on table storage type; MEMORY is default for NDB Cluster.)
It will be possible to set the above per field
example:
create table t1 (a int column_format DYNAMIC,
a1 int column_format FIXED,
b int NOT NULL column_format DYNAMIC,
b1 int NOT NULL column_format FIXED storage DISK,
c VARCHAR(100) column_format FIXED,
c1 VARCHAR(100) column_format DYNAMIC storage memory,
d VARCHAR(100) NOT NULL column_format FIXED,
d1 VARCHAR(100) NOT NULL column_format DYNAMIC,
e CHAR(100) column_format FIXED,
e1 CHAR(100) column_format DYNAMIC,
f CHAR(100) NOT NULL column_format FIXED,
f1 char(100) NOT NULL column_format DYNAMIC storage DISK,
index (b)) TABLESPACE ts1 engine NDB;
These specifiers can also be used with ALTER TABLE ... MODIFY COLUMN ...
Copyright (c) 2000, 2025, Oracle Corporation and/or its affiliates. All rights reserved.