search

LucidDB / luciddb

DEFUNCT: See README
https://github.com/LucidDB/luciddb
Apache License 2.0
52 stars 24 forks source link

[FRG-75] Can't Find Plan For SQL/MED Projection With Fennel Calc #795

Closed dynamobi-build closed 12 years ago

dynamobi-build commented 12 years ago

[reporter="jvs", created="Fri, 17 Mar 2006 14:48:31 -0500 (GMT-05:00)"] alter system set "calcVirtualMachine" = 'CALCVM_FENNEL';
explain plan for select job from hsqldb_demo.sales.emp;

gives

Internal error: node could not be implemented: Subset#1.ITERATOR (state=,code=0)

Works fine with CALCVM_JAVA or CALCVM_AUTO.

A normal project like the one below works fine with CALVM_FENNEL:

explain plan for select name from sales.depts;
------- Comment #1 From Julian Hyde 2005-10-24 11:01 [reply] -------
accept -- will not fix until after rexprogram rework is complete

dynamobi-build commented 12 years ago

[author="stephan", created="Thu, 21 Sep 2006 15:37:50 -0500 (GMT-05:00)"] This appears to work correctly using the HEP planner. I've also verified that it is working with the Volcano planner. Unclear what change(s) resolved the original issue.