DuckDB crashes with the UNNEST function. #11445
Description
What happens?
DuckDB crashes with the UNNEST function.
To Reproduce
PoC:
SELECT UNNEST ( ( '1,2,3,4,,6' , ( 1 ) ) ) , x x;
Backtrace:
#0 0x70c3f2 (_ZN10duckdb_fmt2v620basic_printf_contextISt20back_insert_iteratorINS0_8internal6bufferIcEEEcE12parse_headerERPKcS9_RNS0_18basic_format_specsIcEE+0x2)
#1 0x70bc6f (_ZN10duckdb_fmt2v620basic_printf_contextISt20back_insert_iteratorINS0_8internal6bufferIcEEEcE6formatINS0_20printf_arg_formatterINS0_12buffer_rangeIcEEEEEES6_v+0x1af)
#2 0x6fcf57 (_ZN10duckdb_fmt2v68vsprintfINSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEEcEENS3_IT0_S4_IS8_ESaIS8_EEERKT_NS0_17basic_format_argsINS0_20basic_printf_contextISt20back_insert_iteratorINS0_8internal6bufferIS8_EEES8_EEEE+0x67)
#3 0x69368c (_ZN6duckdb20ExceptionFormatValue6FormatERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEERSt6vectorIS0_SaIS0_EE+0x3bc)
#4 0x6932c9 (_ZN6duckdb9Exception25ConstructMessageRecursiveERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEERSt6vectorINS_20ExceptionFormatValueESaISA_EE+0x9)
#5 0x47d638 (_ZN6duckdb9Exception25ConstructMessageRecursiveINSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEEJEEES7_RKS7_RSt6vectorINS_20ExceptionFormatValueESaISB_EET_DpT0_+0x148)
#6 0x493bb0 (_ZN6duckdb9Exception25ConstructMessageRecursiveINSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEEJS7_EEES7_RKS7_RSt6vectorINS_20ExceptionFormatValueESaISB_EET_DpT0_+0x1d0)
#7 0x49388d (_ZN6duckdb9Exception16ConstructMessageIJNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEES7_EEES7_RKS7_DpT_+0x12d)
#8 0x490a0d (_ZN6duckdb10StringUtil6FormatIJNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEES7_EEES7_S7_DpT_+0x10d)
#9 0x4c7145 (_ZN6duckdb15BinderException14ColumnNotFoundERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEERKNS_6vectorIS6_Lb1EEENS_17QueryErrorContextE+0x445)
#10 0xbe3c61 (_ZN6duckdb16ExpressionBinder17QualifyColumnNameERKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEERNS_9ErrorDataE+0x3d1)
#11 0xbe4658 (_ZN6duckdb16ExpressionBinder17QualifyColumnNameERNS_19ColumnRefExpressionERNS_9ErrorDataE+0xa8)
#12 0xbe62f6 (_ZN6duckdb16ExpressionBinder14BindExpressionERNS_19ColumnRefExpressionEm+0xd6)
#13 0xc8183f (_ZN6duckdb16ExpressionBinder14BindExpressionERNS_10unique_ptrINS_16ParsedExpressionESt14default_deleteIS2_ELb1EEEmb+0x26f)
#14 0xc62f47 (_ZN6duckdb16BaseSelectBinder13BindColumnRefERNS_10unique_ptrINS_16ParsedExpressionESt14default_deleteIS2_ELb1EEEm+0x27)
#15 0xc62923 (_ZN6duckdb16BaseSelectBinder14BindExpressionERNS_10unique_ptrINS_16ParsedExpressionESt14default_deleteIS2_ELb1EEEmb+0x83)
#16 0xc63157 (_ZN6duckdb16BaseSelectBinder13BindColumnRefERNS_10unique_ptrINS_16ParsedExpressionESt14default_deleteIS2_ELb1EEEm+0x237)
#17 0xc62923 (_ZN6duckdb16BaseSelectBinder14BindExpressionERNS_10unique_ptrINS_16ParsedExpressionESt14default_deleteIS2_ELb1EEEmb+0x83)
#18 0xc63157 (_ZN6duckdb16BaseSelectBinder13BindColumnRefERNS_10unique_ptrINS_16ParsedExpressionESt14default_deleteIS2_ELb1EEEm+0x237)
#19 0xc62923 (_ZN6duckdb16BaseSelectBinder14BindExpressionERNS_10unique_ptrINS_16ParsedExpressionESt14default_deleteIS2_ELb1EEEmb+0x83)
...
#40252 0xc63157 (_ZN6duckdb16BaseSelectBinder13BindColumnRefERNS_10unique_ptrINS_16ParsedExpressionESt14default_deleteIS2_ELb1EEEm+0x237)
#40253 0xc62923 (_ZN6duckdb16BaseSelectBinder14BindExpressionERNS_10unique_ptrINS_16ParsedExpressionESt14default_deleteIS2_ELb1EEEmb+0x83)
OS:
Ubuntu 20.04
DuckDB Version:
v0.10.1
DuckDB Client:
binary (/usr/local/bin/duckdb)
Full Name:
Zongrui Peng
Affiliation:
Wingtecher Lab of Tsinghua University
Have you tried this on the latest nightly build?
I have tested with a nightly build
Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?
- Yes, I have