Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
Description
--source include/have_sequence.inc
|
|
CREATE SEQUENCE s; |
CREATE table t1 (a int NOT NULL DEFAULT NEXTVAL(s)); |
INSERT into t1 values(),(); |
|
create view v1 as select default(a) from t1; |
select * from v1; |
|
# Cleanup
|
DROP VIEW v1; |
DROP TABLE t1; |
DROP SEQUENCE s; |
10.3 c2300d06f7845f51db6318c2fd |
220803 12:08:11 [ERROR] mysqld got signal 11 ;
|
|
Server version: 10.3.36-MariaDB-debug-log
|
|
sql/signal_handler.cc:231(handle_fatal_signal)[0x561e05d69598]
|
sql/item_func.cc:6797(Item_func_nextval::val_int())[0x561e05ef908d]
|
sql/item.cc:7002(Item::save_int_in_field(Field*, bool))[0x561e05dea66b]
|
sql/sql_type.cc:2597(Type_handler_int_result::Item_save_in_field(Item*, Field*, bool) const)[0x561e05b010ac]
|
sql/item.cc:7012(Item::save_in_field(Field*, bool))[0x561e05dea84f]
|
sql/field.cc:2425(Field::set_default())[0x561e05cc45d8]
|
sql/item.cc:9544(Item_default_value::calculate())[0x561e05e0375a]
|
sql/item.cc:9580(Item_default_value::send(Protocol*, st_value*))[0x561e05e03950]
|
sql/item.cc:8389(Item_ref::send(Protocol*, st_value*))[0x561e05df6969]
|
sql/item.cc:9115(Item_direct_view_ref::send(Protocol*, st_value*))[0x561e05dffe1d]
|
sql/protocol.cc:1000(Protocol::send_result_set_row(List<Item>*))[0x561e0534ebf1]
|
sql/sql_class.cc:3049(select_send::send_data(List<Item>&))[0x561e054eab69]
|
sql/sql_select.cc:21093(end_send(JOIN*, st_join_table*, bool))[0x561e057316a2]
|
sql/sql_select.cc:20134(evaluate_join_record(JOIN*, st_join_table*, int))[0x561e05729b41]
|
sql/sql_select.cc:19907(sub_select(JOIN*, st_join_table*, bool))[0x561e05728459]
|
sql/sql_select.cc:19445(do_select(JOIN*, Procedure*))[0x561e05726418]
|
sql/sql_select.cc:4163(JOIN::exec_inner())[0x561e056b9027]
|
sql/sql_select.cc:3958(JOIN::exec())[0x561e056b69a4]
|
sql/sql_select.cc:4368(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x561e056ba4a2]
|
sql/sql_select.cc:372(handle_select(THD*, LEX*, select_result*, unsigned long))[0x561e056909cd]
|
sql/sql_parse.cc:6340(execute_sqlcom_select(THD*, TABLE_LIST*))[0x561e056016dd]
|
sql/sql_parse.cc:3871(mysql_execute_command(THD*))[0x561e055ef718]
|
sql/sql_parse.cc:7871(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x561e0560b43a]
|
sql/sql_parse.cc:1855(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x561e055e2317]
|
sql/sql_parse.cc:1398(do_command(THD*))[0x561e055dee5a]
|
sql/sql_connect.cc:1403(do_handle_one_connection(CONNECT*))[0x561e059b2475]
|
sql/sql_connect.cc:1309(handle_one_connection)[0x561e059b1d2f]
|
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x561e06fe29c1]
|
nptl/pthread_create.c:478(start_thread)[0x7f996b10d609]
|
|
Query (0x62b000000290): select * from v1
|
Attachments
Issue Links
- relates to
-
MDEV-22785 Crash with prepared statements and NEXTVAL()
- Closed