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

New STRICT flags for sql_mode

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • OTHER
    • None

    Description

      Currently we have two flags:

      • STRICT_TRANS_TABLES
      • STRICT_ALL_TABLES

      These flags were originally added to control how to treat warnings that happen on updating table fields for transactional and non-transactional tables.

      Gradually these flags spread all around the code to change the server behavior in contexts not directly related to tables, such as:

      • SP variables, SP routine parameters, function return values
      • Built-in SQL functions (e.g. badly formed strings)
      • Too long comments
      • Too long messages in SIGNAL
      • Duplicate values in ENUM/SET
      • Automatic VARCHAR -> BLOB conversion

      During recent discussions we agreed (bar, elenst, serg) that STRICT_XXX_TABLES should not affect anything when no tables are involved.

      To address that we restore the original meaning of these flags:

      • STRICT_TRANS_TABLES applies to all cases where a statement can be cleanly aborted, restoring the data as it was before the statement started executing
      • STRICT_ALL_TABLES applies to all cases, even when it'll leave tables partially updated

      We might rename flags to better match the intended semantics.

      original proposal:

      To address this, we'll introduce a new STRICT_XXX flag that will control server behavior when no tables are involved.

      The exact flags name is a subject to discussion.

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11875 Inconsistent behavior of CREATE TABLE AS ... <string function> depending on strict mode

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28140 Unexpected error when UPDATE a NULL

          • Major - Major loss of function.
          • Confirmed
          is duplicated by

          Task - A task that needs to be done. MDEV-31810 Sec feature request: New strict SQL mode for SELECT statement

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-8300 CAST('' AS DECIMAL) is too strict on INSERT in strict mode

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11876 CONVERT produces a warning and result depends on strict mode

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11888 SELECT produces more warnings in non-strict mode than in strict mode

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28069 A misleading warning message from the DELETE statement

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28142 Unexpected UPDATE behavior under strict sql_mode

          • Major - Major loss of function.
          • Open

          Activity

            People

              serg Sergei Golubchik
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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