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

[Draft] MSAN errors in Item_field::is_null

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6, 12.2
    • N/A
    • Optimizer
    • None

    Description

      Reproducible on 10.6 and main, also on 10.6.23, needs cleaning

      # Remaining options: --mysqld=--innodb --mysqld=--lower-case-table-names=1
      # Search pattern(s): (?^s:Item_field::is_null)
       
      --disable_abort_on_error
      CREATE DATABASE IF NOT EXISTS world_db;
      USE world_db;|||
      --delimiter ;
      CREATE TABLE DD (pk varchar(3) NOT NULL DEFAULT '', col_int_nokey int(11) DEFAULT NULL, col_int_key int(11) DEFAULT NULL, col_varchar_key varchar(52) DEFAULT NULL, col_varchar_nokey varchar(52) DEFAULT NULL, PRIMARY KEY (pk), UNIQUE KEY col_varchar_key (col_varchar_key), KEY col_int_key (col_int_key));
      CREATE TEMPORARY TABLE test.tmp87 SELECT pk AS f1, col_varchar_key AS f2, col_varchar_nokey AS f3 FROM world_db.dd;
      ALTER IGNORE TABLE test.tmp87 CHANGE IF EXISTS f2 f2 TIME NULL DEFAULT CURRENT_TIME(0);
      CREATE TABLE test.tmp206 SELECT f2 AS f1, f2 AS f2, f2 AS f3 FROM test.tmp87;
      ANALYZE FORMAT=JSON SELECT DISTINCT STD((CONVERT((MAKETIME(('vhoihppzenpoayzgyhgaehzikdowezxwajjdqawvqfvoatwiqukclafhlpybolklgqxkkvjqrgixvdcotnjwoiyskbgtlsmmovxdwjeiophtjuulwhdoaieylgtgqwssenfqefxddznhvtysshlighclskeglvbpiqsnufqxuuagipqvcerheytzhowrcxxydkiuiizx' IS NOT TRUE), (IF(f3, 6986208921958481920, f3)), f1)) USING latin1))) AS field1 FROM test.tmp206 WHERE (DEFAULT(f2)) IS NULL;
      

      main 366de0ae3bb592745ff6769e80a8a3c69804694f

      ==2055661==WARNING: MemorySanitizer: use-of-uninitialized-value
          #0 0x558218760c0d in Item_field::is_null() /data/bld/main-msan/sql/item.h:3915:29
          #1 0x55821815396c in Item::remove_eq_conds(THD*, Item::cond_result*, bool) /data/bld/main-msan/sql/sql_select.cc:21274:18
          #2 0x55821815396c in Item_func_isnull::remove_eq_conds(THD*, Item::cond_result*, bool) /data/bld/main-msan/sql/sql_select.cc
          #3 0x5582180b0006 in optimize_cond(JOIN*, Item*, List<TABLE_LIST>*, bool, Item::cond_result*, COND_EQUAL**, int) /data/bld/main-msan/sql/sql_select.cc:20816:19
          #4 0x55821809eb63 in JOIN::optimize_inner() /data/bld/main-msan/sql/sql_select.cc:2483:10
          #5 0x55821809c04e in JOIN::optimize() /data/bld/main-msan/sql/sql_select.cc:2021:10
          #6 0x55821808417b in mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /data/bld/main-msan/sql/sql_select.cc:5430:19
          #7 0x558218083635 in handle_select(THD*, LEX*, select_result*, unsigned long long) /data/bld/main-msan/sql/sql_select.cc:636:10
          #8 0x558217fc32bc in execute_sqlcom_select(THD*, TABLE_LIST*) /data/bld/main-msan/sql/sql_parse.cc:6211:12
          #9 0x558217fb0bec in mysql_execute_command(THD*, bool) /data/bld/main-msan/sql/sql_parse.cc:3967:12
          #10 0x558217f9e979 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /data/bld/main-msan/sql/sql_parse.cc:7939:18
          #11 0x558217f97b36 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /data/bld/main-msan/sql/sql_parse.cc:1896:7
          #12 0x558217f9fa31 in do_command(THD*, bool) /data/bld/main-msan/sql/sql_parse.cc:1432:17
          #13 0x55821843b7ac in do_handle_one_connection(CONNECT*, bool) /data/bld/main-msan/sql/sql_connect.cc:1503:11
          #14 0x55821843b286 in handle_one_connection /data/bld/main-msan/sql/sql_connect.cc:1415:5
          #15 0x558219282ad7 in pfs_spawn_thread /data/bld/main-msan/storage/perfschema/pfs.cc:2198:3
          #16 0x7f7b80b981c3 in start_thread nptl/pthread_create.c:442:8
          #17 0x7f7b80c1885b in clone3 misc/../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
       
        Memory was marked as uninitialized
          #0 0x558217b6af2d in __msan_allocated_memory (/share8t/bld/main-msan/sql/mariadbd+0x929f2d) (BuildId: 20fd8ec172e0c7a00da682216bbc906fba81be6e)
          #1 0x558219e890e4 in my_malloc /data/bld/main-msan/mysys/my_malloc.c:117:7
       
      SUMMARY: MemorySanitizer: use-of-uninitialized-value /data/bld/main-msan/sql/item.h:3915:29 in Item_field::is_null()
      

      Attachments

        Activity

          People

            elenst Elena Stepanova
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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