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

LP:731264 - Bogus warning printed for certain expressions in 5.1-micro

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Trivial
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None
        • Labels:

          Description

          When inserting invalid values into a DATE column, some subsequent SELECTs may print the following warning:

          Warning 1292 Incorrect date value: '0000-00-00 00:00:00.000001' for column 'f1' at row 1

          even though no such value is present in the table.

          Test case:

          CREATE TABLE t1 (f1 DATE NOT NULL, KEY (f1));

          INSERT INTO t1 VALUES (2006),('02:55:59');

          SELECT f1 FROM t1 FORCE KEY (f1) WHERE f1 NOT IN ( '2001-05-09' , STR_TO_DATE (CURDATE(), 'bogus') );

          SHOW WARNINGS;

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                serg Sergei Golubchik added a comment -

                Re: Bogus warning printed for certain expressions in 5.1-micro
                It's a side effect of MySQL bug.
                I've reported it as http://bugs.mysql.com/bug.php?id=60400

                Show
                serg Sergei Golubchik added a comment - Re: Bogus warning printed for certain expressions in 5.1-micro It's a side effect of MySQL bug. I've reported it as http://bugs.mysql.com/bug.php?id=60400
                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 731264

                Show
                ratzpo Rasmus Johansson added a comment - Launchpad bug id: 731264

                  People

                  • Assignee:
                    serg Sergei Golubchik
                    Reporter:
                    philipstoev Philip Stoev
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: