[php-src] Issue #8502: Mysqli multi column unique index - duplicate insert causes fatal exception

From: Date: Fri, 06 May 2022 10:35:46 +0000
Subject: [php-src] Issue #8502: Mysqli multi column unique index - duplicate insert causes fatal exception
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-241422@lists.php.net to get a copy of this message 
Issue: https://github.com/php/php-src/issues/8502
Author: philliphegarty

### Description

The following code:

Create a Mysql table, testtable with two columns - Domain INT(3), Dataname VARCHAR(10)
Create an index - create unique index idx1 on testtable(Domain, Dataname)

Using mysqli - INSERT INTO testtable (Domain, Dataname) VALUES (1, 'FRED');      // Works
- unique
                         INSERT INTO testtable (Domain, Dataname) VALUES (2, 'JOHN');    
// Works - unique
                         INSERT INTO testtable (Domain, Dataname) VALUES (2, 'FRED');     
// Works - unique
                         INSERT INTO testtable (Domain, Dataname) VALUES (1, 'JOHN');     
// Works - unique
                         INSERT INTO testtable (Domain, Dataname) VALUES (1, 'FRED');     
// Fails - with unhandled Exception

Resulted in this output:
       See above


But I expected this output instead:
       Expected returned resource to be false, because the SQL would result in a duplicate

### PHP Version

PHP 8.1.4

### Operating System

MacOS Monterey 12.3.1

Thread (1 message)

  • philliphegarty
« previous php.bugs (#241422) next »