Logical error: 'Filling column rank() OVER () is not present in the block 1_UInt8' #84427
Description
Describe the bug
The logical error has been happening since v25.3. Before that, it was a NOT_FOUND_COLUMN_IN_BLOCK. Only triggers with new analyzer enabled.
How to reproduce
Run Fiddle: https://fiddle.clickhouse.com/7f032105-697d-4d39-8ac5-38725e1c5fa2
Error message and/or stacktrace
Stack trace:
<Fatal> : Logical error: 'Filling column rank() OVER () is not present in the block 1_UInt8'.
<Fatal> : Stack trace (when copying this message, always include the lines below):
0. contrib/llvm-project/libcxx/include/__exception/exception.h:113: Poco::Exception::Exception(String const&, int) @ 0x000000002663c8f2
1. src/Common/Exception.cpp:115: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x00000000140c1fe6
2. src/Common/Exception.h:119: DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000cdb55ac
3. src/Common/Exception.h:137: DB::Exception::Exception<String const&, String>(int, FormatStringHelperImpl<std::type_identity<String const&>::type, std::type_identity<String>::type>, String const&, String&&) @ 0x000000000dbefc36
4. src/Planner/Planner.cpp:807: DB::Planner::buildPlanForQueryNode() @ 0x000000001a69d120
5. src/Planner/Planner.cpp:1387: DB::Planner::buildQueryPlanIfNeeded() @ 0x000000001a693e13
6. src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:269: DB::InterpreterSelectQueryAnalyzer::getQueryPlan() @ 0x000000001afcc5cd
7. src/Interpreters/executeQuery.cpp:1508: DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::ImplicitTransactionControlExecutor>) @ 0x000000001b2c2bb9
8. src/Interpreters/executeQuery.cpp:1769: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000001b2bd1bb
9. src/Server/TCPHandler.cpp:723: DB::TCPHandler::runImpl() @ 0x000000001e5420d2
10. src/Server/TCPHandler.cpp:2727: DB::TCPHandler::run() @ 0x000000001e55b864
11. base/poco/Net/src/TCPServerConnection.cpp:40: Poco::Net::TCPServerConnection::start() @ 0x00000000266f29c7
12. base/poco/Net/src/TCPServerDispatcher.cpp:115: Poco::Net::TCPServerDispatcher::run() @ 0x00000000266f2fa5
13. base/poco/Foundation/src/ThreadPool.cpp:205: Poco::PooledThread::run() @ 0x000000002669293f
14. base/poco/Foundation/src/Thread_POSIX.cpp:341: Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000026690011
15. start_thread @ 0x00000000000a27f1
16. __GI___clone3 @ 0x0000000000133c9c