Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5.16, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9
-
None
-
None
Description
expect consistent results
MariaDB [mydb]> select b.a as x, b.a as y from (select database() as a from t1) as b group by 2;
|
+------+------+
|
| y | y |
|
+------+------+
|
| mydb | mydb |
|
+------+------+
|
1 row in set (0.001 sec)
|
 |
MariaDB [mydb]> select b.a as x, b.a as y from (select database() as a from t1) as b;
|
+------+------+
|
| x | y |
|
+------+------+
|
| mydb | mydb |
|
+------+------+
|
1 row in set (0.001 sec)
|