Bug #63399 Some SHOW commands do not set FOUND_ROWS correctly
| Submitted: | 23 Nov 2011 9:27 | Modified: | 2 Dec 2011 23:37 |
|---|---|---|---|
| Reporter: | Hartmut Holzgraefe | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Information schema | Severity: | S3 (Non-critical) |
| Version: | OS: | Any | |
| Assigned to: | CPU Architecture: | Any |
[23 Nov 2011 9:27]
Hartmut Holzgraefe
[23 Nov 2011 9:27]
Hartmut Holzgraefe
Backgroud: i'm trying to determine whether a mysql server is configured as slave in init_file, if SHOW SLAVE STATUS would set FOUND_ROWS() correctly i could simply check for 1 or 0 there, now i'm falling back to checking for the existence of the master.info file using LOAD DATA INFILE Checking the actual SHOW results using a stored procedure and cursor is not an option as for a cursor FETCH i need to know the exact column count which may change between releases though ...
[23 Nov 2011 9:43]
Valeriy Kravchuk
Thank you for the bug report. Verified on Mac OS X: mysql> show slave status; Empty set (0.00 sec) mysql> select found_rows(); +--------------+ | found_rows() | +--------------+ | 1 | +--------------+ 1 row in set (0.00 sec) mysql> select version(); +--------------+ | version() | +--------------+ | 5.5.17-debug | +--------------+ 1 row in set (0.00 sec)
[2 Dec 2011 23:37]
Hartmut Holzgraefe
Probably also somehow related: bug #63399
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.