Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.6(EOL), 10.11, 11.4, 11.8, 12.2(EOL), 11.8.3
-
Unexpected results
-
Q2/2026 Server Development, Q3/2026 Server Maintenance
Description
Run the following statements, -3 is expected.
CREATE TABLE t1 (c1 LONGTEXT) STATS_PERSISTENT = DEFAULT; |
INSERT INTO t1 VALUES ('03ksy'); |
SELECT (MIN((LOWER((-(CAST(c1 AS BINARY))))))) FROM t1 GROUP BY c1; -- {NULL}, expected: {-3} |