[Date Prev][Date Next]
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.
MySQL and IBM UDB doesn't.
In any case, I applied the patch to HEAD.
Thanks for contributing, p.
SysNet - via Dossi,8 27100 Pavia Tel: +390382573859 Fax: +390382476497