| Bug #110588 | Timestamp cleanup error | ||
|---|---|---|---|
| Submitted: | 3 Apr 2023 7:58 | Modified: | 3 Apr 2023 9:10 |
| Reporter: | Pedro Ferreira | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Optimizer | Severity: | S6 (Debug Builds) |
| Version: | 8.0.32 | OS: | Ubuntu (22.04) |
| Assigned to: | CPU Architecture: | x86 (x86_64) | |
| Tags: | GROUP BY, timestamp | ||
[3 Apr 2023 9:10]
MySQL Verification Team
Hello Pedro Ferreira, Thank you for the report and feedback. Observed that 8.0.32 debug build is affected. regards, Umesh
Description: Run these queries: CREATE TABLE t1 (c0 INT); CREATE TABLE t2 (c1 INT); SELECT DISTINCT x.c0 FROM (SELECT t2.c1, TIMESTAMP '1973-4-11 10:8:29' FROM t2) x(c0,c1) RIGHT JOIN t1 ON x.c1 = x.c0 GROUP BY x.c1; The select query will trigger an assertion error at sql/item_timefunc.h:946: void cleanup() override { assert(marker == MARKER_NONE); } The compilation parameters are the same as issue 108148: -DWITH_DEBUG=1 -DWITH_ASAN=ON -DWITH_UBSAN=ON and boost library version 1.77 How to repeat: Run the statements above.