Re: Call for testing experimental patch

["Chris Travers" <..hidden..>]

You misunderstand.  id is unique within ap.  It is not unique between ap and gl, for example.  I don't think that distinct adds anything.

On 9/13/06, David Tangye <..hidden..> wrote:

On Mon, 2006-09-11 at 22:49 -0700, Chris Travers wrote:
> This patch will hopefully get included with the next version but I
> want to put it through some more vetting first.  I am testing it on my
> production machines.
A small thought: Would 'distinct' and 'order by' improve it? distinct
will merge duplicate values, and order by .. well why not?
eg

insert into id_tracker (id, table_name) SELECT distinct id, 'ap' FROM ap
order by id;



-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Ledger-smb-devel mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel