date:20091107

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
>   
Hi Ted,

Go to Database -> Connect Database -> Select SQLite Database -> Browse 
to the new file.
It opens this SQLite file.

- Gary



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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 some package happy.
> > 
> > If my Linux box were up, it would be a no-brainer.  I'd compile it
> > for SQLite.  But as is well known, Windows users don't have that
> > option.
> 
> I don't at all understand what you are talking about. It's not like
> Windows comes preinstalled with Apache, MySQL or PHP any more than it
> does SQLite. What is this "package" that you need to keep "happy"?
> 
> Igor Tandetnik
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

WAMP ia an installable package for Windows that gives the Windows user
Apache, MySQL, and PHP.  I'd like to see SQLite instead of MySQL as the
database.

Ted
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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.  I'd compile it for
> SQLite.  But as is well known, Windows users don't have that option.

I don't at all understand what you are talking about. It's not like Windows 
comes preinstalled with Apache, MySQL or PHP any more than it does SQLite. What 
is this "package" that you need to keep "happy"?

Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[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 as is well known, Windows users don't have that option.

Ted
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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 conflicts.

Thanks for your reply.

> From: slav...@bigfraud.org
> Date: Sat, 7 Nov 2009 23:55:52 +
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Avoiding "Ambigious column"?
> 
> 
> 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:
> >
> > SELECT SUM(Salary - TotalSpent) / 100 FROM ((T2 NATURAL JOIN T4)) 
> > NATURAL JOIN (T2 NATURAL JOIN T3);
> >
> > Why is this so?
> 
> Because there's no longer any reason to wonder if the Salary column 
> could come from T2 NATURAL JOIN T4: you haven't referred to either of 
> them directly.
> 
> Another way to get rid of the error message would be to specify 
> T2.Salary or T3.Salary.
> 
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

_
Nya Windows 7 gör allt lite enklare. Hitta en dator som passar dig!
http://windows.microsoft.com/shop
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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:
>
> SELECT SUM(Salary - TotalSpent) / 100 FROM ((T2 NATURAL JOIN T4))  
> NATURAL JOIN (T2 NATURAL JOIN T3);
>
> Why is this so?

Because there's no longer any reason to wonder if the Salary column  
could come from T2 NATURAL JOIN T4: you haven't referred to either of  
them directly.

Another way to get rid of the error message would be to specify  
T2.Salary or T3.Salary.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[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 ((T2 NATURAL JOIN T4)) NATURAL JOIN 
(T2 NATURAL JOIN T3);

 

 

Why is this so?
  
_
Nya Windows 7 - Hitta en dator som passar dig! Mer information. 
http://windows.microsoft.com/shop
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[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 checked Main->Open the last used database box,
but it doesn't work.  Is there something I'm missing?

Ted
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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 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_version();
> SELECT sqlite_source_id();
> 
> Thanks!
> 
> D. Richard Hipp
> d...@hwaci.com
> 
> 
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
  
_
Lagra alla dina foton på Skydrive. Det är enkelt och säkert!
http://www.skydrive.live.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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, 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
> 
> 
> Try that again using 3.6.20.
> 
> That problem was fixed by http://www.sqlite.org/src/vinfo/ 
> 6fe63711754on 2009-10-19.
> 
> D. Richard Hipp
> d...@hwaci.com
> 
> 
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
  
_
Nya Windows 7 gör allt lite enklare. Hitta en dator som passar dig!
http://windows.microsoft.com/shop
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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_version();
 SELECT sqlite_source_id();

Thanks!

D. Richard Hipp
d...@hwaci.com

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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


Try that again using 3.6.20.

That problem was fixed by http://www.sqlite.org/src/vinfo/ 
6fe63711754on  2009-10-19.

D. Richard Hipp
d...@hwaci.com



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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) natural join (test1);
10

 

Present in both 3.6.19 and 3.6.20 (where it was fixed, according to the ticket).

 

Thanks.

 
> Date: Sat, 7 Nov 2009 15:54:42 +
> From: simon.james.dav...@googlemail.com
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] 3.6.20 NATURAL self-join still not fixed
> 
> 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 INTEGER NOT NULL,
> >  T6 INTEGER NOT NULL,
> >  T7 INTEGER NOT NULL,
> >  DT DATE NOT NULL,
> >  T8 INTEGER NOT NULL,
> >  T9 INTEGER NOT NULL,
> >  T10 INTEGER NOT NULL,
> >  T11 INTEGER NOT NULL,
> >
> >  UNIQUE (T2, T1)
> > );
> >
> > -- Fill with random data!
> >
> > COMMIT TRANSACTION;
> >
> >
> > SELECT COUNT(*) FROM Test; -- Blistering fast!
> >
> > SELECT COUNT(*) FROM Test NATURAL JOIN Test; -- "Never" terminates
> >
> > I have over 50,000 entries...
> 
> 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> CREATE TABLE Test1
> ...> (
> ...> T1 INTEGER NOT NULL,
> ...> T2 INTEGER NOT NULL
> ...> );
> sqlite>
> sqlite> CREATE TABLE Test2
> ...> (
> ...> T1 INTEGER NOT NULL,
> ...> T2 INTEGER NOT NULL
> ...> );
> sqlite>
> sqlite> insert into test1 values( 1, 1 );
> sqlite> insert into test1 values( 2, 2 );
> sqlite> insert into test1 values( 3, 3 );
> sqlite> insert into test1 values( 4, 4 );
> sqlite> insert into test1 values( 5, 5 );
> sqlite> insert into test1 values( 6, 6 );
> sqlite> insert into test1 values( 7, 7 );
> sqlite> insert into test1 values( 8, 8 );
> sqlite> insert into test1 values( 9, 9 );
> sqlite> insert into test1 values( 10, 10 );
> sqlite>
> sqlite> insert into test2 values( 1, 1 );
> sqlite> insert into test2 values( 2, 2 );
> sqlite> insert into test2 values( 3, 3 );
> sqlite> insert into test2 values( 4, 4 );
> sqlite> insert into test2 values( 5, 5 );
> sqlite> insert into test2 values( 6, 6 );
> sqlite> insert into test2 values( 7, 7 );
> sqlite> insert into test2 values( 8, 8 );
> sqlite> insert into test2 values( 9, 9 );
> sqlite> insert into test2 values( 10, 10 );
> sqlite>
> sqlite>
> sqlite> select count(*) from test1 natural join test2;
> 10
> sqlite> select count(*) from test1 natural join test1;
> 100
> sqlite> select count(*) from test1 as t1 natural join test1;
> 10
> sqlite>
> 
> >
> > Thanks.
> >
> >> From: danielk1...@gmail.com
> >> To: sqlite-users@sqlite.org
> >> Date: Sat, 7 Nov 2009 11:36:52 +0700
> >> Subject: Re: [sqlite] 3.6.20 NATURAL self-join still not fixed
> >>
> 
> Regards,
> Simon
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
  
_
Nya Windows 7 - Hitta en dator som passar dig! Mer information. 
http://windows.microsoft.com/shop
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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 INTEGER NOT NULL,
>  T6 INTEGER NOT NULL,
>  T7 INTEGER NOT NULL,
>  DT DATE NOT NULL,
>  T8 INTEGER NOT NULL,
>  T9 INTEGER NOT NULL,
>  T10 INTEGER NOT NULL,
>  T11 INTEGER NOT NULL,
>
>  UNIQUE (T2, T1)
> );
>
> -- Fill with random data!
>
> COMMIT TRANSACTION;
>
>
> SELECT COUNT(*) FROM Test; -- Blistering fast!
>
> SELECT COUNT(*) FROM Test NATURAL JOIN Test; -- "Never" terminates
>
> I have over 50,000 entries...

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> CREATE TABLE Test1
   ...> (
   ...>  T1 INTEGER NOT NULL,
   ...>  T2 INTEGER NOT NULL
   ...> );
sqlite>
sqlite> CREATE TABLE Test2
   ...> (
   ...>  T1 INTEGER NOT NULL,
   ...>  T2 INTEGER NOT NULL
   ...> );
sqlite>
sqlite> insert into test1 values( 1, 1 );
sqlite> insert into test1 values( 2, 2 );
sqlite> insert into test1 values( 3, 3 );
sqlite> insert into test1 values( 4, 4 );
sqlite> insert into test1 values( 5, 5 );
sqlite> insert into test1 values( 6, 6 );
sqlite> insert into test1 values( 7, 7 );
sqlite> insert into test1 values( 8, 8 );
sqlite> insert into test1 values( 9, 9 );
sqlite> insert into test1 values( 10, 10 );
sqlite>
sqlite> insert into test2 values( 1, 1 );
sqlite> insert into test2 values( 2, 2 );
sqlite> insert into test2 values( 3, 3 );
sqlite> insert into test2 values( 4, 4 );
sqlite> insert into test2 values( 5, 5 );
sqlite> insert into test2 values( 6, 6 );
sqlite> insert into test2 values( 7, 7 );
sqlite> insert into test2 values( 8, 8 );
sqlite> insert into test2 values( 9, 9 );
sqlite> insert into test2 values( 10, 10 );
sqlite>
sqlite>
sqlite> select count(*) from test1 natural join test2;
10
sqlite> select count(*) from test1 natural join test1;
100
sqlite> select count(*) from test1 as t1 natural join test1;
10
sqlite>

