#28925 [Opn->Bgs]: MYSQLI_UNIQUE_KEY_FLAG not found on UNIQUE indexes
| From: | georg@php.net | Date: | Wed, 11 Aug 2004 12:51:57 +0000 |
| Subject: | #28925 [Opn->Bgs]: MYSQLI_UNIQUE_KEY_FLAG not found on UNIQUE indexes | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-64424@lists.php.net to get a copy of this message | ||
ID: 28925
Updated by: georg@php.net
Reported By: danielc at analysisandsolutions dot com
-Status: Open
+Status: Bogus
Bug Type: MySQL related
Operating System: Windows 2000
PHP Version: 5CVS-2004-06-25 (dev)
Assigned To: georg
New Comment:
Sorry, but your problem does not imply a bug in PHP itself. For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system
is not the
appropriate forum for asking support questions.
Thank you for your interest in PHP.
Currently the resultset sent from server to client doesn't contain this
flag anymore.
Not sure if it will be implemented again (if not I will remove it from
PHP)
Previous Comments:
------------------------------------------------------------------------
[2004-06-25 17:11:25] danielc at analysisandsolutions dot com
Description:
------------
MYSQLI_UNIQUE_KEY_FLAG aren't being indicated for columns that have
UNIQUE indexes.
Reproduce code:
---------------
mysqli_query($db->connection,
'CREATE TABLE phptest_fk (a VARCHAR(5),' .
' UNIQUE (a))');
$r = mysqli_query($db->connection,
'SELECT a FROM phptest_fk');
$tmp = mysqli_fetch_field($r);
echo 'MYSQLI_UNIQUE_KEY_FLAG? ';
if ($tmp->flags & MYSQLI_UNIQUE_KEY_FLAG) {
echo "yes\n";
} else {
echo "no\n";
}
mysqli_query($db->connection,
'DROP TABLE phptest_fk');
Expected result:
----------------
MYSQLI_UNIQUE_KEY_FLAG? yes
Actual result:
--------------
MYSQLI_UNIQUE_KEY_FLAG? no
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=28925&edit=1