Bug #27786 Inconsistent Operation Performing UNION On View With ORDER BY
Submitted: 12 Apr 2007 15:43 Modified: 24 Apr 2007 17:29
Reporter: Devin Withers Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.40-BK, 5.0.37 OS:Linux
Assigned to: Georgi Kodinov CPU Architecture:Any
Tags: Contribution, regression

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[16 Apr 2007 0:26] Martin Friebe
possible patch and testcase

Attachment: union_view.patch (text/x-patch), 11.57 KiB.

[16 Apr 2007 11:09] Martin Friebe
some more test cases. Italso works if the view is in braces and an order to the view is given inside the braces

Attachment: union_view_tests.patch (text/x-patch), 2.10 KiB.