#37668 [Opn->Bgs]: fetch->Field doesn't take the correct type
ID: 37668
Updated by: tony2001@php.net
Reported By: eric dot potvin at zendphp dot com
-Status: Open
+Status: Bogus
Bug Type: MySQLi related
Operating System: WIN32 & FREEBSD
PHP Version: 5.1.4
New Comment:
This is what MySQL API call returns and there is nothing we can do
about it.
Please report it to MySQL developers.
Previous Comments:
------------------------------------------------------------------------
[2006-06-01 23:46:52] eric dot potvin at zendphp dot com
Description:
------------
The mysqli_fetch_fields dosen't take the correct field type for the
ENUM and SET type.
Reproduce code:
---------------
Create a table with a ENUM type with value like 'True', 'False' and
default value to True.
do : $finfo = mysqli_fetch_field($result)
you will get : $finfo->type = 254
So, a STRING. - MYSQLI_TYPE_STRING and with no default value.
Same thing for the set type.
Expected result:
----------------
The $finfo->type
should have 247 (MYSQLI_TYPE_ENUM) as value.
or
248 (MYSQLI_TYPE_SET) as value for a SET type
Actual result:
--------------
array(0) {
}
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=37668&edit=1
Thread (2 messages)