SIGABRT in duckdb::HandleCastError::AssignError on SELECT ... UNION

SET sql_mode='';

INSTALL SONAME 'ha_duckdb';

CREATE TABLE t1 (c1 INT KEY,c2 INT) ENGINE=DuckDB;

CREATE TABLE t2 (c1 INT KEY,c2 BIT(30));

REPLACE INTO t2 SET c1='a',c2='a+abc';

SELECT * FROM t1 WHERE EXISTS (SELECT 1) UNION SELECT * FROM t2;

Core was generated by `/test/MD180826-mariadb-13.1.0-linux-x86_64-opt/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 4051841)]

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

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

#5  0x00007d3c96ca5ff5 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6

#6  0x00007d3c96cbb0da in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6

#7  0x00007d3c96ca5a55 in std::terminate() ()

   from /lib/x86_64-linux-gnu/libstdc++.so.6

#8  0x00007d3c96cbb391 in __cxa_throw ()

   from /lib/x86_64-linux-gnu/libstdc++.so.6

#9  0x0000753b9da2b10e in duckdb::HandleCastError::AssignError(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >*, duckdb::optional_ptr<duckdb::Expression const, true>, duckdb::optional_idx) ()

   from /test/MD180826-mariadb-13.1.0-linux-x86_64-opt/lib/plugin/ha_duckdb.so

#10 0x0000753b9cf62b86 in duckdb::Blob::TryGetBlobSize(duckdb::string_t, unsigned long&, duckdb::CastParameters&) ()

   from /test/MD180826-mariadb-13.1.0-linux-x86_64-opt/lib/plugin/ha_duckdb.so

#11 0x0000753b9cf62de5 in duckdb::Blob::GetBlobSize(duckdb::string_t, duckdb::CastParameters&) ()

   from /test/MD180826-mariadb-13.1.0-linux-x86_64-opt/lib/plugin/ha_duckdb.so

#12 0x0000753b9cf63004 in duckdb::Blob::ToBlob[abi:cxx11](duckdb::string_t, duckdb::CastParameters&) ()

   from /test/MD180826-mariadb-13.1.0-linux-x86_64-opt/lib/plugin/ha_duckdb.so

#13 0x0000753b9cf891eb in duckdb::Value::BLOB(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&) ()

   from /test/MD180826-mariadb-13.1.0-linux-x86_64-opt/lib/plugin/ha_duckdb.so

#14 0x0000753b9ccf96a3 in myduck::item_to_duckdb_value (item=<optimized out>, type=<optimized out>)at /test/13.1_opt/storage/duckdb/runtime/fiber_scan.cc:72

#15 0x0000753b9ccf98c2 in myduck::select_to_duckdb::send_data (this=0x7536e408f2d0, items=<optimized out>)at /test/13.1_opt/storage/duckdb/runtime/fiber_scan.cc:111

#16 0x00005fc42997f50f in select_result_sink::send_data_with_check (this=0x3d9f7d, items=<error reading variable: Cannot access memory at address 0x3dd381>, u=0x6, sent=137699177131020) at /test/13.1_opt/sql/sql_class.cc:3331

#17 0x00005fc429a290c6 in end_send (join=0x7536e40942a0, join_tab=0x7536e4095d88, end_of_records=<optimized out>)at /test/13.1_opt/sql/sql_select.cc:26149

#18 0x00005fc429a48ced in evaluate_join_record (join=join@entry=0x7536e40942a0, join_tab=join_tab@entry=0x7536e4095910, error=<optimized out>) at /test/13.1_opt/sql/sql_select.cc:24983

#19 0x00005fc429a12d11 in sub_select (join=0x7536e40942a0, join_tab=0x7536e4095910, end_of_records=<optimized out>)at /test/13.1_opt/sql/sql_select.cc:24750

#20 0x00005fc429a2d253 in do_select (join=join@entry=0x7536e40942a0, procedure=<optimized out>) at /test/13.1_opt/sql/sql_select.cc:24261

#21 0x00005fc429a2cd29 in JOIN::exec_inner (this=this@entry=0x7536e40942a0)at /test/13.1_opt/sql/sql_select.cc:5126

#22 0x00005fc429a135a7 in JOIN::exec (this=0x7536e40942a0)at /test/13.1_opt/sql/sql_select.cc:4914

#23 mysql_select (thd=thd@entry=0x7536e4087470, tables=<optimized out>, fields=@0x7536e408f9e8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7536e408f4e0, last = 0x7536e408f640, elements = 2}, <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=0x7536e408f2d0, unit=0x7536e408ba30, select_lex=0x7536e408f730)at /test/13.1_opt/sql/sql_select.cc:5440

#24 0x00005fc429a131c0 in handle_select (thd=thd@entry=0x7536e4087470, lex=lex@entry=0x7536e408b950, result=result@entry=0x7536e408f2d0, setup_tables_done_option=setup_tables_done_option@entry=0)at /test/13.1_opt/sql/sql_select.cc:637

#25 0x00005fc4299dec87 in execute_sqlcom_select (thd=thd@entry=0x7536e4087470, all_tables=0x7536e4090080) at /test/13.1_opt/sql/sql_parse.cc:6229

#26 0x00005fc4299da4c7 in mysql_execute_command (thd=thd@entry=0x7536e4087470, is_called_from_prepared_stmt=false) at /test/13.1_opt/sql/sql_parse.cc:3997

#27 0x0000753b9ccfa325 in myduck::fiber_scan_func (arg=0x7536e4007030)at /test/13.1_opt/storage/duckdb/runtime/fiber_scan.cc:353

#28 0x0000753b9ccf90a5 in fiber_context_spawn (c=0x7536e4007030, f=0x3dd381, d=0x6) at /test/13.1_opt/storage/duckdb/runtime/fiber_context.cpp:156

Core was generated by `/test/MD180826-mariadb-13.1.0-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 4053045)]

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

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

