ID: 42378
Comment by: uwendel at mysql dot com
Reported By: jullrich at sans dot org
Status: Assigned
Bug Type: MySQLi related
Operating System: Linux (CentOS 4.5)
PHP Version: 5.2.3
Assigned To: andrey
New Comment:
Bug is verified. I can reproduce it on a box with PHP5.2.4RC1-dev and
MySQL 5.1.20-beta.
Previous Comments:
------------------------------------------------------------------------
[2007-09-04 16:50:12] uwendel at mysql dot com
Thanks! May I also ask you for the MySQL Server version?
I've written a test which reads 100 rows from a table which has a
column that I use FORMAT() on. The test checks all *INT* types, FLOAT
and DECIMAL. So far I have not been able to reproduce your problem with
PHP 5_2 CVS and PHP 6.
I'll give it another try with your table definition...
------------------------------------------------------------------------
[2007-09-03 18:55:58] jullrich at sans dot org
as requested, the table definition:
CREATE TABLE `trends` (
`targetport` int(11) NOT NULL default '0',
`sources` double(17,4) default NULL,
`current_sources` double(17,0) default NULL,
`reports` double(17,4) default NULL,
`current_reports` double(17,0) default NULL,
`targets` double(17,4) default NULL,
`current_targets` double(17,0) default NULL,
`maxsources` int(11) default NULL,
`maxtargets` int(11) default NULL,
`maxreports` int(11) default NULL,
`trend` float default NULL,
PRIMARY KEY (`targetport`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
------------------------------------------------------------------------
[2007-09-03 14:52:13] uwendel at mysql dot com
Can you add the table definition to the bug report?
------------------------------------------------------------------------
[2007-08-23 10:42:28] [EMAIL PROTECTED]
Assigned to the Mysqli maintainer.
------------------------------------------------------------------------
[2007-08-22 11:44:28] jullrich at sans dot org
'cast' can be used as a workaround:
works: cast(format(trend,2) as char(10)))
does not work (same memory error): cast(format(trend,2) as char)
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/42378
--
Edit this bug report at http://bugs.php.net/?id=42378&edit=1
