Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL), 10.4(EOL), 10.5(EOL), 10.6(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 12.1(EOL)
-
Not for Release Notes
-
Q3/2026 Server Maintenance, Q3/2026 Server Development, Q4/2026 Server Maintenance
Description
If the table, constructed via VALUES() has multiple columns and some values are identical, then we get the same column names:
|
|
MariaDB [test]> SELECT * from (VALUES (1,1),(2,2)) t;
|
ERROR 1060 (42S21): Duplicate column name '1'
|
|
|
MariaDB [test]> SELECT * from (VALUES (1,2),(2,2)) t;
|
+---+---+
|
| 1 | 2 |
|
+---+---+
|
| 1 | 2 |
|
| 2 | 2 |
|
+---+---+
|
2 rows in set (0.000 sec)
|
|
Attachments
Issue Links
- is part of
-
MDEV-31466 Add optional correlation column list for derived tables
-
- Closed
-
