[MDEV-25755] Incomplete documentation for the `WITH` clause Created: 2021-05-21  Updated: 2021-06-19

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

Type: Bug Priority: Trivial
Reporter: Riccardo Paolo Bestetti Assignee: Ian Gilfillan
Resolution: Unresolved Votes: 0
Labels: None


 Description   

https://mariadb.com/kb/en/with/

The `WITH` clause supports multiple CTEs in a single statement, e.g.:

WITH a AS (SELECT 1),
b AS (SELECT 2)
SELECT a.*, b.* FROM a, b

This (as far as I can see) is not documented anywhere.

In my opinion, it should be documented at a minimum by changing the documented syntax to reflect the functionality, and optionally by mentioning it explicitly.


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