-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Inconsistent AST formatting of INSERT SELECT EXCEPT/INTERSECT #90925
Copy link
Copy link
Closed
Labels
fuzzProblem found by one of the fuzzersProblem found by one of the fuzzerstestingSpecial issue with list of bugs found by CISpecial issue with list of bugs found by CI
Description
CI report: BuzzHouse (amd_debug)
CIDB statistics: cidb
Test output:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
FAIL [Logical error: 'Inconsistent AST formatting: the query:]
| Error:
| Logical error: 'Inconsistent AST formatting: the query:
| INSERT INTO t13 (c1, c2, c4, c3, c0) (SELECT t1d1.c2 + 'look' AS a0, a0 AS a1, exp10(a1)[2] AS a2, randomPrintableASCII(64), t1d1.c4 AS a4 FROM t9 AS t0d1 PASTE JOIN t9 AS t1d1 QUALIFY CAST('126228532...
| w0 AS (),
| w1 AS ()) INTERSECT ALL (SELECT map(-inf, CAST('14461152579428909443', 'Int16')) AS a7, a7, tuple(), CAST('10442924752350650183', 'Int64') AS a8, a8)
| cannot parse query back from INSERT INTO TABLE `t13` (`c1`, `c2`, `c4`, `c3`, `c0`) SELECT ALL `t1d1`.`c2` + 'look' AS `a0`, `a0` AS `a1`, exp10(`a1`)[2] AS `a2`, randomPrintableASCII(64), (`t1d1`.`c4...
| ---
|
| Failed query:
| INSERT INTO t13 (c1, c2, c4, c3, c0) (SELECT t1d1.c2 + 'look' AS a0, a0 AS a1, exp10(a1)[2] AS a2, randomPrintableASCII(64), t1d1.c4 AS a4 FROM t9 AS t0d1 PASTE JOIN t9 AS t1d1 QUALIFY CAST('126228532...
| ---
|
| Stack trace:
| pthread_kill @ 0x00000000000969fd
| raise @ 0x0000000000042476
| __lgamma_r_finite@GLIBC_2.15 @ 0x00000000000287f3
| src/Common/Exception.cpp:52: DB::abortOnFailedAssertion(String const&, void* const*, unsigned long, unsigned long) @ 0x0000000015c4da3a
| src/Common/Exception.cpp:85: DB::handle_error_code(String const&, std::basic_string_view<char, std::char_traits<char>>, int, bool, std::vector<void*, std::allocator<void*>> const&) @ 0x0000000015c4e47...
| src/Common/Exception.cpp:136: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x0000000015c4e7a5
| src/Common/Exception.h:123: DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000d9894ce
| src/Common/Exception.h:58: DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000d989011
| src/Common/Exception.h:141: DB::Exception::Exception<String&, std::basic_string_view<char, std::char_traits<char>>&>(int, FormatStringHelperImpl<std::type_identity<String&>::type, std::type_identity<s...
| src/Interpreters/executeQuery.cpp:1221: DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum, std::unique_ptr<DB::ReadBuffer, std...
| src/Interpreters/executeQuery.cpp:1921: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000001c060052
| src/Server/TCPHandler.cpp:765: DB::TCPHandler::runImpl() @ 0x000000001f56c2ea
| src/Server/TCPHandler.cpp:2861: DB::TCPHandler::run() @ 0x000000001f586f64
| base/poco/Net/src/TCPServerConnection.cpp:40: Poco::Net::TCPServerConnection::start() @ 0x00000000259d7fc7
| base/poco/Net/src/TCPServerDispatcher.cpp:115: Poco::Net::TCPServerDispatcher::run() @ 0x00000000259d85a5
| base/poco/Foundation/src/ThreadPool.cpp:205: Poco::PooledThread::run() @ 0x0000000025975c7f
| base/poco/Foundation/src/Thread_POSIX.cpp:341: Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000025973411
| start_thread @ 0x0000000000094ac3
| __GI___clone3 @ 0x00000000001268c0
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
fuzzProblem found by one of the fuzzersProblem found by one of the fuzzerstestingSpecial issue with list of bugs found by CISpecial issue with list of bugs found by CI