Re: Error in query with DBD-SQLite-1.37 - Aggregate functions are not allowed in the GROUP BY clause.

Replies are listed 'Best First'.
Re^2: Error in query with DBD-SQLite-1.37 - Aggregate functions are not allowed in the GROUP BY clause. by saumitra121 (Novice) on Jul 30, 2012 at 11:44 UTC
No its giving the same error when I ran it on SQLite-3.7.11 command line. Please check my updated answer with new findings and guide me with troubleshooting this issue.	[reply]
Re^3: Error in query with DBD-SQLite-1.37 - Aggregate functions are not allowed in the GROUP BY clause. by Corion (Patriarch) on Jul 30, 2012 at 12:07 UTC
If it does not work on the sqlite3 command line then it is a problem with SQL and SQLite. There is very little we can do from a Perl perspective. As your SQL statement is quite long, try reducing the columns and aggregates. The error message says that you try to `GROUP BY` something that is an aggregate function, which SQLite does not allow (and which does not make much sense to me either). Consider moving your subselects into views maybe to disambiguate the aggregates etc.	[reply] [d/l]
Re^4: Error in query with DBD-SQLite-1.37 - Aggregate functions are not allowed in the GROUP BY clause. by saumitra121 (Novice) on Jul 30, 2012 at 12:31 UTC
Can u please help me in troubleshooting why DBD-SQlite is unable to detect the the current SQLITE version? The strange thing is that the same query with GROUP BY is running fine with DBI but not on command line.	[reply]
Re^5: Error in query with DBD-SQLite-1.37 - Aggregate functions are not allowed in the GROUP BY clause. by Corion (Patriarch) on Jul 30, 2012 at 12:38 UTC
Re^5: Error in query with DBD-SQLite-1.37 - Aggregate functions are not allowed in the GROUP BY clause. by roboticus (Chancellor) on Jul 30, 2012 at 12:56 UTC


Syntactic Confectionery Delight
	PerlMonks