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.3(EOL), 10.4(EOL), 10.5, 10.6, 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

          blocks

          Task - A task that needs to be done. MDEV-16546 System versioning setting to allow history modification

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33433 SET row_end / row_start = DEFAULT causes OM => NS replication failure

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          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.