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

LP:750117 - Bogus warning (data corruption?) with aggregate and datetime column in 5.1-micro

        Details

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

          Description

          Not repeatable with mysql-5.1. The following query:

          SELECT MIN( f1 ) FROM t1 WHERE f1 >= '2006-05-25 07:00:20' AND f1 BETWEEN '2003-11-23 10:00:09' AND '2010-01-01 01:01:01' AND f1 > '2001-01-01 01:01:01' ;

          returns the following warning:

          Warning 1292 Incorrect datetime value: '72025063209000000' for column 'f1' at row 1

          The warning goes away if MIN() is removed and if the >= is replaced by >

          test case:

          DROP TABLE IF EXISTS t1;
          CREATE TABLE t1 ( f1 datetime, KEY (f1) );
          INSERT INTO t1 VALUES ('2000-03-09 15:56:59'),('2000-05-05 23:24:28'),('2000-06-13 13:12:06');
          SELECT MIN( f1 ) FROM t1 WHERE f1 >= '2006-05-25 07:00:20' AND f1 BETWEEN '2003-11-23 10:00:09' AND '2010-01-01 01:01:01' AND f1 > '2001-01-01 01:01:01' ;

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 750117

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

                  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: