Skip to content

Inconsistent AST formatting of INSERT SELECT EXCEPT/INTERSECT #90925

@maxknv

Description

@maxknv

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
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Metadata

Metadata

Labels

fuzzProblem found by one of the fuzzerstestingSpecial issue with list of bugs found by CI

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions