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

ID: 33717 Updated by: wez@php.net 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: 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")); Previous Comments: ------------------------------------------------------------------------ [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