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
>
>
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:
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
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;
>
st1) 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
t 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
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 Da
7 matches
Mail list logo