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

LP:778901 - Crash in Item_func::Item_func in maria-5.3-mwl34 with simple blob comparisons

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      Not repeatable with maria-5.3. Simple blob queries crash as follows:

      #4 <signal handler called>
      #5 0x082125bd in Item_func::Item_func (this=0xae513d50, a=0xae5132c8, b=0x0) at item_func.h:82
      #6 0x08212681 in Item_int_func::Item_int_func (this=0xae513d50, a=0xae5132c8, b=0x0) at item_func.h:402
      #7 0x08212d09 in Item_bool_func2::Item_bool_func2 (this=0xae513d50, a=0xae5132c8, b=0x0) at item_cmpfunc.h:357
      #8 0x08212f13 in Item_bool_rowready_func2::Item_bool_rowready_func2 (this=0xae513d50, a=0xae5132c8, b=0x0) at item_cmpfunc.h:390
      #9 0x08213147 in Item_func_eq::Item_func_eq (this=0xae513d50, a=0xae5132c8, b=0x0) at item_cmpfunc.h:495
      #10 0x0821153e in Item_equal::add_const (this=0xae513700, c=0xae5132c8, f=0x0) at item_cmpfunc.cc:5621
      #11 0x08211771 in Item_equal::update_const (this=0xae513700) at item_cmpfunc.cc:5750
      #12 0x08326adc in update_const_equal_items (cond=0xae513700, tab=0xae5138c8) at sql_select.cc:10349
      #13 0x0832fa24 in join_read_const_table (tab=0xae5138c8, pos=0xae528c80) at sql_select.cc:14374
      #14 0x083161a6 in make_join_statistics (join=0xae526440, tables_arg=0xae513008, conds=0xae513700, keyuse_array=0xae52b568) at sql_select.cc:3023
      #15 0x0830f7b3 in JOIN::optimize (this=0xae526440) at sql_select.cc:992
      #16 0x08315079 in mysql_select (thd=0xa7d2ed8, rref_pointer_array=0xa7d4978, tables=0xae513008, wild_num=1, fields=..., conds=0xae513368, og_num=0,
      order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xae5134e0, unit=0xa7d45d8, select_lex=0xa7d4874)
      at sql_select.cc:2687
      #17 0x0830d95b in handle_select (thd=0xa7d2ed8, lex=0xa7d457c, result=0xae5134e0, setup_tables_done_option=0) at sql_select.cc:282
      #18 0x082aa308 in execute_sqlcom_select (thd=0xa7d2ed8, all_tables=0xae513008) at sql_parse.cc:5094
      #19 0x082a1152 in mysql_execute_command (thd=0xa7d2ed8) at sql_parse.cc:2239
      #20 0x082ac8ab in mysql_parse (thd=0xa7d2ed8, rawbuf=0xae512eb0 "SELECT * FROM t1 WHERE f1 = f2", length=31, found_semicolon=0xae8e1228)
      at sql_parse.cc:6094
      #21 0x0829eddb in dispatch_command (command=COM_QUERY, thd=0xa7d2ed8, packet=0xa82dae9 "SELECT * FROM t1 WHERE f1 = f2 ", packet_length=32)
      at sql_parse.cc:1215
      #22 0x0829e239 in do_command (thd=0xa7d2ed8) at sql_parse.cc:904
      #23 0x0829b2ec in handle_one_connection (arg=0xa7d2ed8) at sql_connect.cc:1154
      #24 0x00821919 in start_thread () from /lib/libpthread.so.0
      #25 0x0076acce in clone () from /lib/libc.so.6

      test case:

      CREATE TABLE t1 ( f1 blob, f2 blob );
      INSERT INTO t1 VALUES ('','');

      SELECT * FROM t1 WHERE f1 = f2 ;

      Attachments

        Activity

          People

            monty Michael Widenius
            philipstoev Philip Stoev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.