Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
None
-
Not for Release Notes
-
Q4/2026 Server Maintenance, Q4/2026 Server Development
Description
SET sql_mode='ONLY_FULL_GROUP_BY'; |
CREATE TABLE t0 (a INT, b INT, c INT); |
CREATE TABLE t1 (b INT); |
INSERT INTO t0 VALUES (1,10,100),(1,20,200),(2,30,300); |
INSERT INTO t1 VALUES (1000); |
|
|
#here error as expected: |
--error 1055
|
SELECT (SELECT sum(t0.b + t1.b) FROM t1) AS s, t0.c FROM t0 GROUP BY t0.a; |
|
|
#here error is also expected: |
SELECT t0.a, (SELECT sum(t0.b + t1.b) FROM t1) AS s FROM t0 GROUP BY t0.a; |
SELECT t0.a, (SELECT any_value(t0.b + t1.b) FROM t1) AS s FROM t0 GROUP BY t0.a; |
|
|
DROP TABLE t0, t1; |
SET sql_mode=DEFAULT; |
regression after pr 5151 (715a937e98c ?)
on main:
query 'SELECT t0.a, (SELECT sum(t0.b + t1.b) FROM t1) AS s FROM t0 GROUP BY t0.a' failed: ER_WRONG_FIELD_WITH_GROUP (1055): 'test.t0.b' isn't in GROUP BY
|
Attachments
Issue Links
- is caused by
-
MDEV-10426 ANY_VALUE function
-
- Closed
-
- relates to
-
MDEV-40022 ONLY_FULL_GROUP_BY not enforced for outer column reference inside HAVING
-
- Confirmed
-
-
MDEV-41400 Server is crashing in base_list::push_back/List<Item_field>::push_back
-
- Closed
-