[FRG-170] FIRST_VALUE and LAST_VALUE cannot find implementation

[dynamobi-build]

[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:>

[dynamobi-build]

[author="jvs", created="Mon, 17 Jul 2006 11:34:36 -0500 (GMT-05:00)"] Assigning to Julian for dispatch. I don't know if any SQL/OLAP execution plans are supposed to be available in vanilla Farrago.