www.infinidb.org

Hallo i'm trying to run this query on infinidb


here there are many lwa-tupel having the same wgl-id and i want the smallest one
but i recieve this error witch i dont understand



and i cant find any thing on this error in google or infinidb forums or ducumentations

thanx for ur help

Hi Alexy,

Thank you for download and using Calpont InfiniDB. One of our engineers is looking into this and we will get back to you as soon as possible.

The query has some syntax that we don't currently support. We currently do not allow the comparison in blue below. The semi join is between the outer lwa result and the inner lwa result. We do not support a comparison between another outer table, only the on in the semi join.

SELECT *

FROM wgl
left outer join lwa on wgl.wgl_id = lwa.wgl_id

WHERE lwa.lwa_id = (select min(lwa_id) from lwa where wgl.wgl_id = lwa.wgl_id);

Using the outer lwa.wgl_id in the sub query filter is supported and is an equivalent query.

SELECT *

FROM wgl
left outer join lwa lwa_outer on wgl.wgl_id = lwa_outer.wgl_id

WHERE lwa.lwa_id = (select min(lwa_id) from lwa where lwa_outer.wgl_id = lwa.wgl_id);

Thanks.