[Bug]: Using subqueries will cause the database to exit. #3137
Description
Is there an existing issue for the same bug?
- I have checked the existing issues.
Version or Commit ID
0.6.10
Other environment information
Actual behavior and How to reproduce it
sql:
create table tb(col int);
select col from tb where col > (select avg(col) from tb);
result:
[16:20:47.475] [2805813] [critical] Error: Segmentation fault
[16:20:47.480] [2805813] [critical] 0# infinity::PrintStacktrace@infinity_core(std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&) at /home/weilongma/zpf/infinity/src/common/utility/exception_impl.cpp:47
1# (anonymous namespace)::SignalHandler(int, siginfo_t*, void*) at /home/weilongma/zpf/infinity/src/bin/infinity_main.cpp:160
2# at ./signal/../sysdeps/unix/sysv/linux/x86_64/libc_sigaction.c:0
3# __strlen_avx2 at ../sysdeps/x86_64/multiarch/strlen-avx2.S:76
4# ___interceptor_strlen at compiler-rt/lib/asan/../sanitizer_common/sanitizer_common_interceptors.inc:0
5# std::char_traits::length(char const*) at /usr/lib/gcc/x86_64-linux-gnu/15/../../../../include/c++/15/bits/char_traits.h:393
6# std::__cxx11::basic_string<char, std::char_traits, std::allocator >::assign(char const*) at /usr/lib/gcc/x86_64-linux-gnu/15/../../../../include/c++/15/bits/basic_string.h:1848
7# std::__cxx11::basic_string<char, std::char_traits, std::allocator >::operator=(char const*) at /usr/lib/gcc/x86_64-linux-gnu/15/../../../../include/c++/15/bits/basic_string.h:916
8# infinity::Connection@infinity_core::HandlerSimpleQuery(infinity::QueryContext@infinity_core*) at /home/weilongma/zpf/infinity/src/network/connection_impl.cpp:163
9# infinity::Connection@infinity_core::HandleRequest() at /home/weilongma/zpf/infinity/src/network/connection_impl.cpp:136
10# infinity::Connection@infinity_core::Run() at /home/weilongma/zpf/infinity/src/network/connection_impl.cpp:82
11# infinity::PGServer@infinity_core::StartConnection(std::shared_ptrinfinity::Connection@infinity_core&)::$_0::operator()() at /home/weilongma/zpf/infinity/src/network/pg_server_impl.cpp:94
12# void std::__invoke_impl<void, infinity::PGServer@infinity_core::StartConnection(std::shared_ptrinfinity::Connection@infinity_core&)::$_0>(std::__invoke_other, infinity::PGServer@infinity_core::StartConnection(std::shared_ptrinfinity::Connection@infinity_core&)::$_0&&) at /usr/lib/gcc/x86_64-linux-gnu/15/../../../../include/c++/15/bits/invoke.h:63
13# std::__invoke_result<infinity::PGServer@infinity_core::StartConnection(std::shared_ptrinfinity::Connection@infinity_core&)::$_0>::type std::__invoke<infinity::PGServer@infinity_core::StartConnection(std::shared_ptrinfinity::Connection@infinity_core&)::$_0>(infinity::PGServer@infinity_core::StartConnection(std::shared_ptrinfinity::Connection@infinity_core&)::$_0&&) at /usr/lib/gcc/x86_64-linux-gnu/15/../../../../include/c++/15/bits/invoke.h:98
14# void std::thread::_Invoker<std::tuple<infinity::PGServer@infinity_core::StartConnection(std::shared_ptrinfinity::Connection@infinity_core&)::$_0> >::_M_invoke<0ul>(std::_Index_tuple<0ul>) at /usr/lib/gcc/x86_64-linux-gnu/15/../../../../include/c++/15/bits/std_thread.h:303
15# std::thread::_Invoker<std::tuple<infinity::PGServer@infinity_core::StartConnection(std::shared_ptrinfinity::Connection@infinity_core&)::$_0> >::operator()() at /usr/lib/gcc/x86_64-linux-gnu/15/../../../../include/c++/15/bits/std_thread.h:310
16# std::thread::_State_impl<std::thread::_Invoker<std::tuple<infinity::PGServer@infinity_core::StartConnection(std::shared_ptrinfinity::Connection@infinity_core&)::$_0> > >::_M_run() at /usr/lib/gcc/x86_64-linux-gnu/15/../../../../include/c++/15/bits/std_thread.h:255
17# execute_native_thread_routine at :0
18# asan_thread_start at build-llvm/tools/clang/stage2-bins/runtimes/runtimes-bins/compiler-rt/lib/asan/asan_interceptors.cpp:239
19# start_thread at ./nptl/pthread_create.c:447
20# clone3 at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
21#
Expected behavior
No response
Additional information
No response