This is the mail archive of the
cygwin
mailing list for the Cygwin project.
Re: [bug] Something fishy going on with sqlite3...
On 3/15/2012 2:14 PM, Achim Gratz wrote:
> Renà Berber <r.berber@computer.org> writes:
>> The obvious question: what is your $TMP ?
>
> Obvious maybe â but TMP doesn't get invoked. :-)
>
> SQLite tries to create the file in the current working directory.
> Again, if I do that from a windows console window, all is well, if I do
> it from mintty I get an access denied error.
Right. Problem is I can't reproduce the error.
I'm not using a snapshot, I'm at "1.7.11(0.260/5/3) 2012-02-24", and the
operation you show, using mintty:
$ sqlite3 test
SQLite version 3.7.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .databases
seq name file
--- --------------- --------------------------------------
0 main C:\Cygwin\home\rberber\test
sqlite> create TEMP TABLE two (
...> id INTEGER NOT NULL,
...> name CHAR (64) NOT NULL
...> );
sqlite> .databases
seq name file
--- --------------- ---------------------------------------
0 main C:\Cygwin\home\rberber\test
1 temp
sqlite> .schema two
CREATE TABLE two (
id INTEGER NOT NULL,
name CHAR (64) NOT NULL
);
No access denied. The file test is created in the same directory, also
.sqlite_history .
--
Renà Berber
--
Problem reports: http://cygwin.com/problems.html
FAQ: http://cygwin.com/faq/
Documentation: http://cygwin.com/docs.html
Unsubscribe info: http://cygwin.com/ml/#unsubscribe-simple