[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: (ITS#3629) patch for problem with aggregated attributes in sql-back



> The patch looks fine, although I'm not sure that ordering by the alias 
> name will work on all RDBMSes; while (although not being a good enough 
> reason) with PostgreSQL the order by clause works fine with both 
> aggregate data and alias name.  Maybe we'd better provide an extra 
> switch in ldap_attr_mappings to handle these cases.
> 

IMHO adding an extra switch is not the Best Solution, because it adds
complexity. On the other hand, if that is what it takes... The RDBMS I
used when I got hit by the problem was Oracle 9i. It might be worth
the effort to investigate whether any major RDBMses fails to support
the use of aliases in ORDER BY clauses.

-- 
Kjell-Magne