Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-23182

Server crashes in Item::fix_fields_if_needed / table_value_constr::prepare upon 2nd execution of PS

Details

    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

          Activity

            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.

            igor Igor Babaev (Inactive) added a comment - 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.

            monty Michael Widenius added a comment - 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.

            monty Michael Widenius added a comment - See last comment. This causes crashes/wrong results for anyone using prepared statements with more than in_predicate_conversion_threshold parameters and ? parameters.
            Roel Roel Van de Paar added a comment - - edited

            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.

            Roel Roel Van de Paar added a comment - - edited 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.

            elenst Elena Stepanova added a comment - monty , we have a separate bug report for this, MDEV-27937 . I don't think this one needs re-opening.

            People

              shulga Dmitry Shulga
              elenst Elena Stepanova
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.