dynamobi/dynamobi — Issue #526: [FRG-346] IN and EXISTS queries against SQL/MED JDBC adapter give poor errors
Author: dynamobi-build
Created: 2011-12-30 03:33:26+00:00
State: open
Labels: FRG, SQL Validator

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