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
>
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
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.
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
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
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 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 (
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
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
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
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
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
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
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
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,
15 matches
Mail list logo