[Firebird-docs] Wrong example in FB 4.0 Beta release notes

[Köditz, M. <Mar...@it...>]

Hi,

I think we have a simple error in the release docs for FB 4.0 Beta 1:

Section
More Window Functions (Pages: 76-77)
Ranking Functions:

DENSE_RANK() |
RANK() |
PERCENT_RANK() |
CUME_DIST() |
NTILE(<expr>) |
ROW_NUMBER()

Simple Example
The following example illustrates the behaviour of ranking functions. SUM is included for comparison.

SQL> select
CON> id,
CON> salary,
CON> dense_rank() over (order by salary),
CON> rank() over (order by salary),
CON> percent_rank() over (order by salary),
CON> cume_dist() over (order by salary),
CON> ntile(3) over (order by salary),
CON> row_number() over (order by salary),
CON> sum(1) over (order by salary)
CON> from employee
CON> order by salary;
Statement failed, SQLSTATE = 42S22
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-ID
-At line 2, column

"id" has to be "emp_no". The same for the table.

Please verify. I don't have an installation of FB 4.0.

Regards,
Martin