2008/11/12 1:09 Hitoshi Harada <umi.tanuki@gmail.com>:
> So obviously nth_value(expr, 0) causes error and nth_value(expr, 1)
> returns the first row. I will update my patch soon.
Fixed these issues:
- ntile() value check
- nth_value() value check and behavior change
Also, I found a bug that is fixed in this release:
SELECT sum(salary) OVER w1, count(*) OVER w2 FROM empsalary WINDOW w1
AS (ORDER BY salary), w2 AS (ORDER BY salary);
The identical windows named differently were not processed
appropriately. It works now.
Regards,
--
Hitoshi Harada