Details
-
Bug
-
Status: In Progress (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3(EOL), 10.4(EOL), 10.5(EOL), 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 12.1(EOL)
-
None
-
Q3/2026 Server Maintenance, Q3/2026 Server Development
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)
|
|
