Issue Details (XML | Word | Printable)

Key: CORE-1530
Type: Bug Bug
Status: Reopened Reopened
Priority: Minor Minor
Assignee: Dmitry Yemanov
Reporter: Vlad Khorsun
Votes: 0
Watchers: 0
Operations

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

UNION DISTINCT accept BLOB fields

Created: 19/Oct/07 01:38 PM   Updated: 26/Jan/08 01:03 PM
Component/s: Engine
Affects Version/s: 2.1 Beta 2
Fix Version/s: None

Time Tracking:
Not Specified

Issue Links:
Relate
 


 Description  « Hide
Since FB 2.1 it is illegal to sort blobs i.e. ORDER BY BLOB_FIELD is rejected by the engine

Union also involves sorting but (wrongly) accept BLOB fields :

SELECT F.RDB$DESCRIPTOR FROM RDB$FORMATS F
UNION
SELECT F.RDB$DESCRIPTOR FROM RDB$FORMATS F


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
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.