Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.6.9, 10.7.5, 10.8.4, 10.9.2, 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
MariaDB Community Server 10.8.4 and operating system Windows Server 2019 X64-based
Description
My current MariaDB version is MariaDB Community Server 10.8.4 and operating system Windows Server 2019 X64-based
A business table was created and an error was reported when using the following SQL:
INSERT INTO meeting (fielDID,fieldorder) SELECT MAX(fielDID)+1 AS fielDID, MAX(fieldorder)+1 AS fieldorder FROM meeting
ERROR 1048 (23000): Column 'FIELDID' cannot be null
Attachments
Issue Links
- is caused by
-
MDEV-26585 Wrong query results when `using index for group-by`
-
- Closed
-
Thanks for the report. Reproducible as described.
MTR-friendly, otherwise the same test case:
10.5 ba987a46
The failure started happening after this commit in 10.5.15:
commit 38058c04a4fc021f381f8000e40ed23bd4fb8d75
Author: Monty
Date: Wed Feb 2 14:25:25 2022 +0200
MDEV-26585 Wrong query results when `using index for group-by`