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] -----------------------------------------------------------------------------
