Re: [sqlite] [sqlite-dev] query on sqlite3_open16
> According to documentation on CreateFile() function: "In the ANSI > version of this function, the name is limited to MAX_PATH characters. > To extend this limit to 32,767 wide characters, call the Unicode > version of the function and prepend "\\?\" to the path." > > SQLite is already calling CreateFileW() function so all you need is to > prepend your file name with "\\?\". Last time I tried this (1 year or so) that was not enough, you also had to compile with an increased max path define because the IO system. I reported a bug on it at the time. William Bardwell wbard...@curl.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Are callbacks re-entrant and can you setjmp/throw?
> I am working on a language binding to SQLite, and I am trying to > figure out what features can safely be made available to untrusted > code. And I am trying to figure out if I can make > callbacks/handlers/authorizer safe for untrusted code, I suspect not. > So, is it safe to make normal SQLite API calls from inside a SQLite > callback/handler? Is it safe to setjmp/throw out of a callback/handler? > Basically is the state of the statement and database in a consistent > state when callbacks/handlers are called? So, in my tests reentrancy seems to work, I can do various SQLite calls from inside a callback/handler. setjmp/throw out of a callback seems to work sometimes, but not always, sqlite3_exec() leaves un-finalized statements around if you do that. And it seems like that is asking for trouble in general, so I will definately disallow exceptions in callbacks in my language binding. William Bardwell [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] binding to parameters in PRAGMA statements doesn't work
Although it is certainly not a critical thing, it would be nice if binding a table-name parameter in a PRAGMA statement worked. executing "PRAGMA table_info (?)" produces a SYNTAX error. William Bardwell [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Are callbacks re-entrant and can you setjmp/throw?
I am working on a language binding to SQLite, and I am trying to figure out what features can safely be made available to untrusted code. And I am trying to figure out if I can make callbacks/handlers/authorizer safe for untrusted code, I suspect not. So, is it safe to make normal SQLite API calls from inside a SQLite callback/handler? Is it safe to setjmp/throw out of a callback/handler? Basically is the state of the statement and database in a consistent state when callbacks/handlers are called? William Bardwell [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] binding to missing indexes with ?NNN parameters is odd
If I have parameters like "?3, ?" then the parameter count is 4, but I can still bind to indexes 1 and 2. Is this on purpose? Is this a good thing? Is there any way to detect that the missing indexes are missing, parameter_index and parameter_name don't provide any indication? Thanks. William Bardwell [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users