[Rt-devel] Sortorder of customfields

[Joop van de Wege]

On Fri, 28 Apr 2006 11:01:31 -0400
Jesse Vincent <jesse at bestpractical.com> wrote:

> Joop van de Wege wrote:
> > Hello All,

> > We have no clue whatsoever where that comment about orderby not being
> > the main table is going to need a groupby.
> > This is atleast not true for Oracle 9i, never has been and can be
> > removed.
> 
> I recall that this change was made at the request of a customer who had
> an oracle sorting issue. I don't doubt your analysis at all. Alex, do
> you remember the issue we were looking to solve with it?  Joop, do you
> have a proposed patch?
Patch attached, might need some cleaning up.

 
> > This solves the ordering problem with customfields with one side note
> > that to be 100% sure that you get the desired order you would need to
> > have the subselect in the order by clause, as explained in the previous
> > post.
Haven't done this part (yet). I'm not sure it is needed but I'm having
no time to look at it now

 
> > By looking at the svn repository I can see that 4254 is the last change
> > and it was introduced then. Looks like it is verbatim copied from Pg.pm
> > where this might be true.
> 
> I'm pretty sure it is, there.
Have been reading the Pg documentation but couldn't find any reference
to it but I'll trust you on this ;)

Joop


-- 
Joop van de Wege <JoopvandeWege at mococo.nl>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Oracle.diff
Type: application/octet-stream
Size: 1686 bytes
Desc: not available
Url : http://lists.bestpractical.com/pipermail/rt-devel/attachments/20060505/13b5fcea/Oracle.obj