Re: [sqlite] Firefox SQLite Manager extension troubles.

2009-11-07 Thread Gary_Gabriel
Ted Rolle wrote: > I'm using the Firefox SQLite Manager extension. > I've renamed the database file. > I get this message: 'The file does not exist anymore: E:\Documents and > Settings\ted\Books\William R. Denslow\10' > Well, duh. > Where is the SQL database file name stored in the Firefox SQLite >

Re: [sqlite] WASP

2009-11-07 Thread Ted Rolle
On Sat, 7 Nov 2009 20:39:22 -0500 "Igor Tandetnik" wrote: > Ted Rolle wrote: > > First there was LAMP (Linux, Apache, MySQL, PHP), then WAMP > > (Windows, Apache MySQL, PHP). > > Now we need a WASP. > > > > I don't relish the thought of converting my SQLite database to > > MySQL just to keep som

Re: [sqlite] WASP

2009-11-07 Thread Igor Tandetnik
Ted Rolle wrote: > First there was LAMP (Linux, Apache, MySQL, PHP), then WAMP (Windows, > Apache MySQL, PHP). > Now we need a WASP. > > I don't relish the thought of converting my SQLite database to > MySQL just to keep some package happy. > > If my Linux box were up, it would be a no-brainer.

[sqlite] WASP

2009-11-07 Thread Ted Rolle
First there was LAMP (Linux, Apache, MySQL, PHP), then WAMP (Windows, Apache MySQL, PHP). Now we need a WASP. I don't relish the thought of converting my SQLite database to MySQL just to keep some package happy. If my Linux box were up, it would be a no-brainer. I'd compile it for SQLite. But a

Re: [sqlite] Avoiding "Ambigious column"?

2009-11-07 Thread Kristoffer Danielsson
Ok, so parentheses "hide" the columns in the present clause? There must be a common rule for this... And yes, I know you can explicitly use "table.column", but in this case the code comes from the user and conflicts with my own columns. Hence, I have to think of a way to avoid column confli

Re: [sqlite] Avoiding "Ambigious column"?

2009-11-07 Thread Simon Slavin
On 7 Nov 2009, at 10:56pm, Kristoffer Danielsson wrote: > SELECT SUM(Salary - TotalSpent) / 100 FROM (T2 NATURAL JOIN T4) > NATURAL JOIN (T2 NATURAL JOIN T3); > > Error: Ambigious column name: Salary > > However, if I add two parentheses around "T2 NATURAL JOIN T4", the > error goes away: > >

[sqlite] Avoiding "Ambigious column"?

2009-11-07 Thread Kristoffer Danielsson
SQLite 3.6.20. SELECT SUM(Salary - TotalSpent) / 100 FROM (T2 NATURAL JOIN T4) NATURAL JOIN (T2 NATURAL JOIN T3); Error: Ambigious column name: Salary However, if I add two parentheses around "T2 NATURAL JOIN T4", the error goes away: SELECT SUM(Salary - TotalSpent) / 100 FROM (

[sqlite] Firefox SQLite Manager extension troubles.

2009-11-07 Thread Ted Rolle
I'm using the Firefox SQLite Manager extension. I've renamed the database file. I get this message: 'The file does not exist anymore: E:\Documents and Settings\ted\Books\William R. Denslow\10' Well, duh. Where is the SQL database file name stored in the Firefox SQLite Manager extension? I've check

Re: [sqlite] 3.6.20 NATURAL self-join still not fixed

2009-11-07 Thread Kristoffer Danielsson
Sorry :P Seems my SQLite.exe was still 3.6.19. Downloaded the latest exe and now it works \o/ Thanks. > From: d...@hwaci.com > To: sqlite-users@sqlite.org > Date: Sat, 7 Nov 2009 11:05:39 -0500 > Subject: Re: [sqlite] 3.6.20 NATURAL self-join still not fixed > > > On Nov 7, 2009, at 1

Re: [sqlite] 3.6.20 NATURAL self-join still not fixed

2009-11-07 Thread Kristoffer Danielsson
Like I said, I'm running 3.6.20 now. Same problem. > From: d...@hwaci.com > To: sqlite-users@sqlite.org > Date: Sat, 7 Nov 2009 11:04:16 -0500 > Subject: Re: [sqlite] 3.6.20 NATURAL self-join still not fixed > > > On Nov 7, 2009, at 10:54 AM, Simon Davies wrote: > > > > I used 10,000 entries

Re: [sqlite] 3.6.20 NATURAL self-join still not fixed

2009-11-07 Thread D. Richard Hipp
On Nov 7, 2009, at 10:59 AM, Kristoffer Danielsson wrote: > > Present in both 3.6.19 and 3.6.20 (where it was fixed, according to > the ticket). In whatever environment you are running your experiment, please also run the following queries and let us know the result: SELECT sqlite_vers

Re: [sqlite] 3.6.20 NATURAL self-join still not fixed

2009-11-07 Thread D. Richard Hipp
On Nov 7, 2009, at 10:54 AM, Simon Davies wrote: > > I used 10,000 entries, and it returned in a few seconds... (using > 3.6.19) > > But there does appear to be a problem: > sqlite> select count(*) from test1 natural join test2; > 10 > sqlite> select count(*) from test1 natural join test1; > 100

Re: [sqlite] 3.6.20 NATURAL self-join still not fixed

2009-11-07 Thread Kristoffer Danielsson
Exactly my point. A few seconds is a LOT more than 0 seconds (I cancelled the query after a few seconds since it was obvious it did not do what it was supposed to). Just like in my first report, adding parentheses around the table name resolves this: sqlite> select count(*) from (test1) natu

Re: [sqlite] 3.6.20 NATURAL self-join still not fixed

2009-11-07 Thread Simon Davies
2009/11/7 Kristoffer Danielsson : > > Using SQLite 3.6.20 (SQLITE_ENABLE_STAT2=1). > > PRAGMA foreign_keys=OFF; > > BEGIN TRANSACTION; > > CREATE TABLE Test > ( >  TestID INTEGER PRIMARY KEY, >  T1 INTEGER NOT NULL, >  T2 INTEGER NOT NULL, >  T3 INTEGER NOT NULL, >  T4 INTEGER NOT NULL, >  T5 INTEG

Re: [sqlite] 3.6.20 NATURAL self-join still not fixed

2009-11-07 Thread Kristoffer Danielsson
Using SQLite 3.6.20 (SQLITE_ENABLE_STAT2=1). PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE Test ( TestID INTEGER PRIMARY KEY, T1 INTEGER NOT NULL, T2 INTEGER NOT NULL, T3 INTEGER NOT NULL, T4 INTEGER NOT NULL, T5 INTEGER NOT NULL, T6 INTEGER NOT NULL, T7 INTEGER NOT NULL,