php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #74184 Sqlite PDO doesn't support URI filenames
Submitted: 2017-02-28 18:05 UTC Modified: -
Votes:2
Avg. Score:5.0 ± 0.0
Reproduced:2 of 2 (100.0%)
Same Version:0 (0.0%)
Same OS:1 (50.0%)
From: sergey dot payu at gmail dot com Assigned:
Status: Open Package: PDO SQLite
PHP Version: master-Git-2017-02-28 (Git) OS: Any
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please — but make sure to vote on the bug!
Your email address:
MUST BE VALID
Solve the problem:
25 - 23 = ?
Subscribe to this entry?

 
 [2017-02-28 18:05 UTC] sergey dot payu at gmail dot com
Description:
------------
Current implementation of Sqlite PDO does support ":memory:", but lacks support of "file:" scheme (URI filenames). This may be essential if one wants to change VFS. Trying to use URI filenames leads to "unable to open database" error. More information on URI filename can be found on official sqlite site: https://www.sqlite.org/c3ref/open.html#urifilenameexamples

Test script:
---------------
$pdo = new PDO("sqlite:file:/opt/databases/mydb.sq2?vfs=unix-ecl"); 


Patches

sqlite_driver.c.path (last revision 2017-02-28 18:05 UTC by sergey dot payu at gmail dot com)

Add a Patch

Pull Requests

Add a Pull Request

 
PHP Copyright © 2001-2019 The PHP Group
All rights reserved.
Last updated: Mon Jul 15 22:01:26 2019 UTC