[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.

PostgreSQL works
MySQL and IBM UDB doesn't.

In any case, I applied the patch to HEAD.

Thanks for contributing, p.

Pierangelo Masarati

    SysNet - via Dossi,8 27100 Pavia Tel: +390382573859 Fax: +390382476497