| Subject | Re: [firebird-support] Re: Automatic Firing of Query. |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2017-08-17T13:33:57Z |
On 2017-08-17 13:40, Svein Erling Tysvær setysvar@...
[firebird-support] wrote:
If you mean you "would be surprised if it would be a database library",
why? For example Jaybird still has some SQL-89 style joins in its
database metadata, even though I dislike SQL-89 style joins. There are
simply more important things to tackle, and in some case keeping the
SQL-89 style join means I don't have to consider if I need to add a
where clause (or an AND) or not when generating the where condition,
which keeps things simpler.
Mark
[firebird-support] wrote:
> Since the query contains 'from RDB$RELATION_FIELDS R, RDB$FIELDS FIf what?
> where ... R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME' (SQL-89 type of JOIN)
> and not 'from RDB$RELATION_FIELDS R JOIN RDB$FIELDS F ON
> R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME' (SQL-92 type of JOIN), I would
> be surprised if database access library.
If you mean you "would be surprised if it would be a database library",
why? For example Jaybird still has some SQL-89 style joins in its
database metadata, even though I dislike SQL-89 style joins. There are
simply more important things to tackle, and in some case keeping the
SQL-89 style join means I don't have to consider if I need to add a
where clause (or an AND) or not when generating the where condition,
which keeps things simpler.
Mark