Issue Details (XML | Word | Printable)

Key: DOC-76
Type: Improvement Improvement
Status: Open Open
Priority: Trivial Trivial
Assignee: Paul Vinkenoog
Reporter: arni
Votes: 0
Watchers: 0

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

Incorrect ORDER BY clause in SELECT UNION syntax sample

Created: 28/Dec/11 08:58 AM   Updated: 29/Dec/11 12:36 AM
Component/s: None
Affects Version/s: None
Fix Version/s: None

 Description  « Hide
Firebird 2.5 Language Reference Update,
8 Oct 2011,
document version 1.1,
page 95

With a UNION:

SELECT [FIRST p] [SKIP q] <columns> FROM ...
[WHERE ...]
[ORDER BY ...]
SELECT [FIRST r] [SKIP s] <columns> FROM ...
[WHERE ...]
[ORDER BY ...]
ROWS <m> [TO <n>]

ORDER BY clause before UNION ALL is illegal in this sample.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Paul Vinkenoog added a comment - 29/Dec/11 12:35 AM - edited
You're right, thanks. I'll fix it for the next edition of the LangRefUpdates.