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

Server crashes in Item_func_vec_fromtext::val_str upon query from empty table

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • N/A
    • 11.7.1
    • Vector search
    • None

    Description

      CREATE TABLE t (f VARCHAR(128)) ENGINE=MyISAM;
      SELECT * FROM t WHERE VEC_FromText(f) IS NOT NULL;
       
      # Cleanup
      DROP TABLE t;
      

      bb-11.6-MDEV-32887-vector 4dfa605f405df3bee7142be6bcdc364f5a5e0db3

      #4  <signal handler called>
      #5  0x000055fda19e56f8 in Charset::charset (this=0x0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_string.h:114
      #6  Item_func_vec_fromtext::val_str (this=0x7f8c50017a68, buf=0x7f8c5f4fb100) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/item_vectorfunc.cc:142
      #7  0x000055fda0cedf88 in Type_handler_string_result::Item_update_null_value (this=<optimized out>, item=0x7f8c50017a68) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_type.cc:4342
      #8  0x000055fda0055313 in Item::update_null_value (this=0x7f8c50017a68) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/item.h:2145
      #9  0x000055fda01037fb in Item_func::is_null (this=0x7f8c50017a68) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/item_func.h:241
      #10 0x000055fda137a744 in Item_func_isnotnull::val_int (this=<optimized out>) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/item_cmpfunc.cc:5827
      #11 0x000055fda0cdd4f1 in Type_handler_int_result::Item_val_bool (this=<optimized out>, item=0x7f8c50017b38) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_type.cc:5220
      #12 0x000055fda00543c1 in Item::val_bool (this=0x7f8c50017b38) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/item.h:1718
      #13 0x000055fda071e145 in Item::eval_const_cond (this=this@entry=0x7f8c50017b38) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/item.h:1725
      #14 0x000055fda0600b6b in Item::remove_eq_conds (this=0x7f8c50017b38, thd=<optimized out>, cond_value=0x7f8c50018948, top_level_arg=<optimized out>) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:20399
      #15 0x000055fda0701e32 in make_join_statistics (join=join@entry=0x7f8c500185b0, tables_list=..., keyuse_array=keyuse_array@entry=0x7f8c50018910) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:6055
      #16 0x000055fda070b6b5 in JOIN::optimize_inner (this=this@entry=0x7f8c500185b0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:2687
      #17 0x000055fda070c090 in JOIN::optimize (this=this@entry=0x7f8c500185b0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:1985
      #18 0x000055fda070cd91 in mysql_select (thd=thd@entry=0x7f8c50000d58, tables=0x7f8c500171e8, fields=..., conds=conds@entry=0x7f8c50017b38, og_num=og_num@entry=0, order=order@entry=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x7f8c50018588, unit=0x7f8c50005250, select_lex=0x7f8c50016bb0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:5328
      #19 0x000055fda070dab2 in handle_select (thd=thd@entry=0x7f8c50000d58, lex=lex@entry=0x7f8c50005170, result=result@entry=0x7f8c50018588, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:624
      #20 0x000055fda04e3c74 in execute_sqlcom_select (thd=thd@entry=0x7f8c50000d58, all_tables=0x7f8c500171e8) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_parse.cc:6151
      #21 0x000055fda050c862 in mysql_execute_command (thd=thd@entry=0x7f8c50000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_parse.cc:3953
      #22 0x000055fda0521828 in mysql_parse (thd=thd@entry=0x7f8c50000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7f8c5f4fc440) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_parse.cc:7873
      #23 0x000055fda05281fc in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f8c50000d58, packet=packet@entry=0x7f8c5000b3c9 "SELECT * FROM t WHERE VEC_FromText(f) IS NOT NULL", packet_length=packet_length@entry=49, blocking=blocking@entry=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_parse.cc:1892
      #24 0x000055fda05309ed in do_command (thd=0x7f8c50000d58, blocking=blocking@entry=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_parse.cc:1405
      #25 0x000055fda0a2b898 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55fda7e78438, put_in_cache=put_in_cache@entry=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_connect.cc:1448
      #26 0x000055fda0a2c74e in handle_one_connection (arg=0x55fda7e78438) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_connect.cc:1350
      #27 0x000055fda1bfa397 in pfs_spawn_thread (arg=0x55fda7e41c48) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/storage/perfschema/pfs.cc:2198
      #28 0x00007f8c738a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #29 0x00007f8c7392861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.