SIGSEGV in sec_part_shift

CREATE TABLE t1 (c1 INT);

(SELECT 1 FROM t1 LIMIT 1) ORDER BY PERCENTILE_DISC(1) WITHIN GROUP(ORDER BY TIME'0') OVER();

Core was generated by `/test/MD090926-mariadb-13.0.2-linux-x86_64-opt/bin/mariadbd --no-defaults --loo'.

Program terminated with signal SIGSEGV, Segmentation fault.

#0  0x000055bcf3c01a66 in sec_part_shift (second_part=3020400000000, digits=10)at /test/13.0_opt/include/my_time.h:250

[Current thread is 1 (LWP 1728717)]

(gdb) bt

#0  0x000055bcf3c01a66 in sec_part_shift (second_part=3020400000000, digits=10)at /test/13.0_opt/include/my_time.h:250

#1  Field_time_hires::Field_time_hires (this=0x6c57a006e2d0, ptr_arg=<optimized out>, null_ptr_arg=<optimized out>, null_bit_arg=1 '\001', unireg_check_arg=Field::NONE, field_name_arg=0x6c57a0019780, dec_arg=10)at /test/13.0_opt/sql/field.h:3856

#2  new_Field_time (root=<optimized out>, ptr=<optimized out>, null_ptr=<optimized out>, null_bit=1 '\001', unireg_check=unireg_check@entry=Field::NONE, field_name=0x6c57a0019780, dec=10) at /test/13.0_opt/sql/field.h:4161

#3  0x000055bcf3c04b7b in Type_handler_time2::make_table_field (this=<optimized out>, root=0x6c57a006e2d0, name=0x0, addr=<optimized out>, attr=<optimized out>, share=<optimized out>)at /test/13.0_opt/sql/sql_type.cc:3937

#4  0x000055bcf3c04355 in Type_handler::make_and_init_table_field (this=0x6c57a006e2d0, root=0x0, name=0x0, name@entry=0x6c57a0019780, addr=@0x55bcf4d5eed0: {m_ptr = 0x1 <error: Cannot access memory at address 0x1>, m_null = {m_ptr = 0xa <error: Cannot access memory at address 0xa>, m_offs = 100 'd'}}, attr=<error reading variable: Cannot access memory at address 0x1>, table=0x6c57a006d620) at /test/13.0_opt/sql/sql_type.cc:3721

#5  0x000055bcf3ab6e12 in Item_result_field::create_tmp_field_ex_from_handler (this=0x6c57a0019730, root=0x0, table=0x0, src=<optimized out>, param=0x7458496b14f4, h=0x2bf3dde7c00)at /test/13.0_opt/sql/sql_select.cc:21846

#6  0x000055bcf3ab6f28 in create_tmp_field (table=table@entry=0x6c57a006d620, item=item@entry=0x6c57a0019730, copy_func=copy_func@entry=0x7458496b1588, from_field=from_field@entry=0x6c57a006df70, default_field=0x6c57a006df50, group=false, modify_item=<optimized out>, table_cant_handle_bit_fields=<optimized out>, make_copy_field=<optimized out>) at /test/13.0_opt/sql/sql_select.cc:21932

#7  0x000055bcf3ab803b in Create_tmp_table::add_fields (this=this@entry=0x7458496b1618, thd=thd@entry=0x6c57a0000c70, table=0x6c57a006d620, param=param@entry=0x6c57a001f2a0, fields=@0x6c57a001b490: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x6c57a001c430, last = 0x6c57a0019f20, elements = 2}, <No data fields>})at /test/13.0_opt/sql/sql_select.cc:22371

#8  0x000055bcf3a9ccf7 in create_tmp_table (thd=0x6c57a0000c70, param=param@entry=0x6c57a001f2a0, fields=@0x6c57a001b490: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x6c57a001c430, last = 0x6c57a0019f20, elements = 2}, <No data fields>}, group=group@entry=0x0, distinct=<optimized out>, save_sum_fields=<optimized out>, select_options=2164525824, rows_limit=18446744073709551615, table_alias=0x55bcf4b81fe0 <empty_clex_str>, do_not_open=<optimized out>, keep_row_order=<optimized out>) at /test/13.0_opt/sql/sql_select.cc:23048

#9  0x000055bcf3a9d8c3 in JOIN::create_postjoin_aggr_table (this=0x6c57a001b0f0, tab=tab@entry=0x6c57a0066898, table_fields=table_fields@entry=0x6c57a001b490, table_group=0x0, save_sum_fields=false, distinct=false, keep_row_order=<optimized out>)at /test/13.0_opt/sql/sql_select.cc:4408

#10 0x000055bcf3a9b088 in JOIN::make_aggr_tables_info (this=this@entry=0x6c57a001b0f0) at /test/13.0_opt/sql/sql_select.cc:3968

#11 0x000055bcf3a8fb5f in JOIN::optimize_stage2 (this=this@entry=0x6c57a001b0f0) at /test/13.0_opt/sql/sql_select.cc:3576

#12 0x000055bcf3a8e2cf in JOIN::optimize_inner (this=this@entry=0x6c57a001b0f0)at /test/13.0_opt/sql/sql_select.cc:2789

#13 0x000055bcf3a87569 in JOIN::optimize (this=0x6c57a001b0f0)at /test/13.0_opt/sql/sql_select.cc:2016

#14 mysql_select (thd=thd@entry=0x6c57a0000c70, tables=<optimized out>, fields=@0x6c57a0019ba8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x6c57a0019f20, last = 0x6c57a0019f20, elements = 1}, <No data fields>}, conds=<optimized out>, og_num=<optimized out>, order=<optimized out>, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x6c57a001b0c0, unit=0x6c57a00051b8, select_lex=0x6c57a00198f0)at /test/13.0_opt/sql/sql_select.cc:5425

#15 0x000055bcf3a87000 in handle_select (thd=thd@entry=0x6c57a0000c70, lex=lex@entry=0x6c57a00050d8, result=result@entry=0x6c57a001b0c0, setup_tables_done_option=setup_tables_done_option@entry=0)at /test/13.0_opt/sql/sql_select.cc:636

#16 0x000055bcf3a54ce7 in execute_sqlcom_select (thd=thd@entry=0x6c57a0000c70, all_tables=0x6c57a0019f70) at /test/13.0_opt/sql/sql_parse.cc:6217

#17 0x000055bcf3a506e6 in mysql_execute_command (thd=thd@entry=0x6c57a0000c70, is_called_from_prepared_stmt=false) at /test/13.0_opt/sql/sql_parse.cc:3991

#18 0x000055bcf3a4ba2d in mysql_parse (thd=thd@entry=0x6c57a0000c70, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7458496b24f0)at /test/13.0_opt/sql/sql_parse.cc:7943

#19 0x000055bcf3a4a1ff in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x6c57a0000c70, packet=packet@entry=0x6c57a0008d91 "(SELECT 1 FROM t1 LIMIT 1) ORDER BY PERCENTILE_DISC(1) WITHIN GROUP(ORDER BY TIME'0') OVER()", packet_length=packet_length@entry=92, blocking=true)at /test/13.0_opt/sql/sql_parse.cc:1903

#20 0x000055bcf3a4beb0 in do_command (thd=thd@entry=0x6c57a0000c70, blocking=true) at /test/13.0_opt/sql/sql_parse.cc:1437

#21 0x000055bcf3b7435d in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55bd2ece0560, put_in_cache=true)at /test/13.0_opt/sql/sql_connect.cc:1514

#22 0x000055bcf3b74192 in handle_one_connection (arg=arg@entry=0x55bd2ece0560)at /test/13.0_opt/sql/sql_connect.cc:1426

#23 0x000055bcf3f17453 in pfs_spawn_thread (arg=0x55bd2ed00950)at /test/13.0_opt/storage/perfschema/pfs.cc:2198

#24 0x000074587729cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447

#25 0x0000745877329ecc in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

mariadbd: /test/13.0_dbg/sql/field.h:3830: Field_time_with_dec::Field_time_with_dec(uchar *, uchar *, uchar, enum utype, const LEX_CSTRING *, decimal_digits_t): Assertion `dec <= 6' failed.

