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

Assertion `ltime->neg == 0' failed in void date_to_datetime(MYSQL_TIME*)

Details

    • 10.1.20

    Description

      Stack trace from 10.0 b34d7fba31c

      		 
      mysqld: /data/src/10.0/sql/sql_time.h:79: void date_to_datetime(MYSQL_TIME*): Assertion `ltime->neg == 0' failed.
      		 
      160912 21:04:03 [ERROR] mysqld got signal 6 ;
      		 
       
      		 
      #7  0x00007fba28db4312 in __GI___assert_fail (assertion=0xf4e681 "ltime->neg == 0", file=0xf4e609 "/data/src/10.0/sql/sql_time.h", line=79, function=0xf4f800 <date_to_datetime(st_mysql_time*)::__PRETTY_FUNCTION__> "void date_to_datetime(MYSQL_TIME*)") at assert.c:101
      		 
      #8  0x00000000008f7fde in date_to_datetime (ltime=0x7fba2b077d10) at /data/src/10.0/sql/sql_time.h:79
      		 
      #9  0x00000000008f0ff7 in Item_temporal_hybrid_func::fix_temporal_type (this=0x7fba214fa3b0, ltime=0x7fba2b077d10) at /data/src/10.0/sql/item_timefunc.cc:1530
      		 
      #10 0x00000000008f10ae in Item_temporal_hybrid_func::val_str_ascii (this=0x7fba214fa3b0, str=0x7fba2b077f40) at /data/src/10.0/sql/item_timefunc.cc:1550
      		 
      #11 0x00000000008b8096 in Item_func::val_str_from_val_str_ascii (this=0x7fba214fa3b0, str=0x7fba2b077f40, str2=0x7fba214fa488) at /data/src/10.0/sql/item_strfunc.cc:83
      		 
      #12 0x00000000008f7412 in Item_temporal_hybrid_func::val_str (this=0x7fba214fa3b0, str=0x7fba2b077f40) at /data/src/10.0/sql/item_timefunc.h:552
      		 
      #14 0x00000000008540e9 in Item::send (this=0x7fba214fa600, protocol=0x7fba243dd5f8, buffer=0x7fba2b077f40) at /data/src/10.0/sql/item.cc:6509
      		 
      #15 0x000000000059f1d8 in Protocol::send_result_set_row (this=0x7fba243dd5f8, row_items=0x7fba243e1218) at /data/src/10.0/sql/protocol.cc:912
      		 
      #16 0x000000000060d779 in select_send::send_data (this=0x7fba214faee0, items=...) at /data/src/10.0/sql/sql_class.cc:2573
      		 
      #17 0x00000000006a9d2b in end_send (join=0x7fba214faf00, join_tab=0x7fba217ae3b0, end_of_records=false) at /data/src/10.0/sql/sql_select.cc:18972
      		 
      #18 0x00000000006a7ab4 in evaluate_join_record (join=0x7fba214faf00, join_tab=0x7fba217ae088, error=0) at /data/src/10.0/sql/sql_select.cc:18065
      		 
      #19 0x00000000006a73d6 in sub_select (join=0x7fba214faf00, join_tab=0x7fba217ae088, end_of_records=false) at /data/src/10.0/sql/sql_select.cc:17843
      		 
      #20 0x00000000006a6c49 in do_select (join=0x7fba214faf00, fields=0x7fba243e1218, table=0x0, procedure=0x0) at /data/src/10.0/sql/sql_select.cc:17505
      		 
      #21 0x0000000000683d40 in JOIN::exec_inner (this=0x7fba214faf00) at /data/src/10.0/sql/sql_select.cc:3084
      		 
      #22 0x0000000000681216 in JOIN::exec (this=0x7fba214faf00) at /data/src/10.0/sql/sql_select.cc:2373
      		 
      #23 0x000000000068457e in mysql_select (thd=0x7fba243dd070, rref_pointer_array=0x7fba243e1378, tables=0x7fba214fa848, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fba214faee0, unit=0x7fba243e0a10, select_lex=0x7fba243e1100) at /data/src/10.0/sql/sql_select.cc:3308
      		 
      #24 0x000000000067a93a in handle_select (thd=0x7fba243dd070, lex=0x7fba243e0948, result=0x7fba214faee0, setup_tables_done_option=0) at /data/src/10.0/sql/sql_select.cc:373
      		 
      #25 0x000000000064f197 in execute_sqlcom_select (thd=0x7fba243dd070, all_tables=0x7fba214fa848) at /data/src/10.0/sql/sql_parse.cc:5294
      		 
      #26 0x00000000006476c2 in mysql_execute_command (thd=0x7fba243dd070) at /data/src/10.0/sql/sql_parse.cc:2563
      		 
      #27 0x0000000000651e18 in mysql_parse (thd=0x7fba243dd070, rawbuf=0x7fba214fa088 "SELECT REPLACE( ADDDATE( d, INTERVAL 0.6732771076944444 HOUR_SECOND ), '2', 'x' ) FROM t1", length=89, parser_state=0x7fba2b079650) at /data/src/10.0/sql/sql_parse.cc:6576
      		 
      #28 0x0000000000644918 in dispatch_command (command=COM_QUERY, thd=0x7fba243dd070, packet=0x7fba243d3071 "", packet_length=89) at /data/src/10.0/sql/sql_parse.cc:1309
      		 
      #29 0x0000000000643bdb in do_command (thd=0x7fba243dd070) at /data/src/10.0/sql/sql_parse.cc:999
      		 
      #30 0x0000000000761efa in do_handle_one_connection (thd_arg=0x7fba243dd070) at /data/src/10.0/sql/sql_connect.cc:1378
      		 
      #31 0x0000000000761c6c in handle_one_connection (arg=0x7fba243dd070) at /data/src/10.0/sql/sql_connect.cc:1293
      		 
      #32 0x00000000009faa88 in pfs_spawn_thread (arg=0x7fba22d91370) at /data/src/10.0/storage/perfschema/pfs.cc:1860
      		 
      #33 0x00007fba2acb60a4 in start_thread (arg=0x7fba2b07a700) at pthread_create.c:309
      		 
      #34 0x00007fba28e6e87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111


      CREATE TABLE t1 (d DATE);
      		 
      INSERT INTO t1 VALUES ('2005-07-20'),('2012-12-21');
      		 
      SELECT REPLACE( ADDDATE( d, INTERVAL 0.6732771076944444 HOUR_SECOND ), '2', 'x' ) FROM t1;

      10.2 is also affected.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          elenst Elena Stepanova created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Component/s Temporal Types [ 11000 ]
          Fix Version/s 10.0 [ 16000 ]
          Fix Version/s 10.1 [ 16100 ]
          Affects Version/s 10.0 [ 16000 ]
          Affects Version/s 10.1 [ 16100 ]
          Affects Version/s 10.2 [ 14601 ]
          Assignee Elena Stepanova [ elenst ] Alexander Barkov [ bar ]
          Description http://buildbot.askmonty.org/buildbot/builders/win-rqg-se/builds/2683/steps/rqg_crash_tests/logs/stdio
          {noformat}
          Assertion failed: ltime->neg == 0, file e:\buildbot\bbwin1\win-rqg-se\build-debug\sql\sql_time.h, line 116
          R6010
          - abort() has been called
          160909 14:58:06 [ERROR] mysqld got exception 0x80000003 ;
          This could be because you hit a bug. It is also possible that this binary
          or one of the libraries it was linked against is corrupt, improperly built,
          or misconfigured. This error can also be caused by malfunctioning hardware.

          To report this bug, see https://mariadb.com/kb/en/reporting-bugs

          We will try our best to scrape up some info that will hopefully help
          diagnose the problem, but since we have already crashed,
          something is definitely wrong and this may fail.

          Server version: 10.2.2-MariaDB-debug-log
          key_buffer_size=1048576
          read_buffer_size=131072
          max_used_connections=7
          max_threads=1001
          thread_count=7
          It is possible that mysqld could use up to
          key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 388184 K bytes of memory
          Hope that's ok; if not, decrease some variables in the equation.

          Thread pointer: 0x0xee306be1c8
          Attempting backtrace. You can use the following information to find out
          where mysqld died. If you see no messages after this, something went
          terribly wrong...
          mysqld.exe!my_sigabrt_handler()[my_thr_init.c:477]
          mysqld.exe!raise()[winsig.c:594]
          mysqld.exe!abort()[abort.c:82]
          mysqld.exe!_wassert()[assert.c:380]
          mysqld.exe!date_to_datetime()[sql_time.h:116]
          mysqld.exe!Item_temporal_hybrid_func::fix_temporal_type()[item_timefunc.cc:1535]
          mysqld.exe!Item_temporal_hybrid_func::val_str_ascii()[item_timefunc.cc:1555]
          mysqld.exe!Item_func::val_str_from_val_str_ascii()[item_strfunc.cc:81]
          mysqld.exe!Item_temporal_hybrid_func::val_str()[item_timefunc.h:599]
          mysqld.exe!Item_func_replace::val_str()[item_strfunc.cc:1213]
          mysqld.exe!Item_func_set_user_var::check()[item_func.cc:5045]
          mysqld.exe!Item_func_set_user_var::val_real()[item_func.cc:5165]
          mysqld.exe!Aggregator_simple::arg_val_real()[item_sum.cc:1516]
          mysqld.exe!Item_sum_sum::add_helper()[item_sum.cc:1375]
          mysqld.exe!Item_sum_sum::add()[item_sum.cc:1340]
          mysqld.exe!Item_sum_avg::add()[item_sum.cc:1693]
          2016-09-09 14:58:08 4976 [Note] InnoDB: Online DDL : Start
          2016-09-09 14:58:08 4976 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
          2016-09-09 14:58:08 4976 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
          2016-09-09 14:58:08 4976 [Note] InnoDB: Online DDL : Start merge-sorting index `rkr_index_2`--temporary-- (1 / 1), estimated cost : 20.0000
          2016-09-09 14:58:08 4976 [Note] InnoDB: Online DDL : End of merge-sorting index `rkr_index_2`--temporary-- (1 / 1)
          2016-09-09 14:58:08 4976 [Note] InnoDB: Online DDL : Start building index `rkr_index_2`--temporary-- (1 / 1), estimated cost : 30.0000
          mysqld.exe!Aggregator_simple::add()[item_sum.h:677]
          2016-09-09 14:58:09 4976 [Note] InnoDB: Online DDL : End of building index `rkr_index_2`--temporary-- (1 / 1)
          2016-09-09 14:58:09 4976 [Note] InnoDB: Online DDL : Start applying row log
          2016-09-09 14:58:09 4976 [Note] InnoDB: Online DDL : End of applying row log
          2016-09-09 14:58:09 4976 [Note] InnoDB: Online DDL : Completed
          mysqld.exe!Item_sum::aggregator_add()[item_sum.h:526]
          mysqld.exe!Item_sum::reset_and_add()[item_sum.h:416]
          mysqld.exe!init_sum_functions()[sql_select.cc:23202]
          mysqld.exe!end_send_group()[sql_select.cc:19691]
          mysqld.exe!evaluate_join_record()[sql_select.cc:18544]
          mysqld.exe!sub_select()[sql_select.cc:18319]
          mysqld.exe!do_select()[sql_select.cc:17863]
          mysqld.exe!JOIN::exec_inner()[sql_select.cc:3353]
          mysqld.exe!JOIN::exec()[sql_select.cc:3165]
          mysqld.exe!mysql_select()[sql_select.cc:3551]
          mysqld.exe!handle_select()[sql_select.cc:373]
          mysqld.exe!execute_sqlcom_select()[sql_parse.cc:6334]
          mysqld.exe!mysql_execute_command()[sql_parse.cc:3365]
          mysqld.exe!mysql_parse()[sql_parse.cc:7763]
          mysqld.exe!dispatch_command()[sql_parse.cc:1797]
          mysqld.exe!do_command()[sql_parse.cc:1354]
          mysqld.exe!threadpool_process_request()[threadpool_common.cc:251]
          mysqld.exe!io_completion_callback()[threadpool_win.cc:462]
          KERNEL32.DLL!VirtualUnlock()
          ntdll.dll!RtlGetActiveActivationContext()
          ntdll.dll!RtlFreeUnicodeString()
          KERNEL32.DLL!BaseThreadInitThunk()
          ntdll.dll!RtlUserThreadStart()

          Trying to get some variables.
          Some pointers may be invalid and cause the dump to abort.
          Query (0xee306e8520): SELECT AVG( @A := ( REPLACE( ( ADDDATE( `col_datetime_nokey`, INTERVAL ( RTRIM( ( RAND() ) ) ) HOUR_SECOND ) ), ( DECODE( ( @A := `col_time_nokey` ), `col_time_key` ) ), 'ojeecpsiewfqferdvtxywwfxpqddfyft' ) ) ) AS field1, BINARY 'c' AS field2 FROM `cc` WHERE CURRENT_DATE /* QUERY_NO 1738 CON_ID 13 */ /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QUERY_NO 1746 CON_ID 13 */
          Connection ID (thread ID): 13
          Status: NOT_KILLED

          Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=on,mrr_cost_based=on,mrr_sort_keys=on,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on
          {noformat}           		{noformat:title=Stack trace from 10.0 b34d7fba31c}
          mysqld: /data/src/10.0/sql/sql_time.h:79: void date_to_datetime(MYSQL_TIME*): Assertion `ltime->neg == 0' failed.
          160912 21:04:03 [ERROR] mysqld got signal 6 ;

          #7 0x00007fba28db4312 in __GI___assert_fail (assertion=0xf4e681 "ltime->neg == 0", file=0xf4e609 "/data/src/10.0/sql/sql_time.h", line=79, function=0xf4f800 <date_to_datetime(st_mysql_time*)::__PRETTY_FUNCTION__> "void date_to_datetime(MYSQL_TIME*)") at assert.c:101
          #8 0x00000000008f7fde in date_to_datetime (ltime=0x7fba2b077d10) at /data/src/10.0/sql/sql_time.h:79
          #9 0x00000000008f0ff7 in Item_temporal_hybrid_func::fix_temporal_type (this=0x7fba214fa3b0, ltime=0x7fba2b077d10) at /data/src/10.0/sql/item_timefunc.cc:1530
          #10 0x00000000008f10ae in Item_temporal_hybrid_func::val_str_ascii (this=0x7fba214fa3b0, str=0x7fba2b077f40) at /data/src/10.0/sql/item_timefunc.cc:1550
          #11 0x00000000008b8096 in Item_func::val_str_from_val_str_ascii (this=0x7fba214fa3b0, str=0x7fba2b077f40, str2=0x7fba214fa488) at /data/src/10.0/sql/item_strfunc.cc:83
          #12 0x00000000008f7412 in Item_temporal_hybrid_func::val_str (this=0x7fba214fa3b0, str=0x7fba2b077f40) at /data/src/10.0/sql/item_timefunc.h:552
          #14 0x00000000008540e9 in Item::send (this=0x7fba214fa600, protocol=0x7fba243dd5f8, buffer=0x7fba2b077f40) at /data/src/10.0/sql/item.cc:6509
          #15 0x000000000059f1d8 in Protocol::send_result_set_row (this=0x7fba243dd5f8, row_items=0x7fba243e1218) at /data/src/10.0/sql/protocol.cc:912
          #16 0x000000000060d779 in select_send::send_data (this=0x7fba214faee0, items=...) at /data/src/10.0/sql/sql_class.cc:2573
          #17 0x00000000006a9d2b in end_send (join=0x7fba214faf00, join_tab=0x7fba217ae3b0, end_of_records=false) at /data/src/10.0/sql/sql_select.cc:18972
          #18 0x00000000006a7ab4 in evaluate_join_record (join=0x7fba214faf00, join_tab=0x7fba217ae088, error=0) at /data/src/10.0/sql/sql_select.cc:18065
          #19 0x00000000006a73d6 in sub_select (join=0x7fba214faf00, join_tab=0x7fba217ae088, end_of_records=false) at /data/src/10.0/sql/sql_select.cc:17843
          #20 0x00000000006a6c49 in do_select (join=0x7fba214faf00, fields=0x7fba243e1218, table=0x0, procedure=0x0) at /data/src/10.0/sql/sql_select.cc:17505
          #21 0x0000000000683d40 in JOIN::exec_inner (this=0x7fba214faf00) at /data/src/10.0/sql/sql_select.cc:3084
          #22 0x0000000000681216 in JOIN::exec (this=0x7fba214faf00) at /data/src/10.0/sql/sql_select.cc:2373
          #23 0x000000000068457e in mysql_select (thd=0x7fba243dd070, rref_pointer_array=0x7fba243e1378, tables=0x7fba214fa848, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fba214faee0, unit=0x7fba243e0a10, select_lex=0x7fba243e1100) at /data/src/10.0/sql/sql_select.cc:3308
          #24 0x000000000067a93a in handle_select (thd=0x7fba243dd070, lex=0x7fba243e0948, result=0x7fba214faee0, setup_tables_done_option=0) at /data/src/10.0/sql/sql_select.cc:373
          #25 0x000000000064f197 in execute_sqlcom_select (thd=0x7fba243dd070, all_tables=0x7fba214fa848) at /data/src/10.0/sql/sql_parse.cc:5294
          #26 0x00000000006476c2 in mysql_execute_command (thd=0x7fba243dd070) at /data/src/10.0/sql/sql_parse.cc:2563
          #27 0x0000000000651e18 in mysql_parse (thd=0x7fba243dd070, rawbuf=0x7fba214fa088 "SELECT REPLACE( ADDDATE( d, INTERVAL 0.6732771076944444 HOUR_SECOND ), '2', 'x' ) FROM t1", length=89, parser_state=0x7fba2b079650) at /data/src/10.0/sql/sql_parse.cc:6576
          #28 0x0000000000644918 in dispatch_command (command=COM_QUERY, thd=0x7fba243dd070, packet=0x7fba243d3071 "", packet_length=89) at /data/src/10.0/sql/sql_parse.cc:1309
          #29 0x0000000000643bdb in do_command (thd=0x7fba243dd070) at /data/src/10.0/sql/sql_parse.cc:999
          #30 0x0000000000761efa in do_handle_one_connection (thd_arg=0x7fba243dd070) at /data/src/10.0/sql/sql_connect.cc:1378
          #31 0x0000000000761c6c in handle_one_connection (arg=0x7fba243dd070) at /data/src/10.0/sql/sql_connect.cc:1293
          #32 0x00000000009faa88 in pfs_spawn_thread (arg=0x7fba22d91370) at /data/src/10.0/storage/perfschema/pfs.cc:1860
          #33 0x00007fba2acb60a4 in start_thread (arg=0x7fba2b07a700) at pthread_create.c:309
          #34 0x00007fba28e6e87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
          {noformat}

          {code:sql}
          CREATE TABLE t1 (d DATE);
          INSERT INTO t1 VALUES ('2005-07-20'),('2012-12-21');
          SELECT REPLACE( ADDDATE( d, INTERVAL 0.6732771076944444 HOUR_SECOND ), '2', 'x' ) FROM t1;
          {code}
          Summary [Draft] Assertion failed: ltime->neg == 0 Assertion `ltime->neg == 0' failed in void date_to_datetime(MYSQL_TIME*)
          elenst Elena Stepanova made changes -
          Description {noformat:title=Stack trace from 10.0 b34d7fba31c}
          mysqld: /data/src/10.0/sql/sql_time.h:79: void date_to_datetime(MYSQL_TIME*): Assertion `ltime->neg == 0' failed.
          160912 21:04:03 [ERROR] mysqld got signal 6 ;

          #7 0x00007fba28db4312 in __GI___assert_fail (assertion=0xf4e681 "ltime->neg == 0", file=0xf4e609 "/data/src/10.0/sql/sql_time.h", line=79, function=0xf4f800 <date_to_datetime(st_mysql_time*)::__PRETTY_FUNCTION__> "void date_to_datetime(MYSQL_TIME*)") at assert.c:101
          #8 0x00000000008f7fde in date_to_datetime (ltime=0x7fba2b077d10) at /data/src/10.0/sql/sql_time.h:79
          #9 0x00000000008f0ff7 in Item_temporal_hybrid_func::fix_temporal_type (this=0x7fba214fa3b0, ltime=0x7fba2b077d10) at /data/src/10.0/sql/item_timefunc.cc:1530
          #10 0x00000000008f10ae in Item_temporal_hybrid_func::val_str_ascii (this=0x7fba214fa3b0, str=0x7fba2b077f40) at /data/src/10.0/sql/item_timefunc.cc:1550
          #11 0x00000000008b8096 in Item_func::val_str_from_val_str_ascii (this=0x7fba214fa3b0, str=0x7fba2b077f40, str2=0x7fba214fa488) at /data/src/10.0/sql/item_strfunc.cc:83
          #12 0x00000000008f7412 in Item_temporal_hybrid_func::val_str (this=0x7fba214fa3b0, str=0x7fba2b077f40) at /data/src/10.0/sql/item_timefunc.h:552
          #14 0x00000000008540e9 in Item::send (this=0x7fba214fa600, protocol=0x7fba243dd5f8, buffer=0x7fba2b077f40) at /data/src/10.0/sql/item.cc:6509
          #15 0x000000000059f1d8 in Protocol::send_result_set_row (this=0x7fba243dd5f8, row_items=0x7fba243e1218) at /data/src/10.0/sql/protocol.cc:912
          #16 0x000000000060d779 in select_send::send_data (this=0x7fba214faee0, items=...) at /data/src/10.0/sql/sql_class.cc:2573
          #17 0x00000000006a9d2b in end_send (join=0x7fba214faf00, join_tab=0x7fba217ae3b0, end_of_records=false) at /data/src/10.0/sql/sql_select.cc:18972
          #18 0x00000000006a7ab4 in evaluate_join_record (join=0x7fba214faf00, join_tab=0x7fba217ae088, error=0) at /data/src/10.0/sql/sql_select.cc:18065
          #19 0x00000000006a73d6 in sub_select (join=0x7fba214faf00, join_tab=0x7fba217ae088, end_of_records=false) at /data/src/10.0/sql/sql_select.cc:17843
          #20 0x00000000006a6c49 in do_select (join=0x7fba214faf00, fields=0x7fba243e1218, table=0x0, procedure=0x0) at /data/src/10.0/sql/sql_select.cc:17505
          #21 0x0000000000683d40 in JOIN::exec_inner (this=0x7fba214faf00) at /data/src/10.0/sql/sql_select.cc:3084
          #22 0x0000000000681216 in JOIN::exec (this=0x7fba214faf00) at /data/src/10.0/sql/sql_select.cc:2373
          #23 0x000000000068457e in mysql_select (thd=0x7fba243dd070, rref_pointer_array=0x7fba243e1378, tables=0x7fba214fa848, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fba214faee0, unit=0x7fba243e0a10, select_lex=0x7fba243e1100) at /data/src/10.0/sql/sql_select.cc:3308
          #24 0x000000000067a93a in handle_select (thd=0x7fba243dd070, lex=0x7fba243e0948, result=0x7fba214faee0, setup_tables_done_option=0) at /data/src/10.0/sql/sql_select.cc:373
          #25 0x000000000064f197 in execute_sqlcom_select (thd=0x7fba243dd070, all_tables=0x7fba214fa848) at /data/src/10.0/sql/sql_parse.cc:5294
          #26 0x00000000006476c2 in mysql_execute_command (thd=0x7fba243dd070) at /data/src/10.0/sql/sql_parse.cc:2563
          #27 0x0000000000651e18 in mysql_parse (thd=0x7fba243dd070, rawbuf=0x7fba214fa088 "SELECT REPLACE( ADDDATE( d, INTERVAL 0.6732771076944444 HOUR_SECOND ), '2', 'x' ) FROM t1", length=89, parser_state=0x7fba2b079650) at /data/src/10.0/sql/sql_parse.cc:6576
          #28 0x0000000000644918 in dispatch_command (command=COM_QUERY, thd=0x7fba243dd070, packet=0x7fba243d3071 "", packet_length=89) at /data/src/10.0/sql/sql_parse.cc:1309
          #29 0x0000000000643bdb in do_command (thd=0x7fba243dd070) at /data/src/10.0/sql/sql_parse.cc:999
          #30 0x0000000000761efa in do_handle_one_connection (thd_arg=0x7fba243dd070) at /data/src/10.0/sql/sql_connect.cc:1378
          #31 0x0000000000761c6c in handle_one_connection (arg=0x7fba243dd070) at /data/src/10.0/sql/sql_connect.cc:1293
          #32 0x00000000009faa88 in pfs_spawn_thread (arg=0x7fba22d91370) at /data/src/10.0/storage/perfschema/pfs.cc:1860
          #33 0x00007fba2acb60a4 in start_thread (arg=0x7fba2b07a700) at pthread_create.c:309
          #34 0x00007fba28e6e87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
          {noformat}

          {code:sql}
          CREATE TABLE t1 (d DATE);
          INSERT INTO t1 VALUES ('2005-07-20'),('2012-12-21');
          SELECT REPLACE( ADDDATE( d, INTERVAL 0.6732771076944444 HOUR_SECOND ), '2', 'x' ) FROM t1;
          {code}           		{noformat:title=Stack trace from 10.0 b34d7fba31c}
          mysqld: /data/src/10.0/sql/sql_time.h:79: void date_to_datetime(MYSQL_TIME*): Assertion `ltime->neg == 0' failed.
          160912 21:04:03 [ERROR] mysqld got signal 6 ;

          #7 0x00007fba28db4312 in __GI___assert_fail (assertion=0xf4e681 "ltime->neg == 0", file=0xf4e609 "/data/src/10.0/sql/sql_time.h", line=79, function=0xf4f800 <date_to_datetime(st_mysql_time*)::__PRETTY_FUNCTION__> "void date_to_datetime(MYSQL_TIME*)") at assert.c:101
          #8 0x00000000008f7fde in date_to_datetime (ltime=0x7fba2b077d10) at /data/src/10.0/sql/sql_time.h:79
          #9 0x00000000008f0ff7 in Item_temporal_hybrid_func::fix_temporal_type (this=0x7fba214fa3b0, ltime=0x7fba2b077d10) at /data/src/10.0/sql/item_timefunc.cc:1530
          #10 0x00000000008f10ae in Item_temporal_hybrid_func::val_str_ascii (this=0x7fba214fa3b0, str=0x7fba2b077f40) at /data/src/10.0/sql/item_timefunc.cc:1550
          #11 0x00000000008b8096 in Item_func::val_str_from_val_str_ascii (this=0x7fba214fa3b0, str=0x7fba2b077f40, str2=0x7fba214fa488) at /data/src/10.0/sql/item_strfunc.cc:83
          #12 0x00000000008f7412 in Item_temporal_hybrid_func::val_str (this=0x7fba214fa3b0, str=0x7fba2b077f40) at /data/src/10.0/sql/item_timefunc.h:552
          #14 0x00000000008540e9 in Item::send (this=0x7fba214fa600, protocol=0x7fba243dd5f8, buffer=0x7fba2b077f40) at /data/src/10.0/sql/item.cc:6509
          #15 0x000000000059f1d8 in Protocol::send_result_set_row (this=0x7fba243dd5f8, row_items=0x7fba243e1218) at /data/src/10.0/sql/protocol.cc:912
          #16 0x000000000060d779 in select_send::send_data (this=0x7fba214faee0, items=...) at /data/src/10.0/sql/sql_class.cc:2573
          #17 0x00000000006a9d2b in end_send (join=0x7fba214faf00, join_tab=0x7fba217ae3b0, end_of_records=false) at /data/src/10.0/sql/sql_select.cc:18972
          #18 0x00000000006a7ab4 in evaluate_join_record (join=0x7fba214faf00, join_tab=0x7fba217ae088, error=0) at /data/src/10.0/sql/sql_select.cc:18065
          #19 0x00000000006a73d6 in sub_select (join=0x7fba214faf00, join_tab=0x7fba217ae088, end_of_records=false) at /data/src/10.0/sql/sql_select.cc:17843
          #20 0x00000000006a6c49 in do_select (join=0x7fba214faf00, fields=0x7fba243e1218, table=0x0, procedure=0x0) at /data/src/10.0/sql/sql_select.cc:17505
          #21 0x0000000000683d40 in JOIN::exec_inner (this=0x7fba214faf00) at /data/src/10.0/sql/sql_select.cc:3084
          #22 0x0000000000681216 in JOIN::exec (this=0x7fba214faf00) at /data/src/10.0/sql/sql_select.cc:2373
          #23 0x000000000068457e in mysql_select (thd=0x7fba243dd070, rref_pointer_array=0x7fba243e1378, tables=0x7fba214fa848, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fba214faee0, unit=0x7fba243e0a10, select_lex=0x7fba243e1100) at /data/src/10.0/sql/sql_select.cc:3308
          #24 0x000000000067a93a in handle_select (thd=0x7fba243dd070, lex=0x7fba243e0948, result=0x7fba214faee0, setup_tables_done_option=0) at /data/src/10.0/sql/sql_select.cc:373
          #25 0x000000000064f197 in execute_sqlcom_select (thd=0x7fba243dd070, all_tables=0x7fba214fa848) at /data/src/10.0/sql/sql_parse.cc:5294
          #26 0x00000000006476c2 in mysql_execute_command (thd=0x7fba243dd070) at /data/src/10.0/sql/sql_parse.cc:2563
          #27 0x0000000000651e18 in mysql_parse (thd=0x7fba243dd070, rawbuf=0x7fba214fa088 "SELECT REPLACE( ADDDATE( d, INTERVAL 0.6732771076944444 HOUR_SECOND ), '2', 'x' ) FROM t1", length=89, parser_state=0x7fba2b079650) at /data/src/10.0/sql/sql_parse.cc:6576
          #28 0x0000000000644918 in dispatch_command (command=COM_QUERY, thd=0x7fba243dd070, packet=0x7fba243d3071 "", packet_length=89) at /data/src/10.0/sql/sql_parse.cc:1309
          #29 0x0000000000643bdb in do_command (thd=0x7fba243dd070) at /data/src/10.0/sql/sql_parse.cc:999
          #30 0x0000000000761efa in do_handle_one_connection (thd_arg=0x7fba243dd070) at /data/src/10.0/sql/sql_connect.cc:1378
          #31 0x0000000000761c6c in handle_one_connection (arg=0x7fba243dd070) at /data/src/10.0/sql/sql_connect.cc:1293
          #32 0x00000000009faa88 in pfs_spawn_thread (arg=0x7fba22d91370) at /data/src/10.0/storage/perfschema/pfs.cc:1860
          #33 0x00007fba2acb60a4 in start_thread (arg=0x7fba2b07a700) at pthread_create.c:309
          #34 0x00007fba28e6e87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
          {noformat}

          {code:sql}
          CREATE TABLE t1 (d DATE);
          INSERT INTO t1 VALUES ('2005-07-20'),('2012-12-21');
          SELECT REPLACE( ADDDATE( d, INTERVAL 0.6732771076944444 HOUR_SECOND ), '2', 'x' ) FROM t1;
          {code}

          10.2 is also affected.
          bar Alexander Barkov made changes -
          Priority Major [ 3 ] Critical [ 2 ]
          bar Alexander Barkov made changes -
          Affects Version/s 10.2 [ 14601 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Sprint 10.1.20 [ 119 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Rank Ranked higher
          bar Alexander Barkov made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          bar Alexander Barkov made changes -
          Assignee Alexander Barkov [ bar ] Sergei Golubchik [ serg ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          serg Sergei Golubchik made changes -
          Assignee Sergei Golubchik [ serg ] Alexander Barkov [ bar ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          bar Alexander Barkov made changes -
          Fix Version/s 10.0.29 [ 22312 ]
          Fix Version/s 10.1.20 [ 22112 ]
          Fix Version/s 10.2.3 [ 22115 ]
          Fix Version/s 10.0 [ 16000 ]
          Fix Version/s 10.1 [ 16100 ]
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 77028 ] MariaDB v4 [ 150904 ]

          People

            bar Alexander Barkov
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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