search

LucidDB / luciddb

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

[FRG-346] IN and EXISTS queries against SQL/MED JDBC adapter give poor errors #526

Open dynamobi-build opened 12 years ago

dynamobi-build commented 12 years ago

[reporter="jhyde", created="Tue, 16 Sep 2008 14:57:41 -0500 (GMT-05:00)"] IN and EXISTS queries against SQL/MED JDBC adapter give poor errors. Even though IN and EXISTS do not work they should give better errors.


Testcases are in farrago/unitsql/med/scott.sql:


SELECT * FROM dept WHERE EXISTS (
SELECT 1 FROM emp WHERE emp.deptno = dept.deptno AND sal >= 800);
Error: org.codehaus.janino.CompileException: File net/sf/farrago/dynamic/stmt11/Transformer1.java, Line 28, Column 115: Thrown exception of type "java.sql.SQLException" is neither caught by a "try...catch" block nor declared in the "throws" clause of the declaring function (state=,code=0)


SELECT * FROM emp WHERE deptno IN (
SELECT deptno FROM dept WHERE sal >= 800);
Error: org.codehaus.janino.CompileException: File net/sf/farrago/dynamic/stmt12/Transformer1.java, Line 33, Column 115: Thrown exception of type "java.sql.SQLException" is neither caught by a "try...catch" block nor declared in the "throws" clause of the declaring function (state=,code=0)


Those queries have been disabled pending this bug.

dynamobi-build commented 12 years ago

[author="stephan", created="Tue, 16 Sep 2008 17:28:00 -0500 (GMT-05:00)"] This bug is caused by the fact that MedJdbcQueryRel is missing an implementation of clone(), which causes the MedJdbcQueryRel to be converted to JdbcQuery when cloned.


Fixed in //open/dev @11516.

dynamobi-build commented 12 years ago

[author="jvs", created="Tue, 16 Sep 2008 18:44:27 -0500 (GMT-05:00)"] Julian, close this one once you have sync'd down Stephan's fix.