On Mon, Feb 28, 2011 at 6:23 PM, John wrote:
> Reading a little more about how the vdbe works and a little of the source
> code, I then examined the output of explain. Explain shows that the
> statement:
>
> select distinct x, abs(x) from T ;
>
> First loops over my T
>>
>>
>>
>> From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
>> behalf of John [j...@rkroll.com]
>> Sent: Sunday, February 27, 2011 8:37 PM
>> To: General Discussion of SQLite Database
>
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
> behalf of John [j...@rkroll.com]
> Sent: Sunday, February 27, 2011 8:37 PM
> To: General Discussion of SQLite Database
> Subject: EXT :[sqlite] "select disctict" calles tcl functions twice?
&g
: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of John [j...@rkroll.com]
Sent: Sunday, February 27, 2011 8:37 PM
To: General Discussion of SQLite Database
Subject: EXT :[sqlite] "select disctict" calles tcl functions twice?
Hi All,
In my example
Hi All,
In my example code here the function "fun" is called twice for each row. The
first set of calls is made in the initial evaluation of the sql statement, then
"fun" is called again as the tcl body is evaluated for each row. I wasn't
expecting this.
Thanks,
John
5 matches
Mail list logo