Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL)
-
None
Description
This script:
DROP TABLE IF EXISTS t1,t2;
|
CREATE TABLE t1 (
|
vc VARCHAR(10) NOT NULL DEFAULT 'test',
|
ts timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
CREATE TABLE t2 AS SELECT * FROM t1 LIMIT 0;
|
SHOW CREATE TABLE t2;
|
returns
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| t2 | CREATE TABLE `t2` (
|
`vc` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT 'test',
|
`ts` timestamp NULL DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
Notice: DEFAULT is preserved, ON UPDATE is not.
The expected behaviour is to preserve both.
Attachments
Issue Links
- relates to
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Affects Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.0 [ 16000 ] |
| Fix Version/s | 10.0 [ 16000 ] |
| Fix Version/s | 10.0.18 [ 18702 ] | |
| Fix Version/s | 10.0 [ 16000 ] |
| Component/s | Data Definition - Alter Table [ 10114 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Component/s | Temporal Types [ 11000 ] |
| Workflow | MariaDB v2 [ 60741 ] | MariaDB v3 [ 62737 ] |
| Workflow | MariaDB v3 [ 62737 ] | MariaDB v4 [ 149113 ] |
The patch for mdev-7778 fixes this problem as well. Waiting for Serg to review 7778.