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

Row-based replication DATETIME(m) to DATETIME(s) does not work or incorrect

    XMLWordPrintable

    Details

      Description

      When Master sets up @@global.mysql56_temporal_format=0
      to create a table with DATETIME(m) column its row-based format image does not include the precision
      which therefore is unknown by Slave. When master and slave precisions are different (m \not= s) both lossy and non-lossy replication fail. Consequently fails DATATIME(m) to DATE because inferred conversion involves
      DATETIME(m) to DATETIME(0) at the first stage.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Elkin Andrei Elkin
              Reporter:
              Elkin Andrei Elkin
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: