Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.6, 10.11, 11.4, 11.8, 12.3, 13.0, 12.2.2
-
None
-
Ubuntu 24.04
-
Can result in hang or crash
Description
The following input will cause MariaDB to crash:
DROP DATABASE IF EXISTS db; |
CREATE DATABASE db; |
USE db; |
|
|
CREATE TABLE t (id INT PRIMARY KEY, p INT, o INT, v INT); |
INSERT INTO t VALUES (1,1,1,1); |
|
|
SELECT ROW_NUMBER() OVER (ORDER BY id) AS rn, |
(WITH x(x) AS (SELECT 1) SELECT LASTVAL(x)) AS seq_value |
FROM t; |
Stack Trace:
mariadbd(my_print_stacktrace+0x30)[0x58fe35def960]
mariadbd(handle_fatal_signal+0x1f3)[0x58fe3593b843]
/lib/x86_64-linux-gnu/libc.so.6(+0x45330)[0x7ffa72101330]
mariadbd(_ZN17Item_func_lastval7val_intEv+0x75)[0x58fe359dffe5]
mariadbd(_ZNK23Type_handler_int_result18Item_save_in_fieldEP4ItemP5Fieldb+0x26)[0x58fe35864dd6]
mariadbd(_ZN4Item13save_in_fieldEP5Fieldb+0x39)[0x58fe359666d9]
mariadbd(+0x922d80)[0x58fe3569ed80]
mariadbd(+0x91986e)[0x58fe3569586e]
mariadbd(_Z10sub_selectP4JOINP13st_join_tableb+0x225)[0x58fe35695bd5]
mariadbd(_ZN4JOIN10exec_innerEv+0xd11)[0x58fe35661e11]
Attachments
Issue Links
- is duplicated by
-
MDEV-39063 Server crashes at Item_func_lastval::val_int and Item_func_setval::val_int with CTE alias
-
- Approved
-