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

Assertion `my_charset_same(args[0]->collation.collation, collation.collation) || (args[0]->collation.repertoire == MY_REPERTOIRE_ASCII && !(collation.collation->state & 8192))' failed in Item_func_set_collation::val_str with WEIGHT_STRING

    XMLWordPrintable

Details

    • Can result in hang or crash

    Description

      SET CHARACTER SET DEFAULT;
      SELECT WEIGHT_STRING(TIMESTAMP'2001-01-01 01:01:00' AS CHAR(1)) COLLATE latin1_swedish_ci + 0;
      

      Leads to:

      CS 10.11.19 6ab0036cf354c5b79284fd0007993a1171b94f6c (Debug, Clang 18.1.3-11) Build 14/09/2026

      mariadbd: /test/10.11_dbg/sql/item_strfunc.cc:3941: virtual String *Item_func_set_collation::val_str(String *): Assertion `my_charset_same(args[0]->collation.collation, collation.collation) || (args[0]->collation.repertoire == MY_REPERTOIRE_ASCII && !(collation.collation->state & 8192))' failed.
      

      CS 10.11.19 6ab0036cf354c5b79284fd0007993a1171b94f6c (Debug, Clang 18.1.3-11) Build 14/09/2026

      Core was generated by `/test/MD140926-mariadb-10.11.19-linux-x86_64-dbg/bin/mariadbd --no-defaults --l'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
       
      [Current thread is 1 (LWP 105249)]
      (gdb) bt
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
      #1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
      #2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
      #3  0x00007ec648a4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x00007ec648a288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x00007ec648a2881b in __assert_fail_base (fmt=0x7ec648bd1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x576a9c3d8699 "my_charset_same(args[0]->collation.collation, collation.collation) || (args[0]->collation.repertoire == MY_REPERTOIRE_ASCII && !(collation.collation->state & 8192))", file=file@entry=0x576a9c3d7516 "/test/10.11_dbg/sql/item_strfunc.cc", line=line@entry=3941, function=function@entry=0x576a9c3d85af "virtual String *Item_func_set_collation::val_str(String *)") at ./assert/assert.c:96
      #6  0x00007ec648a3b517 in __assert_fail (assertion=0x576a9c3d8699 "my_charset_same(args[0]->collation.collation, collation.collation) || (args[0]->collation.repertoire == MY_REPERTOIRE_ASCII && !(collation.collation->state & 8192))", file=0x576a9c3d7516 "/test/10.11_dbg/sql/item_strfunc.cc", line=3941, function=0x576a9c3d85af "virtual String *Item_func_set_collation::val_str(String *)") at ./assert/assert.c:105
      #7  0x0000576a9b82a183 in Item_func_set_collation::val_str (this=0x76c588013c48, str=0x76c620e15358)at /test/10.11_dbg/sql/item_strfunc.cc:3938
      #8  0x0000576a9b818b74 in Item_str_func::val_real (this=0x76c588013c48)at /test/10.11_dbg/sql/item_strfunc.cc:189
      #9  0x0000576a9b7d2f94 in Item_func_plus::real_op (this=0x76c588013d80)at /test/10.11_dbg/sql/item_func.cc:1161
      #10 0x0000576a9b610999 in Item_func_hybrid_field_type::val_real_from_real_op (this=0x76c588013d80) at /test/10.11_dbg/sql/item_func.h:929
      #11 0x0000576a9b5fa169 in Type_handler_real_result::Item_func_hybrid_field_type_val_real (this=0x576a9cee5708 <type_handler_double>, item=0x76c588013d80)at /test/10.11_dbg/sql/sql_type.cc:5644
      #12 0x0000576a9b3361fa in Item_func_hybrid_field_type::val_real (this=0x76c588013d80) at /test/10.11_dbg/sql/item_func.h:976
      #13 0x0000576a9b6005a5 in Type_handler::Item_send_double (this=0x576a9cee5708 <type_handler_double>, item=0x76c588013d80, protocol=0x76c588001378, buf=0x76c620e155a0)at /test/10.11_dbg/sql/sql_type.cc:7775
      #14 0x0000576a9b61522d in Type_handler_double::Item_send (this=0x576a9cee5708 <type_handler_double>, item=0x76c588013d80, protocol=0x76c588001378, buf=0x76c620e155a0)at /test/10.11_dbg/sql/sql_type.h:6182
      #15 0x0000576a9b1b6edd in Item::send (this=0x76c588013d80, protocol=0x76c588001378, buffer=0x76c620e155a0)at /test/10.11_dbg/sql/item.h:1266
      #16 0x0000576a9b1ff1a2 in Protocol::send_result_set_row (this=0x76c588001378, row_items=0x76c588013890) at /test/10.11_dbg/sql/protocol.cc:1333
      #17 0x0000576a9b2c1d8e in select_send::send_data (this=0x76c588014818, items=@0x76c588013890: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x76c588013e30, last = 0x76c588013e30, elements = 1}, <No data fields>})at /test/10.11_dbg/sql/sql_class.cc:3234
      #18 0x0000576a9b417a30 in select_result_sink::send_data_with_check (this=0x76c588014818, items=@0x76c588013890: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x76c588013e30, last = 0x76c588013e30, elements = 1}, <No data fields>}, u=0x76c588005028, sent=0) at /test/10.11_dbg/sql/sql_class.h:6082
      #19 0x0000576a9b3d9c32 in JOIN::exec_inner (this=0x76c588014840)at /test/10.11_dbg/sql/sql_select.cc:4890
      #20 0x0000576a9b3d9660 in JOIN::exec (this=0x76c588014840)at /test/10.11_dbg/sql/sql_select.cc:4807
      #21 0x0000576a9b3b55a6 in mysql_select (thd=0x76c588000d58, tables=0x0, fields=@0x76c588013890: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x76c588013e30, last = 0x76c588013e30, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2164525824, result=0x76c588014818, unit=0x76c588005028, select_lex=0x76c5880135d8) at /test/10.11_dbg/sql/sql_select.cc:5285
      #22 0x0000576a9b3b5035 in handle_select (thd=0x76c588000d58, lex=0x76c588004f50, result=0x76c588014818, setup_tables_done_option=0)at /test/10.11_dbg/sql/sql_select.cc:601
      #23 0x0000576a9b35b931 in execute_sqlcom_select (thd=0x76c588000d58, all_tables=0x0) at /test/10.11_dbg/sql/sql_parse.cc:6452
      #24 0x0000576a9b34f45a in mysql_execute_command (thd=0x76c588000d58, is_called_from_prepared_stmt=false)at /test/10.11_dbg/sql/sql_parse.cc:4032
      #25 0x0000576a9b3475b4 in mysql_parse (thd=0x76c588000d58, rawbuf=0x76c5880134c0 "SELECT WEIGHT_STRING(TIMESTAMP'2001-01-01 01:01:00' AS CHAR(1)) COLLATE latin1_swedish_ci + 0", length=93, parser_state=0x76c620e17ae0) at /test/10.11_dbg/sql/sql_parse.cc:8210
      #26 0x0000576a9b344aa9 in dispatch_command (command=COM_QUERY, thd=0x76c588000d58, packet=0x76c58800af49 "", packet_length=93, blocking=true) at /test/10.11_dbg/sql/sql_parse.cc:1924
      #27 0x0000576a9b348163 in do_command (thd=0x76c588000d58, blocking=true)at /test/10.11_dbg/sql/sql_parse.cc:1434
      #28 0x0000576a9b529a99 in do_handle_one_connection (connect=0x576aa5126018, put_in_cache=true) at /test/10.11_dbg/sql/sql_connect.cc:1486
      #29 0x0000576a9b529832 in handle_one_connection (arg=0x576aa52071d8)at /test/10.11_dbg/sql/sql_connect.cc:1398
      #30 0x00007ec648a9cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #31 0x00007ec648b29ecc in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed
      CS  10.11  dbg  280926  f24a3ef7edd4080d4cf6e109dac26e93872068dc  my_charset_same(args[0]->collation.collation, collation.collation) || (args[0]->collation.repertoire == MY_REPERTOIRE_ASCII && !(collation.collation->state & 8192))|SIGABRT|Item_func_set_collation::val_str|Item_str_func::val_real|Item_func_plus::real_op|Item_func_hybrid_field_type::val_real_from_real_op
      CS  10.11  opt  280926  f24a3ef7edd4080d4cf6e109dac26e93872068dc  No bug found
      CS  11.4   dbg  140926  03acdd67d599ab7136ef18c36f3479a306870290  my_charset_same(args[0]->collation.collation, collation.collation) || (args[0]->collation.repertoire == MY_REPERTOIRE_ASCII && !(collation.collation->state & 8192))|SIGABRT|Item_func_set_collation::val_str|Item_str_func::val_real|Item_func_plus::real_op|Item_func_hybrid_field_type::val_real_from_real_op
      CS  11.4   opt  140926  03acdd67d599ab7136ef18c36f3479a306870290  No bug found
      CS  11.8   dbg  140926  08c28e3fbd56c26fe0973bfcc807fa95c2b23ee3  No bug found
      CS  11.8   opt  140926  08c28e3fbd56c26fe0973bfcc807fa95c2b23ee3  No bug found
      CS  12.3   dbg  140926  0fcc374c2df8b9a7a5004b3afcc7cc42c3b7c13f  No bug found
      CS  12.3   opt  140926  0fcc374c2df8b9a7a5004b3afcc7cc42c3b7c13f  No bug found
      CS  13.1   dbg  140926  e30f2bd21e463d5f5f9f9210b75193a0257b8a8c  No bug found
      CS  13.1   opt  140926  e30f2bd21e463d5f5f9f9210b75193a0257b8a8c  No bug found
      CS  13.2   dbg  240926  45717ef4c736a6a92e0acf49399ce677bfcaea89  No bug found
      CS  13.2   opt  240926  45717ef4c736a6a92e0acf49399ce677bfcaea89  No bug found
      ES  11.4   dbg  060526  90f707057d44f1b5c013a0c3672fd12f32ea7085  my_charset_same(args[0]->collation.collation, collation.collation) || (args[0]->collation.repertoire == MY_REPERTOIRE_ASCII && !(collation.collation->state & 8192))|SIGABRT|Item_func_set_collation::val_str|Item_str_func::val_real|Item_func_plus::real_op|Item_func_hybrid_field_type::val_real_from_real_op
      ES  11.4   opt  060526  90f707057d44f1b5c013a0c3672fd12f32ea7085  No bug found
      ES  11.8   dbg  060526  1499789de285a8109d68d79347de0281865b28f4  No bug found
      ES  11.8   opt  060526  1499789de285a8109d68d79347de0281865b28f4  No bug found
      ES  12.3   dbg  280926  082387a5f3cbb877157998bb4baa95928f4aa121  No bug found
      ES  12.3   opt  280926  082387a5f3cbb877157998bb4baa95928f4aa121  No bug found
      

      Attachments

        Activity

          People

            raghunandan.bhat Raghunandan Bhat
            ramesh Ramesh Sivaraman
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Time Tracking

                Estimated:
                Original Estimate - 0d
                0d
                Remaining:
                Time Spent - 40m Remaining Estimate - 2d
                2d
                Logged:
                Time Spent - 40m Remaining Estimate - 2d
                40m

                Git Integration

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