[rt-devel] Debugging print statements

[Jesse Vincent]

On Wed, Feb 19, 2003 at 02:31:28PM +0000, Ian Grant wrote:
> Dear RT types,
> 
> I am attempting to create a SearchBuilder driver for Sybase/Microsoft SQL 
> Server databases. I have some of the basics working but have hit some problems 
> I could use help with.

I suspect that SearchBuilder's query building probably needs to be
refactored to call out to methods in Handle, to allow easier
customization....It's a fairly serious refactoring job, if you're up for
it.

> 
> The first is that SearchBuilder does SELECTs always using the DISTINCT 
> keyword. This is a problem because SQL Server will not allow DISTINCT with 
> large object (type TEXT) fields. (They can be up to 2GB and I suppose the 
> comparisons could get expensive.)
> 
> My question is: Does anyone know, or, failing that, can anyone suggest a way 
> to find out where the DISTINCT clauses are really necessary?

Er. Just about everywhere. DBIx::SearchBuilder desperately needs the set
of rows returned to be unique.

> I have not yet determined whether there is a means of telling SQL Server to 
> return rows distinct in every column not TEXT type.
> 
> Regards
> Ian
> -- 
> Ian Grant, Computer Lab., William Gates Building, JJ Thomson Ave., Cambridge
> Phone: +44 1223 334420
> 
> 
> 
> -- 
> Ian Grant, Computer Lab., William Gates Building, JJ Thomson Ave., Cambridge
> Phone: +44 1223 334420
> 
> 
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.