|Subject||Re: [Firebird-Architect] XSQLDA/XSQLVAR issues|
> >The only problem i currently can see is what field would have theprecedence
> >in this query :TableX.F2
> > F1 AS F2
> > TableX
> > F2 = 1
> >Where TableX has F1 and F2 as fields, should it use TableX.F1 or
> >in the WHERE clause? May be a stupid example, but you can imagine...Actually, I disagree. IMO, it should raise an error so that it shows
> An interesting philosophical question. It could be left undefined,
> defined in one of at least three ways, or an explicit error. I favor
> the first because the second encourages doing bonehead things and the
> third strikes me as unnecessarily nasty.
the user that there is a field "F2" in the table. That way, "undefined"
behaviour can be avoided.
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL