Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8455

Make explicit_defaults_for_timestamp dynamic

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Temporal Types
    • Labels:
      None

      Description

      MDEV-3929 will merge a patch from MySQL that added a read-only variable explicit_defaults_for_timestamp.

      This task will make explicit_defaults_for_timestamp dynamic and replication safe.

      Monty suggested the following regarding replication of explicit_defaults_for_timestamp:

      ok, the easy way to do this would be:
      Change SELECT_DISTINCT from 1 to (1ULL << 39)
      Add - OPTION_explicit_defaults_for_timestamp as 1
      Add OPTION_explicit_defaults_for_timestamp to OPTIONS_WRITTEN_TO_BIN_LOG
      In Query_log_event::do_apply_event set explicit_defaults_for_timestamp if OPTION_explicit_defaults_for_timestamp is set
      That should help ensure:

      • If you replicate from mariadb to mariadb, the slave will follow the master
      • If you replicate from MySQL to MariaDB, you have to have the same setting for MySQL and MariaDB
        Not much we can do for the second case, but the first case is the important one

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              bar Alexander Barkov
              Reporter:
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: