Skip to content

Logical error: 'Inconsistent AST formatting in Subquery: the query: #92386

@Avogar

Description

@Avogar

Important: This issue was automatically generated and is used by CI for matching failures. DO NOT modify the body content. DO NOT remove labels.

Test name: Logical error: 'Inconsistent AST formatting in Subquery: the query: (STID: 1941-1bfa)
CI report: BuzzHouse (amd_debug)
CIDB statistics: cidb

Test output:

Error:
Logical error: 'Inconsistent AST formatting in Subquery: the query:
INSERT INTO TABLE d0.`t42` (`c0.c1`) SELECT `c1` FROM generateRandom('c1 Array(DateTime)', 338545717747078723, 215, 4) LIMIT 70 PARALLEL WITH DESCRIBE (WITH '9ba1f7a9-8106-fef3-e54b-b51db5436a33'::UUI...
Formatted as:
INSERT INTO d0.t42 (`c0.c1`) SELECT c1 FROM generateRandom('c1 Array(DateTime)', 338545717747078723, 215, 4) LIMIT 70 PARALLEL WITH DESCRIBE TABLE (WITH CAST('9ba1f7a9-8106-fef3-e54b-b51db5436a33', 'U...
        w0 AS (),
        w1 AS (PARTITION BY CAST(addSeconds(now(), 73), 'DateTime64(4)') RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW),
        w2 AS (ROWS BETWEEN UNBOUNDED PRECEDING AND concatAssumeInjective(toIntervalMinute(lag(CAST('50', 'Int128') GLOBAL NOT IN (SELECT CAST('{"😉😉":[]}', 'JSON') FROM `null`('c0 Nullable(DateTime), ...
Was parsed and formatted back as:
INSERT INTO d0.t42 (`c0.c1`) SELECT c1 FROM generateRandom('c1 Array(DateTime)', 338545717747078723, 215, 4) LIMIT 70 PARALLEL WITH DESCRIBE TABLE (WITH CAST('9ba1f7a9-8106-fef3-e54b-b51db5436a33', 'U...
        w0 AS (),
---

Failed query:
DESCRIBE TABLE (WITH CAST('9ba1f7a9-8106-fef3-e54b-b51db5436a33', 'UUID')[CAST('10', 'Int16')] AS a0 SELECT DISTINCT [-[1], hiveHash(CAST('-31', 'Int') OR '漂亮'), f10(percent_rank() OVER (w3), CAST('20...
---

Stack trace:
pthread_kill@@GLIBC_2.34 @ 0x00000000000969fd
raise @ 0x0000000000042476
__ieee754_lgamma_r @ 0x00000000000287f3
src/Common/Exception.cpp:54: DB::abortOnFailedAssertion(String const&, std::basic_string_view<char, std::char_traits<char>>, void* const*, unsigned long, unsigned long) @ 0x0000000015ca55fc
src/Common/Exception.cpp:87: DB::handle_error_code(String const&, std::basic_string_view<char, std::char_traits<char>>, int, bool, std::vector<void*, std::allocator<void*>> const&) @ 0x0000000015ca6a4...
src/Common/Exception.cpp:138: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x0000000015ca6d65
src/Common/Exception.h:123: DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000d63a214
src/Common/Exception.h:58: DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000d639d93
src/Common/Exception.h:141: DB::Exception::Exception<String, std::basic_string_view<char, std::char_traits<char>>&, String&, String&>(int, FormatStringHelperImpl<std::type_identity<String>::type, std:...
src/Interpreters/executeQuery.cpp:1284: 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:1959: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000001c2aab54
src/Server/TCPHandler.cpp:776: DB::TCPHandler::runImpl() @ 0x000000001fabec49
src/Server/TCPHandler.cpp:2866: DB::TCPHandler::run() @ 0x000000001fad9d24
base/poco/Net/src/TCPServerConnection.cpp:40: Poco::Net::TCPServerConnection::start() @ 0x0000000025fb194e
base/poco/Net/src/TCPServerDispatcher.cpp:115: Poco::Net::TCPServerDispatcher::run() @ 0x0000000025fb1fbb
base/poco/Foundation/src/ThreadPool.cpp:205: Poco::PooledThread::run() @ 0x0000000025f524bf
base/poco/Foundation/src/Thread_POSIX.cpp:341: Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000025f4fb4f
start_thread @ 0x0000000000094ac3
clone3 @ 0x00000000001268c0

Metadata

Metadata

Assignees

No one assigned

    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