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

CREATE ... SELECT system_versioned_table causes invalid defaults

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10
    • Fix Version/s: 10.11.1
    • Component/s: Versioned Tables
    • Labels:
      None

      Description

      Fields AS ROW START and AS ROW END appear to have a default value of 0.
      It matters when one creates a new table out of system versioned table using
      CREATE ... SELECT. But the default value avoids validation, these fields are created with zero defaults even if sql_mode=NO_ZERO_DATE. Examples are in versioning.create test which succeeds even in the traditional mode.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.