[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