When you have in query for NetteDBDataSource GROUP BY, queries looks like this:
SELECT COUNT() FROM table -- missing GROUP BY
SELECT * FROM table GROUP BY column
Right count will be like something this:
SELECT COUNT() FROM (SELECT … FROM table WHERE … GROUP BY column)
I compare NetteDBDataSource and DibiDataSource. DibiDataSource is working fine.
Testing on v2.0.7.2
When you have in query for NetteDBDataSource GROUP BY, queries looks like this:
SELECT COUNT() FROM table -- missing GROUP BY
SELECT * FROM table GROUP BY column
Right count will be like something this:
SELECT COUNT() FROM (SELECT … FROM table WHERE … GROUP BY column)
I compare NetteDBDataSource and DibiDataSource. DibiDataSource is working fine.
Testing on v2.0.7.2