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

Wrong result for IFNULL(FROM_UNIXTIME(..),0)+0

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 5.3.12, 5.5.37, 10.0.11
        • Fix Version/s: 10.1
        • Component/s: None
        • Labels:
          None

          Description

          DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a DATE) ENGINE=MyISAM;
INSERT INTO t1 VALUES ('2005-05-04'),('2000-02-23');
SELECT a, FROM_UNIXTIME(CONCAT(a,'10')) AS f1, IFNULL(FROM_UNIXTIME(CONCAT(a,'10')),0)+0  AS f2 FROM t1;

          returns

          +------------+---------------------+------+
| a          | f1                  | f2   |
+------------+---------------------+------+
| 2005-05-04 | 1970-01-01 03:33:25 | 1970 |
| 2000-02-23 | 1970-01-01 03:33:20 | 1970 |
+------------+---------------------+------+

          The expected result for f2 is 19700101033325 and 19700101033330.

          The same problem happens with IF:

          SELECT a, FROM_UNIXTIME(CONCAT(a,'10')) AS f1, IF(1,FROM_UNIXTIME(CONCAT(a,'10')),0)+0  AS f2 FROM t1;

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                bar Alexander Barkov added a comment -

                The problem is that IFNULL(temporal,int) returns a VARCHAR result.
                It should return an INT or DECIMAL result.

                Show
                bar Alexander Barkov added a comment - The problem is that IFNULL(temporal,int) returns a VARCHAR result. It should return an INT or DECIMAL result.
                Hide
                Permalink
                bar Alexander Barkov added a comment -

                Removing 5.3 and 5.5 from fixVersion, as agreed with Sergei on IRC.

                Show
                bar Alexander Barkov added a comment - Removing 5.3 and 5.5 from fixVersion, as agreed with Sergei on IRC.

                  People

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

                    Dates

                    • Created:
                      Updated: