ID: 31979
User updated by: danielc at analysisandsolutions dot com
Reported By: danielc at analysisandsolutions dot com
-Status: Bogus
+Status: Open
Bug Type: mSQL related
Operating System: NetBSD 2.0
PHP Version: 5CVS-2005-02-15
New Comment:
Jani, you can do better than that. Are you saying you ran my test and
got the expected result? Or are you passing the buck?
Previous Comments:
------------------------------------------------------------------------
[2005-06-07 00:24:32] [EMAIL PROTECTED]
Apparently the msql version you've compiled PHP does not set the field
properly.
------------------------------------------------------------------------
[2005-02-15 05:26:25] danielc at analysisandsolutions dot com
Description:
------------
One of the properties returned by msql_fetch_field() is "unique". It
is supposed to contain 1 if the column in question is part of a unique
key and 0 if it's not. But it always returns 0.
Reproduce code:
---------------
$con = msql_connect();
$db = msql_select_db('ptdb', $con);
msql_query('CREATE TABLE blah (i INT)', $con);
msql_query('CREATE UNIQUE INDEX bi ON blah (i)', $con);
$result = msql_query('SELECT * FROM blah', $con);
$info = msql_fetch_field($result);
print_r($info);
msql_query('DROP TABLE blah', $con);
Expected result:
----------------
stdClass Object
(
[name] => i
[table] => blah
[not_null] => 0
[unique] => 1
[type] => int
)
Actual result:
--------------
stdClass Object
(
[name] => i
[table] => blah
[not_null] => 0
[unique] => 0
[type] => int
)
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=31979&edit=1
