UBSAN: applying zero offset to null pointer in strings/ctype-bin.c | my_strnncollsp_8bit_bin | group_concat_key_cmp_with_order

CREATE TABLE t (a TEXT COLLATE latin1_bin);

INSERT INTO t VALUES ('');

INSERT INTO t VALUES ('test');

SELECT GROUP_CONCAT(a ORDER BY a) FROM t ;

/test/12.1_opt_san/strings/ctype-bin.c:205:10: runtime error: applying zero offset to null pointer

    #0 0x55a9e58b151b in my_strnncollsp_8bit_bin /test/12.1_opt_san/strings/ctype-bin.c:205:10

    #1 0x55a9e4673a33 in group_concat_key_cmp_with_order /test/12.1_opt_san/sql/item_sum.cc:3727:21

    #2 0x55a9e58434d7 in tree_insert /test/12.1_opt_san/mysys/tree.c:249:9

    #3 0x55a9e467f2df in Item_func_group_concat::add(bool) /test/12.1_opt_san/sql/item_sum.cc:4254:9

    #4 0x55a9e359d71e in Item_sum::aggregator_add() /test/12.1_opt_san/sql/item_sum.h:569:47

    #5 0x55a9e359d71e in update_sum_func(Item_sum**) /test/12.1_opt_san/sql/sql_select.cc:30042:15

    #6 0x55a9e358dc01 in end_send_group(JOIN*, st_join_table*, bool) /test/12.1_opt_san/sql/sql_select.cc:26043:7

    #7 0x55a9e3592197 in evaluate_join_record(JOIN*, st_join_table*, int) /test/12.1_opt_san/sql/sql_select.cc:24681:11

    #8 0x55a9e346ad8d in sub_select(JOIN*, st_join_table*, bool) /test/12.1_opt_san/sql/sql_select.cc:24485:9

    #9 0x55a9e34f88d7 in do_select(JOIN*, Procedure*) /test/12.1_opt_san/sql/sql_select.cc:23959:14

    #10 0x55a9e34f5ce6 in JOIN::exec_inner() /test/12.1_opt_san/sql/sql_select.cc:5074:50

    #11 0x55a9e34f2a10 in JOIN::exec() /test/12.1_opt_san/sql/sql_select.cc:4857:8

    #12 0x55a9e346ee66 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*) /test/12.1_opt_san/sql/sql_select.cc:5390:21

    #13 0x55a9e346d5a0 in handle_select(THD*, LEX*, select_result*, unsigned long long) /test/12.1_opt_san/sql/sql_select.cc:634:10

    #14 0x55a9e3358b31 in execute_sqlcom_select(THD*, TABLE_LIST*) /test/12.1_opt_san/sql/sql_parse.cc:6166:12

    #15 0x55a9e3339c20 in mysql_execute_command(THD*, bool) /test/12.1_opt_san/sql/sql_parse.cc:3954:12

    #16 0x55a9e331ba90 in mysql_parse(THD*, char*, unsigned int, Parser_state*) /test/12.1_opt_san/sql/sql_parse.cc:7882:18

    #17 0x55a9e3312de6 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /test/12.1_opt_san/sql/sql_parse.cc:1877:7

    #18 0x55a9e331dd56 in do_command(THD*, bool) /test/12.1_opt_san/sql/sql_parse.cc:1416:17

    #19 0x55a9e39abc5c in do_handle_one_connection(CONNECT*, bool) /test/12.1_opt_san/sql/sql_connect.cc:1414:11

    #20 0x55a9e39ab4b6 in handle_one_connection /test/12.1_opt_san/sql/sql_connect.cc:1326:5

    #21 0x55a9e2d39e0c in asan_thread_start(void*) asan_interceptors.cpp.o

    #22 0x7f7b51a9caa3 in start_thread nptl/pthread_create.c:447:8

    #23 0x7f7b51b29c3b in clone3 misc/../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

SUMMARY: UndefinedBehaviorSanitizer: nullptr-with-offset /test/12.1_opt_san/strings/ctype-bin.c:205:10

Compiled with a recent version of Clang (I used Clang 18.1.3) with LLVM 18. Ubuntu instructions:

  # Note: It is strongly recommended to uninstall all old Clang & LLVM packages (ref  dpkg --list | grep -iE 'clang|llvm'  and use  apt purge  and  dpkg --purge  to remove the packages), before installing Clang/LLVM 18

     sudo apt install clang llvm-18 llvm-18-linker-tools llvm-18-runtime llvm-18-tools llvm-18-dev libstdc++-14-dev llvm-dev

Compiled with: "-DCMAKE_C_COMPILER=/usr/bin/clang -DCMAKE_CXX_COMPILER=/usr/bin/clang++ -DCMAKE_C{,XX}_FLAGS='-march=native -mtune=native'" and:

    -DWITH_ASAN=ON -DWITH_ASAN_SCOPE=ON -DWITH_UBSAN=ON -DWSREP_LIB_WITH_ASAN=ON

Set before execution:

    export UBSAN_OPTIONS=print_stacktrace=1:report_error_type=1   # And you may also want to supress UBSAN startup issues using 'suppressions=UBSAN.filter' in UBSAN_OPTIONS. For an example of UBSAN.filter, which includes current startup issues see: https://github.com/mariadb-corporation/mariadb-qa/blob/master/UBSAN.filter

    Rel    o/d  Build   Commit                                    UniqueID observed

