Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL)
-
None
Description
CREATE TABLE t1 (c VARCHAR(8)); |
INSERT INTO t1 VALUES (NULL),('bar'); |
SELECT RPAD( c, 0, '?' ) FROM t1; |
10.3 92f9be495b7 |
mysqld: /data/src/10.3/sql/sql_type.cc:5044: bool Type_handler::Item_send_str(Item*, Protocol*, st_value*) const: Assertion `!item->null_value' failed.
|
170816 17:53:47 [ERROR] mysqld got signal 6 ;
|
 |
#7 0x00007f780df34ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x00005590367e621c in Type_handler::Item_send_str (this=0x559037c6ad50 <type_handler_varchar>, item=0x7f77b8014c38, protocol=0x7f77b8001098, buf=0x7f7800343200) at /data/src/10.3/sql/sql_type.cc:5044
|
#9 0x00005590367e9954 in Type_handler_string_result::Item_send (this=0x559037c6ad50 <type_handler_varchar>, item=0x7f77b8014c38, protocol=0x7f77b8001098, buf=0x7f7800343200) at /data/src/10.3/sql/sql_type.h:1659
|
#10 0x000055903654a9b0 in Item::send (this=0x7f77b8014c38, protocol=0x7f77b8001098, buffer=0x7f7800343200) at /data/src/10.3/sql/item.h:724
|
#11 0x00005590365468ea in Protocol::send_result_set_row (this=0x7f77b8001098, row_items=0x7f77b8004f08) at /data/src/10.3/sql/protocol.cc:985
|
#12 0x00005590365ca2ee in select_send::send_data (this=0x7f77b80154b0, items=...) at /data/src/10.3/sql/sql_class.cc:2823
|
#13 0x000055903668ee8e in end_send (join=0x7f77b80154d0, join_tab=0x7f77b80168d0, end_of_records=false) at /data/src/10.3/sql/sql_select.cc:20021
|
#14 0x000055903668ca0c in evaluate_join_record (join=0x7f77b80154d0, join_tab=0x7f77b8016520, error=0) at /data/src/10.3/sql/sql_select.cc:19078
|
#15 0x000055903668c4b0 in sub_select (join=0x7f77b80154d0, join_tab=0x7f77b8016520, end_of_records=false) at /data/src/10.3/sql/sql_select.cc:18897
|
#16 0x000055903668b8b5 in do_select (join=0x7f77b80154d0, procedure=0x0) at /data/src/10.3/sql/sql_select.cc:18398
|
#17 0x0000559036664cd5 in JOIN::exec_inner (this=0x7f77b80154d0) at /data/src/10.3/sql/sql_select.cc:3540
|
#18 0x0000559036664182 in JOIN::exec (this=0x7f77b80154d0) at /data/src/10.3/sql/sql_select.cc:3335
|
#19 0x000055903666534d in mysql_select (thd=0x7f77b8000b00, tables=0x7f77b8014dd0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f77b80154b0, unit=0x7f77b80046a0, select_lex=0x7f77b8004de0) at /data/src/10.3/sql/sql_select.cc:3735
|
#20 0x0000559036659ab8 in handle_select (thd=0x7f77b8000b00, lex=0x7f77b80045d8, result=0x7f77b80154b0, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:376
|
#21 0x0000559036625d3c in execute_sqlcom_select (thd=0x7f77b8000b00, all_tables=0x7f77b8014dd0) at /data/src/10.3/sql/sql_parse.cc:6441
|
#22 0x000055903661c82a in mysql_execute_command (thd=0x7f77b8000b00) at /data/src/10.3/sql/sql_parse.cc:3694
|
#23 0x0000559036629778 in mysql_parse (thd=0x7f77b8000b00, rawbuf=0x7f77b80148d8 "SELECT RPAD( c, 0, '?' ) FROM t1", length=32, parser_state=0x7f7800345200, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7896
|
#24 0x000055903661775a in dispatch_command (command=COM_QUERY, thd=0x7f77b8000b00, packet=0x7f77b808fb41 "", packet_length=32, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1814
|
#25 0x00005590366160d4 in do_command (thd=0x7f77b8000b00) at /data/src/10.3/sql/sql_parse.cc:1372
|
#26 0x0000559036765fe6 in do_handle_one_connection (connect=0x559039536570) at /data/src/10.3/sql/sql_connect.cc:1354
|
#27 0x0000559036765d73 in handle_one_connection (arg=0x559039536570) at /data/src/10.3/sql/sql_connect.cc:1260
|
#28 0x0000559036bc3e0f in pfs_spawn_thread (arg=0x5590395532b0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
|
#29 0x00007f780fe79494 in start_thread (arg=0x7f7800346700) at pthread_create.c:333
|
#30 0x00007f780dff193f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Reproducible with both MyISAM and InnoDB.
Not reproducible on 10.2.