>
> Thanks.
>
>> From: danielk1...@gmail.com
>> To: sqlite-users@sqlite.org
>> Date: Sat, 7 Nov 2009 11:36:52 +0700
>> Subject: Re: [sqlite] 3.6.20 NATURAL self-join still not fixed
>>

Regards,
Simon
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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,
 DT DATE NOT NULL,
 T8 INTEGER NOT NULL,
 T9 INTEGER NOT NULL,
 T10 INTEGER NOT NULL,
 T11 INTEGER NOT NULL,
 
 UNIQUE (T2, T1)
);

 

-- Fill with random data!

 

COMMIT TRANSACTION;

 

 

SELECT COUNT(*) FROM Test; -- Blistering fast!

SELECT COUNT(*) FROM Test NATURAL JOIN Test; -- "Never" terminates

 

I have over 50,000 entries...

 

Thanks.
 
> From: danielk1...@gmail.com
> To: sqlite-users@sqlite.org
> Date: Sat, 7 Nov 2009 11:36:52 +0700
> Subject: Re: [sqlite] 3.6.20 NATURAL self-join still not fixed
> 
> 
> On Nov 7, 2009, at 5:25 AM, Kristoffer Danielsson wrote:
> 
> >
> > http://www.sqlite.org/src/info/b73fb0bd64
> >
> >
> >
> > Just tried this statement in SQLite 3.6.20:
> >
> > SELECT COUNT(*) FROM X NATURAL JOIN X; <--- "never" terminates
> 
> What is the schema and contents of table X that causes this?
> 
> Dan.
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
  
_
Nya Windows 7 - Hitta en dator som passar dig! Mer information. 
http://windows.microsoft.com/shop
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Firefox SQLite Manager extension troubles.

Re: [sqlite] WASP

Re: [sqlite] WASP

[sqlite] WASP

Re: [sqlite] Avoiding "Ambigious column"?

Re: [sqlite] Avoiding "Ambigious column"?

[sqlite] Avoiding "Ambigious column"?

[sqlite] Firefox SQLite Manager extension troubles.

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

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

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

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

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

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

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

15 matches

Site Navigation

Mail list logo

Footer information