We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.
  1. Home
  2. Paginator

paginator adapter querybuilder generate wrong count sql

I found this line of code generate wrong SQL

https://github.com/phalcon/cphalcon/blob/1.3.5/ext/paginator/adapter/querybuilder.c#L369

From version 1.3.3 began to have problems

when version 1.3.2 is

SELECT COUNT(*) AS rowcount FROM tablename WHERE ...

since 1.3.3

SELECT COUNT() "rowcount" FROM (SELECT tablename. FROM tablename WHERE (...) AS T



43.9k

Hi,

Phalcon's Github issues is the right place to post this ...



1.1k
in reply to le51

please visit https://github.com/phalcon/cphalcon/issues/9939

thank you

Hi,

Phalcon's Github issues is the right place to post this ...