"Deprecation" of implicit joins mentioned in language reference?

[Mark Rotteveel]

The Firebird Language Reference mentions a few times that implicit joins
(e.g. `select * from employee, project`) are deprecated and might be
removed in a future version (e.g. at [1]).

However, this syntax is still very much part of the SQL standard, and I
think it is unlikely to ever get removed from the standard. Does anyone
know the origin of the claim it might get removed in a future version?

I think it is best to remove this claim and maybe just replace it with
something saying people should prefer explicit joins.

[1]:
https://www.firebirdsql.org/file/documentation/html/en/refdocs/fblangref40/firebird-40-language-reference.html#fblangref40-dml-select-joins-implicit

Mark
--
Mark Rotteveel

[Dmitry Yemanov]

23.05.2023 12:50, Mark Rotteveel wrote:

> The Firebird Language Reference mentions a few times that implicit joins
> (e.g. `select * from employee, project`) are deprecated and might be
> removed in a future version (e.g. at [1]).
>
> However, this syntax is still very much part of the SQL standard, and I
> think it is unlikely to ever get removed from the standard. Does anyone
> know the origin of the claim it might get removed in a future version?

Nope.

> I think it is best to remove this claim and maybe just replace it with
> something saying people should prefer explicit joins.

Agreed.


Dmitry

[Mark Rotteveel]

On 23-05-2023 12:34, Dmitry Yemanov wrote:
> 23.05.2023 12:50, Mark Rotteveel wrote:
>
>> The Firebird Language Reference mentions a few times that implicit
>> joins (e.g. `select * from employee, project`) are deprecated and
>> might be removed in a future version (e.g. at [1]).
>>
>> However, this syntax is still very much part of the SQL standard, and
>> I think it is unlikely to ever get removed from the standard. Does
>> anyone know the origin of the claim it might get removed in a future
>> version?
>
> Nope.

I also found it mentioned in the old language reference updates for 2.0
and 2.5 (e.g. see [1]), but there is no mention of deprecation in the
Firebird 2.0 release notes (explicit `CROSS JOIN` was introduced in
Firebird 2.0), and I haven't found a tracker ticket for this.

>
>> I think it is best to remove this claim and maybe just replace it with
>> something saying people should prefer explicit joins.
>
> Agreed.

Ok, I'll make the changes.


[1]:
https://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-select.html#langrefupd25-join-crossjoin
--
Mark Rotteveel