Hi

Today I noticed a bug or limitation in our FB, I can obviously rewrite my query but I figured there might be in interesting explanation floating around:

Select * from table1
WHERE table1.id IN
(SELECT FIRST 1 id in
FROM table2
WHERE table2.number > 3
ORDER BY table2.number
)



I figured this should only return one row in total but apparently the system optimizes the "FIRST 1" part away in the inner query.

I believe it is common that this is not allowed in other DBs but here I get no complaints, instead I just get the full set of rows mathcing the inner query returned.

Cheers

Tim