php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #37668 fetch->Field doesn't take the correct type
Submitted: 2006-06-01 23:46 UTC Modified: 2006-06-20 14:39 UTC
From: eric dot potvin at zendphp dot com Assigned:
Status: Not a bug Package: MySQLi related
PHP Version: 5.1.4 OS: WIN32 & FREEBSD
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: eric dot potvin at zendphp dot com
New email:
PHP Version: OS:

 

 [2006-06-01 23:46 UTC] 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) {
}

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-06-20 14:39 UTC] tony2001@php.net
This is what MySQL API call returns and there is nothing we can do about it.
Please report it to MySQL developers.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Dec 26 13:01:30 2024 UTC