Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL), 10.5, 10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
-
None
Description
SELECT EXTRACT(HOUR_MICROSECOND FROM '42949672955000x1'); |
10.4 64f44b22d9a3dab3d4c0b77addbcbdafde57b466 |
mysqld: /data/bld/10.4-asan/sql-common/my_time.c:964: str_to_DDhhmmssff_internal: Assertion `value <= ((ulonglong) 0xFFFFFFFFL) * 10000ULL' failed.
|
231127 15:14:36 [ERROR] mysqld got signal 6 ;
|
 |
#9 0x00007f8f0c253e32 in __GI___assert_fail (assertion=0x55c6a35f8760 "value <= ((ulonglong) 0xFFFFFFFFL) * 10000ULL", file=0x55c6a35f8120 "/data/bld/10.4-asan/sql-common/my_time.c", line=964, function=0x55c6a35f8ce0 <__PRETTY_FUNCTION__.8> "str_to_DDhhmmssff_internal") at ./assert/assert.c:101
|
#10 0x000055c6a279bc6e in str_to_DDhhmmssff_internal (neg=0 '\000', str=0x62b000062986 "x1", length=16, l_time=0x7f8f03210f00, max_hour=87649415, err_hour=87649415, status=0x7f8f03210c00, endptr=0x7f8f032100a0) at /data/bld/10.4-asan/sql-common/my_time.c:964
|
#11 0x000055c6a279a618 in str_to_datetime_or_date_or_time_body (str=0x62b000062978 "42949672955000x1", length=16, l_time=0x7f8f03210f00, fuzzydate=0, status=0x7f8f03210c00, time_max_hour=87649415, time_err_hour=87649415, allow_dates_delimited=1 '\001', allow_dates_numeric=0 '\000') at /data/bld/10.4-asan/sql-common/my_time.c:754
|
#12 0x000055c6a279aec6 in str_to_datetime_or_date_or_interval_hhmmssff (str=0x62b000062978 "42949672955000x1", length=16, to=0x7f8f03210f00, mode=0, status=0x7f8f03210c00, time_max_hour=87649415, time_err_hour=87649415) at /data/bld/10.4-asan/sql-common/my_time.c:839
|
#13 0x000055c6a0f13e9f in Temporal::ascii_to_datetime_or_date_or_interval_DDhhmmssff (this=0x7f8f03210f00, st=0x7f8f03210c00, str=0x62b000062978 "42949672955000x1", length=16, mode=...) at /data/bld/10.4-asan/sql/sql_type.h:926
|
#14 0x000055c6a0f13b76 in Temporal::ascii_to_temporal (this=0x7f8f03210f00, st=0x7f8f03210c00, str=0x62b000062978 "42949672955000x1", length=16, mode=...) at /data/bld/10.4-asan/sql/sql_type.h:910
|
#15 0x000055c6a0f0a40b in Temporal::str_to_temporal (this=0x7f8f03210f00, thd=0x62b00005b208, status=0x7f8f03210c00, str=0x62b000062978 "42949672955000x1", length=16, cs=0x55c6a4383120 <my_charset_latin1>, flags=...) at /data/bld/10.4-asan/sql/sql_time.cc:412
|
#16 0x000055c6a110514a in Temporal::make_from_str (this=0x7f8f03210f00, thd=0x62b00005b208, warn=0x7f8f03210a00, str=0x62b000062978 "42949672955000x1", length=16, cs=0x55c6a4383120 <my_charset_latin1>, fuzzydate=...) at /data/bld/10.4-asan/sql/sql_type.cc:246
|
#17 0x000055c6a113cee5 in Temporal_hybrid::Temporal_hybrid (this=0x7f8f03210f00, thd=0x62b00005b208, warn=0x7f8f03210a00, str=0x62b0000629c8, mode=...) at /data/bld/10.4-asan/sql/sql_type.h:1114
|
#18 0x000055c6a13ab8e3 in Item::get_date_from_string (this=0x62b000062998, thd=0x62b00005b208, to=0x7f8f03210f00, mode=...) at /data/bld/10.4-asan/sql/item.cc:1434
|
#19 0x000055c6a08f814f in Item_string::get_date (this=0x62b000062998, thd=0x62b00005b208, ltime=0x7f8f03210f00, fuzzydate=<error reading variable: Cannot access memory at address 0xffffffffffffffe6>) at /data/bld/10.4-asan/sql/item.h:4512
|
#20 0x000055c6a11053a5 in Temporal_hybrid::Temporal_hybrid (this=0x7f8f03210f00, thd=0x62b00005b208, item=0x62b000062998, fuzzydate=...) at /data/bld/10.4-asan/sql/sql_type.cc:255
|
#21 0x000055c6a1616873 in Extract_source::Extract_source (this=0x7f8f03210f00, thd=0x62b00005b208, item=0x62b000062998, mode=<error reading variable: Cannot access memory at address 0xffffffffffffffe6>) at /data/bld/10.4-asan/sql/sql_type.h:1211
|
#22 0x000055c6a160a797 in Item_extract::val_int (this=0x62b000062a68) at /data/bld/10.4-asan/sql/item_timefunc.cc:2169
|
#23 0x000055c6a112aec8 in Type_handler::Item_send_longlong (this=0x55c6a3d91760 <type_handler_longlong>, item=0x62b000062a68, protocol=0x62b00005b808, buf=0x7f8f032110f0) at /data/bld/10.4-asan/sql/sql_type.cc:7146
|
#24 0x000055c6a11443d0 in Type_handler_longlong::Item_send (this=0x55c6a3d91760 <type_handler_longlong>, item=0x62b000062a68, protocol=0x62b00005b808, buf=0x7f8f032110f0) at /data/bld/10.4-asan/sql/sql_type.h:5255
|
#25 0x000055c6a08f4040 in Item::send (this=0x62b000062a68, protocol=0x62b00005b808, buffer=0x7f8f032110f0) at /data/bld/10.4-asan/sql/item.h:1045
|
#26 0x000055c6a08e5c95 in Protocol::send_result_set_row (this=0x62b00005b808, row_items=0x62b0000625f8) at /data/bld/10.4-asan/sql/protocol.cc:1033
|
#27 0x000055c6a0a911bf in select_send::send_data (this=0x62b0000634f8, items=...) at /data/bld/10.4-asan/sql/sql_class.cc:3130
|
#28 0x000055c6a0c82992 in JOIN::exec_inner (this=0x62b000063528) at /data/bld/10.4-asan/sql/sql_select.cc:4493
|
#29 0x000055c6a0c8156a in JOIN::exec (this=0x62b000063528) at /data/bld/10.4-asan/sql/sql_select.cc:4407
|
#30 0x000055c6a0c855f8 in mysql_select (thd=0x62b00005b208, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x62b0000634f8, unit=0x62b00005f140, select_lex=0x62b000062498) at /data/bld/10.4-asan/sql/sql_select.cc:4846
|
#31 0x000055c6a0c55edb in handle_select (thd=0x62b00005b208, lex=0x62b00005f080, result=0x62b0000634f8, setup_tables_done_option=0) at /data/bld/10.4-asan/sql/sql_select.cc:442
|
#32 0x000055c6a0bc077c in execute_sqlcom_select (thd=0x62b00005b208, all_tables=0x0) at /data/bld/10.4-asan/sql/sql_parse.cc:6521
|
#33 0x000055c6a0badb42 in mysql_execute_command (thd=0x62b00005b208) at /data/bld/10.4-asan/sql/sql_parse.cc:3978
|
#34 0x000055c6a0bc9a6b in mysql_parse (thd=0x62b00005b208, rawbuf=0x62b0000623b8 "SELECT EXTRACT(HOUR_MICROSECOND FROM '42949672955000x1')", length=56, parser_state=0x7f8f03213c60, is_com_multi=false, is_next_command=false) at /data/bld/10.4-asan/sql/sql_parse.cc:8060
|
#35 0x000055c6a0b9fae2 in dispatch_command (command=COM_QUERY, thd=0x62b00005b208, packet=0x62900021c209 "", packet_length=56, is_com_multi=false, is_next_command=false) at /data/bld/10.4-asan/sql/sql_parse.cc:1857
|
#36 0x000055c6a0b9c651 in do_command (thd=0x62b00005b208) at /data/bld/10.4-asan/sql/sql_parse.cc:1378
|
#37 0x000055c6a0fa2d15 in do_handle_one_connection (connect=0x6080000009a8) at /data/bld/10.4-asan/sql/sql_connect.cc:1419
|
#38 0x000055c6a0fa262c in handle_one_connection (arg=0x6080000009a8) at /data/bld/10.4-asan/sql/sql_connect.cc:1323
|
#39 0x000055c6a1c0726c in pfs_spawn_thread (arg=0x615000003508) at /data/bld/10.4-asan/storage/perfschema/pfs.cc:1869
|
#40 0x00007f8f0c2a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#41 0x00007f8f0c32861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
Non-debug builds return NULL with a warning, which appears to be a correct outcome:
EXTRACT(HOUR_MICROSECOND FROM '42949672955000x1') |
NULL
|
Warnings:
|
Warning 1292 Incorrect interval value: '42949672955000x1' |