[MDEV-3652] LP:524679 - make test ORDER BY date_ord ASC Created: 2010-02-19  Updated: 2012-10-04  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: PetePDX (Inactive) Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug524679.xml     Text File LPexportBug524679_mysqltest.log    

 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

 Comments   
Comment by PetePDX (Inactive) [ 2010-02-19 ]

Re: make test ORDER BY date_ord ASC

Comment by PetePDX (Inactive) [ 2010-02-19 ]

mysqltest.log
LPexportBug524679_mysqltest.log

Comment by PetePDX (Inactive) [ 2010-02-22 ]

Re: make test ORDER BY date_ord ASC
mariadb version

mariadb-5.1.41-rc

sorry for the omission

-pete

Comment by Michael Widenius [ 2010-02-23 ]

[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

Comment by Rasmus Johansson (Inactive) [ 2010-06-28 ]

Launchpad bug id: 524679

Generated at Thu Feb 08 06:50:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.