Core was generated by `/test/MD090926-mariadb-13.0.2-linux-x86_64-dbg/bin/mariadbd --no-defaults --loo'.

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 1728743)]

(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  0x000071a63a84527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26

#4  0x000071a63a8288ff in __GI_abort () at ./stdlib/abort.c:79

#5  0x000071a63a82881b in __assert_fail_base (fmt=0x71a63a9d1208 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x6553c5c01f18 "dec <= 6", file=file@entry=0x6553c5beac9f "/test/13.0_dbg/sql/field.h", line=line@entry=3830, function=function@entry=0x6553c5c6476c "Field_time_with_dec::Field_time_with_dec(uchar *, uchar *, uchar, enum utype, const LEX_CSTRING *, decimal_digits_t)") at ./assert/assert.c:96

#6  0x000071a63a83b517 in __assert_fail (assertion=0x6553c5c01f18 "dec <= 6", file=0x6553c5beac9f "/test/13.0_dbg/sql/field.h", line=3830, function=0x6553c5c6476c "Field_time_with_dec::Field_time_with_dec(uchar *, uchar *, uchar, enum utype, const LEX_CSTRING *, decimal_digits_t)")at ./assert/assert.c:105

#7  0x00006553c4efd69f in Field_time_with_dec::Field_time_with_dec (this=0x69a544092240, ptr_arg=0x0, null_ptr_arg=0x6553c5e1dce4 "", null_bit_arg=1 '\001', unireg_check_arg=Field::NONE, field_name_arg=0x69a54401bfe0, dec_arg=10)at /test/13.0_dbg/sql/field.h:3830

#8  0x00006553c4efd423 in Field_time_hires::Field_time_hires (this=0x69a544092240, ptr_arg=0x0, null_ptr_arg=0x6553c5e1dce4 "", null_bit_arg=1 '\001', unireg_check_arg=Field::NONE, field_name_arg=0x69a54401bfe0, dec_arg=10)at /test/13.0_dbg/sql/field.h:3851

#9  0x00006553c4ed86be in new_Field_time (root=0x69a544091620, ptr=0x0, null_ptr=0x6553c5e1dce4 "", null_bit=1 '\001', unireg_check=Field::NONE, field_name=0x69a54401bfe0, dec=10) at /test/13.0_dbg/sql/field.h:4161

#10 0x00006553c4edc873 in Type_handler_time2::make_table_field (this=0x6553c691d768 <type_handler_time2>, root=0x69a544091620, name=0x69a54401bfe0, addr=@0x69a5f790ecf0: {m_ptr = 0x0, m_null = {m_ptr = 0x6553c5e1dce4 "", m_offs = 0 '\000'}}, attr=@0x69a54401bf90: {<Type_std_attributes> = {<Type_numeric_attributes> = {max_length = 17, decimals = 10, unsigned_flag = false}, collation = {collation = 0x6553c6782930 <my_charset_latin1>, derivation = DERIVATION_NUMERIC, repertoire = MY_REPERTOIRE_ASCII}}, _vptr$Type_all_attributes = 0x6553c666fea8 <vtable for Item_window_func+16>, static _vtable$ = <optimized out>}, share=0x69a544091730) at /test/13.0_dbg/sql/sql_type.cc:3937

#11 0x00006553c4edbb64 in Type_handler::make_and_init_table_field (this=0x6553c691d768 <type_handler_time2>, root=0x69a544091620, name=0x69a54401bfe0, addr=@0x69a5f790ecf0: {m_ptr = 0x0, m_null = {m_ptr = 0x6553c5e1dce4 "", m_offs = 0 '\000'}}, attr=@0x69a54401bf90: {<Type_std_attributes> = {<Type_numeric_attributes> = {max_length = 17, decimals = 10, unsigned_flag = false}, collation = {collation = 0x6553c6782930 <my_charset_latin1>, derivation = DERIVATION_NUMERIC, repertoire = MY_REPERTOIRE_ASCII}}, _vptr$Type_all_attributes = 0x6553c666fea8 <vtable for Item_window_func+16>, static _vtable$ = <optimized out>}, table=0x69a544091320) at /test/13.0_dbg/sql/sql_type.cc:3721

#12 0x00006553c4ccb231 in Item_result_field::create_tmp_field_ex_from_handler (this=0x69a54401bf90, root=0x69a544091620, table=0x69a544091320, src=0x69a5f790ed88, param=0x69a5f790ed84, h=0x6553c691d768 <type_handler_time2>)at /test/13.0_dbg/sql/sql_select.cc:21846

#13 0x00006553c4ac2a17 in Item_result_field::create_tmp_field_ex (this=0x69a54401bf90, root=0x69a544091620, table=0x69a544091320, src=0x69a5f790ed88, param=0x69a5f790ed84) at /test/13.0_dbg/sql/item.h:3700

#14 0x00006553c4ccb3f3 in create_tmp_field (table=0x69a544091320, item=0x69a54401bf90, copy_func=0x69a5f790eef8, from_field=0x69a544091e40, default_field=0x69a544091e00, group=false, modify_item=true, table_cant_handle_bit_fields=false, make_copy_field=false)at /test/13.0_dbg/sql/sql_select.cc:21932

#15 0x00006553c4ccd3b8 in Create_tmp_table::add_fields (this=0x69a5f790ef88, thd=0x69a544000d60, table=0x69a544091320, param=0x69a544021d90, fields=@0x69a54401dcf8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x69a54401eca0, last = 0x69a54401c780, elements = 2}, <No data fields>})at /test/13.0_dbg/sql/sql_select.cc:22371

#16 0x00006553c4caa7e0 in create_tmp_table (thd=0x69a544000d60, param=0x69a544021d90, fields=@0x69a54401dcf8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x69a54401eca0, last = 0x69a54401c780, elements = 2}, <No data fields>}, group=0x0, distinct=false, save_sum_fields=false, select_options=2164525824, rows_limit=18446744073709551615, table_alias=0x6553c64fc780 <empty_clex_str>, do_not_open=true, keep_row_order=false) at /test/13.0_dbg/sql/sql_select.cc:23048

#17 0x00006553c4caba8d in JOIN::create_postjoin_aggr_table (this=0x69a54401d950, tab=0x69a54408a608, table_fields=0x69a54401dcf8, table_group=0x0, save_sum_fields=false, distinct=false, keep_row_order=false) at /test/13.0_dbg/sql/sql_select.cc:4408

#18 0x00006553c4ca8692 in JOIN::make_aggr_tables_info (this=0x69a54401d950)at /test/13.0_dbg/sql/sql_select.cc:3968

#19 0x00006553c4c993c7 in JOIN::optimize_stage2 (this=0x69a54401d950)at /test/13.0_dbg/sql/sql_select.cc:3576

#20 0x00006553c4c9710f in JOIN::optimize_inner (this=0x69a54401d950)at /test/13.0_dbg/sql/sql_select.cc:2789

#21 0x00006553c4c94ce6 in JOIN::optimize (this=0x69a54401d950)at /test/13.0_dbg/sql/sql_select.cc:2016

#22 0x00006553c4c8d52d in mysql_select (thd=0x69a544000d60, tables=0x69a54401c7d0, fields=@0x69a54401c408: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x69a54401c780, last = 0x69a54401c780, elements = 1}, <No data fields>}, conds=0x0, og_num=1, order=0x69a54401c0a0, group=0x0, having=0x0, proc_param=0x0, select_options=2164525824, result=0x69a54401d920, unit=0x69a544005280, select_lex=0x69a54401c150)at /test/13.0_dbg/sql/sql_select.cc:5425

#23 0x00006553c4c8d12d in handle_select (thd=0x69a544000d60, lex=0x69a5440051a0, result=0x69a54401d920, setup_tables_done_option=0)at /test/13.0_dbg/sql/sql_select.cc:636

#24 0x00006553c4c37af6 in execute_sqlcom_select (thd=0x69a544000d60, all_tables=0x69a54401c7d0) at /test/13.0_dbg/sql/sql_parse.cc:6217

#25 0x00006553c4c2df28 in mysql_execute_command (thd=0x69a544000d60, is_called_from_prepared_stmt=false) at /test/13.0_dbg/sql/sql_parse.cc:3991

#26 0x00006553c4c26d18 in mysql_parse (thd=0x69a544000d60, rawbuf=0x69a54401a3c0 "(SELECT 1 FROM t1 LIMIT 1) ORDER BY PERCENTILE_DISC(1) WITHIN GROUP(ORDER BY TIME'0') OVER()", length=92, parser_state=0x69a5f79119f0) at /test/13.0_dbg/sql/sql_parse.cc:7943

#27 0x00006553c4c2446e in dispatch_command (command=COM_QUERY, thd=0x69a544000d60, packet=0x69a54400b5f1 "(SELECT 1 FROM t1 LIMIT 1) ORDER BY PERCENTILE_DISC(1) WITHIN GROUP(ORDER BY TIME'0') OVER()", packet_length=92, blocking=true)at /test/13.0_dbg/sql/sql_parse.cc:1903

#28 0x00006553c4c2779a in do_command (thd=0x69a544000d60, blocking=true)at /test/13.0_dbg/sql/sql_parse.cc:1437

#29 0x00006553c4df975e in do_handle_one_connection (connect=0x6553f5c046f0, put_in_cache=true) at /test/13.0_dbg/sql/sql_connect.cc:1514

#30 0x00006553c4df9541 in handle_one_connection (arg=0x6553f5be3050)at /test/13.0_dbg/sql/sql_connect.cc:1426

#31 0x000071a63a89cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447

#32 0x000071a63a929ecc in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

    Rel    o/d  Build   Commit                                    UniqueID observed             

CS  10.11  dbg  090926  2753b5919a10abd32ba822877c6a1cbf602d3748  dec <= 6|SIGABRT|Field_time_with_dec::Field_time_with_dec|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

CS  10.11  opt  090926  2753b5919a10abd32ba822877c6a1cbf602d3748  SIGSEGV|sec_part_shift|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

CS  11.4   dbg  090926  42038e1145dd43b3910055c364fb720a8a152d61  dec <= 6|SIGABRT|Field_time_with_dec::Field_time_with_dec|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

CS  11.4   opt  090926  42038e1145dd43b3910055c364fb720a8a152d61  SIGSEGV|sec_part_shift|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

CS  11.8   dbg  090926  e2e060ce3d8c3ce11b6c7ba28ced0f1a30c50a54  dec <= 6|SIGABRT|Field_time_with_dec::Field_time_with_dec|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

CS  11.8   opt  090926  e2e060ce3d8c3ce11b6c7ba28ced0f1a30c50a54  SIGSEGV|sec_part_shift|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

CS  12.3   dbg  090926  e9f84a1fdf7093191e55b55dc14b08b9d4ebaa20  dec <= 6|SIGABRT|Field_time_with_dec::Field_time_with_dec|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

CS  12.3   opt  090926  e9f84a1fdf7093191e55b55dc14b08b9d4ebaa20  SIGSEGV|sec_part_shift|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

CS  13.0   dbg  090926  b2c4e675049e23ce8c7346985f40840fcd4e583f  dec <= 6|SIGABRT|Field_time_with_dec::Field_time_with_dec|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

CS  13.0   opt  090926  b2c4e675049e23ce8c7346985f40840fcd4e583f  SIGSEGV|sec_part_shift|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

CS  13.1   dbg  090926  02c842c30dcb05a962eaac58c69920e6be3369cf  dec <= 6|SIGABRT|Field_time_with_dec::Field_time_with_dec|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

CS  13.1   opt  090926  02c842c30dcb05a962eaac58c69920e6be3369cf  SIGSEGV|sec_part_shift|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

ES  10.6   dbg  090926  aa3fb9800c358182ee2a1f8cca8ffbdd6d0a37eb  dec <= 6|SIGABRT|Field_time_with_dec::Field_time_with_dec|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

ES  10.6   opt  090926  aa3fb9800c358182ee2a1f8cca8ffbdd6d0a37eb  SIGSEGV|sec_part_shift|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

ES  11.4   dbg  090926  32807340954440071ca8ae8e2de51fb180d134c6  dec <= 6|SIGABRT|Field_time_with_dec::Field_time_with_dec|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

ES  11.4   opt  090926  32807340954440071ca8ae8e2de51fb180d134c6  SIGSEGV|sec_part_shift|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

ES  11.8   dbg  090926  c4af6f687a2dd983072457429aa2294f11957650  dec <= 6|SIGABRT|Field_time_with_dec::Field_time_with_dec|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

ES  11.8   opt  090926  c4af6f687a2dd983072457429aa2294f11957650  SIGSEGV|sec_part_shift|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

ES  12.3   dbg  090926  c3bd5108d81f19e33efb93f7b6ae971293732fd0  dec <= 6|SIGABRT|Field_time_with_dec::Field_time_with_dec|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field

ES  12.3   opt  090926  c3bd5108d81f19e33efb93f7b6ae971293732fd0  SIGSEGV|sec_part_shift|Field_time_hires::Field_time_hires|new_Field_time|Type_handler_time2::make_table_field