#5  0x000071d6598a5ff5 in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6

#6  0x000071d6598bb0da in ?? () from /lib/x86_64-linux-gnu/libstdc++.so.6

#7  0x000071d6598a5a55 in std::terminate() ()

   from /lib/x86_64-linux-gnu/libstdc++.so.6

#8  0x000071d6598bb391 in __cxa_throw ()

   from /lib/x86_64-linux-gnu/libstdc++.so.6

#9  0x000069d51cb52979 in duckdb::HandleCastError::AssignError (error_message="Invalid byte encountered in STRING -> BLOB conversion of string \"?\377\377\377\". All non-ascii characters must be escaped with hex codes (e.g. \\xAA)", error_message_ptr=0x0, cast_source={ptr = 0x0}, error_location={static INVALID_INDEX = 18446744073709551615, index = 18446744073709551615})at /test/13.1_dbg/storage/duckdb/third_parties/duckdb/src/function/cast/default_casts.cpp:47

#10 0x000069d51cb52821 in duckdb::HandleCastError::AssignError (error_message="Invalid byte encountered in STRING -> BLOB conversion of string \"?\377\377\377\". All non-ascii characters must be escaped with hex codes (e.g. \\xAA)", parameters=@0x69d070084a78: {cast_data = {ptr = 0x0}, strict = false, error_message = 0x0, cast_source = {ptr = 0x0}, cast_target = {ptr = 0x0}, local_state = {ptr = 0x0}, query_location = {static INVALID_INDEX = 18446744073709551615, index = 18446744073709551615}, nullify_parent = false})at /test/13.1_dbg/storage/duckdb/third_parties/duckdb/src/function/cast/default_casts.cpp:37

#11 0x000069d51ba4cb70 in duckdb::Blob::TryGetBlobSize (str={static PREFIX_BYTES = 4, static INLINE_BYTES = 12, static HEADER_SIZE = 8, static MAX_STRING_SIZE = 4294967295, static PREFIX_LENGTH = 4, static INLINE_LENGTH = 12, value = {pointer = {length = 4, prefix = "?\377\377\377", ptr = 0x0}, inlined = {length = 4, inlined = "?\377\377\377\000\000\000\000\000\000\000"}}}, str_len=@0x69d070084948: 1, parameters=@0x69d070084a78: {cast_data = {ptr = 0x0}, strict = false, error_message = 0x0, cast_source = {ptr = 0x0}, cast_target = {ptr = 0x0}, local_state = {ptr = 0x0}, query_location = {static INVALID_INDEX = 18446744073709551615, index = 18446744073709551615}, nullify_parent = false})at /test/13.1_dbg/storage/duckdb/third_parties/duckdb/src/common/types/blob.cpp:103

#12 0x000069d51ba4ccdc in duckdb::Blob::GetBlobSize (str={static PREFIX_BYTES = 4, static INLINE_BYTES = 12, static HEADER_SIZE = 8, static MAX_STRING_SIZE = 4294967295, static PREFIX_LENGTH = 4, static INLINE_LENGTH = 12, value = {pointer = {length = 4, prefix = "?\377\377\377", ptr = 0x0}, inlined = {length = 4, inlined = "?\377\377\377\000\000\000\000\000\000\000"}}}, parameters=@0x69d070084a78: {cast_data = {ptr = 0x0}, strict = false, error_message = 0x0, cast_source = {ptr = 0x0}, cast_target = {ptr = 0x0}, local_state = {ptr = 0x0}, query_location = {static INVALID_INDEX = 18446744073709551615, index = 18446744073709551615}, nullify_parent = false})at /test/13.1_dbg/storage/duckdb/third_parties/duckdb/src/common/types/blob.cpp:117

#13 0x000069d51ba4d185 in duckdb::Blob::ToBlob[abi:cxx11](duckdb::string_t, duckdb::CastParameters&) (str={static PREFIX_BYTES = 4, static INLINE_BYTES = 12, static HEADER_SIZE = 8, static MAX_STRING_SIZE = 4294967295, static PREFIX_LENGTH = 4, static INLINE_LENGTH = 12, value = {pointer = {length = 4, prefix = "?\377\377\377", ptr = 0x0}, inlined = {length = 4, inlined = "?\377\377\377\000\000\000\000\000\000\000"}}}, parameters=@0x69d070084a78: {cast_data = {ptr = 0x0}, strict = false, error_message = 0x0, cast_source = {ptr = 0x0}, cast_target = {ptr = 0x0}, local_state = {ptr = 0x0}, query_location = {static INVALID_INDEX = 18446744073709551615, index = 18446744073709551615}, nullify_parent = false})at /test/13.1_dbg/storage/duckdb/third_parties/duckdb/src/common/types/blob.cpp:153

#14 0x000069d51ba4d130 in duckdb::Blob::ToBlob[abi:cxx11](duckdb::string_t) (str={static PREFIX_BYTES = 4, static INLINE_BYTES = 12, static HEADER_SIZE = 8, static MAX_STRING_SIZE = 4294967295, static PREFIX_LENGTH = 4, static INLINE_LENGTH = 12, value = {pointer = {length = 4, prefix = "?\377\377\377", ptr = 0x0}, inlined = {length = 4, inlined = "?\377\377\377\000\000\000\000\000\000\000"}}})at /test/13.1_dbg/storage/duckdb/third_parties/duckdb/src/common/types/blob.cpp:149

#15 0x000069d51ba70046 in duckdb::Value::BLOB (data="?\377\377\377")at /test/13.1_dbg/storage/duckdb/third_parties/duckdb/src/common/types/value.cpp:966

#16 0x000069d51b6acc81 in myduck::item_to_duckdb_value (item=0x69d070091270, type=@0x69d070004968: {id_ = duckdb::LogicalTypeId::BLOB, physical_type_ = duckdb::PhysicalType::VARCHAR, type_info_ = {internal = std::shared_ptr<struct duckdb::ExtraTypeInfo> (empty) = {      get() = 0x0    }}, static SQLNULL = duckdb::LogicalTypeId::SQLNULL, static UNKNOWN = duckdb::LogicalTypeId::UNKNOWN, static BOOLEAN = duckdb::LogicalTypeId::BOOLEAN, static TINYINT = duckdb::LogicalTypeId::TINYINT, static UTINYINT = duckdb::LogicalTypeId::UTINYINT, static SMALLINT = duckdb::LogicalTypeId::SMALLINT, static USMALLINT = duckdb::LogicalTypeId::USMALLINT, static INTEGER = duckdb::LogicalTypeId::INTEGER, static UINTEGER = duckdb::LogicalTypeId::UINTEGER, static BIGINT = duckdb::LogicalTypeId::BIGINT, static UBIGINT = duckdb::LogicalTypeId::UBIGINT, static FLOAT = duckdb::LogicalTypeId::FLOAT, static DOUBLE = duckdb::LogicalTypeId::DOUBLE, static DATE = duckdb::LogicalTypeId::DATE, static TIMESTAMP = duckdb::LogicalTypeId::TIMESTAMP, static TIMESTAMP_S = duckdb::LogicalTypeId::TIMESTAMP_SEC, static TIMESTAMP_MS = duckdb::LogicalTypeId::TIMESTAMP_MS, static TIMESTAMP_NS = duckdb::LogicalTypeId::TIMESTAMP_NS, static TIME = duckdb::LogicalTypeId::TIME, static TIME_NS = duckdb::LogicalTypeId::TIME_NS, static TIMESTAMP_TZ = duckdb::LogicalTypeId::TIMESTAMP_TZ, static TIME_TZ = duckdb::LogicalTypeId::TIME_TZ, static VARCHAR = duckdb::LogicalTypeId::VARCHAR, static ANY = duckdb::LogicalTypeId::ANY, static BLOB = duckdb::LogicalTypeId::BLOB, static BIT = duckdb::LogicalTypeId::BIT, static BIGNUM = duckdb::LogicalTypeId::BIGNUM, static INTERVAL = duckdb::LogicalTypeId::INTERVAL, static HUGEINT = duckdb::LogicalTypeId::HUGEINT, static UHUGEINT = duckdb::LogicalTypeId::UHUGEINT, static UUID = duckdb::LogicalTypeId::UUID, static HASH = duckdb::LogicalTypeId::UBIGINT, static POINTER = duckdb::LogicalTypeId::POINTER, static TABLE = duckdb::LogicalTypeId::TABLE, static LAMBDA = duckdb::LogicalTypeId::LAMBDA, static INVALID = duckdb::LogicalTypeId::INVALID, static ROW_TYPE = duckdb::LogicalTypeId::BIGINT, static JSON_TYPE_NAME = <optimized out>})at /test/13.1_dbg/storage/duckdb/runtime/fiber_scan.cc:72

