| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.5.0b4 |
| Bug #6599 | sqlite:///:memory: trys to open file | ||
|---|---|---|---|
| Submitted: | 2006-01-26 17:18 UTC | ||
| From: | coz at metamule dot com | Assigned: | lsmith |
| Status: | Closed | Package: | MDB2_Driver_sqlite |
| PHP Version: | 5.0.5 | OS: | SunOS 5.8 Generic_11 |
| Roadmaps: | (Not assigned) | ||
[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
Comments
[2006-03-11 10:22 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2006-03-17 08:47 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!