Details
-
Type:
Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
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
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Re: make test ORDER BY date_ord ASC
Re: make test ORDER BY date_ord ASC
mariadb version
mariadb-5.1.41-rc
sorry for the omission
-pete
[Bug 524679] Re: make test ORDER BY date_ord ASC
Hi!
>>>>> "PetePDX" == PetePDX <pete@petelancashire.com> 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
Launchpad bug id: 524679
mysqltest.log
LPexportBug524679_mysqltest.log