[luciddb-users] "IN" clause in JOIN

[Dan K. <da...@th...>]

Hi guys,
I am currently migrating to LucidDB from MySQL and think I may have found a bug.

Consider the following query:
SELECT
*
FROM
(VALUES(1),(2),(3) ) a
INNER JOIN (VALUES(1),(2),(3),(4) ) b ON a.EXPR$0 = b.EXPR$0
WHERE
b.EXPR$0 IN(1,2)

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

SELECT
*
FROM
(VALUES(1),(2),(3) ) a
LEFT JOIN (VALUES(1),(2),(3),(4) ) b ON a.EXPR$0 = b.EXPR$0 AND b.EXPR$0 IN(1,2)

I received the error:
Error Executing Query: java.lang.NullPointerException: null

The Trace.log file shows:
SEVERE: Internal error: while converting `A`.`EXPR$0` = `B`.`EXPR$0` AND `B`.`EXPR$0` IN (1, 2)

I am running LucidDB 0.9.3. Has anyone else experienced this issue? Also sorry if this has already been addressed.

Thanks,
Dan Kinsley

ps - Not a real issue but is there a way to alias the column names returned from VALUES?