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

Assertion `maybe_null || !null_value' fails in Item_func_ceiling::time_op

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4, 10.5, 10.6
    • 10.4, 10.5, 10.6
    • None
    • None

    Description

      CREATE TABLE t1 (tm time(6) NOT NULL  DEFAULT '00:00:00.000000') engine=myisam;
      SELECT 1 FROM t1 WHERE CEILING(tm) ;
      

      Version: '10.4.16-MariaDB-debug-log'  socket: '/10.4/mysql-test/var/tmp/mysqld.1.sock'  port: 16000  Source distribution
      mysqld: /10.4/sql/item_func.cc:2317: virtual bool Item_func_ceiling::time_op(THD*, MYSQL_TIME*): Assertion `maybe_null || !null_value' failed.
      201009 11:25:15 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.4.16-MariaDB-debug-log
       
      linux/raise.c:51(__GI_raise)[0x7fa7ff38b7bb]
      stdlib/abort.c:81(__GI_abort)[0x7fa7ff376535]
      intl/loadmsgcat.c:1177(_nl_load_domain)[0x7fa7ff37640f]
      /lib/x86_64-linux-gnu/libc.so.6(+0x30102)[0x7fa7ff384102]
      sql/item_func.cc:2318(Item_func_ceiling::time_op(THD*, st_mysql_time*))[0x555ac52d096a]
      sql/item_func.h:718(Item_func_hybrid_field_type::time_op_with_null_check(THD*, st_mysql_time*))[0x555ac528b6d9]
      sql/item_func.cc:912(Item_func_hybrid_field_type::val_real_from_time_op())[0x555ac4eac994]
      sql/sql_type.cc:4989(Type_handler_time_common::Item_func_hybrid_field_type_val_real(Item_func_hybrid_field_type*) const)[0x555ac493788f]
      sql/item_func.h:788(Item_func_hybrid_field_type::val_real())[0x555ac46cf52e]
      sql/sql_type.cc:4518(Type_handler_temporal_result::Item_val_bool(Item*) const)[0x555ac4af4f34]
      sql/item.h:1462(Item::val_bool())[0x555ac4a262d7]
      sql/item.h:1470(Item::eval_const_cond())[0x555ac4a1f2ae]
      sql/sql_select.cc:17435(Item::remove_eq_conds(THD*, Item::cond_result*, bool))[0x555ac4a3fa15]
      sql/sql_select.cc:5331(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x555ac4a11a04]
      sql/sql_select.cc:2268(JOIN::optimize_inner())[0x555ac4985971]
      sql/sql_select.cc:1615(JOIN::optimize())[0x555ac49732c5]
      sql/sql_select.cc:4681(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x555ac498ea3b]
      sql/sql_select.cc:410(handle_select(THD*, LEX*, select_result*, unsigned long))[0x555ac496602a]
      sql/sql_parse.cc:6355(execute_sqlcom_select(THD*, TABLE_LIST*))[0x555ac4962aa9]
      sql/sql_parse.cc:3889(mysql_execute_command(THD*))[0x555ac4d3f695]
      sql/sql_parse.cc:7896(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x555ac4d3ef37]
      sql/sql_parse.cc:1837(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x555ac636e80f]
      nptl/pthread_create.c:487(start_thread)[0x7fa7ffe46fa3]
       
      Query (0x62b000062290): SELECT 1 FROM t1 WHERE CEILING(tm)
      

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.