[MDEV-23078] Standard SQL doesn't have RESTRICT in CYCLE Created: 2020-07-03  Updated: 2020-07-07  Resolved: 2020-07-07

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: 10.5.4
Fix Version/s: N/A

Type: Bug Priority: Trivial
Reporter: Markus Winand Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: recursive
Environment:

https://mariadb.com/kb/en/with/#cycle-restrict



 Description   

The documentation for CYCLE claims that RESTRICT is required in stadard SQL.

That's wrong. ISO/IEC 9075:2016-2 defines CYCLE as follows:

<cycle clause> ::=
CYCLE <cycle column list> SET <cycle mark column> TO <cycle mark value>
DEFAULT <non-cycle mark value> USING <path column>

(I havent seen RESTRICT in elder versions either).

I think this happend with MDEV-20632 on 2020-02-28 15:21 when RESTRICT was added to the MariaDB implemenation syntax, but accedenally also added to the standard SQL example.


Generated at Thu Feb 08 09:19:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.