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

Server crashes in Item_func_in::val_int or Assertion `in_item' failed in virtual longlong Item_func_in::val_int

    Details

      Description

      CREATE TABLE t1 (d DATE NULL);
      INSERT INTO t1 VALUES ('1984-12-05'),('2021-03-27');
      SELECT * FROM t1 WHERE '2017-09-01' IN ( d, NAME_CONST( 'tm', NULL ) );
       
      # Cleanup
      DROP TABLE t1;
      

      5.5 debug d947d1bf6e1ebd

      mysqld: /data/src/5.5/sql/item_cmpfunc.cc:4208: virtual longlong Item_func_in::val_int(): Assertion `in_item' failed.
      170916  1:45:42 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007efd86602ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x00000000007ea74c in Item_func_in::val_int (this=0x7efd81148d10) at /data/src/5.5/sql/item_cmpfunc.cc:4208
      #9  0x0000000000658bb5 in evaluate_join_record (join=0x7efd81148f00, join_tab=0x7efd81180078, error=0) at /data/src/5.5/sql/sql_select.cc:17154
      #10 0x00000000006587ff in sub_select (join=0x7efd81148f00, join_tab=0x7efd81180078, end_of_records=false) at /data/src/5.5/sql/sql_select.cc:17059
      #11 0x000000000065806b in do_select (join=0x7efd81148f00, fields=0x7efd82267b80, table=0x0, procedure=0x0) at /data/src/5.5/sql/sql_select.cc:16721
      #12 0x00000000006365a2 in JOIN::exec (this=0x7efd81148f00) at /data/src/5.5/sql/sql_select.cc:2882
      #13 0x0000000000636d7e in mysql_select (thd=0x7efd82264060, rref_pointer_array=0x7efd82267cf0, tables=0x7efd811482c8, wild_num=1, fields=..., conds=0x7efd81148d10, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7efd81148ee0, unit=0x7efd82267388, select_lex=0x7efd82267a68) at /data/src/5.5/sql/sql_select.cc:3103
      #14 0x000000000062d5a2 in handle_select (thd=0x7efd82264060, lex=0x7efd822672d8, result=0x7efd81148ee0, setup_tables_done_option=0) at /data/src/5.5/sql/sql_select.cc:319
      #15 0x00000000006069bf in execute_sqlcom_select (thd=0x7efd82264060, all_tables=0x7efd811482c8) at /data/src/5.5/sql/sql_parse.cc:4685
      #16 0x00000000005ffd32 in mysql_execute_command (thd=0x7efd82264060) at /data/src/5.5/sql/sql_parse.cc:2233
      #17 0x000000000060958a in mysql_parse (thd=0x7efd82264060, rawbuf=0x7efd81148078 "SELECT * FROM t1 WHERE '2017-09-01' IN ( d, NAME_CONST( 'tm', NULL ) )", length=70, parser_state=0x7efd88075640) at /data/src/5.5/sql/sql_parse.cc:5930
      #18 0x00000000005fd28d in dispatch_command (command=COM_QUERY, thd=0x7efd82264060, packet=0x7efd85f5b061 "", packet_length=70) at /data/src/5.5/sql/sql_parse.cc:1075
      #19 0x00000000005fc499 in do_command (thd=0x7efd82264060) at /data/src/5.5/sql/sql_parse.cc:793
      #20 0x00000000006ff17f in do_handle_one_connection (thd_arg=0x7efd82264060) at /data/src/5.5/sql/sql_connect.cc:1268
      #21 0x00000000006fef0c in handle_one_connection (arg=0x7efd82264060) at /data/src/5.5/sql/sql_connect.cc:1184
      #22 0x0000000000a0c94b in pfs_spawn_thread (arg=0x7efd82f76fc0) at /data/src/5.5/storage/perfschema/pfs.cc:1015
      #23 0x00007efd87ca9494 in start_thread (arg=0x7efd88076700) at pthread_create.c:333
      #24 0x00007efd866bf93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      5.5.56 non-debug

      #2  <signal handler called>
      #3  val_int (this=0x7f35ca102cb0) at /home/buildbot/buildbot/build/sql/item_cmpfunc.cc:4211
      #4  Item_func_in::val_int (this=0x7f35ca102cb0) at /home/buildbot/buildbot/build/sql/item_cmpfunc.cc:4183
      #5  0x00000000005c3024 in evaluate_join_record (join=join@entry=0x7f35ca102ea0, join_tab=join_tab@entry=0x7f35ca0f7018, error=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_select.cc:17079
      #6  0x00000000005c34c6 in sub_select (join=0x7f35ca102ea0, join_tab=0x7f35ca0f7018, end_of_records=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_select.cc:16984
      #7  0x00000000005da65d in do_select (join=join@entry=0x7f35ca102ea0, fields=fields@entry=0x7f35cfe13980, table=table@entry=0x0, procedure=0x0) at /home/buildbot/buildbot/build/sql/sql_select.cc:16646
      #8  0x00000000005efd94 in JOIN::exec (this=this@entry=0x7f35ca102ea0) at /home/buildbot/buildbot/build/sql/sql_select.cc:2878
      #9  0x00000000005eb0a5 in mysql_select (thd=thd@entry=0x7f35cfe10000, rref_pointer_array=rref_pointer_array@entry=0x7f35cfe13ad8, tables=0x7f35ca102268, wild_num=<optimized out>, fields=..., conds=<optimized out>, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=result@entry=0x7f35ca102e80, unit=0x7f35cfe13188, select_lex=select_lex@entry=0x7f35cfe13868) at /home/buildbot/buildbot/build/sql/sql_select.cc:3099
      #10 0x00000000005f1cc3 in handle_select (thd=thd@entry=0x7f35cfe10000, lex=lex@entry=0x7f35cfe130d8, result=result@entry=0x7f35ca102e80, setup_tables_done_option=setup_tables_done_option@entry=0) at /home/buildbot/buildbot/build/sql/sql_select.cc:319
      #11 0x000000000059bd18 in execute_sqlcom_select (thd=thd@entry=0x7f35cfe10000, all_tables=0x7f35ca102268) at /home/buildbot/buildbot/build/sql/sql_parse.cc:4686
      #12 0x00000000005a3ba3 in mysql_execute_command (thd=thd@entry=0x7f35cfe10000) at /home/buildbot/buildbot/build/sql/sql_parse.cc:2234
      #13 0x00000000005a74c4 in mysql_parse (thd=thd@entry=0x7f35cfe10000, parser_state=parser_state@entry=0x7f35d8eac6e0, length=<optimized out>, rawbuf=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_parse.cc:5931
      #14 0x00000000005a9983 in dispatch_command (command=COM_QUERY, thd=0x7f35cfe10000, packet=<optimized out>, packet_length=70) at /home/buildbot/buildbot/build/sql/sql_parse.cc:1245
      #15 0x00000000005a9afe in do_command (thd=<optimized out>) at /home/buildbot/buildbot/build/sql/sql_parse.cc:793
      #16 0x000000000065c58b in do_handle_one_connection (thd_arg=thd_arg@entry=0x7f35cfe10000) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1268
      #17 0x000000000065c60c in handle_one_connection (arg=arg@entry=0x7f35cfe10000) at /home/buildbot/buildbot/build/sql/sql_connect.cc:1184
      #18 0x0000000000979828 in pfs_spawn_thread (arg=0x7f35d5fff6d0) at /home/buildbot/buildbot/build/storage/perfschema/pfs.cc:1015
      #19 0x00007f35d84a5494 in start_thread (arg=0x7f35d8ead700) at pthread_create.c:333
      #20 0x00007f35d7b6293f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      10.3 doesn't seem to be affected.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: