Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9
-
None
-
None
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)
|
|