Issue Details (XML | Word | Printable)

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

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: 03/Jun/14 10:52 AM
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

Issue Links:

 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   Change History   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.