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

[ando@sys-net.it]

>> 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
mailto:pierangelo.masarati@sys-net.it


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