Debugging print statements

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.

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?

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

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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

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