#40969 [NEW]: Insert row with unique key violation, no error.

From: andrew dot craft at wyndhamworldwide dot com Operating system: Windows XP SP2 32bit PHP version: 5.2.1 PHP Bug Type: MySQLi related Bug description: Insert row with unique key violation, no error. Description: ------------ I am using mysql 5.0.27. There is a table that has a unique index on it. When inserting a new row that would violate the uniqueness using a prepared statement no errors/exceptions are raised. When looking at the query log the statement is prepared but no executions queries. Should there not be an exception raised for the error? I did a google search and searched the bug database but did not find an existing issue. Reproduce code: --------------- CREATE TABLE docs_classification ( classification_id smallint(6) NOT NULL auto_increment, name varchar(100) NOT NULL, description varchar(255) NOT NULL, short_name char(3) NOT NULL, bit_value int(11) NOT NULL, PRIMARY KEY (classification_id), UNIQUE KEY bit_value (bit_value) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; ////////// First Run array('test1', 'test1test1', 'TS1', '1'), array('test2', 'test2test2', 'TS2', '2'), array('test3', 'test3test3', 'TS3', '4') ); $m = new mysqli('localhost', 'dbuser', '','dbname'); $sql = 'INSERT INTO dbtable ' ' (classification_id, name, description, short_name, bit_value) '. ' VALUES (NULL, ?, ?, ?, ?)'; $stmt = $m->prepare($sql); foreach ($a as $b) { $stmt->bind_param('ssss', $b[0], $b[1], $b[2], $b[3]); $stmt->execute(); } /////// Then repeat above code and no errors are raised. Expected result: ---------------- Expected to be notified of the duplicate entry error in the bit_value field when re-running the code. Actual result: -------------- No errors or indication of any errors. In the query log it shows the sql being prepared but no Execute commands. -- Edit bug report at http://bugs.php.net/?id=40969&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=40969&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=40969&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=40969&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=40969&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=40969&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=40969&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=40969&r=needscript Try newer version: http://bugs.php.net/fix.php?id=40969&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=40969&r=support Expected behavior: http://bugs.php.net/fix.php?id=40969&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=40969&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=40969&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=40969&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=40969&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=40969&r=dst IIS Stability: http://bugs.php.net/fix.php?id=40969&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=40969&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=40969&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=40969&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=40969&r=mysqlcfg