Details
-
Bug
-
Status: Closed (View Workflow)
-
Resolution: Fixed
-
None
-
None
-
None
Description
Platform is x86_64 Fedora11 updated to latest today.
cat /proc/version
Linux version 2.6.30.9-96.fc11.x86_64 (<email address hidden>) (gcc version 4.4.1 20090725 (Red Hat 4.4.1-2) (GCC) ) #1 SMP Wed Nov 4 00:02:04 EST 2009
download lastest from Lanchpad
./BUILD/autorun.sh
./configure
make
make test
CURRENT_TEST: main.func_if
— /home/mariadb/repos/maria/trunk/mysql-test/r/func_if.result 2010-02-19 11:40:23.087790884 -0800
+++ /home/mariadb/repos/maria/trunk/mysql-test/r/func_if.reject 2010-02-19 12:40:31.530666212 -0800
@@ -99,14 +99,14 @@
INSERT INTO t1 VALUES (1,1110000000,'Day 1'),(2,1111000000,'Day 2'),(3,1112000000,'Day 3');
SELECT id, IF(date IS NULL, '', FROM_UNIXTIME(date, '%d%m-%Y')) AS date_ord, text FROM t1 ORDER BY date_ord ASC;
id date_ord text
-1 05-03-2005 Day 1
+1 04-03-2005 Day 1
2 16-03-2005 Day 2
3 28-03-2005 Day 3
SELECT id, IF(date IS NULL, '', FROM_UNIXTIME(date, '%d%m-%Y')) AS date_ord, text FROM t1 ORDER BY date_ord DESC;
id date_ord text
3 28-03-2005 Day 3
2 16-03-2005 Day 2
-1 05-03-2005 Day 1
+1 04-03-2005 Day 1
DROP TABLE t1;
CREATE TABLE t1 (a CHAR(10));
INSERT INTO t1 VALUES ('aaa'), (NULL), (''), ('bbb');
mysqltest: Result content mismatch