Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.5, 10.6, 10.9(EOL)
-
None
Description
repro: https://dbfiddle.uk/1BpvGW2V
here is the same repro working for MySQL: https://dbfiddle.uk/wa8Kc48N
and for PostgreSQL: https://dbfiddle.uk/6Z-IfLMx
The failing query patten is important to be supported. In complex queries, it allows to deduplicate subqueries used later more than one without having to put them in the main select.
I would be grateful if it can be fixed.
Attachments
Issue Links
- duplicates
-
MDEV-19078 Support lateral derived tables
- Open