Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
11.1(EOL)
-
None
Description
CREATE TABLE v0 ( v1 INT ) Engine = InnoDB ; |
INSERT INTO v0 VALUES ( 20 ) , ( -1 ) , ( 0 ) ; |
INSERT INTO v0 SELECT 74 * v1 + -128 FROM v0 ; |
INSERT INTO v0 SELECT 68 * v1 + -32768 FROM v0 ; |
INSERT INTO v0 SELECT 22 * v1 + 85 FROM v0 ; |
INSERT INTO v0 SELECT 99 * v1 + -128 FROM v0 ; |
INSERT INTO v0 ( v1 ) SELECT 36 FROM ( SELECT v1 , v1 * 80 * 28 AS v3 FROM v0 ) AS v2 NATURAL JOIN v0 WHERE v1 IN ( SELECT v1 = 'x' ) ; |
INSERT INTO v0 SELECT v1 , v1 , v1 , v1 FROM v0 ; |
SELECT VAR_SAMP ( ) INTO @ a ; |
Stack Trace:
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7f6fe55a5880 thread_stack 0x5fc00
/usr/local/mysql/bin/mariadbd(__interceptor_backtrace+0x5b)[0x781b5b]
mysys/stacktrace.c:215(my_print_stacktrace)[0x228cfae]
sql/signal_handler.cc:0(handle_fatal_signal)[0x12bd0d2]
sigaction.c:0(__restore_rt)[0x7f70056a2420]
sql/sql_lex.cc:3326(st_select_lex::mark_as_dependent(THD*, st_select_lex*, Item_ident*))[0xab307b]
sql/item.cc:5228(mark_as_dependent(THD*, st_select_lex*, st_select_lex*, Item_ident*, Item_ident*, bool))[0x13301c2]
sql/item.cc:5921(Item_field::fix_outer_field(THD*, Field*, Item*))[0x13315d6]
sql/item.cc:6135(Item_field::fix_fields(THD*, Item**))[0x1335608]
sql/item_func.cc:349(Item_func::fix_fields(THD*, Item**))[0x1438790]
sql/sql_select.cc:2309(JOIN::optimize_inner())[0xc15a58]
/usr/local/mysql/bin/mariadbd(_ZN4JOIN8optimizeEv+0x176)[0xbffb46]
sql/sql_derived.cc:1037(mysql_derived_optimize(THD*, LEX*, TABLE_LIST*))[0xa5bf21]
/usr/local/mysql/bin/mariadbd(_Z27mysql_handle_single_derivedP3LEXP10TABLE_LISTj+0x172)[0xa5f042]
/usr/local/mysql/bin/mariadbd(_ZN4JOIN14optimize_innerEv+0x3138)[0xc16a68]
/usr/local/mysql/bin/mariadbd(_ZN4JOIN8optimizeEv+0x176)[0xbffb46]
sql/sql_select.cc:5237(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0xbe886f]
sql/sql_select.cc:628(handle_select(THD*, LEX*, select_result*, unsigned long long))[0xbe7e59]
/usr/local/mysql/bin/mariadbd(_Z21mysql_execute_commandP3THDb+0x9d8c)[0xb39e7c]
sql/sql_class.h:2830(THD::enter_stage(PSI_stage_info_v1 const*, char const*, char const*, unsigned int))[0xb24c79]
/usr/local/mysql/bin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x2cf8)[0xb1e648]
sql/sql_parse.cc:1407(do_command(THD*, bool))[0xb25971]
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0xf0d066]
sql/sql_connect.cc:1322(handle_one_connection)[0xf0caa9]
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x19d710b]
nptl/pthread_create.c:478(start_thread)[0x7f7005696609]
addr2line: DWARF error: section .debug_info is larger than its filesize! (0x93ef57 vs 0x530f28)
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f70053ae133]
Attachments
Issue Links
- duplicates
-
MDEV-29071 SIGSEGV's in st_select_lex::mark_as_dependent and Assertion `outer_context || !*from_field || *from_field == not_found_field' failed in Item_field::fix_outer_field on INSERT
- Confirmed