#49961 [Com]: Value of length column for fetch_fields() is incorrect.
ID: 49961
Comment by: aavolkoff at gmail dot com
Reported By: aavolkoff at gmail dot com
Status: Feedback
Bug Type: MySQLi related
Operating System: Linux l9.in-solve.ru 2.6.26-r9-s
PHP Version: 5.2.11
New Comment:
MySQL charset: UTF-8 Unicode (utf8)
?
$mysqli = new mysqli(localhost, root, );
if (mysqli_connect_errno()) return false;
$db_name = local;
$query = CREATE DATABASE `$db_name`;
$mysqli-real_query($query);
$mysqli-select_db($db_name);
$table_name = Users;
$query = CREATE TABLE `.$table_name.`(id int not null
auto_increment, name varchar(200), description varchar(200), primary
key (id)) TYPE=MyISAM;
$mysqli-real_query($query);
$query= SELECT * FROM `$table_name` LIMIT 0;
$query_result = $mysqli-real_query($query);
if ($query_result)
{
$mysqli_result = $mysqli-use_result();
$mysqli_fields = $mysqli_result-fetch_fields();
$mysqli_result-free_result();
print_r($mysqli_fields);
}
?
Previous Comments:
[2009-10-23 07:18:21] u...@php.net
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves.
A proper reproducing script starts with ?php and ends with ?,
is max. 10-20 lines long and does not require any external
resources such as databases, etc. If the script requires a
database to demonstrate the issue, please make sure it creates
all necessary tables, stored procedures etc.
Please avoid embedding huge scripts into the report.
What is needed is all the character sets: MySQL server, client etc.
[2009-10-23 07:17:16] u...@php.net
Sounds bogus. The mysql extensions in 5.2 forward 1 by 1 what the C API
= Mysql returns. The multiplier of 3 hints that a 3-byte charset gets
used in one case and a 1-byte charset in the other
Without information on the character sets used, this cannot be
verified. You need to provide character set information
[2009-10-22 18:02:12] aavolkoff at gmail dot com
Description:
Value of length column for fetch_fields() is incorrect.
eg: MySQL version: 5.0.37
Reproduce code:
---
I have table Users:
name = id; type = INT; length = 11.
name = name; type = VARCHAR; length = 200.
name = description; type = VARCHAR; length = 200.
Code:
//$mysqli defined earlier
$query= SELECT * FROM `Users` LIMIT 0;
$query_result = $mysqli-real_query($query);
if ($query_result)
{
$mysqli_result = $mysqli-use_result();
$mysqli_fields = $mysqli_result-fetch_fields();
$mysqli_result-free_result();
print_r($mysqli_fields);
}
Expected result:
Array (
[0] = stdClass Object (
[name] = id
[orgname] = id
[table] = Users
[orgtable] = Users
[def] =
[max_length] = 0
[length] = 11
[charsetnr] = 63
[flags] = 49667
[type] = 3
[decimals] = 0 )
[1] = stdClass Object (
[name] = name
[orgname] = name
[table] = Users
[orgtable] = Users
[def] =
[max_length] = 0
[length] = 200
[charsetnr] = 33
[flags] = 0
[type] = 253
[decimals] = 0 )
[2] = stdClass Object (
[name] = description
[orgname] = description
[table] = Users
[orgtable] = Users
[def] =
[max_length] = 0
[length] = 200
[charsetnr] = 33
[flags] = 0
[type] = 253
[decimals] = 0 )
)
Actual result:
--
Array (
[0] = stdClass Object (
[name] = id
[orgname] = id
[table] = Users
[orgtable] = Users
[def] =
[max_length] = 0
[length] = 11
[charsetnr] = 63
[flags] = 49667
[type] = 3
[decimals] = 0 )
[1] = stdClass Object (
[name] = name
[orgname] = name
[table] = Users
[orgtable] = Users
[def] =
[max_length] = 0
[length] = 600
[charsetnr] = 33
[flags] = 0
[type] = 253
[decimals] = 0 )
[2] = stdClass Object (
[name] = description
[orgname] = description
[table] = Users
[orgtable] = Users
[def] =
[max_length] = 0
[length] = 600
[charsetnr] = 33
[flags] = 0
[type] = 253
[decimals] = 0 )
)
Parameter length of array elements is incorrect (600, but not 200).
When I change length in PhpMyAdmin to 150 code says that length is
450.
When I change length in PhpMyAdmin to 1 code says that length is 3.
--
Edit this bug report at http://bugs.php.net/?id=49961edit=1
#49961 [NEW]: Value of length column for fetch_fields() is incorrect.
From: aavolkoff at gmail dot com
Operating system: Linux l9.in-solve.ru 2.6.26-r9-s
PHP version: 5.2.11
PHP Bug Type: MySQLi related
Bug description: Value of length column for fetch_fields() is incorrect.
Description:
Value of length column for fetch_fields() is incorrect.
eg: MySQL version: 5.0.37
Reproduce code:
---
I have table Users:
name = id; type = INT; length = 11.
name = name; type = VARCHAR; length = 200.
name = description; type = VARCHAR; length = 200.
Code:
//$mysqli defined earlier
$query= SELECT * FROM `Users` LIMIT 0;
$query_result = $mysqli-real_query($query);
if ($query_result)
{
$mysqli_result = $mysqli-use_result();
$mysqli_fields = $mysqli_result-fetch_fields();
$mysqli_result-free_result();
print_r($mysqli_fields);
}
Expected result:
Array (
[0] = stdClass Object (
[name] = id
[orgname] = id
[table] = Users
[orgtable] = Users
[def] =
[max_length] = 0
[length] = 11
[charsetnr] = 63
[flags] = 49667
[type] = 3
[decimals] = 0 )
[1] = stdClass Object (
[name] = name
[orgname] = name
[table] = Users
[orgtable] = Users
[def] =
[max_length] = 0
[length] = 200
[charsetnr] = 33
[flags] = 0
[type] = 253
[decimals] = 0 )
[2] = stdClass Object (
[name] = description
[orgname] = description
[table] = Users
[orgtable] = Users
[def] =
[max_length] = 0
[length] = 200
[charsetnr] = 33
[flags] = 0
[type] = 253
[decimals] = 0 )
)
Actual result:
--
Array (
[0] = stdClass Object (
[name] = id
[orgname] = id
[table] = Users
[orgtable] = Users
[def] =
[max_length] = 0
[length] = 11
[charsetnr] = 63
[flags] = 49667
[type] = 3
[decimals] = 0 )
[1] = stdClass Object (
[name] = name
[orgname] = name
[table] = Users
[orgtable] = Users
[def] =
[max_length] = 0
[length] = 600
[charsetnr] = 33
[flags] = 0
[type] = 253
[decimals] = 0 )
[2] = stdClass Object (
[name] = description
[orgname] = description
[table] = Users
[orgtable] = Users
[def] =
[max_length] = 0
[length] = 600
[charsetnr] = 33
[flags] = 0
[type] = 253
[decimals] = 0 )
)
Parameter length of array elements is incorrect (600, but not 200).
When I change length in PhpMyAdmin to 150 code says that length is
450.
When I change length in PhpMyAdmin to 1 code says that length is 3.
--
Edit bug report at http://bugs.php.net/?id=49961edit=1
--
Try a snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=49961r=trysnapshot52
Try a snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=49961r=trysnapshot53
Try a snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=49961r=trysnapshot60
Fixed in SVN:
http://bugs.php.net/fix.php?id=49961r=fixed
Fixed in SVN and need be documented:
http://bugs.php.net/fix.php?id=49961r=needdocs
Fixed in release:
http://bugs.php.net/fix.php?id=49961r=alreadyfixed
Need backtrace:
http://bugs.php.net/fix.php?id=49961r=needtrace
Need Reproduce Script:
http://bugs.php.net/fix.php?id=49961r=needscript
Try newer version:
http://bugs.php.net/fix.php?id=49961r=oldversion
Not developer issue:
http://bugs.php.net/fix.php?id=49961r=support
Expected behavior:
http://bugs.php.net/fix.php?id=49961r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=49961r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=49961r=submittedtwice
register_globals:
http://bugs.php.net/fix.php?id=49961r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=49961r=php4
Daylight Savings:http://bugs.php.net/fix.php?id=49961r=dst
IIS Stability:
http://bugs.php.net/fix.php?id=49961r=isapi
Install GNU Sed:
http://bugs.php.net/fix.php?id=49961r=gnused
Floating point limitations:
http://bugs.php.net/fix.php?id=49961r=float
No Zend Extensions:
http://bugs.php.net/fix.php?id=49961r=nozend
MySQL Configuration Error:
http://bugs.php.net/fix.php?id=49961r=mysqlcfg
