At 10:20 PM 16/09/2009, SET wrote:

>Although I know that Firebird in many cases resolves a subquery to EXISTS, I'd be impressed if Dmitry could claim that Firebird is able to transform every other possible form of IN (<subselect>) into EXISTS, there are so many possible ways to write bad SQL (not that I know whether Firebird is able to do this or not, I'd just be impressed).

I think you can prepare to be impressed, you Unbeliever! But maybe not for a few days, as Dmitry is enjoying a well-earned vacation (well, I *hope* he's enjoying it!) ;-) Adriano could probably talk to you about it but I don't think he follows this list. fb-devel?

./h