2026-03-19 17:20:07 Reason: return code:  158
2026-03-19 17:20:07 [882c784f8171] 2026.03.19 07:20:07.024598 [ 12215 ] {b9a92e56-e828-4f69-9901-8016cc675496} <Error> executeQuery: Code: 158. DB::Exception: Limit for rows (controlled by 'max_rows_to_read' setting) exceeded, max rows: 106.50 thousand, current rows: 107.69 thousand. (TOO_MANY_ROWS) (version 26.3.1.863) (from [::1]:33904) (comment: 04004_integral_col_comparison_with_float_key_condition.sql-test_zkwaz9pj) (query 4, line 7) (in query: SELECT count() FROM test_int64 WHERE uid < 100000.5 SETTINGS force_primary_key = 1, max_rows_to_read = 106496;), Stack trace (when copying this message, always include the lines below):
2026-03-19 17:20:07 
2026-03-19 17:20:07 0. /ClickHouse/contrib/llvm-project/libcxx/include/__exception/exception.h:113:14: Poco::Exception::Exception(String&&, int) @ 0x0000000027a33f33
2026-03-19 17:20:07 1. /ClickHouse/src/Common/Exception.cpp:139:7: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001657a4e9
2026-03-19 17:20:07 2. /ClickHouse/src/Common/Exception.h:171:100: DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000e5cb2d4
2026-03-19 17:20:07 3. /ClickHouse/src/Common/Exception.h:57:54: DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000e5cadd1
2026-03-19 17:20:07 4. /ClickHouse/src/Common/Exception.h:189:77: DB::Exception::Exception<char const*&, String, String>(int, FormatStringHelperImpl<std::type_identity<char const*&>::type, std::type_identity<String>::type, std::type_identity<String>::type>, char const*&, String&&, String&&) @ 0x000000001b7b2b49
2026-03-19 17:20:07 5. /ClickHouse/src/QueryPipeline/SizeLimits.cpp:32:19: DB::SizeLimits::check(unsigned long, unsigned long, char const*, int, int) const @ 0x000000001b7b245c
2026-03-19 17:20:07 6. /ClickHouse/src/Storages/MergeTree/MergeTreeDataSelectExecutor.cpp:1003:28: DB::MergeTreeDataSelectExecutor::filterPartsByPrimaryKeyAndSkipIndexes(DB::MergeTreeDataSelectExecutor::IndexAnalysisContext&, DB::RangesInDataParts, std::vector<DB::ReadFromMergeTree::IndexStat, std::allocator<DB::ReadFromMergeTree::IndexStat>>&)::$_0::operator()(unsigned long) const @ 0x000000001fdc66fc
2026-03-19 17:20:07 7. /ClickHouse/src/Storages/MergeTree/MergeTreeDataSelectExecutor.cpp:1014:17: DB::MergeTreeDataSelectExecutor::filterPartsByPrimaryKeyAndSkipIndexes(DB::MergeTreeDataSelectExecutor::IndexAnalysisContext&, DB::RangesInDataParts, std::vector<DB::ReadFromMergeTree::IndexStat, std::allocator<DB::ReadFromMergeTree::IndexStat>>&) @ 0x000000001fdc0f6b
2026-03-19 17:20:07 8. /ClickHouse/src/Processors/QueryPlan/ReadFromMergeTree.cpp:2502:40: DB::ReadFromMergeTree::selectRangesToRead(DB::RangesInDataParts const&, std::shared_ptr<DB::MergeTreeData::IMutationsSnapshot const>, std::optional<DB::VectorSearchParameters> const&, std::optional<DB::TopKFilterInfo> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, DB::SelectQueryInfo const&, std::shared_ptr<DB::Context const>, unsigned long, std::shared_ptr<std::unordered_map<String, long, std::hash<String>, std::equal_to<String>, std::allocator<std::pair<String const, long>>> const>, DB::MergeTreeData const&, std::shared_ptr<DB::MergeTreeSettings const> const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<Poco::Logger>, std::optional<DB::ReadFromMergeTree::Indexes>&, bool, bool, bool, bool) @ 0x0000000020b37329
2026-03-19 17:20:07 9. /ClickHouse/src/Processors/QueryPlan/ReadFromMergeTree.cpp:1886:27: DB::ReadFromMergeTree::selectRangesToRead(bool) const @ 0x0000000020b34cc4
2026-03-19 17:20:07 10. /ClickHouse/src/Processors/QueryPlan/Optimizations/optimizeUseAggregateProjection.cpp:584:53: DB::QueryPlanOptimizations::optimizeUseAggregateProjections(DB::QueryPlan::Node&, std::list<DB::QueryPlan::Node, std::allocator<DB::QueryPlan::Node>>&, bool, bool, unsigned long) @ 0x0000000020ca5ab1
2026-03-19 17:20:07 11. /ClickHouse/src/Processors/QueryPlan/Optimizations/optimizeTree.cpp:321:47: DB::QueryPlanOptimizations::optimizeTreeSecondPass(DB::QueryPlanOptimizationSettings const&, DB::QueryPlan::Node&, std::list<DB::QueryPlan::Node, std::allocator<DB::QueryPlan::Node>>&, DB::QueryPlan&) @ 0x0000000020c130a3
2026-03-19 17:20:07 12. /ClickHouse/src/Processors/QueryPlan/QueryPlan.cpp:651:5: DB::QueryPlan::optimize(DB::QueryPlanOptimizationSettings const&) @ 0x0000000020b042e2
2026-03-19 17:20:07 13. /ClickHouse/src/Processors/QueryPlan/QueryPlan.cpp:184:9: DB::QueryPlan::buildQueryPipeline(DB::QueryPlanOptimizationSettings const&, DB::BuildQueryPipelineSettings const&, bool) @ 0x0000000020b03b91
2026-03-19 17:20:07 14. /ClickHouse/src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:379:34: DB::InterpreterSelectQueryAnalyzer::buildQueryPipeline() @ 0x000000001c960f31
2026-03-19 17:20:07 15. /ClickHouse/src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:344:29: DB::InterpreterSelectQueryAnalyzer::execute() @ 0x000000001c960b1e
2026-03-19 17:20:07 16. /ClickHouse/src/Interpreters/executeQuery.cpp:1786:40: DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum, std::unique_ptr<DB::ReadBuffer, std::default_delete<DB::ReadBuffer>>&, boost::intrusive_ptr<DB::IAST>&, std::shared_ptr<DB::ImplicitTransactionControlExecutor>, std::function<void ()>, DB::QueryResultDetails&) @ 0x000000001ccd9e3b
2026-03-19 17:20:07 17. /ClickHouse/src/Interpreters/executeQuery.cpp:2123:11: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000001ccd4223
2026-03-19 17:20:07 18. /ClickHouse/src/Server/TCPHandler.cpp:821:68: DB::TCPHandler::runImpl() @ 0x000000002044a818
2026-03-19 17:20:07 19. /ClickHouse/src/Server/TCPHandler.cpp:2959:9: DB::TCPHandler::run() @ 0x0000000020465ea4
2026-03-19 17:20:07 20. /ClickHouse/base/poco/Net/src/TCPServerConnection.cpp:40:3: Poco::Net::TCPServerConnection::start() @ 0x0000000027aea40e
2026-03-19 17:20:07 21. /ClickHouse/base/poco/Net/src/TCPServerDispatcher.cpp:115:42: Poco::Net::TCPServerDispatcher::run() @ 0x0000000027aeaa52
2026-03-19 17:20:07 22. /ClickHouse/base/poco/Foundation/src/ThreadPool.cpp:205:14: Poco::PooledThread::run() @ 0x0000000027a8a73f
2026-03-19 17:20:07 23. /ClickHouse/base/poco/Foundation/src/Thread_POSIX.cpp:341:27: Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000027a87dcf
2026-03-19 17:20:07 24. start_thread @ 0x0000000000094ac3
2026-03-19 17:20:07 25. clone3 @ 0x00000000001268d0
2026-03-19 17:20:07 
2026-03-19 17:20:07 Received exception from server (version 26.3.1):
2026-03-19 17:20:07 Code: 158. DB::Exception: Received from localhost:9000. DB::Exception: Limit for rows (controlled by 'max_rows_to_read' setting) exceeded, max rows: 106.50 thousand, current rows: 107.69 thousand. (TOO_MANY_ROWS)
2026-03-19 17:20:07 (query: SELECT count() FROM test_int64 WHERE uid < 100000.5 SETTINGS force_primary_key = 1, max_rows_to_read = 106496;)
2026-03-19 17:20:07 , result:
2026-03-19 17:20:07 
2026-03-19 17:20:07 -- { echo }
2026-03-19 17:20:07 
2026-03-19 17:20:07 DROP TABLE IF EXISTS test_int64;
2026-03-19 17:20:07 CREATE TABLE test_int64 (uid Int64) ENGINE = MergeTree ORDER BY uid SETTINGS index_granularity = 8192;
2026-03-19 17:20:07 INSERT INTO test_int64 SELECT number FROM numbers(200000);
2026-03-19 17:20:07 SELECT count() FROM test_int64 WHERE uid < 100000.5 SETTINGS force_primary_key = 1, max_rows_to_read = 106496;
2026-03-19 17:20:07 
2026-03-19 17:20:07 stdout:
2026-03-19 17:20:07 -- { echo }
2026-03-19 17:20:07 
2026-03-19 17:20:07 DROP TABLE IF EXISTS test_int64;
2026-03-19 17:20:07 CREATE TABLE test_int64 (uid Int64) ENGINE = MergeTree ORDER BY uid SETTINGS index_granularity = 8192;
2026-03-19 17:20:07 INSERT INTO test_int64 SELECT number FROM numbers(200000);
2026-03-19 17:20:07 SELECT count() FROM test_int64 WHERE uid < 100000.5 SETTINGS force_primary_key = 1, max_rows_to_read = 106496;
2026-03-19 17:20:07 
~~~~~ truncated 6 lines ~~~~~