UNION DISTINCT accept BLOB fields [CORE1530]

[firebird-automations]

Submitted by: @hvlad

Is related to QA196

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

Commits: b32234e fec2f3e c952f13

[firebird-automations]

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

[firebird-automations]

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.1 RC1 [ 10201 ]

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA196 [ QA196 ]

[firebird-automations]

Commented by: @dyemanov

Restored the legacy behavior until we're able to implement DISTINCT for blobs properly.

[firebird-automations]

Modified by: @dyemanov

status: Resolved [ 5 ] => Reopened [ 4 ]

resolution: Fixed [ 1 ] =>

[firebird-automations]

Modified by: @dyemanov

Fix Version: 2.1 RC1 [ 10201 ] =>

[firebird-automations]

Modified by: @pcisar

Workflow: jira [ 13333 ] => Firebird [ 14017 ]

[firebird-automations]

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ] =>