Hi, What I got 33 call to the xFinal (NOT EXPECTED) and 33 call to xStep and only 3 rows as a result (AS EXPECTED). Even if I have 11 elements grouped, I should got only 3 calls to xFinal and 33 to xStep. Also by debuging the code xStep and xFinal called with non-result data.
Thanks, Mina. On 8/17/07, Sreedhar.a <[EMAIL PROTECTED]> wrote: > Hi, > > One idea,Please check whether each row has 11 elements. > That's could be the reason why u have got 33 times call back. > > > Best Regards, > A.Sreedhar. > > > -----Original Message----- > From: Mina R Waheeb [mailto:[EMAIL PROTECTED] > Sent: Friday, August 17, 2007 12:12 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Aggregate and query limit > > Hi, > I have some questions about the behavior of aggregate functions and the > result LIMIT. > After register TEST function and executing query (SELECT TEST() FROM objects > group by id LIMIT 30,3) > > I was expect calling back TEST() only 3 times but what happened is the > TEST() is called 33 time, and the result set is correct 3 rows. > > My questions: > - Why TEST() is called for non-result rows? Is this designed feature? > - When the evaluation of the result-column functions happen? > - How SQLite preform the LIMIT? > > Thanks, > Mina. > > ---------------------------------------------------------------------------- > - > To unsubscribe, send email to [EMAIL PROTECTED] > ---------------------------------------------------------------------------- > - > > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
