#33717 [Asn]: crash 'apache' when a query contain ':memory:'

ID: 33717 User updated by: fhenninot at freesurf dot fr Reported By: fhenninot at freesurf dot fr Status: Assigned Bug Type: PDO related Operating System: Linux PHP Version: 5.1.0b3 Assigned To: wez New Comment: hi wez! thank you for your help! but!! If i use parameters, this don't crash apache!! ok! but if my table haven't record like the parameter (now not only '::memory') then that kill the PHP script!! I've test it on beta2 and this work properly but with beta3 crashed. Previous Comments: ------------------------------------------------------------------------ [2005-07-15 23:33:22] wez@php.net Doh. Like this: $stmt = $db->prepare("SELECT * from database where location like ?"); $stmt->execute(array(":memory:")); ------------------------------------------------------------------------ [2005-07-15 23:32:41] wez@php.net BTW, if you want a workaround, you can use parameters like this: $stmt = $db->prepare("SELECT * from database where location like ?"); $stmt->execute(array(":memory")); ------------------------------------------------------------------------ [2005-07-15 23:30:54] wez@php.net Sounds like a pretty nasty problem to me. ------------------------------------------------------------------------ [2005-07-15 23:01:05] fhenninot at freesurf dot fr Description: ------------ This is a bug, i think, in PHP-5.1B3 When i search a string named ':memory:' into a database field, this crash apache with the message : [Fri Jul 15 20:17:11 2005] [notice] child pid 11338 exit signal Segmentation fault (11) I can test it on linux only! and with some apache version. Reproduce code: --------------- <?php $PDO_DB = new PDO('sqlite:/usr/local/apache2/htdocs/SQLiteManager-1.1.2CVS/include/config3.db', '', ''); $res = $PDO_DB->query("SELECT * FROM database WHERE location like ':memory:'"); ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=33717&edit=1