#41325 [Opn->Fbk]: mysqli_affected_rows() returns wrong value if warnings are raised
| From: | scottmac@php.net | Date: | Tue, 08 May 2007 15:07:08 +0000 |
| Subject: | #41325 [Opn->Fbk]: mysqli_affected_rows() returns wrong value if warnings are raised | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-112401@lists.php.net to get a copy of this message | ||
ID: 41325
Updated by: scottmac@php.net
Reported By: php-qa at sebastianmendel dot de
-Status: Open
+Status: Feedback
Bug Type: MySQLi related
Operating System: Windows / Linux
PHP Version: 5.2.2
New Comment:
I can't reproduce this with 5.0.27. I get the expected output of 1.
Do you have any other sort of special configuration or setting?
Previous Comments:
------------------------------------------------------------------------
[2007-05-08 14:50:46] php-qa at sebastianmendel dot de
Description:
------------
issuing an insert statement that raises warnings mysqli_affected_rows()
returns the warning count instead of inserted rows count
tested with MySQL server 5.0, 5.1 and 5.2 (6.0)
Reproduce code:
---------------
// open db connection/select db
//$mysqli = mysqli_...
// create table
$sql = 'CREATE TABLE
test (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
int int(11) NOT NULL,
int2 int(11) NOT NULL,
PRIMARY KEY (id)
)';
mysqli_query($mysqli, $sql);
// insert row
$sql = 'INSERT INTO test (int, int2) VALUES
('', '');'
mysqli_query($mysqli, $sql);
echo mysqli_affected_rows($mysqli);
Expected result:
----------------
1
Actual result:
--------------
2
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=41325&edit=1