dynamobi/dynamobi — Issue #702: [FRG-170] FIRST_VALUE and LAST_VALUE cannot find implementation
Author: dynamobi-build
Created: 2011-12-30 03:44:06+00:00
State: open
Labels: DDL, FRG

[reporter="johnk", created="Mon, 17 Jul 2006 11:21:03 -0500 (GMT-05:00)"]
Perhaps this isn't valid SQL?

0: jdbc:farrago:> select FIRST_VALUE(name) over (order by empno) from sales.emps;

Error: Optimizer failed to find a valid physical implementation for relational expression rel#96:WindowedAggregateRel.NONE(child=HepRelVertex#92,expr#0..1={inputs},expr#2=FIRST_VALUE($t1) OVER (ORDER BY $t0),EXPR$0=$t2); see trace for partially optimized plan (state=,code=0)

0: jdbc:farrago:>select LAST_VALUE(name) over (order by empno) from sales.emps;

Error: Optimizer failed to find a valid physical implementation for relational expression rel#114:WindowedAggregateRel.NONE(child=HepRelVertex#110,expr#0..1={inputs},expr#2=LAST_VALUE($t1) OVER (ORDER BY $t0),EXPR$0=$t2); see trace for partially optimized plan (state=,code=0)

0: jdbc:farrago:>