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

DATE(zerofill_column) and DATE(COALESCE(zerofill_column)) return different results

        Details

        • Sprint:
          10.1.8-3

          Description

          DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a INT(6) ZEROFILL);
INSERT INTO t1 VALUES (1);
SELECT DATE(a), DATE(COALESCE(a)) FROM t1;

          returns

          +------------+-------------------+
| DATE(a)    | DATE(COALESCE(a)) |
+------------+-------------------+
| 2000-00-01 | NULL              |
+------------+-------------------+
1 row in set, 1 warning (0.00 sec)

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Bug - A problem which impairs or prevents the functions of the product. MDEV-8660 TIME(int_zerofill_column) returns a wrong result

                • Major - Major loss of function.
                • Closed

                  Activity

                  Hide
                  Permalink
                  bar Alexander Barkov added a comment -

                  Not repeatable in MySQL-5.7.8

                  Show
                  bar Alexander Barkov added a comment - Not repeatable in MySQL-5.7.8

                    People

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

                      Dates

                      • Created:
                        Updated:
                        Resolved:

                        Agile