Home » Database » MDB2_Driver_sqlite » Bug #6599

[2006-01-26 17:18 UTC] coz at metamule dot com

Description:
------------
Using sqlite:///:memory: doesn't open a db in memory, it tries to open a real file.

Test script:
---------------
function sqll_cache(&$dataArray){
$dsn = "sqlite:///:memory:";
$options = NULL;
$SQDB = DB::connect($dsn,$options);
$SQDB->query("create table data (data varchar(32))");
if(!$set){
$sth = $SQDB->prepare("insert into data (data) values (?)");
$set = 1;
}
if(is_array($dataArray)){
foreach($dataArray as $x){
$SQDB->execute($sth,array($x));
}
}
$SQDB->query("create index data_idx on data (data)");
return $SQDB;
}

Expected result:
----------------
Should take an array of data and put it in a sqlite table in memory

Actual result:
--------------
Warning: touch() [function.touch]: Unable to create file :memory: because Permission denied in /usr/local/lib/php/DB/sqlite.php on line 117