#17 0x000069d51b6ad04c in myduck::select_to_duckdb::send_data (this=0x69d070091030, items=@0x69d070091778: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x69d070091240, last = 0x69d0700913a0, elements = 2}, <No data fields>})at /test/13.1_dbg/storage/duckdb/runtime/fiber_scan.cc:111

#18 0x00005b96501a45df in select_result_sink::send_data_with_check (this=0x69d070091030, items=@0x69d070091778: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x69d070091240, last = 0x69d0700913a0, elements = 2}, <No data fields>}, u=0x69d07008b858, sent=0) at /test/13.1_dbg/sql/sql_class.cc:3331

#19 0x00005b96502bdc6f in end_send (join=0x69d070097280, join_tab=0x69d070098dd8, end_of_records=false)at /test/13.1_dbg/sql/sql_select.cc:26149

#20 0x00005b96502e6d94 in evaluate_join_record (join=0x69d070097280, join_tab=0x69d070098960, error=0) at /test/13.1_dbg/sql/sql_select.cc:24983

#21 0x00005b965029fed4 in sub_select (join=0x69d070097280, join_tab=0x69d070098960, end_of_records=false)at /test/13.1_dbg/sql/sql_select.cc:24750

#22 0x00005b96502c3e2e in do_select (join=0x69d070097280, procedure=0x0)at /test/13.1_dbg/sql/sql_select.cc:24261

#23 0x00005b96502c3316 in JOIN::exec_inner (this=0x69d070097280)at /test/13.1_dbg/sql/sql_select.cc:5126

#24 0x00005b96502c2633 in JOIN::exec (this=0x69d070097280)at /test/13.1_dbg/sql/sql_select.cc:4914

#25 0x00005b96502a06db in mysql_select (thd=0x69d0700872c0, tables=0x69d070091e10, fields=@0x69d070091778: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x69d070091240, last = 0x69d0700913a0, elements = 2}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2164525824, result=0x69d070091030, unit=0x69d07008b858, select_lex=0x69d0700914c0) at /test/13.1_dbg/sql/sql_select.cc:5440

#26 0x00005b96502a023d in handle_select (thd=0x69d0700872c0, lex=0x69d07008b778, result=0x69d070091030, setup_tables_done_option=0)at /test/13.1_dbg/sql/sql_select.cc:637

#27 0x00005b9650246056 in execute_sqlcom_select (thd=0x69d0700872c0, all_tables=0x69d070091e10) at /test/13.1_dbg/sql/sql_parse.cc:6229

#28 0x00005b965023c2bb in mysql_execute_command (thd=0x69d0700872c0, is_called_from_prepared_stmt=false) at /test/13.1_dbg/sql/sql_parse.cc:3997

