make test ORDER BY date_ord ASC

[PetePDX]

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

[PetePDX (pete-petelancashire)]

mariadb version

mariadb-5.1.41-rc

sorry for the omission

-pete

[Michael Widenius (monty)]

Hi!

>>>>> "PetePDX" == PetePDX <email address hidden> writes:

PetePDX> mariadb version
PetePDX> mariadb-5.1.41-rc

PetePDX> sorry for the omission

Thanks for the bug report. This is now fixed and pushed into the 5.1
bzr tree.

Regards,
Monty