Bug #7460 SQL_CALC_FOUND_ROWS
Submitted: 21 Dec 2004 19:22 Modified: 22 Dec 2004 15:23
Reporter: Oliver Peters Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.1.4 OS:Windows (Windows2000)
Assigned to: CPU Architecture:Any

[21 Dec 2004 19:22] Oliver Peters 
Description:
SELECT SQL_CALC_FOUND_ROWS * FROM play LIMIT 100;

SELECT FOUND_ROWS();

---> Result is 0 (Table has approx. 2.000.000 records)

How to repeat:
do a comparable query (see description)
[22 Dec 2004 15:23] MySQL Verification Team 
Hi,

Thank you for the report, but this is not a bug.
MySQL Query Browser opens new connection each time when you execute query in the query window.
If you want to use SQL_CALC_FOUND_ROWS you can do it in a script or start transaction.