This is the mail archive of the cygwin mailing list for the Cygwin project.


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

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


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]