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

CAST('' AS DECIMAL) is too strict on INSERT in strict mode

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
    • 10.5
    • OTHER
    • 10.1.8-3

    Description

      This script:

      SET sql_mode='STRICT_ALL_TABLES';
      		 
      DROP TABLE IF EXISTS t1;
      		 
      CREATE TABLE t1 (a DECIMAL);
      		 
      INSERT INTO t1 VALUES(CAST('' AS DECIMAL));

      returns an error:

      ERROR 1292 (22007): Truncated incorrect DECIMAL value: ''

      This looks wrong.

      I wrote an explicit CAST, so I expect:

      • CAST to return 0 with a warning
      • INSERT to write 0 into the table normally, as I'm actually inserting the CAST result, which is 0.

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-8109 unexpected CAST result

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

          Task - A task that needs to be done. MDEV-19362 New STRICT flags for sql_mode

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-8466 CAST works differently for DECIMAL/INT vs DOUBLE for empty strings

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-8468 CAST and INSERT work differently for DECIMAL/INT vs DOUBLE for a string with trailing spaces

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            bar Alexander Barkov created issue -
            bar Alexander Barkov made changes -
            Field Original Value New Value
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.0 [ 16000 ]
            bar Alexander Barkov made changes -
            Sprint 10.1.8-3 [ 15 ]
            bar Alexander Barkov made changes -
            Rank Ranked higher
            bar Alexander Barkov made changes -
            Component/s OTHER [ 10125 ]
            Fix Version/s 10.1.8 [ 19605 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            bar Alexander Barkov made changes -
            Labels upstream
            bar Alexander Barkov added a comment -

            Hmm, the was not pushed for some reasons.
            It seems it was closed in a mistake.
            Reopening.

            bar Alexander Barkov added a comment - Hmm, the was not pushed for some reasons. It seems it was closed in a mistake. Reopening.
            bar Alexander Barkov made changes -
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.1.8 [ 19605 ]
            bar Alexander Barkov made changes -
            Affects Version/s 10.2 [ 14601 ]
            Affects Version/s 10.3 [ 22126 ]
            Affects Version/s 10.4 [ 22408 ]
            Affects Version/s 10.5 [ 23123 ]
            bar Alexander Barkov made changes -
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.1 [ 16100 ]
            bar Alexander Barkov made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 69886 ] MariaDB v4 [ 143463 ]
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              1 Vote for this issue
              Watchers:
              2 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.