SHOW CREATE TABLE doesn't show default values
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Drizzle |
Fix Released
|
Medium
|
Toru Maesaka |
Bug Description
drizzle> CREATE TABLE t1 (col1 INT NOT NULL default 99, col2 CHAR(6) NOT NULL);
Query OK, 0 rows affected (0.02 sec)
drizzle> SHOW CREATE TABLE t1;
+------
| Table | Create Table |
+------
| t1 | CREATE TABLE `t1` (
`col1` int NOT NULL,
`col2` varchar(6) NOT NULL
) ENGINE=InnoDB |
+------
1 row in set (0.00 sec)
See also strict test (result will need to be changed when this is fixed)
Related branches
- Drizzle Developers: Pending requested
Changed in drizzle: | |
milestone: | none → cirrus |
status: | Fix Committed → Fix Released |
Confirmed, on both MyISAM and InnoDB:
drizzle> CREATE TABLE t10 (col1 INT NOT NULL default 99, col2 CHAR(6) NOT NULL);
Query OK, 0 rows affected (0.02 sec)
drizzle> SHOW CREATE TABLE t10\g -+----- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -+ -+----- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -+ -+----- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -+
+------
| Table | Create Table |
+------
| t10 | CREATE TABLE `t10` (
`col1` int NOT NULL,
`col2` varchar(6) NOT NULL
) ENGINE=InnoDB |
+------
1 row in set (0.00 sec)
drizzle> CREATE TABLE t11 (col1 INT NOT NULL default 99, col2 CHAR(6) NOT NULL)engine=MyISAM;
Query OK, 0 rows affected (0.05 sec)
drizzle> SHOW CREATE TABLE t11\g -+----- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -+ -+----- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -+ -+----- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- -+
+------
| Table | Create Table |
+------
| t11 | CREATE TABLE `t11` (
`col1` int NOT NULL,
`col2` varchar(6) NOT NULL
) ENGINE=MyISAM |
+------
1 row in set (0.00 sec)