dynamobi/dynamobi — Issue #80: [LDB-243] "IN" clause in JOIN
Author: dynamobi-build
Created: 2011-12-30 02:11:32+00:00
State: open
Labels: LDB

[reporter="dankins", created="Tue, 21 Jun 2011 07:52:41 -0500 (GMT-05:00)"]
Consider the following query:

SELECT

*

FROM

(VALUES 1,2,3 ) AS a(foo)

INNER JOIN (VALUES 1,2,3,4 ) AS b(bar) ON a.foo = b.bar

WHERE b.bar IN(1,2)

Now if you move the IN part into the INNER JOIN like so:

SELECT

*

FROM

(VALUES 1,2,3 ) AS a(foo)

INNER JOIN (VALUES 1,2,3,4 ) AS b(bar) ON a.foo = b.bar AND b.bar IN(1,2)

I received the error:

Error Executing Query: java.lang.NullPointerException: null

The Trace.log file shows:

Jun 21, 2011 8:51:45 AM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException

SEVERE: Internal error: while converting `A`.`FOO` = `B`.`BAR` AND `B`.`BAR` IN (1, 2)

Jun 21, 2011 8:51:45 AM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException

SEVERE: null