Skip to content

Logical error: 'Inconsistent AST formatting in Function_ilike: the query: (STID: 1941-1bfa) #91789

@maxknv

Description

@maxknv

Important: This issue was automatically created and is used by CI. Do not modify the issue title. Do not remove issue labels.

CI report: BuzzHouse (amd_debug)
CIDB statistics: cidb

Test output:

Error:
Logical error: 'Inconsistent AST formatting in Function_ilike: the query:
SELECT mapConcat((('1970-01-01 00:00:00'::DateTime) AS `a1`)), indexOf(randomPrintableASCII(375), ('1900-01-01 00:00:00')) FROM (SELECT `c0` FROM (SELECT DISTINCT (SELECT `t0d2`.`number` FROM numbers_...
Formatted as:
SELECT mapConcat(CAST('1970-01-01 00:00:00', 'DateTime') AS a1), indexOf(randomPrintableASCII(375), '1900-01-01 00:00:00') FROM (SELECT c0 FROM (SELECT DISTINCT (SELECT t0d2.number FROM numbers_mt(417...
Was parsed and formatted back as:
SELECT mapConcat(CAST('1970-01-01 00:00:00', 'DateTime') AS a1), indexOf(randomPrintableASCII(375), '1900-01-01 00:00:00') FROM (SELECT c0 FROM (SELECT DISTINCT (SELECT t0d2.number FROM numbers_mt(417...
---

Failed query:
SELECT mapConcat(CAST('1970-01-01 00:00:00', 'DateTime') AS a1), indexOf(randomPrintableASCII(375), '1900-01-01 00:00:00') FROM (SELECT c0 FROM (SELECT DISTINCT (SELECT t0d2.number FROM numbers_mt(417...
---

Stack trace:
pthread_kill@@GLIBC_2.34 @ 0x00000000000969fd
raise @ 0x0000000000042476
__lgamma_r_finite@GLIBC_2.15 @ 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) @ 0x00000000155c799a
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&) @ 0x00000000155c87b...
src/Common/Exception.cpp:138: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000155c8ae5
src/Common/Exception.h:123: DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000d3010ce
src/Common/Exception.h:58: DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000d300c11
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:1967: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000001ba27052
src/Server/TCPHandler.cpp:777: DB::TCPHandler::runImpl() @ 0x000000001ef185aa
src/Server/TCPHandler.cpp:2873: DB::TCPHandler::run() @ 0x000000001ef33224
base/poco/Net/src/TCPServerConnection.cpp:40: Poco::Net::TCPServerConnection::start() @ 0x00000000251e7d87
base/poco/Net/src/TCPServerDispatcher.cpp:115: Poco::Net::TCPServerDispatcher::run() @ 0x00000000251e8365
base/poco/Foundation/src/ThreadPool.cpp:205: Poco::PooledThread::run() @ 0x0000000025185a3f
base/poco/Foundation/src/Thread_POSIX.cpp:341: Poco::ThreadImpl::runnableEntry(void*) @ 0x00000000251831d1
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