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

CREATE ... SELECT system_versioned_table causes invalid defaults

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.5, 10.6, 10.3(EOL), 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
    • 10.11.1
    • Versioned Tables
    • 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

              serg Sergei Golubchik
              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.