ID: 33005
User updated by: dan at yes dot lt
Reported By: dan at yes dot lt
-Status: Feedback
+Status: Open
Bug Type: MySQLi related
Operating System: winxp
-PHP Version: 5CVS-2005-05-11 (dev)
+PHP Version: 5CVS-2005-05-13 (dev)
Assigned To: andrey
New Comment:
I've tried to update libmysql to 4.1.11 and to 5.0.4-beta - this wont
help... Also - where can I get the newest php_mysqli.dll ? The latest
builds are going without it - may be this is a problem ?
Previous Comments:
------------------------------------------------------------------------
[2005-05-12 21:33:25] [EMAIL PROTECTED]
Cannot reproduce with PHP 5.1-dev, libmysql 4.1.12 and MySQL
5.0.6-beta.
Can you try upgrading your client library? Thanks!
------------------------------------------------------------------------
[2005-05-11 10:52:52] dan at yes dot lt
PHP Version 5.0.5-dev
MySQLi Client API version 4.1.7
MySQL Server version: 5.0.4-beta
------------------------------------------------------------------------
[2005-05-11 09:36:37] [EMAIL PROTECTED]
Can't reproduce
Connecting to MySQL 4.1 returns
int(1)
float(1.23)
Connectiong to MySQL 5.0 returns
int(1)
string(4) "1.23"
Which MySQL client library and server do you use?
------------------------------------------------------------------------
[2005-05-11 07:58:39] dan at yes dot lt
Description:
------------
mysqli do not supports float type neither in results nor in params. for
result it returns NULL instead of float, for params there is no type
letter for float type...
Reproduce code:
---------------
$db = new mysqli(...);
$st = $db->prepare("SELECT 1.23 AS test");
$st->execute();
$st->store_result();
var_dump($st->num_rows);
$st->bind_result($x);
$st->fetch();
$st->free_result();
$st->close();
var_dump($x);
Expected result:
----------------
int(1)
float(1.23)
Actual result:
--------------
int(1)
NULL
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=33005&edit=1
