[MDEV-3744] LP:571200 - MySQL Bug#32426: FederatedX corrupt ORDER BY with TEXT Created: 2010-04-28  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 Priority: Minor
Reporter: Kristian Nielsen Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug571200.xml    

 Description   

http://bugs.mysql.com/bug.php?id=32426

mysql> select * from t1;
------

c1

------

abc
gh
f
ijk
de

------
5 rows in set (0.00 sec)

mysql> select * from t1 order by c1;
------

c1

------

dek
de
d
de
dek

------
5 rows in set (0.00 sec)

Check the MySQL bug link for how to repeat, or comment in the test from .mysql-test/suite/federated/federated.test

This bug was fixed in FEDERATED in MySQL, seems we need to port the fix to FEDERATEDX. The code is sufficiently different that porting the fix is not trivial.

Now that I merge MySQL 5.1.46, I get the test case and see the bug in the testsuite.

I will comment out the test in mysql-test/suite/federated/federated.test. The test needs to be re-enabled as part of this bug fix.

 Comments   
Comment by CaptTofu (Inactive) [ 2010-06-11 ]

Re: MySQL Bug#32426: FederatedX corrupt ORDER BY with TEXT
apparently, this pertains to the how blobs are handled in Federated/FederatedX. I need to discuss with someone what exactly can be done to ensure correct ordering, even for BLOB-type fields.

Comment by Kristian Nielsen [ 2010-06-14 ]

Re: MySQL Bug#32426: FederatedX corrupt ORDER BY with TEXT
There is a patch for this issue against FEDERATED in the MySQL bug:

http://bugs.mysql.com/bug.php?id=32426
http://lists.mysql.com/commits/102419

Can't you use the same method as that patch?

Comment by CaptTofu (Inactive) [ 2010-07-10 ]

Re: MySQL Bug#32426: FederatedX corrupt ORDER BY with TEXT
Yes, working on a fix for this right now! I finally have time to dedicate to FederatedX again

Comment by Michael Widenius [ 2010-08-11 ]

Re: MySQL Bug#32426: FederatedX corrupt ORDER BY with TEXT
I was looking at merging this to 5.1 to fix the open federated bugs in 5.1, but the tree is depending on 5.2

i will look at this next week (after linuxconf) and see if I can easily extract the patch and apply it safely to 5.1

Comment by Michael Widenius [ 2010-08-12 ]

Re: MySQL Bug#32426: FederatedX corrupt ORDER BY with TEXT
Fix now pushed into 5.1

Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ]

Launchpad bug id: 571200

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