Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
-
None
-
None
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.
Attachments
Activity
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?
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 
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
Re: MySQL Bug#32426: FederatedX corrupt ORDER BY with TEXT
Fix now pushed into 5.1
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.