Subject RE: Re[2]: [Firebird-Architect] View updates and upward
Author Claudio Valderrama C.
Dmitry Yemanov wrote:
> "Ann W. Harrison" <aharrison@...> wrote:
>>
>> There is a significant difference between the channge to view
>> updates and other incompatible changes we made in V1.0 and V1.5.
>> In all cases to date, the change has caused programs that had
>> run correctly to report errors.
>
> 1) select father.*
> from msys_menu
> left join msys_menu father
> on msys_menu.cod_menupai = father.cod_menu
>
> produces different results on FB 1.x and HEAD. The old results are
> wrong.
>
> 2) select * from t order by f
>
> produces different NULLs ordering on FB 1.5 and HEAD (ODS 11). The old
> results are not standard-compliant.

Furthermore, there was a change that doesn't necessarily throw errors and
happened when a UDF was corrected. I don't remember who did it:

double EXPORT IB_UDF_log(
double* a,
double* b)
{
- return (log(*a)/log(*b));
+ return (log(*b)/log(*a));
}

People argued that the old code was against the documentation or something
alike.

C.