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

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

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.1, 10.0, 5.5
        • Fix Version/s: 10.1.8
        • Component/s: OTHER
        • Labels:
        • Sprint:
          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.

            Gliffy Diagrams

              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.
                • In Review
                relates to

                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

                  There are no comments yet on this issue.

                    People

                    • Assignee:
                      bar Alexander Barkov
                      Reporter:
                      bar Alexander Barkov
                    • Votes:
                      1 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved:

                        Agile