Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
Description
The failure is scalable and is not limited to low levels of the threshold. The crash happens whenever the number of elements in the IN list equals or exceeds the threshold value.
SET NAMES latin1; |
|
|
CREATE TABLE t1 (f VARCHAR(8) CHARACTER SET utf8, i INT); |
INSERT INTO t1 VALUES ('foo',1),('bar',2); |
|
|
SET in_predicate_conversion_threshold= 3; |
PREPARE stmt FROM "SELECT * FROM t1 WHERE (f IN ('a','b','c') AND i = 10)"; |
EXECUTE stmt; |
EXECUTE stmt; |
|
10.3 f3f23b5c |
#3 <signal handler called>
|
#4 0x0000000000000000 in ?? ()
|
#5 0x0000558dec49e0dd in Item::check_is_evaluable_expression_or_error (this=0x7fe0800130e8) at /data/src/10.3/sql/item.h:1367
|
#6 0x0000558dec49b193 in fix_fields_for_tvc (thd=0x7fe080000af0, li=...) at /data/src/10.3/sql/sql_tvc.cc:63
|
#7 0x0000558dec49b81f in table_value_constr::prepare (this=0x7fe0800828a0, thd=0x7fe080000af0, sl=0x7fe080081c40, tmp_result=0x7fe0800131d0, unit_arg=0x7fe080082058) at /data/src/10.3/sql/sql_tvc.cc:238
|
#8 0x0000558dec37aac0 in st_select_lex_unit::prepare (this=0x7fe080082058, derived_arg=0x7fe080082918, sel_result=0x7fe0800130e8, additional_options=0) at /data/src/10.3/sql/sql_union.cc:1018
|
#9 0x0000558dec22e072 in mysql_derived_prepare (thd=0x7fe080000af0, lex=0x7fe08007e050, derived=0x7fe080082918) at /data/src/10.3/sql/sql_derived.cc:770
|
#10 0x0000558dec22cbfe in mysql_handle_single_derived (lex=0x7fe08007e050, derived=0x7fe080082918, phases=2) at /data/src/10.3/sql/sql_derived.cc:199
|
#11 0x0000558dec3ab028 in TABLE_LIST::handle_derived (this=0x7fe080082918, lex=0x7fe08007e050, phases=2) at /data/src/10.3/sql/table.cc:8356
|
#12 0x0000558dec246c44 in LEX::handle_list_of_derived (this=0x7fe08007e050, table_list=0x7fe08007f9d0, phases=2) at /data/src/10.3/sql/sql_lex.h:3997
|
#13 0x0000558dec252c72 in st_select_lex::handle_derived (this=0x7fe08007e898, lex=0x7fe08007e050, phases=2) at /data/src/10.3/sql/sql_lex.cc:4143
|
#14 0x0000558dec2c0db3 in JOIN::prepare (this=0x7fe080012b80, tables_init=0x7fe08007f9d0, wild_num=0, conds_init=0x7fe080012948, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7fe08007e898, unit_arg=0x7fe08007e110) at /data/src/10.3/sql/sql_select.cc:1045
|
#15 0x0000558dec2ccbb8 in mysql_select (thd=0x7fe080000af0, tables=0x7fe08007f9d0, wild_num=0, fields=..., conds=0x7fe080012948, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7fe080080958, unit=0x7fe08007e110, select_lex=0x7fe08007e898) at /data/src/10.3/sql/sql_select.cc:4293
|
#16 0x0000558dec2be24a in handle_select (thd=0x7fe080000af0, lex=0x7fe08007e050, result=0x7fe080080958, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:370
|
#17 0x0000558dec285b98 in execute_sqlcom_select (thd=0x7fe080000af0, all_tables=0x7fe08007f9d0) at /data/src/10.3/sql/sql_parse.cc:6286
|
#18 0x0000558dec27c2eb in mysql_execute_command (thd=0x7fe080000af0) at /data/src/10.3/sql/sql_parse.cc:3812
|
#19 0x0000558dec2a9444 in Prepared_statement::execute (this=0x7fe080073e90, expanded_query=0x7fe092bd5c70, open_cursor=false) at /data/src/10.3/sql/sql_prepare.cc:4812
|
#20 0x0000558dec2a76ae in Prepared_statement::execute_loop (this=0x7fe080073e90, expanded_query=0x7fe092bd5c70, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/10.3/sql/sql_prepare.cc:4240
|
#21 0x0000558dec2a518e in mysql_sql_stmt_execute (thd=0x7fe080000af0) at /data/src/10.3/sql/sql_prepare.cc:3348
|
#22 0x0000558dec27c330 in mysql_execute_command (thd=0x7fe080000af0) at /data/src/10.3/sql/sql_parse.cc:3828
|
#23 0x0000558dec289ea3 in mysql_parse (thd=0x7fe080000af0, rawbuf=0x7fe080012818 "EXECUTE stmt", length=12, parser_state=0x7fe092bd65e0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7810
|
#24 0x0000558dec2766ea in dispatch_command (command=COM_QUERY, thd=0x7fe080000af0, packet=0x7fe0801234f1 "EXECUTE stmt", packet_length=12, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1848
|
#25 0x0000558dec275002 in do_command (thd=0x7fe080000af0) at /data/src/10.3/sql/sql_parse.cc:1393
|
#26 0x0000558dec3ee4d7 in do_handle_one_connection (connect=0x558def4832e0) at /data/src/10.3/sql/sql_connect.cc:1403
|
#27 0x0000558dec3ee239 in handle_one_connection (arg=0x558def4832e0) at /data/src/10.3/sql/sql_connect.cc:1308
|
#28 0x0000558decda50e8 in pfs_spawn_thread (arg=0x558def49e390) at /data/src/10.3/storage/perfschema/pfs.cc:1869
|
#29 0x00007fe09a9604a4 in start_thread (arg=0x7fe092bd7700) at pthread_create.c:456
|
#30 0x00007fe098a94d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
A much stranger stack trace on 10.5:
|
10.5 30e7a0a8 |
#3 <signal handler called>
|
#4 0x000055cefa45632c in base_list_iterator::next_fast (this=0x7f85b027e570) at /data/src/10.5/sql/sql_list.h:441
|
#5 0x000055cefa4677f3 in List_iterator_fast<Item>::operator++ (this=0x7f85b027e570) at /data/src/10.5/sql/sql_list.h:620
|
#6 0x000055cefa6b9e91 in get_table_map (items=0xa5a5a5a5a5a5a5a5) at /data/src/10.5/sql/sql_update.cc:1459
|
#7 0x000055cefa6bb6c3 in multi_update::prepare (this=0x7f85940141b8, not_used_values=..., lex_unit=0x7f85940141b8) at /data/src/10.5/sql/sql_update.cc:1988
|
#8 0x000055cefa80d76f in Item::check_is_evaluable_expression_or_error (this=0x7f85940141b8) at /data/src/10.5/sql/item.h:1625
|
#9 0x000055cefa80a767 in fix_fields_for_tvc (thd=0x7f8594000b18, li=...) at /data/src/10.5/sql/sql_tvc.cc:93
|
#10 0x000055cefa80addd in table_value_constr::prepare (this=0x7f859406baf8, thd=0x7f8594000b18, sl=0x7f859406add8, tmp_result=0x7f8594014298, unit_arg=0x7f859406b238) at /data/src/10.5/sql/sql_tvc.cc:268
|
#11 0x000055cefa6af8b9 in st_select_lex_unit::prepare (this=0x7f859406b238, derived_arg=0x7f859406c110, sel_result=0x7f85940141b8, additional_options=0) at /data/src/10.5/sql/sql_union.cc:1543
|
#12 0x000055cefa537d63 in mysql_derived_prepare (thd=0x7f8594000b18, lex=0x7f8594065da8, derived=0x7f859406c110) at /data/src/10.5/sql/sql_derived.cc:816
|
#13 0x000055cefa5363d6 in mysql_handle_single_derived (lex=0x7f8594065da8, derived=0x7f859406c110, phases=2) at /data/src/10.5/sql/sql_derived.cc:206
|
#14 0x000055cefa6e3dee in TABLE_LIST::handle_derived (this=0x7f859406c110, lex=0x7f8594065da8, phases=2) at /data/src/10.5/sql/table.cc:9087
|
#15 0x000055cefa5521ea in LEX::handle_list_of_derived (this=0x7f8594065da8, table_list=0x7f8594067ff0, phases=2) at /data/src/10.5/sql/sql_lex.h:4416
|
#16 0x000055cefa560066 in st_select_lex::handle_derived (this=0x7f85940679f8, lex=0x7f8594065da8, phases=2) at /data/src/10.5/sql/sql_lex.cc:4850
|
#17 0x000055cefa5dacc3 in JOIN::prepare (this=0x7f8594013c40, tables_init=0x7f8594067ff0, conds_init=0x7f85940139f0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f85940679f8, unit_arg=0x7f8594065e70) at /data/src/10.5/sql/sql_select.cc:1149
|
#18 0x000055cefa5e7de6 in mysql_select (thd=0x7f8594000b18, tables=0x7f8594067ff0, fields=..., conds=0x7f85940139f0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2201171004160, result=0x7f8594069990, unit=0x7f8594065e70, select_lex=0x7f85940679f8) at /data/src/10.5/sql/sql_select.cc:4619
|
#19 0x000055cefa5d7c30 in handle_select (thd=0x7f8594000b18, lex=0x7f8594065da8, result=0x7f8594069990, setup_tables_done_option=0) at /data/src/10.5/sql/sql_select.cc:429
|
#20 0x000055cefa59d276 in execute_sqlcom_select (thd=0x7f8594000b18, all_tables=0x7f8594067ff0) at /data/src/10.5/sql/sql_parse.cc:6209
|
#21 0x000055cefa59451d in mysql_execute_command (thd=0x7f8594000b18) at /data/src/10.5/sql/sql_parse.cc:3931
|
#22 0x000055cefa5c1ff5 in Prepared_statement::execute (this=0x7f8594065938, expanded_query=0x7f85b0280cc0, open_cursor=false) at /data/src/10.5/sql/sql_prepare.cc:4791
|
#23 0x000055cefa5c04aa in Prepared_statement::execute_loop (this=0x7f8594065938, expanded_query=0x7f85b0280cc0, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/10.5/sql/sql_prepare.cc:4280
|
#24 0x000055cefa5bdf17 in mysql_sql_stmt_execute (thd=0x7f8594000b18) at /data/src/10.5/sql/sql_prepare.cc:3392
|
#25 0x000055cefa594562 in mysql_execute_command (thd=0x7f8594000b18) at /data/src/10.5/sql/sql_parse.cc:3947
|
#26 0x000055cefa5a20c3 in mysql_parse (thd=0x7f8594000b18, rawbuf=0x7f85940138d0 "EXECUTE stmt", length=12, parser_state=0x7f85b0281520, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:7993
|
#27 0x000055cefa58e3bc in dispatch_command (command=COM_QUERY, thd=0x7f8594000b18, packet=0x7f85941af209 "EXECUTE stmt", packet_length=12, is_com_multi=false, is_next_command=false) at /data/src/10.5/sql/sql_parse.cc:1867
|
#28 0x000055cefa58caf4 in do_command (thd=0x7f8594000b18) at /data/src/10.5/sql/sql_parse.cc:1348
|
#29 0x000055cefa7321d9 in do_handle_one_connection (connect=0x55cefdc672f8, put_in_cache=true) at /data/src/10.5/sql/sql_connect.cc:1411
|
#30 0x000055cefa731f41 in handle_one_connection (arg=0x55cefdc672f8) at /data/src/10.5/sql/sql_connect.cc:1313
|
#31 0x000055cefac6fdd0 in pfs_spawn_thread (arg=0x55cefdc66f28) at /data/src/10.5/storage/perfschema/pfs.cc:2201
|
#32 0x00007f85b66cf4a4 in start_thread (arg=0x7f85b0282700) at pthread_create.c:456
|
#33 0x00007f85b4803d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
A more sensible stack trace on 10.5 non-debug:
|
10.5 30e7a0a8 non-debug |
#3 <signal handler called>
|
#4 0x0000562b48d9c994 in Item::fix_fields_if_needed (ref=0x0, thd=0x7f45f00009b8, this=0x7f45f0010c28) at /data/src/10.5/sql/item.h:978
|
#5 fix_fields_for_tvc (thd=thd@entry=0x7f45f00009b8, li=...) at /data/src/10.5/sql/sql_tvc.cc:92
|
#6 0x0000562b48d9cd76 in table_value_constr::prepare (this=0x7f45f0046228, thd=0x7f45f00009b8, sl=sl@entry=0x7f45f0045508, tmp_result=tmp_result@entry=0x7f45f0010c48, unit_arg=unit_arg@entry=0x7f45f0045968) at /data/src/10.5/sql/sql_tvc.cc:268
|
#7 0x0000562b48ccfd03 in st_select_lex_unit::prepare (this=this@entry=0x7f45f0045968, derived_arg=derived_arg@entry=0x7f45f018fb80, sel_result=<optimized out>, additional_options=additional_options@entry=0) at /data/src/10.5/sql/sql_union.cc:1543
|
#8 0x0000562b48be8fbe in mysql_derived_prepare (thd=0x7f45f00009b8, lex=0x7f45f00404d8, derived=0x7f45f018fb80) at /data/src/10.5/sql/sql_derived.cc:816
|
#9 0x0000562b48be7f6f in mysql_handle_single_derived (lex=lex@entry=0x7f45f00404d8, derived=derived@entry=0x7f45f018fb80, phases=phases@entry=2) at /data/src/10.5/sql/sql_derived.cc:206
|
#10 0x0000562b48cecbde in TABLE_LIST::handle_derived (this=this@entry=0x7f45f018fb80, lex=lex@entry=0x7f45f00404d8, phases=phases@entry=2) at /data/src/10.5/sql/table.cc:9087
|
#11 0x0000562b48c06077 in LEX::handle_list_of_derived (phases=2, table_list=<optimized out>, this=0x7f45f00404d8) at /data/src/10.5/sql/sql_lex.h:4416
|
#12 st_select_lex::handle_derived (this=<optimized out>, lex=0x7f45f00404d8, phases=phases@entry=2) at /data/src/10.5/sql/sql_lex.cc:4850
|
#13 0x0000562b48c745e3 in JOIN::prepare (this=this@entry=0x7f45f00105f0, tables_init=tables_init@entry=0x7f45f0042720, conds_init=conds_init@entry=0x7f45f00103a0, og_num=og_num@entry=0, order_init=order_init@entry=0x0, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f45f0042128, unit_arg=0x7f45f00405a0) at /data/src/10.5/sql/sql_select.cc:1149
|
#14 0x0000562b48c847e7 in mysql_select (thd=thd@entry=0x7f45f00009b8, tables=0x7f45f0042720, fields=..., conds=0x7f45f00103a0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2201171004160, result=0x7f45f00440c0, unit=0x7f45f00405a0, select_lex=0x7f45f0042128) at /data/src/10.5/sql/sql_select.cc:4619
|
#15 0x0000562b48c84954 in handle_select (thd=thd@entry=0x7f45f00009b8, lex=lex@entry=0x7f45f00404d8, result=result@entry=0x7f45f00440c0, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.5/sql/sql_select.cc:429
|
#16 0x0000562b48b0b179 in execute_sqlcom_select (thd=thd@entry=0x7f45f00009b8, all_tables=0x7f45f0042720) at /data/src/10.5/sql/sql_parse.cc:6209
|
#17 0x0000562b48c25d38 in mysql_execute_command (thd=0x7f45f00009b8) at /data/src/10.5/sql/sql_parse.cc:3931
|
#18 0x0000562b48c434ac in Prepared_statement::execute (this=this@entry=0x7f45f00400e8, expanded_query=expanded_query@entry=0x7f4602bcaf10, open_cursor=open_cursor@entry=false) at /data/src/10.5/sql/sql_prepare.cc:4791
|
#19 0x0000562b48c435a2 in Prepared_statement::execute_loop (this=0x7f45f00400e8, expanded_query=0x7f4602bcaf10, open_cursor=<optimized out>, packet=<optimized out>, packet_end=<optimized out>) at /data/src/10.5/sql/sql_prepare.cc:4280
|
#20 0x0000562b48c43887 in mysql_sql_stmt_execute (thd=thd@entry=0x7f45f00009b8) at /data/src/10.5/sql/sql_prepare.cc:3392
|
#21 0x0000562b48c26bf4 in mysql_execute_command (thd=thd@entry=0x7f45f00009b8) at /data/src/10.5/sql/sql_parse.cc:3947
|
#22 0x0000562b48c2cb3c in mysql_parse (thd=thd@entry=0x7f45f00009b8, rawbuf=<optimized out>, length=12, parser_state=parser_state@entry=0x7f4602bcb500, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.5/sql/sql_parse.cc:7993
|
#23 0x0000562b48c22928 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f45f00009b8, packet=packet@entry=0x7f45f0007be9 "EXECUTE stmt", packet_length=packet_length@entry=12, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.5/sql/sql_parse.cc:1867
|
#24 0x0000562b48c20cbe in do_command (thd=0x7f45f00009b8) at /data/src/10.5/sql/sql_parse.cc:1348
|
#25 0x0000562b48d18e80 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x562b4ac446c8, put_in_cache=put_in_cache@entry=true) at /data/src/10.5/sql/sql_connect.cc:1411
|
#26 0x0000562b48d194e4 in handle_one_connection (arg=arg@entry=0x562b4ac446c8) at /data/src/10.5/sql/sql_connect.cc:1313
|
#27 0x0000562b4908a6d1 in pfs_spawn_thread (arg=0x562b4ac44738) at /data/src/10.5/storage/perfschema/pfs.cc:2201
|
#28 0x00007f46092854a4 in start_thread (arg=0x7f4602bcc700) at pthread_create.c:456
|
#29 0x00007f4608303d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
Reproducible with at least MyISAM and InnoDB.
For running through the client, SET NAMES latin1 is needed (added it to the test case, even though it's not needed for MTR).
A slightly more complicated variation of essentially the same test case can also cause "pure virtual method called" exceptions on non-debug builds (while on debug build failures look the same as above).
|
10.5 7a60bc22 |
pure virtual method called
|
terminate called without an active exception
|
201227 1:35:42 [ERROR] mysqld got signal 6 ;
|
|
|
#5 0x00007effdee24859 in __GI_abort () at abort.c:79
|
#6 0x00007effdf1e0951 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
|
#7 0x00007effdf1ec47c in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6
|
#8 0x00007effdf1ec4e7 in std::terminate() () from /lib/x86_64-linux-gnu/libstdc++.so.6
|
#9 0x00007effdf1ed245 in __cxa_pure_virtual () from /lib/x86_64-linux-gnu/libstdc++.so.6
|
#10 0x00005564e58a4759 in join_type_handlers_for_tvc (thd=thd@entry=0x7effc8000c58, li=..., holders=holders@entry=0x7effc81a5a08, first_list_el_count=first_list_el_count@entry=1) at /data/src/10.5/sql/sql_tvc.cc:151
|
#11 0x00005564e58a4bb7 in table_value_constr::prepare (this=0x7effc8191a10, thd=0x7effc8000c58, sl=sl@entry=0x7effc8190d30, tmp_result=tmp_result@entry=0x7effc8011ef0, unit_arg=unit_arg@entry=0x7effc8191188) at /data/src/10.5/sql/sql_tvc.cc:266
|
#12 0x00005564e57cf937 in st_select_lex_unit::prepare (this=this@entry=0x7effc8191188, derived_arg=derived_arg@entry=0x7effc8191a88, sel_result=<optimized out>, additional_options=additional_options@entry=0) at /data/src/10.5/sql/sql_union.cc:1567
|
#13 0x00005564e56d13a9 in mysql_derived_prepare (thd=0x7effc8000c58, lex=0x7effc80f14a0, derived=0x7effc8191a88) at /data/src/10.5/sql/sql_derived.cc:816
|
#14 0x00005564e56d0324 in mysql_handle_single_derived (lex=lex@entry=0x7effc80f14a0, derived=derived@entry=0x7effc8191a88, phases=phases@entry=2) at /data/src/10.5/sql/sql_derived.cc:206
|
#15 0x00005564e57eed5e in TABLE_LIST::handle_derived (this=this@entry=0x7effc8191a88, lex=lex@entry=0x7effc80f14a0, phases=phases@entry=2) at /data/src/10.5/sql/table.cc:9120
|
#16 0x00005564e56ed217 in LEX::handle_list_of_derived (phases=2, table_list=<optimized out>, this=0x7effc80f14a0) at /data/src/10.5/sql/table.h:2704
|
#17 st_select_lex::handle_derived (this=<optimized out>, lex=0x7effc80f14a0, phases=phases@entry=2) at /data/src/10.5/sql/sql_lex.cc:4911
|
#18 0x00005564e576bc9d in JOIN::prepare (this=0x7effc8011898, tables_init=<optimized out>, conds_init=<optimized out>, og_num=0, order_init=<optimized out>, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7effc818ff88, unit_arg=0x7effc81903e0) at /data/src/10.5/sql/sql_select.cc:1158
|
#19 0x00005564e59ed82a in subselect_single_select_engine::prepare (thd=0x7effc8000c58, this=0x7effc81923b0) at /data/src/10.5/sql/sql_lex.h:1350
|
#20 subselect_single_select_engine::prepare (this=0x7effc81923b0, thd=0x7effc8000c58) at /data/src/10.5/sql/item_subselect.cc:3760
|
#21 0x00005564e59ecc7d in Item_subselect::fix_fields (this=this@entry=0x7effc8192168, thd_param=thd_param@entry=0x7effc8000c58, ref=ref@entry=0x7effc81a5640) at /data/src/10.5/sql/item_subselect.cc:285
|
#22 0x00005564e59ecfce in Item_in_subselect::fix_fields (this=0x7effc8192168, thd_arg=0x7effc8000c58, ref=0x7effc81a5640) at /data/src/10.5/sql/item_subselect.cc:3438
|
#23 0x00005564e5964cdd in Item::fix_fields_if_needed (ref=0x7effc81a5640, thd=0x7effc8000c58, this=0x7effc8192168) at /data/src/10.5/sql/item.h:986
|
#24 Item::fix_fields_if_needed (ref=0x7effc81a5640, thd=0x7effc8000c58, this=0x7effc8192168) at /data/src/10.5/sql/item.h:986
|
#25 Item_in_optimizer::fix_fields (this=0x7effc81a55a0, thd=0x7effc8000c58, ref=<optimized out>) at /data/src/10.5/sql/item_cmpfunc.cc:1381
|
#26 0x00005564e598bb1d in Item::fix_fields_if_needed (ref=0x7effc8192488, thd=0x7effc8000c58, this=0x7effc81a55a0) at /data/src/10.5/sql/item.h:986
|
#27 Item::fix_fields_if_needed (ref=0x7effc8192488, thd=0x7effc8000c58, this=0x7effc81a55a0) at /data/src/10.5/sql/item.h:986
|
#28 Item_func::fix_fields (ref=0x7effc8192490, thd=0x7effc8000c58, this=0x7effc81923f0) at /data/src/10.5/sql/item_func.cc:352
|
#29 Item_func::fix_fields (this=this@entry=0x7effc81923f0, thd=thd@entry=0x7effc8000c58, ref=ref@entry=0x7effc80107d0) at /data/src/10.5/sql/item_func.cc:319
|
#30 0x00005564e5961b2e in Item_func_not::fix_fields (this=0x7effc81923f0, thd=0x7effc8000c58, ref=0x7effc80107d0) at /data/src/10.5/sql/item_cmpfunc.cc:6445
|
#31 0x00005564e5962431 in Item::fix_fields_if_needed (ref=0x7effc80107d0, thd=0x7effc8000c58, this=0x7effc81923f0) at /data/src/10.5/sql/item.h:986
|
#32 Item::fix_fields_if_needed (ref=0x7effc80107d0, thd=0x7effc8000c58, this=0x7effc81923f0) at /data/src/10.5/sql/item.h:986
|
#33 Item::fix_fields_if_needed_for_scalar (ref=0x7effc80107d0, thd=0x7effc8000c58, this=0x7effc81923f0) at /data/src/10.5/sql/item.h:992
|
#34 Item::fix_fields_if_needed_for_bool (ref=0x7effc80107d0, thd=0x7effc8000c58, this=0x7effc81923f0) at /data/src/10.5/sql/item.h:996
|
#35 Item_cond::fix_fields (this=0x7effc8010698, thd=0x7effc8000c58, ref=<optimized out>) at /data/src/10.5/sql/item_cmpfunc.cc:4901
|
#36 0x00005564e56b192b in Item::fix_fields_if_needed (ref=0x7effc8010d08, thd=0x7effc8000c58, this=0x7effc8010698) at /data/src/10.5/sql/item.h:986
|
#37 Item::fix_fields_if_needed (ref=0x7effc8010d08, thd=0x7effc8000c58, this=0x7effc8010698) at /data/src/10.5/sql/item.h:986
|
#38 Item::fix_fields_if_needed_for_scalar (ref=0x7effc8010d08, thd=0x7effc8000c58, this=0x7effc8010698) at /data/src/10.5/sql/item.h:992
|
#39 Item::fix_fields_if_needed_for_bool (ref=0x7effc8010d08, thd=0x7effc8000c58, this=0x7effc8010698) at /data/src/10.5/sql/item.h:996
|
#40 setup_conds (thd=thd@entry=0x7effc8000c58, tables=tables@entry=0x7effc80f39e8, leaves=..., conds=conds@entry=0x7effc8010d08) at /data/src/10.5/sql/sql_base.cc:8360
|
#41 0x00005564e576c1c4 in setup_without_group (reserved=0x7effc80f355c, hidden_group_fields=0x7effc8010bdf, win_funcs=..., win_specs=..., group=0x0, order=0x0, conds=0x7effc8010d08, all_fields=..., fields=..., leaves=..., tables=0x7effc80f39e8, ref_pointer_array=..., thd=0x7effc8000c58) at /data/src/10.5/sql/sql_select.cc:696
|
#42 JOIN::prepare (this=0x7effc80108f8, tables_init=<optimized out>, conds_init=<optimized out>, og_num=<optimized out>, order_init=<optimized out>, skip_order_by=<optimized out>, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7effc80f3250, unit_arg=0x7effc80f1568) at /data/src/10.5/sql/sql_select.cc:1264
|
#43 0x00005564e577f28f in mysql_select (thd=0x7effc8000c58, tables=0x7effc80f39e8, fields=..., conds=0x7effc8010698, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2201171004160, result=0x7effc80f69c8, unit=0x7effc80f1568, select_lex=0x7effc80f3250) at /data/src/10.5/sql/sql_select.cc:4634
|
#44 0x00005564e577f567 in handle_select (thd=thd@entry=0x7effc8000c58, lex=lex@entry=0x7effc80f14a0, result=result@entry=0x7effc80f69c8, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.5/sql/sql_select.cc:417
|
#45 0x00005564e570e0b1 in execute_sqlcom_select (thd=0x7effc8000c58, all_tables=0x7effc80f39e8) at /data/src/10.5/sql/sql_parse.cc:6264
|
#46 0x00005564e571c24e in mysql_execute_command (thd=0x7effc8000c58) at /data/src/10.5/sql/sql_parse.cc:3968
|
#47 0x00005564e572db45 in Prepared_statement::execute (this=0x7effc811a558, expanded_query=<optimized out>, open_cursor=false) at /data/src/10.5/sql/sql_prepare.cc:4997
|
#48 0x00005564e572dd19 in Prepared_statement::execute_loop (packet=<optimized out>, packet_end=<optimized out>, open_cursor=<optimized out>, expanded_query=0x7effd97d6e50, this=0x7effc811a558) at /data/src/10.5/sql/sql_prepare.cc:4460
|
#49 Prepared_statement::execute_loop (this=0x7effc811a558, expanded_query=0x7effd97d6e50, open_cursor=<optimized out>, packet=<optimized out>, packet_end=<optimized out>) at /data/src/10.5/sql/sql_prepare.cc:4415
|
#50 0x00005564e572e023 in mysql_sql_stmt_execute (thd=thd@entry=0x7effc8000c58) at /data/src/10.5/sql/sql_prepare.cc:3558
|
#51 0x00005564e571ab23 in mysql_execute_command (thd=0x7effc8000c58) at /data/src/10.5/sql/sql_parse.cc:3984
|
#52 0x00005564e5708a5f in mysql_parse (thd=0x7effc8000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.5/sql/sql_parse.cc:8042
|
#53 0x00005564e57147bf in dispatch_command (command=COM_QUERY, thd=0x7effc8000c58, packet=<optimized out>, packet_length=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.5/sql/sql_class.h:1255
|
#54 0x00005564e5716b76 in do_command (thd=0x7effc8000c58) at /data/src/10.5/sql/sql_parse.cc:1353
|
#55 0x00005564e581b8c1 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5564e9180088, put_in_cache=put_in_cache@entry=true) at /data/src/10.5/sql/sql_connect.cc:1410
|
#56 0x00005564e581bd3d in handle_one_connection (arg=arg@entry=0x5564e9180088) at /data/src/10.5/sql/sql_connect.cc:1312
|
#57 0x00005564e5ba32e6 in pfs_spawn_thread (arg=0x5564e9117aa8) at /data/src/10.5/storage/perfschema/pfs.cc:2201
|
#58 0x00007effdf332609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#59 0x00007effdef21293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Attachments
Issue Links
- causes
-
-
- Closed
-
-
-
- Closed
-
- duplicates
-
-
- Closed
-
- relates to
-
-
- Open
-
-
-
- Confirmed
-
Activity
Also affects 10.6. And slightly different stack with this testcase:
SET collation_connection=utf32_czech_ci; |
CREATE TABLE t1 (c VARCHAR(1)) ENGINE=InnoDB; |
SET in_predicate_conversion_threshold=2; |
PREPARE p FROM 'SELECT * FROM t1 WHERE c NOT IN (\'a\',\'a\')'; |
EXECUTE p; |
EXECUTE p; |
Leads to:
|
10.6.2 06dd151bb86ad5b87d4d46011f36da1289c01074 (Debug) |
Core was generated by `/test/MD050621-mariadb-10.6.2-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
|
Program terminated with signal SIGSEGV, Segmentation fault.
|
#0 0x000056129a118d58 in Item::fix_fields_if_needed_for_scalar (
|
ref=0x151534032c00, thd=0x151534000db8, this=0x151534014730)
|
at /test/10.6_dbg/sql/sql_list.h:443
|
[Current thread is 1 (Thread 0x151578095700 (LWP 24722))]
|
(gdb) bt
|
#0 0x000056129a118d58 in Item::fix_fields_if_needed_for_scalar (ref=0x151534032c00, thd=0x151534000db8, this=0x151534014730) at /test/10.6_dbg/sql/sql_list.h:443
|
#1 fix_fields_for_tvc (thd=thd@entry=0x151534000db8, li=@0x151578091740: {<base_list_iterator> = {list = 0x151534032c58, el = 0x151534032c08, prev = 0x0, current = 0x0}, <No data fields>}) at /test/10.6_dbg/sql/sql_tvc.cc:93
|
#2 0x000056129a11925d in table_value_constr::prepare (this=0x151534032c50, thd=<optimized out>, sl=sl@entry=0x151534031f78, tmp_result=tmp_result@entry=0x151534014d40, unit_arg=unit_arg@entry=0x1515340323e0) at /test/10.6_dbg/sql/sql_tvc.cc:269
|
#3 0x0000561299fe9230 in st_select_lex_unit::prepare (this=this@entry=0x1515340323e0, derived_arg=derived_arg@entry=0x151534032cc8, sel_result=<optimized out>, additional_options=additional_options@entry=0) at /test/10.6_dbg/sql/sql_union.cc:1556
|
#4 0x0000561299e9c723 in mysql_derived_prepare (thd=0x151534000db8, lex=<optimized out>, derived=0x151534032cc8) at /test/10.6_dbg/sql/sql_derived.cc:855
|
#5 0x0000561299e9aa02 in mysql_handle_single_derived (lex=lex@entry=0x15153402daa8, derived=derived@entry=0x151534032cc8, phases=phases@entry=2) at /test/10.6_dbg/sql/sql_derived.cc:200
|
#6 0x000056129a017b79 in TABLE_LIST::handle_derived (this=this@entry=0x151534032cc8, lex=lex@entry=0x15153402daa8, phases=phases@entry=2) at /test/10.6_dbg/sql/table.cc:9219
|
#7 0x0000561299ebe34f in LEX::handle_list_of_derived (phases=2, table_list=<optimized out>, this=0x15153402daa8) at /test/10.6_dbg/sql/table.h:2754
|
#8 st_select_lex::handle_derived (this=<optimized out>, lex=0x15153402daa8, phases=phases@entry=2) at /test/10.6_dbg/sql/sql_lex.cc:4995
|
#9 0x0000561299f5d64d in JOIN::prepare (this=0x1515340146b0, tables_init=<optimized out>, conds_init=<optimized out>, og_num=0, order_init=<optimized out>, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x1515340311f0, unit_arg=0x151534031658) at /test/10.6_dbg/sql/sql_select.cc:1299
|
#10 0x000056129a2d0aed in subselect_single_select_engine::prepare (this=0x1515340335e0, thd=0x151534000db8) at /test/10.6_dbg/sql/sql_lex.h:1377
|
#11 0x000056129a2cff37 in Item_subselect::fix_fields (this=this@entry=0x1515340333b8, thd_param=thd_param@entry=0x151534000db8, ref=ref@entry=0x15153407cb10) at /test/10.6_dbg/sql/item_subselect.cc:293
|
#12 0x000056129a2d05c8 in Item_in_subselect::fix_fields (this=0x1515340333b8, thd_arg=0x151534000db8, ref=0x15153407cb10) at /test/10.6_dbg/sql/item_subselect.cc:3545
|
#13 0x000056129a226361 in Item::fix_fields_if_needed (ref=<optimized out>, thd=0x151534000db8, this=<optimized out>) at /test/10.6_dbg/sql/item.h:1144
|
#14 Item_in_optimizer::fix_fields (this=0x15153407ca90, thd=0x151534000db8, ref=<optimized out>) at /test/10.6_dbg/sql/item_cmpfunc.cc:1371
|
#15 0x000056129a25981a in Item::fix_fields_if_needed (ref=0x151534033698, thd=0x151534000db8, this=<optimized out>) at /test/10.6_dbg/sql/item.h:1144
|
#16 Item_func::fix_fields (this=this@entry=0x151534033620, thd=thd@entry=0x151534000db8, ref=ref@entry=0x151534014538) at /test/10.6_dbg/sql/item_func.cc:347
|
#17 0x000056129a22120d in Item_func_not::fix_fields (this=0x151534033620, thd=0x151534000db8, ref=0x151534014538) at /test/10.6_dbg/sql/item_cmpfunc.cc:6451
|
#18 0x0000561299e6c863 in Item::fix_fields_if_needed (ref=0x151534014538, thd=0x151534000db8, this=0x151534033620) at /test/10.6_dbg/sql/item.h:1152
|
#19 Item::fix_fields_if_needed_for_scalar (ref=0x151534014538, thd=0x151534000db8, this=0x151534033620) at /test/10.6_dbg/sql/item.h:1148
|
#20 Item::fix_fields_if_needed_for_bool (ref=0x151534014538, thd=0x151534000db8, this=0x151534033620) at /test/10.6_dbg/sql/item.h:1152
|
#21 setup_conds (thd=thd@entry=0x151534000db8, tables=tables@entry=0x15153402fcd0, leaves=@0x15153402f910: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x1515340146a0, last = 0x1515340146a0, elements = 1}, <No data fields>}, conds=conds@entry=0x151534014538) at /test/10.6_dbg/sql/sql_base.cc:8432
|
#22 0x0000561299f5dcda in setup_without_group (reserved=0x15153402fab4, hidden_group_fields=0x15153401440f, win_funcs=@0x15153402fb48: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x56129b4e3180 <end_of_list>, last = 0x15153402fb48, elements = 0}, <No data fields>}, win_specs=@0x15153402fb30: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x56129b4e3180 <end_of_list>, last = 0x15153402fb30, elements = 0}, <No data fields>}, group=0x0, order=0x0, conds=0x151534014538, all_fields=@0x151534014450: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x15153402fc88, last = 0x15153402fc88, elements = 1}, <No data fields>}, fields=@0x15153402f998: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x15153402fc88, last = 0x15153402fc88, elements = 1}, <No data fields>}, leaves=@0x15153402f910: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x1515340146a0, last = 0x1515340146a0, elements = 1}, <No data fields>}, tables=0x15153402fcd0, ref_pointer_array=<optimized out>, thd=0x151534000db8) at /test/10.6_dbg/sql/sql_select.cc:832
|
#23 JOIN::prepare (this=this@entry=0x1515340140f8, tables_init=tables_init@entry=0x15153402fcd0, conds_init=conds_init@entry=0x151534033620, og_num=og_num@entry=0, order_init=order_init@entry=0x0, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x15153402f6f8, unit_arg=0x15153402db70) at /test/10.6_dbg/sql/sql_select.cc:1401
|
#24 0x0000561299f76a08 in mysql_select (thd=thd@entry=0x151534000db8, tables=0x15153402fcd0, fields=@0x15153402f998: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x15153402fc88, last = 0x15153402fc88, elements = 1}, <No data fields>}, conds=0x151534033620, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2201171004160, result=0x151534030fc8, unit=0x15153402db70, select_lex=0x15153402f6f8) at /test/10.6_dbg/sql/sql_select.cc:4958
|
#25 0x0000561299f76d2f in handle_select (thd=thd@entry=0x151534000db8, lex=lex@entry=0x15153402daa8, result=result@entry=0x151534030fc8, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.6_dbg/sql/sql_select.cc:544
|
#26 0x0000561299eea6ac in execute_sqlcom_select (thd=thd@entry=0x151534000db8, all_tables=0x15153402fcd0) at /test/10.6_dbg/sql/sql_parse.cc:6242
|
#27 0x0000561299ef758c in mysql_execute_command (thd=0x151534000db8) at /test/10.6_dbg/sql/sql_parse.cc:3937
|
#28 0x0000561299f11299 in Prepared_statement::execute (this=this@entry=0x151534028e08, expanded_query=expanded_query@entry=0x151578093d90, open_cursor=open_cursor@entry=false) at /test/10.6_dbg/sql/sql_prepare.cc:5049
|
#29 0x0000561299f115e7 in Prepared_statement::execute_loop (this=this@entry=0x151534028e08, expanded_query=expanded_query@entry=0x151578093d90, open_cursor=open_cursor@entry=false, packet=packet@entry=0x0, packet_end=packet_end@entry=0x0) at /test/10.6_dbg/sql/sql_prepare.cc:4511
|
#30 0x0000561299f11b17 in mysql_sql_stmt_execute (thd=thd@entry=0x151534000db8) at /test/10.6_dbg/sql/sql_prepare.cc:3576
|
#31 0x0000561299ef75f3 in mysql_execute_command (thd=thd@entry=0x151534000db8) at /test/10.6_dbg/sql/sql_parse.cc:3953
|
#32 0x0000561299ee3adc in mysql_parse (thd=thd@entry=0x151534000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x151578094400) at /test/10.6_dbg/sql/sql_parse.cc:8016
|
#33 0x0000561299ef2646 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x151534000db8, packet=packet@entry=0x15153400b769 "EXECUTE p", packet_length=packet_length@entry=9, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_class.h:1340
|
#34 0x0000561299ef5a26 in do_command (thd=0x151534000db8, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_parse.cc:1406
|
#35 0x000056129a059ec2 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x56129c81dc58, put_in_cache=put_in_cache@entry=true) at /test/10.6_dbg/sql/sql_connect.cc:1410
|
#36 0x000056129a05a4c7 in handle_one_connection (arg=arg@entry=0x56129c81dc58) at /test/10.6_dbg/sql/sql_connect.cc:1312
|
#37 0x000056129a50603a in pfs_spawn_thread (arg=0x56129c706128) at /test/10.6_dbg/storage/perfschema/pfs.cc:2201
|
#38 0x000015157a564609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#39 0x000015157a153293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Bug confirmed present in:
MariaDB: 10.3.29 (dbg), 10.3.29 (opt), 10.4.19 (dbg), 10.4.19 (opt), 10.5.10 (dbg), 10.5.10 (opt), 10.6.2 (dbg), 10.6.2 (opt)
Bug (or feature/syntax) confirmed not present in:
MariaDB: 10.2.38 (dbg), 10.2.38 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.34 (dbg), 5.7.34 (opt), 8.0.24 (dbg), 8.0.24 (opt)
Various testcases produce a variety of stacks across versions. List (likely incomplete):
SIGSEGV|Item::fix_fields_if_needed|fix_fields_for_tvc|table_value_constr::prepare|st_select_lex_unit::prepare
|
SIGSEGV|select_unit::cleanup|Item::fix_fields_if_needed|fix_fields_for_tvc|table_value_constr::prepare
|
SIGSEGV|Item::fix_fields_if_needed_for_scalar|fix_fields_for_tvc|table_value_constr::prepare|st_select_lex_unit::prepare
|
SIGSEGV|Item::fix_fields_if_needed|Item::fix_fields_if_needed_for_scalar|fix_fields_for_tvc|table_value_constr::prepare
|
SIGSEGV|Item::fix_fields_if_needed|Item::fix_fields_if_needed|Item::fix_fields_if_needed_for_scalar|fix_fields_for_tvc
|
Reproduction is easy/straightforward, inc on latest 10.7 trunk. Example:
|
10.7.0 1bc82aaf0a7746c0921a94034aff2d51f0d75cd0 (Debug) |
10.7.0-dbg>SET collation_connection=utf32_czech_ci;
|
Query OK, 0 rows affected (0.001 sec)
|
|
|
10.7.0-dbg>CREATE TABLE t1 (c VARCHAR(1)) ENGINE=InnoDB;
|
Query OK, 0 rows affected (0.019 sec)
|
|
|
10.7.0-dbg>SET in_predicate_conversion_threshold=2;
|
Query OK, 0 rows affected (0.000 sec)
|
|
|
10.7.0-dbg>PREPARE p FROM 'SELECT * FROM t1 WHERE c NOT IN (\'a\',\'a\')';
|
Query OK, 0 rows affected (0.001 sec)
|
Statement prepared
|
|
|
10.7.0-dbg>EXECUTE p;
|
Empty set (0.005 sec)
|
|
|
10.7.0-dbg>EXECUTE p;
|
ERROR 2013 (HY000): Lost connection to server during query
|
The query of the original reported test case can be simplified up to
PREPARE stmt FROM "SELECT * FROM t1 WHERE f IN ('a','b','c')"; |
The following diff fixes the problem in a robust and safe way:
diff --git a/sql/sql_tvc.cc b/sql/sql_tvc.cc
|
index 63e9e76..41888e0 100644
|
--- a/sql/sql_tvc.cc
|
+++ b/sql/sql_tvc.cc
|
@@ -538,7 +538,9 @@ bool Item_func_in::create_value_list_for_tvc(THD *thd,
|
|
if (is_list_of_rows)
|
{
|
- Item_row *row_list= (Item_row *)(args[i]);
|
+ Item_row *row_list= (Item_row *)(args[i]->build_clone(thd));
|
+ if (!row_list)
|
+ return true;
|
|
for (uint j=0; j < row_list->cols(); j++)
|
{
|
@@ -560,7 +562,8 @@ bool Item_func_in::create_value_list_for_tvc(THD *thd,
|
sprintf(col_name, "_col_%i", 1);
|
args[i]->set_name(thd, col_name, strlen(col_name), thd->charset());
|
}
|
- if (tvc_value->push_back(args[i]->real_item()))
|
+ Item *arg_clone= args[i]->build_clone(thd);
|
+ if (!arg_clone || tvc_value->push_back(arg_clone))
|
return true;
|
}
|
If arg[i] is too complicated and build_clone() fails the transformation is of no practical value.
The transformation takes those clones of arg[i] s that we get at the first execution. The precondition for the transformation checks that all arg[i] s are inexpensive constants (no '?').
A test case with a row expression in the left part of IN should be added.
The new code causes asserts / Communication packets out of order.
Here is a test case (can be simplified):
prepare stmt from "SELECT `uid` FROM `t1` WHERE (`uid` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (`no_search_sub_entries` = ?)";
set @param1=1;
set @param2=2;
set @param3=3;
set @param4=4;
set @param5=5;
set @param6=6;
set @param7=7;
set @param8=8;
set @param9=9;
set @param10=10;
set @param11=11;
set @param12=12;
set @param13=13;
set @param14=14;
set @param15=15;
set @param16=16;
set @param17=17;
set @param18=18;
set @param19=19;
set @param20=20;
set @param21=21;
set @param22=22;
set @param23=23;
set @param24=24;
set @param25=25;
set @param26=26;
set @param27=27;
set @param28=28;
set @param29=29;
set @param30=30;
set @param31=31;
set @param32=32;
set @param33=33;
set @param34=34;
set @param35=35;
set @param36=36;
set @param37=37;
set @param38=38;
set @param39=39;
set @param40=40;
set @param41=41;
set @param42=42;
set @param43=43;
set @param44=44;
set @param45=45;
set @param46=46;
set @param47=47;
set @param48=48;
set @param49=49;
set @param50=50;
set @param51=51;
set @param52=52;
set @param53=53;
set @param54=54;
set @param55=55;
set @param56=56;
set @param57=57;
set @param58=58;
set @param59=59;
set @param60=60;
set @param61=61;
set @param62=62;
set @param63=63;
set @param64=64;
set @param65=65;
set @param66=66;
set @param67=67;
set @param68=68;
set @param69=69;
set @param70=70;
set @param71=71;
set @param72=72;
set @param73=73;
set @param74=74;
set @param75=75;
set @param76=76;
set @param77=77;
set @param78=78;
set @param79=79;
set @param80=80;
set @param81=81;
set @param82=82;
set @param83=83;
set @param84=84;
set @param85=85;
set @param86=86;
set @param87=87;
set @param88=88;
set @param89=89;
set @param90=90;
set @param91=91;
set @param92=92;
set @param93=93;
set @param94=94;
set @param95=95;
set @param96=96;
set @param97=97;
set @param98=98;
set @param99=99;
set @param100=100;
set @param101=101;
set @param102=102;
set @param103=103;
set @param104=104;
set @param105=105;
set @param106=106;
set @param107=107;
set @param108=108;
set @param109=109;
set @param110=110;
set @param111=111;
set @param112=112;
set @param113=113;
set @param114=114;
set @param115=115;
set @param116=116;
set @param117=117;
set @param118=118;
set @param119=119;
set @param120=120;
set @param121=121;
set @param122=122;
set @param123=123;
set @param124=124;
set @param125=125;
set @param126=126;
set @param127=127;
set @param128=128;
set @param129=129;
set @param130=130;
set @param131=131;
set @param132=132;
set @param133=133;
set @param134=134;
set @param135=135;
set @param136=136;
set @param137=137;
set @param138=138;
set @param139=139;
set @param140=140;
set @param141=141;
set @param142=142;
set @param143=143;
set @param144=144;
set @param145=145;
set @param146=146;
set @param147=147;
set @param148=148;
set @param149=149;
set @param150=150;
set @param151=151;
set @param152=152;
set @param153=153;
set @param154=154;
set @param155=155;
set @param156=156;
set @param157=157;
set @param158=158;
set @param159=159;
set @param160=160;
set @param161=161;
set @param162=162;
set @param163=163;
set @param164=164;
set @param165=165;
set @param166=166;
set @param167=167;
set @param168=168;
set @param169=169;
set @param170=170;
set @param171=171;
set @param172=172;
set @param173=173;
set @param174=174;
set @param175=175;
set @param176=176;
set @param177=177;
set @param178=178;
set @param179=179;
set @param180=180;
set @param181=181;
set @param182=182;
set @param183=183;
set @param184=184;
set @param185=185;
set @param186=186;
set @param187=187;
set @param188=188;
set @param189=189;
set @param190=190;
set @param191=191;
set @param192=192;
set @param193=193;
set @param194=194;
set @param195=195;
set @param196=196;
set @param197=197;
set @param198=198;
set @param199=199;
set @param200=200;
set @param201=201;
set @param202=202;
set @param203=203;
set @param204=204;
set @param205=205;
set @param206=206;
set @param207=207;
set @param208=208;
set @param209=209;
set @param210=210;
set @param211=211;
set @param212=212;
set @param213=213;
set @param214=214;
set @param215=215;
set @param216=216;
set @param217=217;
set @param218=218;
set @param219=219;
set @param220=220;
set @param221=221;
set @param222=222;
set @param223=223;
set @param224=224;
set @param225=225;
set @param226=226;
set @param227=227;
set @param228=228;
set @param229=229;
set @param230=230;
set @param231=231;
set @param232=232;
set @param233=233;
set @param234=234;
set @param235=235;
set @param236=236;
set @param237=237;
set @param238=238;
set @param239=239;
set @param240=240;
set @param241=241;
set @param242=242;
set @param243=243;
set @param244=244;
set @param245=245;
set @param246=246;
set @param247=247;
set @param248=248;
set @param249=249;
set @param250=250;
set @param251=251;
set @param252=252;
set @param253=253;
set @param254=254;
set @param255=255;
set @param256=256;
set @param257=257;
set @param258=258;
set @param259=259;
set @param260=260;
set @param261=261;
set @param262=262;
set @param263=263;
set @param264=264;
set @param265=265;
set @param266=266;
set @param267=267;
set @param268=268;
set @param269=269;
set @param270=270;
set @param271=271;
set @param272=272;
set @param273=273;
set @param274=274;
set @param275=275;
set @param276=276;
set @param277=277;
set @param278=278;
set @param279=279;
set @param280=280;
set @param281=281;
set @param282=282;
set @param283=283;
set @param284=284;
set @param285=285;
set @param286=286;
set @param287=287;
set @param288=288;
set @param289=289;
set @param290=290;
set @param291=291;
set @param292=292;
set @param293=293;
set @param294=294;
set @param295=295;
set @param296=296;
set @param297=297;
set @param298=298;
set @param299=299;
set @param300=300;
set @param301=301;
set @param302=302;
set @param303=303;
set @param304=304;
set @param305=305;
set @param306=306;
set @param307=307;
set @param308=308;
set @param309=309;
set @param310=310;
set @param311=311;
set @param312=312;
set @param313=313;
set @param314=314;
set @param315=315;
set @param316=316;
set @param317=317;
set @param318=318;
set @param319=319;
set @param320=320;
set @param321=321;
set @param322=322;
set @param323=323;
set @param324=324;
set @param325=325;
set @param326=326;
set @param327=327;
set @param328=328;
set @param329=329;
set @param330=330;
set @param331=331;
set @param332=332;
set @param333=333;
set @param334=334;
set @param335=335;
set @param336=336;
set @param337=337;
set @param338=338;
set @param339=339;
set @param340=340;
set @param341=341;
set @param342=342;
set @param343=343;
set @param344=344;
set @param345=345;
set @param346=346;
set @param347=347;
set @param348=348;
set @param349=349;
set @param350=350;
set @param351=351;
set @param352=352;
set @param353=353;
set @param354=354;
set @param355=355;
set @param356=356;
set @param357=357;
set @param358=358;
set @param359=359;
set @param360=360;
set @param361=361;
set @param362=362;
set @param363=363;
set @param364=364;
set @param365=365;
set @param366=366;
set @param367=367;
set @param368=368;
set @param369=369;
set @param370=370;
set @param371=371;
set @param372=372;
set @param373=373;
set @param374=374;
set @param375=375;
set @param376=376;
set @param377=377;
set @param378=378;
set @param379=379;
set @param380=380;
set @param381=381;
set @param382=382;
set @param383=383;
set @param384=384;
set @param385=385;
set @param386=386;
set @param387=387;
set @param388=388;
set @param389=389;
set @param390=390;
set @param391=391;
set @param392=392;
set @param393=393;
set @param394=394;
set @param395=395;
set @param396=396;
set @param397=397;
set @param398=398;
set @param399=399;
set @param400=400;
set @param401=401;
set @param402=402;
set @param403=403;
set @param404=404;
set @param405=405;
set @param406=406;
set @param407=407;
set @param408=408;
set @param409=409;
set @param410=410;
set @param411=411;
set @param412=412;
set @param413=413;
set @param414=414;
set @param415=415;
set @param416=416;
set @param417=417;
set @param418=418;
set @param419=419;
set @param420=420;
set @param421=421;
set @param422=422;
set @param423=423;
set @param424=424;
set @param425=425;
set @param426=426;
set @param427=427;
set @param428=428;
set @param429=429;
set @param430=430;
set @param431=431;
set @param432=432;
set @param433=433;
set @param434=434;
set @param435=435;
set @param436=436;
set @param437=437;
set @param438=438;
set @param439=439;
set @param440=440;
set @param441=441;
set @param442=442;
set @param443=443;
set @param444=444;
set @param445=445;
set @param446=446;
set @param447=447;
set @param448=448;
set @param449=449;
set @param450=450;
set @param451=451;
set @param452=452;
set @param453=453;
set @param454=454;
set @param455=455;
set @param456=456;
set @param457=457;
set @param458=458;
set @param459=459;
set @param460=460;
set @param461=461;
set @param462=462;
set @param463=463;
set @param464=464;
set @param465=465;
set @param466=466;
set @param467=467;
set @param468=468;
set @param469=469;
set @param470=470;
set @param471=471;
set @param472=472;
set @param473=473;
set @param474=474;
set @param475=475;
set @param476=476;
set @param477=477;
set @param478=478;
set @param479=479;
set @param480=480;
set @param481=481;
set @param482=482;
set @param483=483;
set @param484=484;
set @param485=485;
set @param486=486;
set @param487=487;
set @param488=488;
set @param489=489;
set @param490=490;
set @param491=491;
set @param492=492;
set @param493=493;
set @param494=494;
set @param495=495;
set @param496=496;
set @param497=497;
set @param498=498;
set @param499=499;
set @param500=500;
set @param501=501;
set @param502=502;
set @param503=503;
set @param504=504;
set @param505=505;
set @param506=506;
set @param507=507;
set @param508=508;
set @param509=509;
set @param510=510;
set @param511=511;
set @param512=512;
set @param513=513;
set @param514=514;
set @param515=515;
set @param516=516;
set @param517=517;
set @param518=518;
set @param519=519;
set @param520=520;
set @param521=521;
set @param522=522;
set @param523=523;
set @param524=524;
set @param525=525;
set @param526=526;
set @param527=527;
set @param528=528;
set @param529=529;
set @param530=530;
set @param531=531;
set @param532=532;
set @param533=533;
set @param534=534;
set @param535=535;
set @param536=536;
set @param537=537;
set @param538=538;
set @param539=539;
set @param540=540;
set @param541=541;
set @param542=542;
set @param543=543;
set @param544=544;
set @param545=545;
set @param546=546;
set @param547=547;
set @param548=548;
set @param549=549;
set @param550=550;
set @param551=551;
set @param552=552;
set @param553=553;
set @param554=554;
set @param555=555;
set @param556=556;
set @param557=557;
set @param558=558;
set @param559=559;
set @param560=560;
set @param561=561;
set @param562=562;
set @param563=563;
set @param564=564;
set @param565=565;
set @param566=566;
set @param567=567;
set @param568=568;
set @param569=569;
set @param570=570;
set @param571=571;
set @param572=572;
set @param573=573;
set @param574=574;
set @param575=575;
set @param576=576;
set @param577=577;
set @param578=578;
set @param579=579;
set @param580=580;
set @param581=581;
set @param582=582;
set @param583=583;
set @param584=584;
set @param585=585;
set @param586=586;
set @param587=587;
set @param588=588;
set @param589=589;
set @param590=590;
set @param591=591;
set @param592=592;
set @param593=593;
set @param594=594;
set @param595=595;
set @param596=596;
set @param597=597;
set @param598=598;
set @param599=599;
set @param600=600;
set @param601=601;
set @param602=602;
set @param603=603;
set @param604=604;
set @param605=605;
set @param606=606;
set @param607=607;
set @param608=608;
set @param609=609;
set @param610=610;
set @param611=611;
set @param612=612;
set @param613=613;
set @param614=614;
set @param615=615;
set @param616=616;
set @param617=617;
set @param618=618;
set @param619=619;
set @param620=620;
set @param621=621;
set @param622=622;
set @param623=623;
set @param624=624;
set @param625=625;
set @param626=626;
set @param627=627;
set @param628=628;
set @param629=629;
set @param630=630;
set @param631=631;
set @param632=632;
set @param633=633;
set @param634=634;
set @param635=635;
set @param636=636;
set @param637=637;
set @param638=638;
set @param639=639;
set @param640=640;
set @param641=641;
set @param642=642;
set @param643=643;
set @param644=644;
set @param645=645;
set @param646=646;
set @param647=647;
set @param648=648;
set @param649=649;
set @param650=650;
set @param651=651;
set @param652=652;
set @param653=653;
set @param654=654;
set @param655=655;
set @param656=656;
set @param657=657;
set @param658=658;
set @param659=659;
set @param660=660;
set @param661=661;
set @param662=662;
set @param663=663;
set @param664=664;
set @param665=665;
set @param666=666;
set @param667=667;
set @param668=668;
set @param669=669;
set @param670=670;
set @param671=671;
set @param672=672;
set @param673=673;
set @param674=674;
set @param675=675;
set @param676=676;
set @param677=677;
set @param678=678;
set @param679=679;
set @param680=680;
set @param681=681;
set @param682=682;
set @param683=683;
set @param684=684;
set @param685=685;
set @param686=686;
set @param687=687;
set @param688=688;
set @param689=689;
set @param690=690;
set @param691=691;
set @param692=692;
set @param693=693;
set @param694=694;
set @param695=695;
set @param696=696;
set @param697=697;
set @param698=698;
set @param699=699;
set @param700=700;
set @param701=701;
set @param702=702;
set @param703=703;
set @param704=704;
set @param705=705;
set @param706=706;
set @param707=707;
set @param708=708;
set @param709=709;
set @param710=710;
set @param711=711;
set @param712=712;
set @param713=713;
set @param714=714;
set @param715=715;
set @param716=716;
set @param717=717;
set @param718=718;
set @param719=719;
set @param720=720;
set @param721=721;
set @param722=722;
set @param723=723;
set @param724=724;
set @param725=725;
set @param726=726;
set @param727=727;
set @param728=728;
set @param729=729;
set @param730=730;
set @param731=731;
set @param732=732;
set @param733=733;
set @param734=734;
set @param735=735;
set @param736=736;
set @param737=737;
set @param738=738;
set @param739=739;
set @param740=740;
set @param741=741;
set @param742=742;
set @param743=743;
set @param744=744;
set @param745=745;
set @param746=746;
set @param747=747;
set @param748=748;
set @param749=749;
set @param750=750;
set @param751=751;
set @param752=752;
set @param753=753;
set @param754=754;
set @param755=755;
set @param756=756;
set @param757=757;
set @param758=758;
set @param759=759;
set @param760=760;
set @param761=761;
set @param762=762;
set @param763=763;
set @param764=764;
set @param765=765;
set @param766=766;
set @param767=767;
set @param768=768;
set @param769=769;
set @param770=770;
set @param771=771;
set @param772=772;
set @param773=773;
set @param774=774;
set @param775=775;
set @param776=776;
set @param777=777;
set @param778=778;
set @param779=779;
set @param780=780;
set @param781=781;
set @param782=782;
set @param783=783;
set @param784=784;
set @param785=785;
set @param786=786;
set @param787=787;
set @param788=788;
set @param789=789;
set @param790=790;
set @param791=791;
set @param792=792;
set @param793=793;
set @param794=794;
set @param795=795;
set @param796=796;
set @param797=797;
set @param798=798;
set @param799=799;
set @param800=800;
set @param801=801;
set @param802=802;
set @param803=803;
set @param804=804;
set @param805=805;
set @param806=806;
set @param807=807;
set @param808=808;
set @param809=809;
set @param810=810;
set @param811=811;
set @param812=812;
set @param813=813;
set @param814=814;
set @param815=815;
set @param816=816;
set @param817=817;
set @param818=818;
set @param819=819;
set @param820=820;
set @param821=821;
set @param822=822;
set @param823=823;
set @param824=824;
set @param825=825;
set @param826=826;
set @param827=827;
set @param828=828;
set @param829=829;
set @param830=830;
set @param831=831;
set @param832=832;
set @param833=833;
set @param834=834;
set @param835=835;
set @param836=836;
set @param837=837;
set @param838=838;
set @param839=839;
set @param840=840;
set @param841=841;
set @param842=842;
set @param843=843;
set @param844=844;
set @param845=845;
set @param846=846;
set @param847=847;
set @param848=848;
set @param849=849;
set @param850=850;
set @param851=851;
set @param852=852;
set @param853=853;
set @param854=854;
set @param855=855;
set @param856=856;
set @param857=857;
set @param858=858;
set @param859=859;
set @param860=860;
set @param861=861;
set @param862=862;
set @param863=863;
set @param864=864;
set @param865=865;
set @param866=866;
set @param867=867;
set @param868=868;
set @param869=869;
set @param870=870;
set @param871=871;
set @param872=872;
set @param873=873;
set @param874=874;
set @param875=875;
set @param876=876;
set @param877=877;
set @param878=878;
set @param879=879;
set @param880=880;
set @param881=881;
set @param882=882;
set @param883=883;
set @param884=884;
set @param885=885;
set @param886=886;
set @param887=887;
set @param888=888;
set @param889=889;
set @param890=890;
set @param891=891;
set @param892=892;
set @param893=893;
set @param894=894;
set @param895=895;
set @param896=896;
set @param897=897;
set @param898=898;
set @param899=899;
set @param900=900;
set @param901=901;
set @param902=902;
set @param903=903;
set @param904=904;
set @param905=905;
set @param906=906;
set @param907=907;
set @param908=908;
set @param909=909;
set @param910=910;
set @param911=911;
set @param912=912;
set @param913=913;
set @param914=914;
set @param915=915;
set @param916=916;
set @param917=917;
set @param918=918;
set @param919=919;
set @param920=920;
set @param921=921;
set @param922=922;
set @param923=923;
set @param924=924;
set @param925=925;
set @param926=926;
set @param927=927;
set @param928=928;
set @param929=929;
set @param930=930;
set @param931=931;
set @param932=932;
set @param933=933;
set @param934=934;
set @param935=935;
set @param936=936;
set @param937=937;
set @param938=938;
set @param939=939;
set @param940=940;
set @param941=941;
set @param942=942;
set @param943=943;
set @param944=944;
set @param945=945;
set @param946=946;
set @param947=947;
set @param948=948;
set @param949=949;
set @param950=950;
set @param951=951;
set @param952=952;
set @param953=953;
set @param954=954;
set @param955=955;
set @param956=956;
set @param957=957;
set @param958=958;
set @param959=959;
set @param960=960;
set @param961=961;
set @param962=962;
set @param963=963;
set @param964=964;
set @param965=965;
set @param966=966;
set @param967=967;
set @param968=968;
set @param969=969;
set @param970=970;
set @param971=971;
set @param972=972;
set @param973=973;
set @param974=974;
set @param975=975;
set @param976=976;
set @param977=977;
set @param978=978;
set @param979=979;
set @param980=980;
set @param981=981;
set @param982=982;
set @param983=983;
set @param984=984;
set @param985=985;
set @param986=986;
set @param987=987;
set @param988=988;
set @param989=989;
set @param990=990;
set @param991=991;
set @param992=992;
set @param993=993;
set @param994=994;
set @param995=995;
set @param996=996;
set @param997=997;
set @param998=998;
set @param999=999;
set @param1000=1000;
execute stmt using @param1,@param2,@param3,@param4,@param5,@param6,@param7,@param8,@param9,@param10,@param11,@param12,@param13,@param14,@param15,@param16,@param17,@param18,@param19,@param20,@param21,@param22,@param23,@param24,@param25,@param26,@param27,@param28,@param29,@param30,@param31,@param32,@param33,@param34,@param35,@param36,@param37,@param38,@param39,@param40,@param41,@param42,@param43,@param44,@param45,@param46,@param47,@param48,@param49,@param50,@param51,@param52,@param53,@param54,@param55,@param56,@param57,@param58,@param59,@param60,@param61,@param62,@param63,@param64,@param65,@param66,@param67,@param68,@param69,@param70,@param71,@param72,@param73,@param74,@param75,@param76,@param77,@param78,@param79,@param80,@param81,@param82,@param83,@param84,@param85,@param86,@param87,@param88,@param89,@param90,@param91,@param92,@param93,@param94,@param95,@param96,@param97,@param98,@param99,@param100,@param101,@param102,@param103,@param104,@param105,@param106,@param107,@param108,@param109,@param110,@param111,@param112,@param113,@param114,@param115,@param116,@param117,@param118,@param119,@param120,@param121,@param122,@param123,@param124,@param125,@param126,@param127,@param128,@param129,@param130,@param131,@param132,@param133,@param134,@param135,@param136,@param137,@param138,@param139,@param140,@param141,@param142,@param143,@param144,@param145,@param146,@param147,@param148,@param149,@param150,@param151,@param152,@param153,@param154,@param155,@param156,@param157,@param158,@param159,@param160,@param161,@param162,@param163,@param164,@param165,@param166,@param167,@param168,@param169,@param170,@param171,@param172,@param173,@param174,@param175,@param176,@param177,@param178,@param179,@param180,@param181,@param182,@param183,@param184,@param185,@param186,@param187,@param188,@param189,@param190,@param191,@param192,@param193,@param194,@param195,@param196,@param197,@param198,@param199,@param200,@param201,@param202,@param203,@param204,@param205,@param206,@param207,@param208,@param209,@param210,@param211,@param212,@param213,@param214,@param215,@param216,@param217,@param218,@param219,@param220,@param221,@param222,@param223,@param224,@param225,@param226,@param227,@param228,@param229,@param230,@param231,@param232,@param233,@param234,@param235,@param236,@param237,@param238,@param239,@param240,@param241,@param242,@param243,@param244,@param245,@param246,@param247,@param248,@param249,@param250,@param251,@param252,@param253,@param254,@param255,@param256,@param257,@param258,@param259,@param260,@param261,@param262,@param263,@param264,@param265,@param266,@param267,@param268,@param269,@param270,@param271,@param272,@param273,@param274,@param275,@param276,@param277,@param278,@param279,@param280,@param281,@param282,@param283,@param284,@param285,@param286,@param287,@param288,@param289,@param290,@param291,@param292,@param293,@param294,@param295,@param296,@param297,@param298,@param299,@param300,@param301,@param302,@param303,@param304,@param305,@param306,@param307,@param308,@param309,@param310,@param311,@param312,@param313,@param314,@param315,@param316,@param317,@param318,@param319,@param320,@param321,@param322,@param323,@param324,@param325,@param326,@param327,@param328,@param329,@param330,@param331,@param332,@param333,@param334,@param335,@param336,@param337,@param338,@param339,@param340,@param341,@param342,@param343,@param344,@param345,@param346,@param347,@param348,@param349,@param350,@param351,@param352,@param353,@param354,@param355,@param356,@param357,@param358,@param359,@param360,@param361,@param362,@param363,@param364,@param365,@param366,@param367,@param368,@param369,@param370,@param371,@param372,@param373,@param374,@param375,@param376,@param377,@param378,@param379,@param380,@param381,@param382,@param383,@param384,@param385,@param386,@param387,@param388,@param389,@param390,@param391,@param392,@param393,@param394,@param395,@param396,@param397,@param398,@param399,@param400,@param401,@param402,@param403,@param404,@param405,@param406,@param407,@param408,@param409,@param410,@param411,@param412,@param413,@param414,@param415,@param416,@param417,@param418,@param419,@param420,@param421,@param422,@param423,@param424,@param425,@param426,@param427,@param428,@param429,@param430,@param431,@param432,@param433,@param434,@param435,@param436,@param437,@param438,@param439,@param440,@param441,@param442,@param443,@param444,@param445,@param446,@param447,@param448,@param449,@param450,@param451,@param452,@param453,@param454,@param455,@param456,@param457,@param458,@param459,@param460,@param461,@param462,@param463,@param464,@param465,@param466,@param467,@param468,@param469,@param470,@param471,@param472,@param473,@param474,@param475,@param476,@param477,@param478,@param479,@param480,@param481,@param482,@param483,@param484,@param485,@param486,@param487,@param488,@param489,@param490,@param491,@param492,@param493,@param494,@param495,@param496,@param497,@param498,@param499,@param500,@param501,@param502,@param503,@param504,@param505,@param506,@param507,@param508,@param509,@param510,@param511,@param512,@param513,@param514,@param515,@param516,@param517,@param518,@param519,@param520,@param521,@param522,@param523,@param524,@param525,@param526,@param527,@param528,@param529,@param530,@param531,@param532,@param533,@param534,@param535,@param536,@param537,@param538,@param539,@param540,@param541,@param542,@param543,@param544,@param545,@param546,@param547,@param548,@param549,@param550,@param551,@param552,@param553,@param554,@param555,@param556,@param557,@param558,@param559,@param560,@param561,@param562,@param563,@param564,@param565,@param566,@param567,@param568,@param569,@param570,@param571,@param572,@param573,@param574,@param575,@param576,@param577,@param578,@param579,@param580,@param581,@param582,@param583,@param584,@param585,@param586,@param587,@param588,@param589,@param590,@param591,@param592,@param593,@param594,@param595,@param596,@param597,@param598,@param599,@param600,@param601,@param602,@param603,@param604,@param605,@param606,@param607,@param608,@param609,@param610,@param611,@param612,@param613,@param614,@param615,@param616,@param617,@param618,@param619,@param620,@param621,@param622,@param623,@param624,@param625,@param626,@param627,@param628,@param629,@param630,@param631,@param632,@param633,@param634,@param635,@param636,@param637,@param638,@param639,@param640,@param641,@param642,@param643,@param644,@param645,@param646,@param647,@param648,@param649,@param650,@param651,@param652,@param653,@param654,@param655,@param656,@param657,@param658,@param659,@param660,@param661,@param662,@param663,@param664,@param665,@param666,@param667,@param668,@param669,@param670,@param671,@param672,@param673,@param674,@param675,@param676,@param677,@param678,@param679,@param680,@param681,@param682,@param683,@param684,@param685,@param686,@param687,@param688,@param689,@param690,@param691,@param692,@param693,@param694,@param695,@param696,@param697,@param698,@param699,@param700,@param701,@param702,@param703,@param704,@param705,@param706,@param707,@param708,@param709,@param710,@param711,@param712,@param713,@param714,@param715,@param716,@param717,@param718,@param719,@param720,@param721,@param722,@param723,@param724,@param725,@param726,@param727,@param728,@param729,@param730,@param731,@param732,@param733,@param734,@param735,@param736,@param737,@param738,@param739,@param740,@param741,@param742,@param743,@param744,@param745,@param746,@param747,@param748,@param749,@param750,@param751,@param752,@param753,@param754,@param755,@param756,@param757,@param758,@param759,@param760,@param761,@param762,@param763,@param764,@param765,@param766,@param767,@param768,@param769,@param770,@param771,@param772,@param773,@param774,@param775,@param776,@param777,@param778,@param779,@param780,@param781,@param782,@param783,@param784,@param785,@param786,@param787,@param788,@param789,@param790,@param791,@param792,@param793,@param794,@param795,@param796,@param797,@param798,@param799,@param800,@param801,@param802,@param803,@param804,@param805,@param806,@param807,@param808,@param809,@param810,@param811,@param812,@param813,@param814,@param815,@param816,@param817,@param818,@param819,@param820,@param821,@param822,@param823,@param824,@param825,@param826,@param827,@param828,@param829,@param830,@param831,@param832,@param833,@param834,@param835,@param836,@param837,@param838,@param839,@param840,@param841,@param842,@param843,@param844,@param845,@param846,@param847,@param848,@param849,@param850,@param851,@param852,@param853,@param854,@param855,@param856,@param857,@param858,@param859,@param860,@param861,@param862,@param863,@param864,@param865,@param866,@param867,@param868,@param869,@param870,@param871,@param872,@param873,@param874,@param875,@param876,@param877,@param878,@param879,@param880,@param881,@param882,@param883,@param884,@param885,@param886,@param887,@param888,@param889,@param890,@param891,@param892,@param893,@param894,@param895,@param896,@param897,@param898,@param899,@param900,@param901,@param902,@param903,@param904,@param905,@param906,@param907,@param908,@param909,@param910,@param911,@param912,@param913,@param914,@param915,@param916,@param917,@param918,@param919,@param920,@param921,@param922,@param923,@param924,@param925,@param926,@param927,@param928,@param929,@param930,@param931,@param932,@param933,@param934,@param935,@param936,@param937,@param938,@param939,@param940,@param941,@param942,@param943,@param944,@param945,@param946,@param947,@param948,@param949,@param950,@param951,@param952,@param953,@param954,@param955,@param956,@param957,@param958,@param959,@param960,@param961,@param962,@param963,@param964,@param965,@param966,@param967,@param968,@param969,@param970,@param971,@param972,@param973,@param974,@param975,@param976,@param977,@param978,@param979,@param980,@param981,@param982,@param983,@param984,@param985,@param986,@param987,@param988,@param989,@param990,@param991,@param992,@param993,@param994,@param995,@param996,@param997,@param998,@param999,@param1000,@param1,@param2,@param3,@param4,@param5,@param6,@param7,@param8,@param9,@param10,@param11,@param12,@param13,@param14,@param15,@param16,@param17,@param18,@param19,@param20,@param21,@param22,@param23,@param24,@param25,@param26,@param27,@param28,@param29,@param30,@param31,@param32,@param33,@param34,@param35,@param36,@param37,@param38,@param39,@param40,@param41,@param42,@param43,@param44,@param45,@param46,@param47,@param48,@param49,@param50,@param51,@param52,@param53,@param54,@param55,@param56,@param57,@param58,@param59,@param60,@param61,@param62,@param63,@param64,@param65,@param66,@param67,@param68,@param69,@param70,@param71,@param72,@param73,@param74,@param75,@param76,@param77,@param78,@param79,@param80,@param81,@param82,@param83,@param84,@param85,@param86,@param87,@param88,@param89,@param90,@param91,@param92,@param93,@param94,@param95,@param96,@param97,@param98,@param99,@param100,@param101,@param102,@param103,@param104,@param105,@param106,@param107,@param108,@param109,@param110,@param111,@param112,@param113,@param114,@param115,@param116,@param117,@param118,@param119,@param120,@param121,@param122,@param123,@param124,@param125,@param126,@param127,@param128,@param129,@param130,@param131,@param132,@param133,@param134,@param135,@param136,@param137,@param138,@param139,@param140,@param141,@param142,@param143,@param144,@param145,@param146,@param147,@param148,@param149,@param150,@param151,@param152,@param153,@param154,@param155,@param156,@param157,@param158,@param159,@param160,@param161,@param162,@param163,@param164,@param165,@param166,@param167,@param168,@param169,@param170,@param171,@param172,@param173,@param174,@param175,@param176,@param177,@param178,@param179,@param180,@param181,@param182,@param183,@param184,@param185,@param186,@param187,@param188,@param189,@param190,@param191,@param192,@param193,@param194,@param195,@param196,@param197,@param198,@param199,@param200,@param201,@param202,@param203,@param204,@param205,@param206,@param207,@param208,@param209,@param210,@param211,@param212,@param213,@param214,@param215,@param216,@param217,@param218,@param219,@param220,@param221,@param222,@param223,@param224,@param225,@param226,@param227,@param228,@param229,@param230,@param231,@param232,@param233,@param234,@param235,@param236,@param237,@param238,@param239,@param240,@param241,@param242,@param243,@param244,@param245,@param246,@param247,@param248,@param249,@param250,@param251,@param252,@param253,@param254,@param255,@param256,@param257,@param258,@param259,@param260,@param261,@param262,@param263,@param264,@param265,@param266,@param267,@param268,@param269,@param270,@param271,@param272,@param273,@param274,@param275,@param276,@param277,@param278,@param279,@param280,@param281,@param282,@param283,@param284,@param285,@param286,@param287,@param288,@param289,@param290,@param291,@param292,@param293,@param294,@param295,@param296,@param297,@param298,@param299,@param300,@param301,@param302,@param303,@param304,@param305,@param306,@param307,@param308,@param309,@param310,@param311,@param312,@param313,@param314,@param315,@param316,@param317,@param318,@param319,@param320,@param321,@param322,@param323,@param324,@param325,@param326,@param327,@param328,@param329,@param330,@param331,@param332,@param333,@param334,@param335,@param336,@param337,@param338,@param339,@param340,@param341,@param342,@param343,@param344,@param345,@param346,@param347,@param348,@param349,@param350,@param351,@param352,@param353,@param354,@param355,@param356,@param357,@param358,@param359,@param360,@param361,@param362,@param363,@param364,@param365,@param366,@param367,@param368,@param369,@param370,@param371,@param372,@param373,@param374,@param375,@param376,@param377,@param378,@param379,@param380,@param381,@param382,@param383,@param384,@param385,@param386,@param387,@param388,@param389,@param390,@param391,@param392,@param393,@param394,@param395,@param396,@param397,@param398,@param399,@param400,@param401,@param402,@param403,@param404,@param405,@param406,@param407,@param408,@param409,@param410,@param411,@param412,@param413,@param414,@param415,@param416,@param417,@param418,@param419,@param420,@param421,@param422,@param423,@param424,@param425,@param426,@param427,@param428,@param429,@param430,@param431,@param432,@param433,@param434,@param435,@param436,@param437,@param438,@param439,@param440,@param441,@param442,@param443,@param444,@param445,@param446,@param447,@param448,@param449,@param450,@param451,@param452,@param453,@param454,@param455,@param456,@param457,@param458,@param459,@param460,@param461,@param462,@param463,@param464,@param465,@param466,@param467,@param468,@param469,@param470,@param471,@param472,@param473,@param474,@param475,@param476,@param477,@param478,@param479,@param480,@param481,@param482,@param483,@param484,@param485,@param486,@param487,@param488,@param489,@param490,@param491,@param492,@param493,@param494,@param495,@param496,@param497,@param498,@param499,@param500,@param501,@param502,@param503,@param504,@param505,@param506,@param507,@param508,@param509,@param510,@param511,@param512,@param513,@param514,@param515,@param516,@param517,@param518,@param519,@param520,@param521,@param522,@param523,@param524,@param525,@param526,@param527,@param528,@param529,@param530,@param531,@param532,@param533,@param534,@param535,@param536,@param537,@param538,@param539,@param540,@param541,@param542,@param543,@param544,@param545,@param546,@param547,@param548,@param549,@param550,@param551,@param552,@param553,@param554,@param555,@param556,@param557,@param558,@param559,@param560,@param561,@param562,@param563,@param564,@param565,@param566,@param567,@param568,@param569,@param570,@param571,@param572,@param573,@param574,@param575,@param576,@param577,@param578,@param579,@param580,@param581,@param582,@param583,@param584,@param585,@param586,@param587,@param588,@param589,@param590,@param591,@param592,@param593,@param594,@param595,@param596,@param597,@param598,@param599,@param600,@param601,@param602,@param603,@param604,@param605,@param606,@param607,@param608,@param609,@param610,@param611,@param612,@param613,@param614,@param615,@param616,@param617,@param618,@param619,@param620,@param621,@param622,@param623,@param624,@param625,@param626,@param627,@param628,@param629,@param630,@param631,@param632,@param633,@param634,@param635,@param636,@param637,@param638,@param639,@param640,@param641,@param642,@param643,@param644,@param645,@param646,@param647,@param648,@param649,@param650,@param651,@param652,@param653,@param654,@param655,@param656,@param657,@param658,@param659,@param660,@param661,@param662,@param663,@param664,@param665,@param666,@param667,@param668,@param669,@param670,@param671,@param672,@param673,@param674,@param675,@param676,@param677,@param678,@param679,@param680,@param681,@param682,@param683,@param684,@param685,@param686,@param687,@param688,@param689,@param690,@param691,@param692,@param693,@param694,@param695,@param696,@param697,@param698,@param699,@param700,@param701,@param702,@param703,@param704,@param705,@param706,@param707,@param708,@param709,@param710,@param711,@param712,@param713,@param714,@param715,@param716,@param717,@param718,@param719,@param720,@param721,@param722,@param723,@param724,@param725,@param726,@param727,@param728,@param729,@param730,@param731,@param732,@param733,@param734,@param735,@param736,@param737,@param738,@param739,@param740,@param741,@param742,@param743,@param744,@param745,@param746,@param747,@param748,@param749,@param750,@param751,@param752,@param753,@param754,@param755,@param756,@param757,@param758,@param759,@param760,@param761,@param762,@param763,@param764,@param765,@param766,@param767,@param768,@param769,@param770,@param771,@param772,@param773,@param774,@param775,@param776,@param777,@param778,@param779,@param780,@param781,@param782,@param783,@param784,@param785,@param786,@param787,@param788,@param789,@param790,@param791,@param792,@param793,@param794,@param795,@param796,@param797,@param798,@param799,@param800,@param801,@param802,@param803,@param804,@param805,@param806,@param807,@param808,@param809,@param810,@param811,@param812,@param813,@param814,@param815,@param816,@param817,@param818,@param819,@param820,@param821,@param822,@param823,@param824,@param825,@param826,@param827,@param828,@param829,@param830,@param831,@param832,@param833,@param834,@param835,@param836,@param837,@param838,@param839,@param840,@param841,@param842,@param843,@param844,@param845,@param846,@param847,@param848,@param849,@param850,@param851,@param852,@param853,@param854,@param855,@param856,@param857,@param858,@param859,@param860,@param861,@param862,@param863,@param864,@param865,@param866,@param867,@param868,@param869,@param870,@param871,@param872,@param873,@param874,@param875,@param876,@param877,@param878,@param879,@param880,@param881,@param882,@param883,@param884,@param885,@param886,@param887,@param888,@param889,@param890,@param891,@param892,@param893,@param894,@param895,@param896,@param897,@param898,@param899,@param900,@param901,@param902,@param903,@param904,@param905,@param906,@param907,@param908,@param909,@param910,@param911,@param912,@param913,@param914,@param915,@param916,@param917,@param918,@param919,@param920,@param921,@param922,@param923,@param924,@param925,@param926,@param927,@param928,@param929,@param930,@param931,@param932,@param933,@param934,@param935,@param936,@param937,@param938,@param939,@param940,@param941,@param942,@param943,@param944,@param945,@param946,@param947,@param948,@param949,@param950,@param951,@param952,@param953,@param954,@param955,@param956,@param957,@param958,@param959,@param960,@param961,@param962,@param963,@param964,@param965,@param966,@param967,@param968,@param969,@param970,@param971,@param972,@param973,@param974,@param975,@param976,@param977,@param978,@param979,@param980,@param981,@param982,@param983,@param984,@param985,@param986,@param987,@param988,@param989,@param990,@param991,@param992,@param993,@param994,@param995,@param996,@param997,@param998,@param999,@param1000,@param1;
This asserts because of this code in sql_tc.cc:
Item *arg_clone= args[i]->build_clone(thd);
if (!arg_clone || tvc_value->push_back(arg_clone))
return true;
parameters are constants and build_clone will return 0, which causes the function to return with an error condition, but because there was not error message, it causes an assert later in Protocol::end_statement() for debug servers or Communication packages out of order in production builds.
See last comment. This causes crashes/wrong results for anyone using prepared statements with more than in_predicate_conversion_threshold parameters and ? parameters.
Confirmed that the testcase crashes without modifying in_predicate_conversion_threshold on 10.9 debug when using SOURCE at the CLI (only). Optimized did not crash. Added table definition.
CREATE TABLE t (c1 INT,c2 INT) ENGINE=InnoDB;
|
PREPARE stmt FROM "SELECT c1 FROM t WHERE (c1 IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) AND (`c2` = ?)";
|
SET @param1=1,@param2=2,@param3=3,@param4=4,@param5=5,@param6=6,@param7=7,@param8=8,@param9=9,@param10=10,@param11=11,@param12=12,@param13=13,@param14=14,@param15=15,@param16=16,@param17=17,@param18=18,@param19=19,@param20=20,@param21=21,@param22=22,@param23=23,@param24=24,@param25=25,@param26=26,@param27=27,@param28=28,@param29=29,@param30=30,@param31=31,@param32=32,@param33=33,@param34=34,@param35=35,@param36=36,@param37=37,@param38=38,@param39=39,@param40=40,@param41=41,@param42=42,@param43=43,@param44=44,@param45=45,@param46=46,@param47=47,@param48=48,@param49=49,@param50=50,@param51=51,@param52=52,@param53=53,@param54=54,@param55=55,@param56=56,@param57=57,@param58=58,@param59=59,@param60=60,@param61=61,@param62=62,@param63=63,@param64=64,@param65=65,@param66=66,@param67=67,@param68=68,@param69=69,@param70=70,@param71=71,@param72=72,@param73=73,@param74=74,@param75=75,@param76=76,@param77=77,@param78=78,@param79=79,@param80=80,@param81=81,@param82=82,@param83=83,@param84=84,@param85=85,@param86=86,@param87=87,@param88=88,@param89=89,@param90=90,@param91=91,@param92=92,@param93=93,@param94=94,@param95=95,@param96=96,@param97=97,@param98=98,@param99=99,@param100=100,@param101=101,@param102=102,@param103=103,@param104=104,@param105=105,@param106=106,@param107=107,@param108=108,@param109=109,@param110=110,@param111=111,@param112=112,@param113=113,@param114=114,@param115=115,@param116=116,@param117=117,@param118=118,@param119=119,@param120=120,@param121=121,@param122=122,@param123=123,@param124=124,@param125=125,@param126=126,@param127=127,@param128=128,@param129=129,@param130=130,@param131=131,@param132=132,@param133=133,@param134=134,@param135=135,@param136=136,@param137=137,@param138=138,@param139=139,@param140=140,@param141=141,@param142=142,@param143=143,@param144=144,@param145=145,@param146=146,@param147=147,@param148=148,@param149=149,@param150=150,@param151=151,@param152=152,@param153=153,@param154=154,@param155=155,@param156=156,@param157=157,@param158=158,@param159=159,@param160=160,@param161=161,@param162=162,@param163=163,@param164=164,@param165=165,@param166=166,@param167=167,@param168=168,@param169=169,@param170=170,@param171=171,@param172=172,@param173=173,@param174=174,@param175=175,@param176=176,@param177=177,@param178=178,@param179=179,@param180=180,@param181=181,@param182=182,@param183=183,@param184=184,@param185=185,@param186=186,@param187=187,@param188=188,@param189=189,@param190=190,@param191=191,@param192=192,@param193=193,@param194=194,@param195=195,@param196=196,@param197=197,@param198=198,@param199=199,@param200=200,@param201=201,@param202=202,@param203=203,@param204=204,@param205=205,@param206=206,@param207=207,@param208=208,@param209=209,@param210=210,@param211=211,@param212=212,@param213=213,@param214=214,@param215=215,@param216=216,@param217=217,@param218=218,@param219=219,@param220=220,@param221=221,@param222=222,@param223=223,@param224=224,@param225=225,@param226=226,@param227=227,@param228=228,@param229=229,@param230=230,@param231=231,@param232=232,@param233=233,@param234=234,@param235=235,@param236=236,@param237=237,@param238=238,@param239=239,@param240=240,@param241=241,@param242=242,@param243=243,@param244=244,@param245=245,@param246=246,@param247=247,@param248=248,@param249=249,@param250=250,@param251=251,@param252=252,@param253=253,@param254=254,@param255=255,@param256=256,@param257=257,@param258=258,@param259=259,@param260=260,@param261=261,@param262=262,@param263=263,@param264=264,@param265=265,@param266=266,@param267=267,@param268=268,@param269=269,@param270=270,@param271=271,@param272=272,@param273=273,@param274=274,@param275=275,@param276=276,@param277=277,@param278=278,@param279=279,@param280=280,@param281=281,@param282=282,@param283=283,@param284=284,@param285=285,@param286=286,@param287=287,@param288=288,@param289=289,@param290=290,@param291=291,@param292=292,@param293=293,@param294=294,@param295=295,@param296=296,@param297=297,@param298=298,@param299=299,@param300=300,@param301=301,@param302=302,@param303=303,@param304=304,@param305=305,@param306=306,@param307=307,@param308=308,@param309=309,@param310=310,@param311=311,@param312=312,@param313=313,@param314=314,@param315=315,@param316=316,@param317=317,@param318=318,@param319=319,@param320=320,@param321=321,@param322=322,@param323=323,@param324=324,@param325=325,@param326=326,@param327=327,@param328=328,@param329=329,@param330=330,@param331=331,@param332=332,@param333=333,@param334=334,@param335=335,@param336=336,@param337=337,@param338=338,@param339=339,@param340=340,@param341=341,@param342=342,@param343=343,@param344=344,@param345=345,@param346=346,@param347=347,@param348=348,@param349=349,@param350=350,@param351=351,@param352=352,@param353=353,@param354=354,@param355=355,@param356=356,@param357=357,@param358=358,@param359=359,@param360=360,@param361=361,@param362=362,@param363=363,@param364=364,@param365=365,@param366=366,@param367=367,@param368=368,@param369=369,@param370=370,@param371=371,@param372=372,@param373=373,@param374=374,@param375=375,@param376=376,@param377=377,@param378=378,@param379=379,@param380=380,@param381=381,@param382=382,@param383=383,@param384=384,@param385=385,@param386=386,@param387=387,@param388=388,@param389=389,@param390=390,@param391=391,@param392=392,@param393=393,@param394=394,@param395=395,@param396=396,@param397=397,@param398=398,@param399=399,@param400=400,@param401=401,@param402=402,@param403=403,@param404=404,@param405=405,@param406=406,@param407=407,@param408=408,@param409=409,@param410=410,@param411=411,@param412=412,@param413=413,@param414=414,@param415=415,@param416=416,@param417=417,@param418=418,@param419=419,@param420=420,@param421=421,@param422=422,@param423=423,@param424=424,@param425=425,@param426=426,@param427=427,@param428=428,@param429=429,@param430=430,@param431=431,@param432=432,@param433=433,@param434=434,@param435=435,@param436=436,@param437=437,@param438=438,@param439=439,@param440=440,@param441=441,@param442=442,@param443=443,@param444=444,@param445=445,@param446=446,@param447=447,@param448=448,@param449=449,@param450=450,@param451=451,@param452=452,@param453=453,@param454=454,@param455=455,@param456=456,@param457=457,@param458=458,@param459=459,@param460=460,@param461=461,@param462=462,@param463=463,@param464=464,@param465=465,@param466=466,@param467=467,@param468=468,@param469=469,@param470=470,@param471=471,@param472=472,@param473=473,@param474=474,@param475=475,@param476=476,@param477=477,@param478=478,@param479=479,@param480=480,@param481=481,@param482=482,@param483=483,@param484=484,@param485=485,@param486=486,@param487=487,@param488=488,@param489=489,@param490=490,@param491=491,@param492=492,@param493=493,@param494=494,@param495=495,@param496=496,@param497=497,@param498=498,@param499=499,@param500=500,@param501=501,@param502=502,@param503=503,@param504=504,@param505=505,@param506=506,@param507=507,@param508=508,@param509=509,@param510=510,@param511=511,@param512=512,@param513=513,@param514=514,@param515=515,@param516=516,@param517=517,@param518=518,@param519=519,@param520=520,@param521=521,@param522=522,@param523=523,@param524=524,@param525=525,@param526=526,@param527=527,@param528=528,@param529=529,@param530=530,@param531=531,@param532=532,@param533=533,@param534=534,@param535=535,@param536=536,@param537=537,@param538=538,@param539=539,@param540=540,@param541=541,@param542=542,@param543=543,@param544=544,@param545=545,@param546=546,@param547=547,@param548=548,@param549=549,@param550=550,@param551=551,@param552=552,@param553=553,@param554=554,@param555=555,@param556=556,@param557=557,@param558=558,@param559=559,@param560=560,@param561=561,@param562=562,@param563=563,@param564=564,@param565=565,@param566=566,@param567=567,@param568=568,@param569=569,@param570=570,@param571=571,@param572=572,@param573=573,@param574=574,@param575=575,@param576=576,@param577=577,@param578=578,@param579=579,@param580=580,@param581=581,@param582=582,@param583=583,@param584=584,@param585=585,@param586=586,@param587=587,@param588=588,@param589=589,@param590=590,@param591=591,@param592=592,@param593=593,@param594=594,@param595=595,@param596=596,@param597=597,@param598=598,@param599=599,@param600=600,@param601=601,@param602=602,@param603=603,@param604=604,@param605=605,@param606=606,@param607=607,@param608=608,@param609=609,@param610=610,@param611=611,@param612=612,@param613=613,@param614=614,@param615=615,@param616=616,@param617=617,@param618=618,@param619=619,@param620=620,@param621=621,@param622=622,@param623=623,@param624=624,@param625=625,@param626=626,@param627=627,@param628=628,@param629=629,@param630=630,@param631=631,@param632=632,@param633=633,@param634=634,@param635=635,@param636=636,@param637=637,@param638=638,@param639=639,@param640=640,@param641=641,@param642=642,@param643=643,@param644=644,@param645=645,@param646=646,@param647=647,@param648=648,@param649=649,@param650=650,@param651=651,@param652=652,@param653=653,@param654=654,@param655=655,@param656=656,@param657=657,@param658=658,@param659=659,@param660=660,@param661=661,@param662=662,@param663=663,@param664=664,@param665=665,@param666=666,@param667=667,@param668=668,@param669=669,@param670=670,@param671=671,@param672=672,@param673=673,@param674=674,@param675=675,@param676=676,@param677=677,@param678=678,@param679=679,@param680=680,@param681=681,@param682=682,@param683=683,@param684=684,@param685=685,@param686=686,@param687=687,@param688=688,@param689=689,@param690=690,@param691=691,@param692=692,@param693=693,@param694=694,@param695=695,@param696=696,@param697=697,@param698=698,@param699=699,@param700=700,@param701=701,@param702=702,@param703=703,@param704=704,@param705=705,@param706=706,@param707=707,@param708=708,@param709=709,@param710=710,@param711=711,@param712=712,@param713=713,@param714=714,@param715=715,@param716=716,@param717=717,@param718=718,@param719=719,@param720=720,@param721=721,@param722=722,@param723=723,@param724=724,@param725=725,@param726=726,@param727=727,@param728=728,@param729=729,@param730=730,@param731=731,@param732=732,@param733=733,@param734=734,@param735=735,@param736=736,@param737=737,@param738=738,@param739=739,@param740=740,@param741=741,@param742=742,@param743=743,@param744=744,@param745=745,@param746=746,@param747=747,@param748=748,@param749=749,@param750=750,@param751=751,@param752=752,@param753=753,@param754=754,@param755=755,@param756=756,@param757=757,@param758=758,@param759=759,@param760=760,@param761=761,@param762=762,@param763=763,@param764=764,@param765=765,@param766=766,@param767=767,@param768=768,@param769=769,@param770=770,@param771=771,@param772=772,@param773=773,@param774=774,@param775=775,@param776=776,@param777=777,@param778=778,@param779=779,@param780=780,@param781=781,@param782=782,@param783=783,@param784=784,@param785=785,@param786=786,@param787=787,@param788=788,@param789=789,@param790=790,@param791=791,@param792=792,@param793=793,@param794=794,@param795=795,@param796=796,@param797=797,@param798=798,@param799=799,@param800=800,@param801=801,@param802=802,@param803=803,@param804=804,@param805=805,@param806=806,@param807=807,@param808=808,@param809=809,@param810=810,@param811=811,@param812=812,@param813=813,@param814=814,@param815=815,@param816=816,@param817=817,@param818=818,@param819=819,@param820=820,@param821=821,@param822=822,@param823=823,@param824=824,@param825=825,@param826=826,@param827=827,@param828=828,@param829=829,@param830=830,@param831=831,@param832=832,@param833=833,@param834=834,@param835=835,@param836=836,@param837=837,@param838=838,@param839=839,@param840=840,@param841=841,@param842=842,@param843=843,@param844=844,@param845=845,@param846=846,@param847=847,@param848=848,@param849=849,@param850=850,@param851=851,@param852=852,@param853=853,@param854=854,@param855=855,@param856=856,@param857=857,@param858=858,@param859=859,@param860=860,@param861=861,@param862=862,@param863=863,@param864=864,@param865=865,@param866=866,@param867=867,@param868=868,@param869=869,@param870=870,@param871=871,@param872=872,@param873=873,@param874=874,@param875=875,@param876=876,@param877=877,@param878=878,@param879=879,@param880=880,@param881=881,@param882=882,@param883=883,@param884=884,@param885=885,@param886=886,@param887=887,@param888=888,@param889=889,@param890=890,@param891=891,@param892=892,@param893=893,@param894=894,@param895=895,@param896=896,@param897=897,@param898=898,@param899=899,@param900=900,@param901=901,@param902=902,@param903=903,@param904=904,@param905=905,@param906=906,@param907=907,@param908=908,@param909=909,@param910=910,@param911=911,@param912=912,@param913=913,@param914=914,@param915=915,@param916=916,@param917=917,@param918=918,@param919=919,@param920=920,@param921=921,@param922=922,@param923=923,@param924=924,@param925=925,@param926=926,@param927=927,@param928=928,@param929=929,@param930=930,@param931=931,@param932=932,@param933=933,@param934=934,@param935=935,@param936=936,@param937=937,@param938=938,@param939=939,@param940=940,@param941=941,@param942=942,@param943=943,@param944=944,@param945=945,@param946=946,@param947=947,@param948=948,@param949=949,@param950=950,@param951=951,@param952=952,@param953=953,@param954=954,@param955=955,@param956=956,@param957=957,@param958=958,@param959=959,@param960=960,@param961=961,@param962=962,@param963=963,@param964=964,@param965=965,@param966=966,@param967=967,@param968=968,@param969=969,@param970=970,@param971=971,@param972=972,@param973=973,@param974=974,@param975=975,@param976=976,@param977=977,@param978=978,@param979=979,@param980=980,@param981=981,@param982=982,@param983=983,@param984=984,@param985=985,@param986=986,@param987=987,@param988=988,@param989=989,@param990=990,@param991=991,@param992=992,@param993=993,@param994=994,@param995=995,@param996=996,@param997=997,@param998=998,@param999=999,@param1000=1000;
|
EXECUTE stmt USING @param1,@param2,@param3,@param4,@param5,@param6,@param7,@param8,@param9,@param10,@param11,@param12,@param13,@param14,@param15,@param16,@param17,@param18,@param19,@param20,@param21,@param22,@param23,@param24,@param25,@param26,@param27,@param28,@param29,@param30,@param31,@param32,@param33,@param34,@param35,@param36,@param37,@param38,@param39,@param40,@param41,@param42,@param43,@param44,@param45,@param46,@param47,@param48,@param49,@param50,@param51,@param52,@param53,@param54,@param55,@param56,@param57,@param58,@param59,@param60,@param61,@param62,@param63,@param64,@param65,@param66,@param67,@param68,@param69,@param70,@param71,@param72,@param73,@param74,@param75,@param76,@param77,@param78,@param79,@param80,@param81,@param82,@param83,@param84,@param85,@param86,@param87,@param88,@param89,@param90,@param91,@param92,@param93,@param94,@param95,@param96,@param97,@param98,@param99,@param100,@param101,@param102,@param103,@param104,@param105,@param106,@param107,@param108,@param109,@param110,@param111,@param112,@param113,@param114,@param115,@param116,@param117,@param118,@param119,@param120,@param121,@param122,@param123,@param124,@param125,@param126,@param127,@param128,@param129,@param130,@param131,@param132,@param133,@param134,@param135,@param136,@param137,@param138,@param139,@param140,@param141,@param142,@param143,@param144,@param145,@param146,@param147,@param148,@param149,@param150,@param151,@param152,@param153,@param154,@param155,@param156,@param157,@param158,@param159,@param160,@param161,@param162,@param163,@param164,@param165,@param166,@param167,@param168,@param169,@param170,@param171,@param172,@param173,@param174,@param175,@param176,@param177,@param178,@param179,@param180,@param181,@param182,@param183,@param184,@param185,@param186,@param187,@param188,@param189,@param190,@param191,@param192,@param193,@param194,@param195,@param196,@param197,@param198,@param199,@param200,@param201,@param202,@param203,@param204,@param205,@param206,@param207,@param208,@param209,@param210,@param211,@param212,@param213,@param214,@param215,@param216,@param217,@param218,@param219,@param220,@param221,@param222,@param223,@param224,@param225,@param226,@param227,@param228,@param229,@param230,@param231,@param232,@param233,@param234,@param235,@param236,@param237,@param238,@param239,@param240,@param241,@param242,@param243,@param244,@param245,@param246,@param247,@param248,@param249,@param250,@param251,@param252,@param253,@param254,@param255,@param256,@param257,@param258,@param259,@param260,@param261,@param262,@param263,@param264,@param265,@param266,@param267,@param268,@param269,@param270,@param271,@param272,@param273,@param274,@param275,@param276,@param277,@param278,@param279,@param280,@param281,@param282,@param283,@param284,@param285,@param286,@param287,@param288,@param289,@param290,@param291,@param292,@param293,@param294,@param295,@param296,@param297,@param298,@param299,@param300,@param301,@param302,@param303,@param304,@param305,@param306,@param307,@param308,@param309,@param310,@param311,@param312,@param313,@param314,@param315,@param316,@param317,@param318,@param319,@param320,@param321,@param322,@param323,@param324,@param325,@param326,@param327,@param328,@param329,@param330,@param331,@param332,@param333,@param334,@param335,@param336,@param337,@param338,@param339,@param340,@param341,@param342,@param343,@param344,@param345,@param346,@param347,@param348,@param349,@param350,@param351,@param352,@param353,@param354,@param355,@param356,@param357,@param358,@param359,@param360,@param361,@param362,@param363,@param364,@param365,@param366,@param367,@param368,@param369,@param370,@param371,@param372,@param373,@param374,@param375,@param376,@param377,@param378,@param379,@param380,@param381,@param382,@param383,@param384,@param385,@param386,@param387,@param388,@param389,@param390,@param391,@param392,@param393,@param394,@param395,@param396,@param397,@param398,@param399,@param400,@param401,@param402,@param403,@param404,@param405,@param406,@param407,@param408,@param409,@param410,@param411,@param412,@param413,@param414,@param415,@param416,@param417,@param418,@param419,@param420,@param421,@param422,@param423,@param424,@param425,@param426,@param427,@param428,@param429,@param430,@param431,@param432,@param433,@param434,@param435,@param436,@param437,@param438,@param439,@param440,@param441,@param442,@param443,@param444,@param445,@param446,@param447,@param448,@param449,@param450,@param451,@param452,@param453,@param454,@param455,@param456,@param457,@param458,@param459,@param460,@param461,@param462,@param463,@param464,@param465,@param466,@param467,@param468,@param469,@param470,@param471,@param472,@param473,@param474,@param475,@param476,@param477,@param478,@param479,@param480,@param481,@param482,@param483,@param484,@param485,@param486,@param487,@param488,@param489,@param490,@param491,@param492,@param493,@param494,@param495,@param496,@param497,@param498,@param499,@param500,@param501,@param502,@param503,@param504,@param505,@param506,@param507,@param508,@param509,@param510,@param511,@param512,@param513,@param514,@param515,@param516,@param517,@param518,@param519,@param520,@param521,@param522,@param523,@param524,@param525,@param526,@param527,@param528,@param529,@param530,@param531,@param532,@param533,@param534,@param535,@param536,@param537,@param538,@param539,@param540,@param541,@param542,@param543,@param544,@param545,@param546,@param547,@param548,@param549,@param550,@param551,@param552,@param553,@param554,@param555,@param556,@param557,@param558,@param559,@param560,@param561,@param562,@param563,@param564,@param565,@param566,@param567,@param568,@param569,@param570,@param571,@param572,@param573,@param574,@param575,@param576,@param577,@param578,@param579,@param580,@param581,@param582,@param583,@param584,@param585,@param586,@param587,@param588,@param589,@param590,@param591,@param592,@param593,@param594,@param595,@param596,@param597,@param598,@param599,@param600,@param601,@param602,@param603,@param604,@param605,@param606,@param607,@param608,@param609,@param610,@param611,@param612,@param613,@param614,@param615,@param616,@param617,@param618,@param619,@param620,@param621,@param622,@param623,@param624,@param625,@param626,@param627,@param628,@param629,@param630,@param631,@param632,@param633,@param634,@param635,@param636,@param637,@param638,@param639,@param640,@param641,@param642,@param643,@param644,@param645,@param646,@param647,@param648,@param649,@param650,@param651,@param652,@param653,@param654,@param655,@param656,@param657,@param658,@param659,@param660,@param661,@param662,@param663,@param664,@param665,@param666,@param667,@param668,@param669,@param670,@param671,@param672,@param673,@param674,@param675,@param676,@param677,@param678,@param679,@param680,@param681,@param682,@param683,@param684,@param685,@param686,@param687,@param688,@param689,@param690,@param691,@param692,@param693,@param694,@param695,@param696,@param697,@param698,@param699,@param700,@param701,@param702,@param703,@param704,@param705,@param706,@param707,@param708,@param709,@param710,@param711,@param712,@param713,@param714,@param715,@param716,@param717,@param718,@param719,@param720,@param721,@param722,@param723,@param724,@param725,@param726,@param727,@param728,@param729,@param730,@param731,@param732,@param733,@param734,@param735,@param736,@param737,@param738,@param739,@param740,@param741,@param742,@param743,@param744,@param745,@param746,@param747,@param748,@param749,@param750,@param751,@param752,@param753,@param754,@param755,@param756,@param757,@param758,@param759,@param760,@param761,@param762,@param763,@param764,@param765,@param766,@param767,@param768,@param769,@param770,@param771,@param772,@param773,@param774,@param775,@param776,@param777,@param778,@param779,@param780,@param781,@param782,@param783,@param784,@param785,@param786,@param787,@param788,@param789,@param790,@param791,@param792,@param793,@param794,@param795,@param796,@param797,@param798,@param799,@param800,@param801,@param802,@param803,@param804,@param805,@param806,@param807,@param808,@param809,@param810,@param811,@param812,@param813,@param814,@param815,@param816,@param817,@param818,@param819,@param820,@param821,@param822,@param823,@param824,@param825,@param826,@param827,@param828,@param829,@param830,@param831,@param832,@param833,@param834,@param835,@param836,@param837,@param838,@param839,@param840,@param841,@param842,@param843,@param844,@param845,@param846,@param847,@param848,@param849,@param850,@param851,@param852,@param853,@param854,@param855,@param856,@param857,@param858,@param859,@param860,@param861,@param862,@param863,@param864,@param865,@param866,@param867,@param868,@param869,@param870,@param871,@param872,@param873,@param874,@param875,@param876,@param877,@param878,@param879,@param880,@param881,@param882,@param883,@param884,@param885,@param886,@param887,@param888,@param889,@param890,@param891,@param892,@param893,@param894,@param895,@param896,@param897,@param898,@param899,@param900,@param901,@param902,@param903,@param904,@param905,@param906,@param907,@param908,@param909,@param910,@param911,@param912,@param913,@param914,@param915,@param916,@param917,@param918,@param919,@param920,@param921,@param922,@param923,@param924,@param925,@param926,@param927,@param928,@param929,@param930,@param931,@param932,@param933,@param934,@param935,@param936,@param937,@param938,@param939,@param940,@param941,@param942,@param943,@param944,@param945,@param946,@param947,@param948,@param949,@param950,@param951,@param952,@param953,@param954,@param955,@param956,@param957,@param958,@param959,@param960,@param961,@param962,@param963,@param964,@param965,@param966,@param967,@param968,@param969,@param970,@param971,@param972,@param973,@param974,@param975,@param976,@param977,@param978,@param979,@param980,@param981,@param982,@param983,@param984,@param985,@param986,@param987,@param988,@param989,@param990,@param991,@param992,@param993,@param994,@param995,@param996,@param997,@param998,@param999,@param1000,@param1,@param2,@param3,@param4,@param5,@param6,@param7,@param8,@param9,@param10,@param11,@param12,@param13,@param14,@param15,@param16,@param17,@param18,@param19,@param20,@param21,@param22,@param23,@param24,@param25,@param26,@param27,@param28,@param29,@param30,@param31,@param32,@param33,@param34,@param35,@param36,@param37,@param38,@param39,@param40,@param41,@param42,@param43,@param44,@param45,@param46,@param47,@param48,@param49,@param50,@param51,@param52,@param53,@param54,@param55,@param56,@param57,@param58,@param59,@param60,@param61,@param62,@param63,@param64,@param65,@param66,@param67,@param68,@param69,@param70,@param71,@param72,@param73,@param74,@param75,@param76,@param77,@param78,@param79,@param80,@param81,@param82,@param83,@param84,@param85,@param86,@param87,@param88,@param89,@param90,@param91,@param92,@param93,@param94,@param95,@param96,@param97,@param98,@param99,@param100,@param101,@param102,@param103,@param104,@param105,@param106,@param107,@param108,@param109,@param110,@param111,@param112,@param113,@param114,@param115,@param116,@param117,@param118,@param119,@param120,@param121,@param122,@param123,@param124,@param125,@param126,@param127,@param128,@param129,@param130,@param131,@param132,@param133,@param134,@param135,@param136,@param137,@param138,@param139,@param140,@param141,@param142,@param143,@param144,@param145,@param146,@param147,@param148,@param149,@param150,@param151,@param152,@param153,@param154,@param155,@param156,@param157,@param158,@param159,@param160,@param161,@param162,@param163,@param164,@param165,@param166,@param167,@param168,@param169,@param170,@param171,@param172,@param173,@param174,@param175,@param176,@param177,@param178,@param179,@param180,@param181,@param182,@param183,@param184,@param185,@param186,@param187,@param188,@param189,@param190,@param191,@param192,@param193,@param194,@param195,@param196,@param197,@param198,@param199,@param200,@param201,@param202,@param203,@param204,@param205,@param206,@param207,@param208,@param209,@param210,@param211,@param212,@param213,@param214,@param215,@param216,@param217,@param218,@param219,@param220,@param221,@param222,@param223,@param224,@param225,@param226,@param227,@param228,@param229,@param230,@param231,@param232,@param233,@param234,@param235,@param236,@param237,@param238,@param239,@param240,@param241,@param242,@param243,@param244,@param245,@param246,@param247,@param248,@param249,@param250,@param251,@param252,@param253,@param254,@param255,@param256,@param257,@param258,@param259,@param260,@param261,@param262,@param263,@param264,@param265,@param266,@param267,@param268,@param269,@param270,@param271,@param272,@param273,@param274,@param275,@param276,@param277,@param278,@param279,@param280,@param281,@param282,@param283,@param284,@param285,@param286,@param287,@param288,@param289,@param290,@param291,@param292,@param293,@param294,@param295,@param296,@param297,@param298,@param299,@param300,@param301,@param302,@param303,@param304,@param305,@param306,@param307,@param308,@param309,@param310,@param311,@param312,@param313,@param314,@param315,@param316,@param317,@param318,@param319,@param320,@param321,@param322,@param323,@param324,@param325,@param326,@param327,@param328,@param329,@param330,@param331,@param332,@param333,@param334,@param335,@param336,@param337,@param338,@param339,@param340,@param341,@param342,@param343,@param344,@param345,@param346,@param347,@param348,@param349,@param350,@param351,@param352,@param353,@param354,@param355,@param356,@param357,@param358,@param359,@param360,@param361,@param362,@param363,@param364,@param365,@param366,@param367,@param368,@param369,@param370,@param371,@param372,@param373,@param374,@param375,@param376,@param377,@param378,@param379,@param380,@param381,@param382,@param383,@param384,@param385,@param386,@param387,@param388,@param389,@param390,@param391,@param392,@param393,@param394,@param395,@param396,@param397,@param398,@param399,@param400,@param401,@param402,@param403,@param404,@param405,@param406,@param407,@param408,@param409,@param410,@param411,@param412,@param413,@param414,@param415,@param416,@param417,@param418,@param419,@param420,@param421,@param422,@param423,@param424,@param425,@param426,@param427,@param428,@param429,@param430,@param431,@param432,@param433,@param434,@param435,@param436,@param437,@param438,@param439,@param440,@param441,@param442,@param443,@param444,@param445,@param446,@param447,@param448,@param449,@param450,@param451,@param452,@param453,@param454,@param455,@param456,@param457,@param458,@param459,@param460,@param461,@param462,@param463,@param464,@param465,@param466,@param467,@param468,@param469,@param470,@param471,@param472,@param473,@param474,@param475,@param476,@param477,@param478,@param479,@param480,@param481,@param482,@param483,@param484,@param485,@param486,@param487,@param488,@param489,@param490,@param491,@param492,@param493,@param494,@param495,@param496,@param497,@param498,@param499,@param500,@param501,@param502,@param503,@param504,@param505,@param506,@param507,@param508,@param509,@param510,@param511,@param512,@param513,@param514,@param515,@param516,@param517,@param518,@param519,@param520,@param521,@param522,@param523,@param524,@param525,@param526,@param527,@param528,@param529,@param530,@param531,@param532,@param533,@param534,@param535,@param536,@param537,@param538,@param539,@param540,@param541,@param542,@param543,@param544,@param545,@param546,@param547,@param548,@param549,@param550,@param551,@param552,@param553,@param554,@param555,@param556,@param557,@param558,@param559,@param560,@param561,@param562,@param563,@param564,@param565,@param566,@param567,@param568,@param569,@param570,@param571,@param572,@param573,@param574,@param575,@param576,@param577,@param578,@param579,@param580,@param581,@param582,@param583,@param584,@param585,@param586,@param587,@param588,@param589,@param590,@param591,@param592,@param593,@param594,@param595,@param596,@param597,@param598,@param599,@param600,@param601,@param602,@param603,@param604,@param605,@param606,@param607,@param608,@param609,@param610,@param611,@param612,@param613,@param614,@param615,@param616,@param617,@param618,@param619,@param620,@param621,@param622,@param623,@param624,@param625,@param626,@param627,@param628,@param629,@param630,@param631,@param632,@param633,@param634,@param635,@param636,@param637,@param638,@param639,@param640,@param641,@param642,@param643,@param644,@param645,@param646,@param647,@param648,@param649,@param650,@param651,@param652,@param653,@param654,@param655,@param656,@param657,@param658,@param659,@param660,@param661,@param662,@param663,@param664,@param665,@param666,@param667,@param668,@param669,@param670,@param671,@param672,@param673,@param674,@param675,@param676,@param677,@param678,@param679,@param680,@param681,@param682,@param683,@param684,@param685,@param686,@param687,@param688,@param689,@param690,@param691,@param692,@param693,@param694,@param695,@param696,@param697,@param698,@param699,@param700,@param701,@param702,@param703,@param704,@param705,@param706,@param707,@param708,@param709,@param710,@param711,@param712,@param713,@param714,@param715,@param716,@param717,@param718,@param719,@param720,@param721,@param722,@param723,@param724,@param725,@param726,@param727,@param728,@param729,@param730,@param731,@param732,@param733,@param734,@param735,@param736,@param737,@param738,@param739,@param740,@param741,@param742,@param743,@param744,@param745,@param746,@param747,@param748,@param749,@param750,@param751,@param752,@param753,@param754,@param755,@param756,@param757,@param758,@param759,@param760,@param761,@param762,@param763,@param764,@param765,@param766,@param767,@param768,@param769,@param770,@param771,@param772,@param773,@param774,@param775,@param776,@param777,@param778,@param779,@param780,@param781,@param782,@param783,@param784,@param785,@param786,@param787,@param788,@param789,@param790,@param791,@param792,@param793,@param794,@param795,@param796,@param797,@param798,@param799,@param800,@param801,@param802,@param803,@param804,@param805,@param806,@param807,@param808,@param809,@param810,@param811,@param812,@param813,@param814,@param815,@param816,@param817,@param818,@param819,@param820,@param821,@param822,@param823,@param824,@param825,@param826,@param827,@param828,@param829,@param830,@param831,@param832,@param833,@param834,@param835,@param836,@param837,@param838,@param839,@param840,@param841,@param842,@param843,@param844,@param845,@param846,@param847,@param848,@param849,@param850,@param851,@param852,@param853,@param854,@param855,@param856,@param857,@param858,@param859,@param860,@param861,@param862,@param863,@param864,@param865,@param866,@param867,@param868,@param869,@param870,@param871,@param872,@param873,@param874,@param875,@param876,@param877,@param878,@param879,@param880,@param881,@param882,@param883,@param884,@param885,@param886,@param887,@param888,@param889,@param890,@param891,@param892,@param893,@param894,@param895,@param896,@param897,@param898,@param899,@param900,@param901,@param902,@param903,@param904,@param905,@param906,@param907,@param908,@param909,@param910,@param911,@param912,@param913,@param914,@param915,@param916,@param917,@param918,@param919,@param920,@param921,@param922,@param923,@param924,@param925,@param926,@param927,@param928,@param929,@param930,@param931,@param932,@param933,@param934,@param935,@param936,@param937,@param938,@param939,@param940,@param941,@param942,@param943,@param944,@param945,@param946,@param947,@param948,@param949,@param950,@param951,@param952,@param953,@param954,@param955,@param956,@param957,@param958,@param959,@param960,@param961,@param962,@param963,@param964,@param965,@param966,@param967,@param968,@param969,@param970,@param971,@param972,@param973,@param974,@param975,@param976,@param977,@param978,@param979,@param980,@param981,@param982,@param983,@param984,@param985,@param986,@param987,@param988,@param989,@param990,@param991,@param992,@param993,@param994,@param995,@param996,@param997,@param998,@param999,@param1000,@param1;
|
Leads to:
|
10.9.0 4a2a9c02cd6611ef36bbb735c2b483dbc83580d4 (Debug) |
mysqld: /test/10.9_dbg/sql/protocol.cc:617: void Protocol::end_statement(): Assertion `0' failed.
|
|
10.9.0 4a2a9c02cd6611ef36bbb735c2b483dbc83580d4 (Debug) |
Core was generated by `/test/MD260222-mariadb-10.9.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.
|
Program terminated with signal SIGABRT, Aborted.
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
[Current thread is 1 (Thread 0x153f34108700 (LWP 1150944))]
|
(gdb) bt
|
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
|
#1 0x0000153f4a789859 in __GI_abort () at abort.c:79
|
#2 0x0000153f4a789729 in __assert_fail_base (fmt=0x153f4a91f588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x556ef541e1e7 "0", file=0x556ef5240e00 "/test/10.9_dbg/sql/protocol.cc", line=617, function=<optimized out>) at assert.c:92
|
#3 0x0000153f4a79b006 in __GI___assert_fail (assertion=assertion@entry=0x556ef541e1e7 "0", file=file@entry=0x556ef5240e00 "/test/10.9_dbg/sql/protocol.cc", line=line@entry=617, function=function@entry=0x556ef52416a0 "void Protocol::end_statement()") at assert.c:101
|
#4 0x0000556ef44800f4 in Protocol::end_statement (this=0x153efc0013a0) at /test/10.9_dbg/sql/protocol.cc:617
|
#5 0x0000556ef458dea2 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x153efc000db8, packet=<optimized out>, packet@entry=0x153efc162ae9 "EXECUTE stmt USING @param1,@param2,@param3,@param4,@param5,@param6,@param7,@param8,@param9,@param10,@param11,@param12,@param13,@param14,@param15,@param16,@param17,@param18,@param19,@param20,@param21,"..., packet_length=packet_length@entry=19813, blocking=blocking@entry=true) at /test/10.9_dbg/sql/sql_parse.cc:2401
|
#6 0x0000556ef458f426 in do_command (thd=0x153efc000db8, blocking=blocking@entry=true) at /test/10.9_dbg/sql/sql_parse.cc:1402
|
#7 0x0000556ef470a036 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x556ef7e523e8, put_in_cache=put_in_cache@entry=true) at /test/10.9_dbg/sql/sql_connect.cc:1418
|
#8 0x0000556ef470a63b in handle_one_connection (arg=arg@entry=0x556ef7e523e8) at /test/10.9_dbg/sql/sql_connect.cc:1312
|
#9 0x0000556ef4b90d23 in pfs_spawn_thread (arg=0x556ef7d65978) at /test/10.9_dbg/storage/perfschema/pfs.cc:2201
|
#10 0x0000153f4ac9a609 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
#11 0x0000153f4a886163 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
Same assert on 10.8 and 10.7. Did not test earlier versions, but assume same result.
monty, we have a separate bug report for this, MDEV-27937. I don't think this one needs re-opening.
Secondary testcase, different stack.
SET SESSION in_predicate_conversion_threshold=1;CREATE TABLE H (c VARCHAR(1) PRIMARY KEY) ENGINE=InnoDB;PREPARE p FROM 'SELECT * FROM H WHERE c NOT IN (\'a\', \'a\')';EXECUTE p;EXECUTE p;Leads to:
10.4.15 1cda462f46305daf2a5becb1ed0ce4fcdf3ae404 (Optimized)
Core was generated by `/test/MD040920-mariadb-10.4.15-linux-x86_64-opt/bin/mysqld --no-defaults --core'.Program terminated with signal SIGSEGV, Segmentation fault.#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=11)at ../sysdeps/unix/sysv/linux/pthread_kill.c:57[Current thread is 1 (Thread 0x14b960039700 (LWP 2575325))](gdb) bt#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57#1 0x000055e61e256677 in my_write_core (sig=sig@entry=11) at /test/10.4_opt/mysys/stacktrace.c:386#2 0x000055e61dc2c64a in handle_fatal_signal (sig=11) at /test/10.4_opt/sql/signal_handler.cc:343#3 <signal handler called>#4 0x000055e61db80a84 in Item::fix_fields_if_needed (ref=0x0, thd=0x14b938812008, this=0x14b93883f788) at /test/10.4_opt/sql/item.h:960#5 fix_fields_for_tvc (thd=thd@entry=0x14b938812008, li=@0x14b9600327b0: {<base_list_iterator> = {list = 0x14b9388ce138, el = 0x14b9388ce0e8, prev = 0x0, current = 0x0}, <No data fields>}) at /test/10.4_opt/sql/sql_tvc.cc:62#6 0x000055e61db80e8f in table_value_constr::prepare (this=0x14b9388ce130, thd=0x14b938812008, sl=sl@entry=0x14b9388cd468, tmp_result=tmp_result@entry=0x14b93883fd60, unit_arg=unit_arg@entry=0x14b9388cd8c0) at /test/10.4_opt/sql/sql_tvc.cc:238#7 0x000055e61dabd966 in st_select_lex_unit::prepare (this=this@entry=0x14b9388cd8c0, derived_arg=derived_arg@entry=0x14b9388ce1a8, sel_result=<optimized out>, additional_options=additional_options@entry=0) at /test/10.4_opt/sql/sql_union.cc:1079#8 0x000055e61d9df32e in mysql_derived_prepare (thd=0x14b938812008, lex=0x14b9388c9028, derived=0x14b9388ce1a8) at /test/10.4_opt/sql/sql_derived.cc:816#9 0x000055e61d9ddf8a in mysql_handle_single_derived (lex=lex@entry=0x14b9388c9028, derived=derived@entry=0x14b9388ce1a8, phases=phases@entry=2) at /test/10.4_opt/sql/sql_derived.cc:206#10 0x000055e61dadab4e in TABLE_LIST::handle_derived (this=this@entry=0x14b9388ce1a8, lex=lex@entry=0x14b9388c9028, phases=phases@entry=2) at /test/10.4_opt/sql/table.cc:8831#11 0x000055e61d9fa397 in LEX::handle_list_of_derived (phases=2, table_list=<optimized out>, this=0x14b9388c9028) at /test/10.4_opt/sql/sql_lex.h:4339#12 st_select_lex::handle_derived (this=<optimized out>, lex=0x14b9388c9028, phases=phases@entry=2) at /test/10.4_opt/sql/sql_lex.cc:4273#13 0x000055e61da652d8 in JOIN::prepare (this=0x14b93883f708, tables_init=<optimized out>, wild_num=0, conds_init=<optimized out>, og_num=0, order_init=<optimized out>, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x14b9388cc6f8, unit_arg=0x14b9388ccb50) at /test/10.4_opt/sql/sql_select.cc:1148#14 0x000055e61dcdd49c in subselect_single_select_engine::prepare (this=0x14b9388cea98, thd=0x14b938812008) at /test/10.4_opt/sql/item_subselect.cc:3739#15 0x000055e61dcdc809 in Item_subselect::fix_fields (this=this@entry=0x14b9388ce878, thd_param=thd_param@entry=0x14b938812008, ref=ref@entry=0x14b9388c00b8) at /test/10.4_opt/sql/item_subselect.cc:283#16 0x000055e61dcdcb2d in Item_in_subselect::fix_fields (this=0x14b9388ce878, thd_arg=0x14b938812008, ref=0x14b9388c00b8) at /test/10.4_opt/sql/item_subselect.cc:3401#17 0x000055e61dc67c30 in Item::fix_fields_if_needed (ref=0x14b9388c00b8, thd=0x14b938812008, this=0x14b9388ce878) at /test/10.4_opt/sql/item.h:960#18 Item_in_optimizer::fix_fields (this=0x14b9388c0020, thd=0x14b938812008, ref=<optimized out>) at /test/10.4_opt/sql/item_cmpfunc.cc:1372#19 0x000055e61dc905f3 in Item::fix_fields_if_needed (ref=0x14b9388ceb68, thd=0x14b938812008, this=0x14b9388c0020) at /test/10.4_opt/sql/item.h:960#20 Item_func::fix_fields (this=this@entry=0x14b9388cead8, thd=thd@entry=0x14b938812008, ref=ref@entry=0x14b93883f590) at /test/10.4_opt/sql/item_func.cc:352#21 0x000055e61dc64a5e in Item_func_not::fix_fields (this=0x14b9388cead8, thd=0x14b938812008, ref=0x14b93883f590) at /test/10.4_opt/sql/item_cmpfunc.cc:6351#22 0x000055e61d9c054f in Item::fix_fields_if_needed (ref=0x14b93883f590, thd=0x14b938812008, this=0x14b9388cead8) at /test/10.4_opt/sql/item.h:960#23 Item::fix_fields_if_needed_for_scalar (ref=0x14b93883f590, thd=0x14b938812008, this=0x14b9388cead8) at /test/10.4_opt/sql/item.h:964#24 Item::fix_fields_if_needed_for_bool (ref=0x14b93883f590, thd=0x14b938812008, this=0x14b9388cead8) at /test/10.4_opt/sql/item.h:968#25 setup_conds (thd=thd@entry=0x14b938812008, tables=tables@entry=0x14b9388cb1e0, leaves=@0x14b9388cae58: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14b93883f6f8, last = 0x14b93883f6f8, elements = 1}, <No data fields>}, conds=conds@entry=0x14b93883f590) at /test/10.4_opt/sql/sql_base.cc:8420#26 0x000055e61da65779 in setup_without_group (reserved=0x14b9388caf24, hidden_group_fields=0x14b93883f46f, win_funcs=@0x14b9388cb048: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55e61eccc4b0 <end_of_list>, last = 0x14b9388cb048, elements = 0}, <No data fields>}, win_specs=@0x14b9388cb030: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55e61eccc4b0 <end_of_list>, last = 0x14b9388cb030, elements = 0}, <No data fields>}, group=0x0, order=0x0, conds=0x14b93883f590, all_fields=@0x14b93883f4a8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14b9388cb198, last = 0x14b9388cb198, elements = 1}, <No data fields>}, fields=@0x14b9388cad68: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14b9388cb198, last = 0x14b9388cb198, elements = 1}, <No data fields>}, leaves=@0x14b9388cae58: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14b93883f6f8, last = 0x14b93883f6f8, elements = 1}, <No data fields>}, tables=0x14b9388cb1e0, ref_pointer_array=<optimized out>, thd=0x14b938812008) at /test/10.4_opt/sql/sql_select.cc:686#27 JOIN::prepare (this=this@entry=0x14b93883f188, tables_init=tables_init@entry=0x14b9388cb1e0, wild_num=wild_num@entry=0, conds_init=conds_init@entry=0x14b9388cead8, og_num=og_num@entry=0, order_init=order_init@entry=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x14b9388cac20, unit_arg=0x14b9388c90e8) at /test/10.4_opt/sql/sql_select.cc:1255#28 0x000055e61da75b82 in mysql_select (thd=thd@entry=0x14b938812008, tables=0x14b9388cb1e0, wild_num=0, fields=@0x14b9388cad68: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14b9388cb198, last = 0x14b9388cb198, elements = 1}, <No data fields>}, conds=0x14b9388cead8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x14b9388cc4d8, unit=0x14b9388c90e8, select_lex=0x14b9388cac20) at /test/10.4_opt/sql/sql_select.cc:4660#29 0x000055e61da75e21 in handle_select (thd=thd@entry=0x14b938812008, lex=lex@entry=0x14b9388c9028, result=result@entry=0x14b9388cc4d8, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.4_opt/sql/sql_select.cc:410#30 0x000055e61da125f1 in execute_sqlcom_select (thd=thd@entry=0x14b938812008, all_tables=0x14b9388cb1e0) at /test/10.4_opt/sql/sql_parse.cc:6355#31 0x000055e61da1a75a in mysql_execute_command (thd=0x14b938812008) at /test/10.4_opt/sql/sql_parse.cc:3889#32 0x000055e61da366ee in Prepared_statement::execute (this=this@entry=0x14b93884e408, expanded_query=expanded_query@entry=0x14b9600365a0, open_cursor=open_cursor@entry=false) at /test/10.4_opt/sql/sql_prepare.cc:4765#33 0x000055e61da36802 in Prepared_statement::execute_loop (this=0x14b93884e408, expanded_query=0x14b9600365a0, open_cursor=<optimized out>, packet=<optimized out>, packet_end=<optimized out>) at /test/10.4_opt/sql/sql_prepare.cc:4251#34 0x000055e61da36acb in mysql_sql_stmt_execute (thd=thd@entry=0x14b938812008) at /test/10.4_opt/sql/sql_prepare.cc:3368#35 0x000055e61da1c23b in mysql_execute_command (thd=thd@entry=0x14b938812008) at /test/10.4_opt/sql/sql_parse.cc:3905#36 0x000055e61da21baa in mysql_parse (thd=0x14b938812008, rawbuf=<optimized out>, length=9, parser_state=0x14b9600384d0, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/10.4_opt/sql/sql_parse.cc:7896#37 0x000055e61da24005 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14b938812008, packet=packet@entry=0x14b938832009 "EXECUTE p", packet_length=packet_length@entry=9, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_opt/sql/sql_parse.cc:1834#38 0x000055e61da25784 in do_command (thd=0x14b938812008) at /test/10.4_opt/sql/sql_parse.cc:1352#39 0x000055e61db02e4e in do_handle_one_connection (connect=connect@entry=0x14b95cc32748) at /test/10.4_opt/sql/sql_connect.cc:1412#40 0x000055e61db02f0d in handle_one_connection (arg=0x14b95cc32748) at /test/10.4_opt/sql/sql_connect.cc:1316#41 0x000014b95f2376db in start_thread (arg=0x14b960039700) at pthread_create.c:463#42 0x000014b95e3b1a3f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95Bug confirmed present in:
MariaDB: 10.3.25 (dbg), 10.3.25 (opt), 10.4.15 (dbg), 10.4.15 (opt), 10.5.6 (dbg), 10.5.6 (opt)
Bug confirmed not present in:
MariaDB: 10.1.47 (dbg), 10.1.47 (opt), 10.2.34 (dbg), 10.2.34 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.47 (dbg), 5.6.47 (opt), 5.7.29 (dbg), 5.7.29 (opt), 8.0.19 (dbg), 8.0.19 (opt)