[PHP-BUG] Bug #51386 [NEW]: mysql tries to allocate 4294967296 bytes when fetching longtext via mysqli

[email protected] ("rellig at minad dot de")
Newsgroups php.bugs
Message-ID <[email protected]>
From:             
Operating system: gentoo
PHP version:      5.2.13
Package:          MySQLi related
Bug Type:         Bug
Bug description:mysql tries to allocate 4294967296 bytes when fetching longtext via mysqli

Description:
------------
I wanted to fetch some lines in a php script via mysqli-prepared-statement
and got this
error:
Allowed memory size of 134217728 bytes exhausted (tried to allocate
4294967296 bytes)
I was confused because php reportet that this error occured at
bind_result.
After some time I figured out that it works when I turn one field with
LONGTEXT type to
VARCHAR, for example.

here is a link to my php-script:
http://paste.minad.de/?nid=216


you can look at http://bugs.mysql.com/bug.php?id=52234 too.



-- 
Edit bug report at http://bugs.php.net/bug.php?id=51386&edit=1
-- 
Try a snapshot (PHP 5.2):            http://bugs.php.net/fix.php?id=51386&r=trysnapshot52
Try a snapshot (PHP 5.3):            http://bugs.php.net/fix.php?id=51386&r=trysnapshot53
Try a snapshot (PHP 6.0):            http://bugs.php.net/fix.php?id=51386&r=trysnapshot60
Fixed in SVN:                        http://bugs.php.net/fix.php?id=51386&r=fixed
Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=51386&r=needdocs
Fixed in release:                    http://bugs.php.net/fix.php?id=51386&r=alreadyfixed
Need backtrace:                      http://bugs.php.net/fix.php?id=51386&r=needtrace
Need Reproduce Script:               http://bugs.php.net/fix.php?id=51386&r=needscript
Try newer version:                   http://bugs.php.net/fix.php?id=51386&r=oldversion
Not developer issue:                 http://bugs.php.net/fix.php?id=51386&r=support
Expected behavior:                   http://bugs.php.net/fix.php?id=51386&r=notwrong
Not enough info:                     http://bugs.php.net/fix.php?id=51386&r=notenoughinfo
Submitted twice:                     http://bugs.php.net/fix.php?id=51386&r=submittedtwice
register_globals:                    http://bugs.php.net/fix.php?id=51386&r=globals
PHP 4 support discontinued:          http://bugs.php.net/fix.php?id=51386&r=php4
Daylight Savings:                    http://bugs.php.net/fix.php?id=51386&r=dst
IIS Stability:                       http://bugs.php.net/fix.php?id=51386&r=isapi
Install GNU Sed:                     http://bugs.php.net/fix.php?id=51386&r=gnused
Floating point limitations:          http://bugs.php.net/fix.php?id=51386&r=float
No Zend Extensions:                  http://bugs.php.net/fix.php?id=51386&r=nozend
MySQL Configuration Error:           http://bugs.php.net/fix.php?id=51386&r=mysqlcfg
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.