Kjell Rilbe wrote:

> Let's say you have a master-detail relationship between table M and D.
> Now, you may want to update each M record with info from one specific D
> record each. In SQL Server you generally do this using this syntax
> (non-standard?):
>
> update M
> set ...
> from M
> inner join D on ...
> where ...

(...)

> Now, as far as I know FB doesn't support this update ... from syntax,
> but is there any other way that FB could end up mixing data from
> multiple records in this subtle way instead of throwing an exception?

Firebird 2.1 supports MERGE for that purpose. And it too has a bug: if
multiple D records match the same M record, multiple updates take place
on that M record (in unpredictable order). But (afaict) without the
silly null-dependent mixing that you describe.

So - even our *bugs* are smarter than Microsoft's! :-)


Cheers,
Paul Vinkenoog