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

Server crashes in charset / Item_cache_str::convert_to_basic_const_item

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.2
    • Fix Version/s: 10.2.3
    • Component/s: Optimizer, Views
    • Labels:
      None

      Description

      CREATE TABLE t1 (c VARCHAR(3));
      CREATE ALGORITHM=TEMPTABLE VIEW v1 AS SELECT * FROM t1;
      INSERT INTO t1 VALUES ('foo'),('bar');
       
      CREATE TABLE t2 (c VARCHAR(3));
      INSERT INTO t2 VALUES ('qux'),('xyz');
       
      SELECT * FROM v1 WHERE v1.c IN ( SELECT MIN(c) FROM t2 WHERE 0 );
      

      10.2 c35b8c46b404d035e54a23d667da5dff6502fc2e

      #3  <signal handler called>
      #4  0x00007fd3e51d0f8a in charset (this=0x0) at /data/src/10.2/sql/sql_string.h:202
      #5  Item_cache_str::convert_to_basic_const_item (this=0x7fd3d9d201c8, thd=0x7fd3d9c16070) at /data/src/10.2/sql/item.cc:9799
      #6  0x00007fd3e51e0e49 in Item_cache::derived_field_transformer_for_where (this=<optimized out>, thd=<optimized out>, arg=<optimized out>) at /data/src/10.2/sql/item.h:5430
      #7  0x00007fd3e51c7e1d in Item::transform (this=<optimized out>, thd=<optimized out>, transformer=<optimized out>, arg=<optimized out>) at /data/src/10.2/sql/item.cc:707
      #8  0x00007fd3e522257f in Item_args::transform_args (this=this@entry=0x7fd3d9d20478, thd=0x7fd3d9c16070, transformer=<optimized out>, arg=arg@entry=0x7fd3d9c669e8 "\020\365\n\346\323\177") at /data/src/10.2/sql/item_func.cc:328
      #9  0x00007fd3e5222634 in Item_func::transform (this=0x7fd3d9d203f0, thd=0x7fd3d9c16070, transformer=<optimized out>, argument=0x7fd3d9c669e8 "\020\365\n\346\323\177") at /data/src/10.2/sql/item_func.cc:364
      #10 0x00007fd3e4faa4fb in pushdown_cond_for_derived (thd=0x7fd3d9c16070, cond=<optimized out>, derived=derived@entry=0x7fd3d9c642c0) at /data/src/10.2/sql/sql_derived.cc:1195
      #11 0x00007fd3e5036e60 in JOIN::optimize_inner (this=this@entry=0x7fd3d9c68568) at /data/src/10.2/sql/sql_select.cc:1295
      #12 0x00007fd3e503722f in JOIN::optimize (this=this@entry=0x7fd3d9c68568) at /data/src/10.2/sql/sql_select.cc:1076
      #13 0x00007fd3e5037bd5 in mysql_select (thd=thd@entry=0x7fd3d9c16070, tables=0x7fd3d9c642c0, wild_num=1, fields=..., conds=0x7fd3d9c65e38, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fd3d9c68548, unit=0x7fd3d9c19b48, select_lex=0x7fd3d9c1a278) at /data/src/10.2/sql/sql_select.cc:3570
      #14 0x00007fd3e5037e8d in handle_select (thd=thd@entry=0x7fd3d9c16070, lex=lex@entry=0x7fd3d9c19a80, result=result@entry=0x7fd3d9c68548, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.2/sql/sql_select.cc:373
      #15 0x00007fd3e4fc8849 in execute_sqlcom_select (thd=thd@entry=0x7fd3d9c16070, all_tables=0x7fd3d9c642c0) at /data/src/10.2/sql/sql_parse.cc:6347
      #16 0x00007fd3e4fd16d2 in mysql_execute_command (thd=thd@entry=0x7fd3d9c16070) at /data/src/10.2/sql/sql_parse.cc:3370
      #17 0x00007fd3e4fdb2d2 in mysql_parse (thd=thd@entry=0x7fd3d9c16070, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fd3e5fdd8e0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:7790
      #18 0x00007fd3e4fdd55b in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fd3d9c16070, packet=packet@entry=0x7fd3d9c58071 "SELECT * FROM v1 WHERE v1.c IN ( SELECT MIN(c) FROM t2 WHERE 0 )", packet_length=packet_length@entry=64, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:1799
      #19 0x00007fd3e4fe008d in do_command (thd=0x7fd3d9c16070) at /data/src/10.2/sql/sql_parse.cc:1359
      #20 0x00007fd3e50cdf4a in do_handle_one_connection (connect=connect@entry=0x7fd3e2071410) at /data/src/10.2/sql/sql_connect.cc:1354
      #21 0x00007fd3e50ce133 in handle_one_connection (arg=arg@entry=0x7fd3e2071410) at /data/src/10.2/sql/sql_connect.cc:1260
      #22 0x00007fd3e537c1bf in pfs_spawn_thread (arg=0x7fd3e2015df0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
      #23 0x00007fd3e46cf0a4 in start_thread (arg=0x7fd3e5fdf300) at pthread_create.c:309
      #24 0x00007fd3e2eef87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

        Attachments

          Activity

            People

            Assignee:
            igor Igor Babaev
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: