Issue Details (XML | Word | Printable)

Key: CORE-859
Type: Bug Bug
Status: Reopened Reopened
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Dmitry Yemanov
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Sorting is allowed for blobs

Created: 19/Jul/06 07:20 PM   Updated: 20/Nov/10 08:05 PM
Component/s: Engine
Affects Version/s: 1.5.0, 1.5.1, 1.5.2, 1.5.3, 2.0 Beta 1, 2.0 RC1, 2.0 Beta 2, 2.0 RC2, 2.0 RC3
Fix Version/s: None

Time Tracking:
Not Specified

Issue Links:
Duplicate
 
Relate
 


 Description  « Hide
The engine allows blobs and arrays to be sorted on. Both GROUP BY and ORDER BY on blobs can prepared successfully. All versions (except v2.1) throw a runtime error for GROUP BY due to inability to convert from a blob. ORDER BY [a kind of] works in all versions.

As it produces wrong or undesirable results, cannot be implemented properly due to the sorter restrictions and makes very little sense in practice, I'm going to reject this on the prepare stage.

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pavel Cisar added a comment - 21/Apr/07 01:51 PM
Fix confirmed for 2.1 Alpha 1. Test added.

Pavel Cisar added a comment - 26/Apr/07 11:41 AM
Reopened to update ticket information.

Dmitry Yemanov added a comment - 26/Jan/08 01:03 PM
Restored the legacy behavior until we're able to implement DISTINCT for blobs properly.