[rt-devel] DBIx::SearchBuilder ApplyLimits for Oracle

Brook Schofield B.Schofield at mailbox.gu.edu.au
Thu Mar 13 19:24:42 EST 2003


At 03:13 PM 13/03/2003 +0100, BEHAL,PAVEL (HP-Czechia,ex1) wrote:
>There are some more issues to solve with Oracle.

What are the remaining issues with Oracle?

I'm going to finish running up an RT dev environment on my Mac tonight. 
Hopefully I'll have a good weekend of RT/Oracle hacking ahead of me. My 
institution runs on Oracle so RT isn't an option for a wider audience 
without full Oracle support.

What other Oracle tips/problems can people suggest?

>5) I am unsure about one thing in Brook's patch. During paging, the latest
>row from previous page is the first rown of next page. I think, this
>intended and correct. Am I right?

This is what RT currently does under MySQL so I am guessing that it should 
be the same behaviour under Oracle. So for a search result of 10 the pages 
displayed will be: 1 - 10, 10 - 19, 19 - 28. Which is also the numeric 
count at the bottom of the Search/Listing.html page.

>6) Brook, you have suggested to remove the
>"$self->_ApplyLimits(\$QueryString) unless ($all);" from _DoCount. Jesee,
>is this safe also in MySQL and PostgreSQL? I have not tested it.

count(*) will only return ONLY ONE ROW - ever. Unless that count(*) query 
also has a group by clause. Since SearchBuilder doesn't use group by in its 
_DoCount then the removal of ApplyLimits for every database is a good thing.

-Brook

=========================================================================
=     _/_/_/ _/_/_/ _/_/_/ _/_/_/ _/  _/ Brook Schofield                =
=    _/  _/ _/  _/ _/  _/ _/  _/ _/ _/   B.Schofield at griffith.edu.au    =
=   _/_/   _/_/_/ _/  _/ _/  _/ _/_/     Ph: +61 7 387 53779 - WCN 0.28 =
=  _/  _/ _/ _/  _/  _/ _/  _/ _/ _/     Directory Services Integration =
= _/_/_/ _/  _/ _/_/_/ _/_/_/ _/  _/     Griffith University QLD 4111   =
=========================================================================




More information about the Rt-devel mailing list