Details
-
Task
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
-
10.1.6-2, 10.1.8-1, 10.1.8-2
Description
As the description of the main task MDEV-452 already mentions, MySQL implementation has the variable explicit_defaults_for_timestamp which modifies the behavior of auto-updated temporal columns. Since the planned release approaches and we don't have the variable yet, we either need to add it now, or decide to release without it, and add it in further versions. Either is okay as long as it's not completely forgotten.
The definition of MySQL's implementation can be found here:
http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp
What we should do in MariaDB:
- Add this new variable and have it work as MySQL when enabled.
- Have it disabled as default, to not cause incompatibilities with old applications
- Always keep the variable around (not make it deprecated) as we don't want to have it default.
- Add a MYSQL mode where, if enabled, this variable is set.
TODO: check how replication of this variable works in MySQL.
Attachments
Issue Links
- blocks
-
MDEV-8455 Make explicit_defaults_for_timestamp dynamic
-
- Open
-
- duplicates
-
MDEV-5994 MySQL WL#6292 - Make TIMESTAMP columns nullable by default
-
- Closed
-
- is blocked by
-
MDEV-7824 [Bug #68041] Zero date can be inserted in strict no-zero mode through a default value
-
- Closed
-
-
MDEV-7831 Bad warning for DATE_ADD(timestamp_column, INTERVAL 10 SECOND)
-
- Closed
-
-
MDEV-8441 Bad SHOW CREATE TABLE output for a table with a virtual column
-
- Closed
-
- is duplicated by
-
MDEV-5836 MySQL WL#6292 - Make TIMESTAMP columns nullable by default
-
- Closed
-
- relates to
-
MDEV-452 Add full support for auto-initialized/updated timestamp and datetime
-
- Closed
-
-
MDEV-28983 TIMESTAMP logic remains partly non-standard with explicit_defaults_for_timestamp
-
- Open
-
- links to
Activity
Field | Original Value | New Value |
---|---|---|
Link | This issue relates to TODO-310 [ TODO-310 ] |
Status | Open [ 1 ] | In Progress [ 3 ] |
Status | In Progress [ 3 ] | Open [ 1 ] |
Fix Version/s | 10.0.1 [ 11400 ] |
Fix Version/s | 10.1.0 [ 12200 ] |
Remote Link | This issue links to "Bug #68472 (Web Link)" [ 10401 ] |
Assignee | Timour Katchaounov [ timour ] | Alexander Barkov [ bar ] |
Workflow | defaullt [ 25611 ] | MariaDB v2 [ 42425 ] |
Fix Version/s | 10.1 [ 16100 ] | |
Fix Version/s | 10.1.0 [ 12200 ] |
Workflow | MariaDB v2 [ 42425 ] | MariaDB v3 [ 61371 ] |
Description |
As the description of the main task |
As the description of the main task The definition of MySQL's implementation can be found here: http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp What we should do in MariaDB: - Add this new variable and have it work as MySQL when enabled. - Have it disabled as default, to not cause incompatibilities with old applications - Always keep this around (not make it depricated) |
Description |
As the description of the main task The definition of MySQL's implementation can be found here: http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp What we should do in MariaDB: - Add this new variable and have it work as MySQL when enabled. - Have it disabled as default, to not cause incompatibilities with old applications - Always keep this around (not make it depricated) |
As the description of the main task The definition of MySQL's implementation can be found here: http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp What we should do in MariaDB: - Add this new variable and have it work as MySQL when enabled. - Have it disabled as default, to not cause incompatibilities with old applications - Always keep the variable around (not make it deprecated) as we don't want to have it default. - Add a MYSQL mode where, if enabled, this variable is set. |
Priority | Major [ 3 ] | Critical [ 2 ] |
Description |
As the description of the main task The definition of MySQL's implementation can be found here: http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp What we should do in MariaDB: - Add this new variable and have it work as MySQL when enabled. - Have it disabled as default, to not cause incompatibilities with old applications - Always keep the variable around (not make it deprecated) as we don't want to have it default. - Add a MYSQL mode where, if enabled, this variable is set. |
As the description of the main task The definition of MySQL's implementation can be found here: http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp What we should do in MariaDB: - Add this new variable and have it work as MySQL when enabled. - Have it disabled as default, to not cause incompatibilities with old applications - Always keep the variable around (not make it deprecated) as we don't want to have it default. - Add a MYSQL mode where, if enabled, this variable is set. Things to do: - Check how this works with statement based replication. |
Description |
As the description of the main task The definition of MySQL's implementation can be found here: http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp What we should do in MariaDB: - Add this new variable and have it work as MySQL when enabled. - Have it disabled as default, to not cause incompatibilities with old applications - Always keep the variable around (not make it deprecated) as we don't want to have it default. - Add a MYSQL mode where, if enabled, this variable is set. Things to do: - Check how this works with statement based replication. |
As the description of the main task The definition of MySQL's implementation can be found here: http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp What we should do in MariaDB: - Add this new variable and have it work as MySQL when enabled. - Have it disabled as default, to not cause incompatibilities with old applications - Always keep the variable around (not make it deprecated) as we don't want to have it default. - Add a MYSQL mode where, if enabled, this variable is set. TODO: check how replication of this variable works in MySQL. |
Parent |
|
|
Issue Type | Technical task [ 7 ] | Task [ 3 ] |
Sprint | 10.1.6-2 [ 7 ] |
Rank | Ranked lower |
Status | Open [ 1 ] | In Progress [ 3 ] |
Assignee | Alexander Barkov [ bar ] | Sergei Golubchik [ serg ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
Sprint | 10.1.6-2 [ 7 ] | 10.1.6-2, 10.0.21 [ 7, 8 ] |
Rank | Ranked higher |
Sprint | 10.1.6-2, 10.0.21 [ 7, 8 ] | 10.1.6-2 [ 7 ] |
Sprint | 10.1.6-2 [ 7 ] | 10.1.6-2, 10.1.8-1 [ 7, 13 ] |
Assignee | Sergei Golubchik [ serg ] | Alexander Barkov [ bar ] |
Status | In Review [ 10002 ] | Stalled [ 10000 ] |
Assignee | Alexander Barkov [ bar ] | Sergei Golubchik [ serg ] |
Assignee | Sergei Golubchik [ serg ] | Alexander Barkov [ bar ] |
Sprint | 10.1.6-2, 10.1.8-1 [ 7, 13 ] | 10.1.6-2, 10.1.8-1, 10.1.8-2 [ 7, 13, 14 ] |
Rank | Ranked higher |
Component/s | Temporal Types [ 11000 ] | |
Fix Version/s | 10.1.8 [ 19605 ] | |
Fix Version/s | 10.1 [ 16100 ] | |
Resolution | Fixed [ 1 ] | |
Status | Stalled [ 10000 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 61371 ] | MariaDB v4 [ 132040 ] |
Link | This issue relates to MDEV-28983 [ MDEV-28983 ] |
The feature is described here:
http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_explicit_defaults_for_timestamp
The relevant MySQL changesets are:
revno: 3690.68.37
revision-id: gopal.shankar@oracle.com-20120621025740-1mqjdhta9p5z54kq
parent: mysql-builder@oracle.com-20120620213112-ru1ze8ih8zdnmffh
committer: Gopal Shankar <gopal.shankar@oracle.com>
branch nick: mysql-trunk-wl6292-push
timestamp: Thu 2012-06-21 08:27:40 +0530
message:
WL#6292 - Make TIMESTAMP columns nullable by default.
revno: 3899
revision-id: gopal.shankar@oracle.com-20120624093818-4zuroxvphp9199xa
parent: sergey.vojtovich@oracle.com-20120624070758-rhkxh0vqnlqusdo2
committer: Gopal Shankar <gopal.shankar@oracle.com>
branch nick: mysql-trunk-wl6292-postmergefixes
timestamp: Sun 2012-06-24 15:08:18 +0530
message:
WL#6292 - Make TIMESTAMP columns nullable by default.
revno: 4111
revision-id: gopal.shankar@oracle.com-20120803135652-2lulve24dup1to60
parent: guilhem.bichot@oracle.com-20120803124053-psgnzlwyu3o77sw4
committer: Gopal Shankar <gopal.shankar@oracle.com>
branch nick: timestamp_makevisible_5.6
timestamp: Fri 2012-08-03 19:26:52 +0530
message:
Bug#14409088 - MAKE --EXPLICIT_DEFAULTS_FOR_TIMESTAMP SETTING
VISIBLE TO USERS