Re: [sqlite] "select disctict" calles tcl functions twice?

2011-02-28 Thread Nico Williams
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

Re: [sqlite] "select disctict" calles tcl functions twice?

2011-02-28 Thread John
>> >> >> >> 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 >

Re: [sqlite] "select disctict" calles tcl functions twice?

2011-02-28 Thread John
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

Re: [sqlite] "select disctict" calles tcl functions twice?

2011-02-28 Thread Black, Michael (IS)
: 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

[sqlite] "select disctict" calles tcl functions twice?

2011-02-27 Thread John
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