#29 0x000069d51b6ad8e3 in myduck::fiber_scan_func (arg=0x69d0700047f0)at /test/13.1_dbg/storage/duckdb/runtime/fiber_scan.cc:353

#30 0x000069d51b6ac70b in fiber_context_spawn (c=0x69d0700047f0, f=0x69d51b6ad580 <myduck::fiber_scan_func(void*)>, d=0x69d0700047f0)at /test/13.1_dbg/storage/duckdb/runtime/fiber_context.cpp:156

    Rel    o/d  Build   Commit                                    UniqueID observed             

CS  10.11  dbg  180826  8f00e6caca633c783140db86d3a48a96de67cf38  No bug found                  

CS  10.11  opt  180826  8f00e6caca633c783140db86d3a48a96de67cf38  No bug found                  

CS  11.4   dbg  180826  1a052f27e374fc9b4cb5b1fd098cf10f0e1381cc  SIGABRT|__cxa_throw|duckdb::HandleCastError::AssignError|duckdb::HandleCastError::AssignError|duckdb::Blob::TryGetBlobSize

CS  11.4   opt  180826  1a052f27e374fc9b4cb5b1fd098cf10f0e1381cc  SIGABRT|__cxa_throw|duckdb::HandleCastError::AssignError|duckdb::Blob::TryGetBlobSize|duckdb::Blob::GetBlobSize

CS  11.8   dbg  180826  d26f9ab217a7fcf9d4eccc62c01020ff275ff42e  SIGABRT|__cxa_throw|duckdb::HandleCastError::AssignError|duckdb::HandleCastError::AssignError|duckdb::Blob::TryGetBlobSize

CS  11.8   opt  180826  d26f9ab217a7fcf9d4eccc62c01020ff275ff42e  SIGABRT|__cxa_throw|duckdb::HandleCastError::AssignError|duckdb::Blob::TryGetBlobSize|duckdb::Blob::GetBlobSize

CS  12.3   dbg  180826  add63991988734383c5e942de2a19c6c45f511f7  SIGABRT|__cxa_throw|duckdb::HandleCastError::AssignError|duckdb::HandleCastError::AssignError|duckdb::Blob::TryGetBlobSize

CS  12.3   opt  180826  add63991988734383c5e942de2a19c6c45f511f7  SIGABRT|__cxa_throw|duckdb::HandleCastError::AssignError|duckdb::Blob::TryGetBlobSize|duckdb::Blob::GetBlobSize

CS  13.0   dbg  180826  a848493c6fe031f23606144420c1ca1e467cbd81  SIGABRT|__cxa_throw|duckdb::HandleCastError::AssignError|duckdb::HandleCastError::AssignError|duckdb::Blob::TryGetBlobSize

CS  13.0   opt  180826  a848493c6fe031f23606144420c1ca1e467cbd81  SIGABRT|__cxa_throw|duckdb::HandleCastError::AssignError|duckdb::Blob::TryGetBlobSize|duckdb::Blob::GetBlobSize

CS  13.1   dbg  180826  da18481158c81ca94689702073c3e04aad85a6a3  SIGABRT|__cxa_throw|duckdb::HandleCastError::AssignError|duckdb::HandleCastError::AssignError|duckdb::Blob::TryGetBlobSize

CS  13.1   opt  180826  da18481158c81ca94689702073c3e04aad85a6a3  SIGABRT|__cxa_throw|duckdb::HandleCastError::AssignError|duckdb::Blob::TryGetBlobSize|duckdb::Blob::GetBlobSize

ES  10.6   dbg  180826  fcecb2620f25965723d640decede7c018bcb1dcc  No bug found                  

ES  10.6   opt  180826  fcecb2620f25965723d640decede7c018bcb1dcc  No bug found                  

ES  11.4   dbg  180826  3b34189bfe675c18c4ced3ef531d016ea74c76f4  No bug found                  

ES  11.4   opt  180826  3b34189bfe675c18c4ced3ef531d016ea74c76f4  No bug found                  

ES  11.8   dbg  180826  4694e931d10fecf733c34f83ea2146d31b708eb3  No bug found                  

ES  11.8   opt  180826  4694e931d10fecf733c34f83ea2146d31b708eb3  No bug found                  

ES  12.3   dbg  180826  f513f503feacabfb219d4a6f965b5f72b86d4db0  No bug found                  

ES  12.3   opt  180826  f513f503feacabfb219d4a6f965b5f72b86d4db0  No bug found