No it should only return 1 line but even with “and jtype = j.jtype” added to the subselect condition it still takes almost 5 minutes to return data





Stef van der Merwe





From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 29 April 2015 12:52 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: SQL Case query takes 4 minutes 30 seconds to execute !!

On Wed, 29 Apr 2015 08:39:02 +0200, 'Stef' stef@... [firebird-support] <firebird-support@yahoogroups.com> wrote:


Is it intended, that internal query would return multiple lines with jtype=2
and jtype=99 but sums include both jtypes? Because that is only condition not in
included in subselect selecting the sums.


--
Virgo Pärna
virgo.parna@...










[Non-text portions of this message have been removed]