CS  10.6   dbg  150525  60f046d7e6b0a61f9b0762fe05c4021cff1b79d8  UBSAN|applying zero offset to null pointer|strings/ctype-bin.c|my_strnncollsp_8bit_bin|group_concat_key_cmp_with_order|tree_insert|Item_func_group_concat::add

CS  10.6   opt  150525  60f046d7e6b0a61f9b0762fe05c4021cff1b79d8  UBSAN|applying zero offset to null pointer|strings/ctype-bin.c|my_strnncollsp_8bit_bin|group_concat_key_cmp_with_order|tree_insert|Item_func_group_concat::add

CS  10.11  dbg  150525  84dd2437c507ed194da03fe04fea14e261e47bc5  UBSAN|applying zero offset to null pointer|strings/ctype-bin.c|my_strnncollsp_8bit_bin|group_concat_key_cmp_with_order|tree_insert|Item_func_group_concat::add

CS  10.11  dbg  170625  629b8d782cd20194cc1181451306321e44d2ae02  UBSAN|applying zero offset to null pointer|strings/ctype-bin.c|my_strnncollsp_8bit_bin|group_concat_key_cmp_with_order|tree_insert|Item_func_group_concat::add

CS  10.11  opt  150525  84dd2437c507ed194da03fe04fea14e261e47bc5  UBSAN|applying zero offset to null pointer|strings/ctype-bin.c|my_strnncollsp_8bit_bin|group_concat_key_cmp_with_order|tree_insert|Item_func_group_concat::add

CS  10.11  opt  170625  629b8d782cd20194cc1181451306321e44d2ae02  UBSAN|applying zero offset to null pointer|strings/ctype-bin.c|my_strnncollsp_8bit_bin|group_concat_key_cmp_with_order|tree_insert|Item_func_group_concat::add

CS  11.4   dbg  150525  da5a4d05b9da58705498a42b6ffa5d9211f446af  UBSAN|applying zero offset to null pointer|strings/ctype-bin.c|my_strnncollsp_8bit_bin|group_concat_key_cmp_with_order|tree_insert|Item_func_group_concat::add

CS  11.4   opt  150525  da5a4d05b9da58705498a42b6ffa5d9211f446af  UBSAN|applying zero offset to null pointer|strings/ctype-bin.c|my_strnncollsp_8bit_bin|group_concat_key_cmp_with_order|tree_insert|Item_func_group_concat::add

CS  11.8   dbg  150525  865b05bf4acf10e0d4b3359019ed7b2efe0be81d  UBSAN|applying zero offset to null pointer|strings/ctype-bin.c|my_strnncollsp_8bit_bin|group_concat_key_cmp_with_order|tree_insert|Item_func_group_concat::add

CS  11.8   opt  150525  865b05bf4acf10e0d4b3359019ed7b2efe0be81d  UBSAN|applying zero offset to null pointer|strings/ctype-bin.c|my_strnncollsp_8bit_bin|group_concat_key_cmp_with_order|tree_insert|Item_func_group_concat::add

CS  12.0   dbg  140525  00a9afb5818433c26537ccaf6b2c59ad493dd473  UBSAN|applying zero offset to null pointer|strings/ctype-bin.c|my_strnncollsp_8bit_bin|group_concat_key_cmp_with_order|tree_insert|Item_func_group_concat::add

CS  12.0   opt  140525  00a9afb5818433c26537ccaf6b2c59ad493dd473  UBSAN|applying zero offset to null pointer|strings/ctype-bin.c|my_strnncollsp_8bit_bin|group_concat_key_cmp_with_order|tree_insert|Item_func_group_concat::add

CS  12.1   dbg  160625  247e2f8d4dd4124356a337f6b903b176c6780440  UBSAN|applying zero offset to null pointer|strings/ctype-bin.c|my_strnncollsp_8bit_bin|group_concat_key_cmp_with_order|tree_insert|Item_func_group_concat::add

CS  12.1   opt  160625  247e2f8d4dd4124356a337f6b903b176c6780440  UBSAN|applying zero offset to null pointer|strings/ctype-bin.c|my_strnncollsp_8bit_bin|group_concat_key_cmp_with_order|tree_insert|Item_func_group_concat::add

ES  10.6   opt  150525  6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62  UBSAN|applying zero offset to null pointer|strings/ctype-bin.c|my_strnncollsp_8bit_bin|group_concat_key_cmp_with_order|tree_insert|Item_func_group_concat::add

ES  11.4   dbg  150525  9cd12544ebfd0d52d2158af66b5aced58121cf1f  UBSAN|applying zero offset to null pointer|strings/ctype-bin.c|my_strnncollsp_8bit_bin|group_concat_key_cmp_with_order|tree_insert|Item_func_group_concat::add

ES  11.4   opt  150525  9cd12544ebfd0d52d2158af66b5aced58121cf1f  UBSAN|applying zero offset to null pointer|strings/ctype-bin.c|my_strnncollsp_8bit_bin|group_concat_key_cmp_with_order|tree_insert|Item_func_group_concat::add

UBSAN|applying zero offset to null pointer|strings/ctype-uca.inl|my_uca_strnncollsp_onelevel_utf8mb4|group_concat_key_cmp_with_order|tree_insert|Item_func_group_concat::add

CREATE TABLE t (a TEXT);

INSERT INTO t VALUES ('');

INSERT INTO t VALUES ('test');

SELECT GROUP_CONCAT(a ORDER BY a) FROM t ;