Req #51499 [PATCH]: mysql_warning_count to be implemented
Edit report at https://bugs.php.net/bug.php?id=51499&edit=1
ID: 51499
Patch added by: cmb@php.net
Reported by: andrew at ajohnstone dot com
Summary: mysql_warning_count to be implemented
Status: Open
Type: Feature/Change Request
Package: PDO related
PHP Version: Irrelevant
Block user comment: N
Private report: N
New Comment:
The following pull request has been associated:
Patch Name: Fix #51499 PDO: add mysql-specific warning count function
On GitHub: https://github.com/php/php-src/pull/6677
Patch: https://github.com/php/php-src/pull/6677.patch
Previous Comments:
------------------------------------------------------------------------
[2021-02-10 11:00:28] daniel dot beardsley at gmail dot com
I opened a pull request on github to add this feature:
https://github.com/php/php-src/pull/6677
------------------------------------------------------------------------
[2010-08-26 13:53:18] uw@php.net
Well, JDBC has a getWarnings() method as part of its Statement class. I think PDO should have
something similar and do it in a generic way. So, even if there's a shortcut for MySQL,
I'd rather look into how to do this on the upper PDO level than adding the shortcut to
PDO_MySQL. PDO should try to have everything in the core that can be made part of the core. Without
knowing about the other databases, I wonder if PDO could follow the JDBC example.
------------------------------------------------------------------------
[2010-04-07 18:37:19] andrew at ajohnstone dot com
Description:
------------
The warning count is sent in the returned OK packet from a executed statement, however there is no
functionality within PDO to extract, how many warnings were triggered from the statement.
This will save on round trips to the database to identify whether data could have been truncated for
example.
http://dev.mysql.com/doc/refman/5.0/en/mysql-warning-count.html
http://forge.mysql.com/wiki/MySQL_Internals_ClientServer_Protocol#Types_Of_Result_Packets
This would need to be implemented for other drivers too.
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=51499&edit=1
Thread (5 messages)