SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
(OP)
Hi Guys,
As per MySQL documentation, SQL_CALC_FOUND_ROWS and FOUND_ROWS() has been deprecated since MySQL 8.0.17.
How come I can still use it in MySQL 8.0.29?
Comments please? Or maybe I missed a newer memo on this?
As per MySQL documentation, SQL_CALC_FOUND_ROWS and FOUND_ROWS() has been deprecated since MySQL 8.0.17.
How come I can still use it in MySQL 8.0.29?
Comments please? Or maybe I missed a newer memo on this?
RE: SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Depreciated doesn't mean removed. It will be removed in a future version. Think of it as a warning that you should refactor your code if you do use it.
Mark
"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach
RE: SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Hi. Thanks for your reply. Noted on this.
I stumbled into these because I encountered a very weird error using SELECT COUNT(*)....
This I believe is the offending code:
In my ODBC trace, this is what I found:
That is why I tried substituting it with:
My code works with MySQL ODBC 8.0.30 and MySQL Server 5.7.37 perfectly... when I run it with MySQL ODBC 8.0.30 and
MySQL Server 8.0.30.. that is where the error appear...