Logical error: 'col.name == prewhere_info->prewhere_column_name' (STID: 2508-4688) #90265
Description
Describe the bug
How to reproduce
Run:
INSERT INTO FUNCTION file('f.parquet') SELECT 1 x SETTINGS engine_file_truncate_on_insert = 1;
SELECT 1 FROM file('f.parquet') WHERE x > 1 AND 3 % x ORDER BY x > 1, _row_number;Error message and/or stacktrace
Stack trace:
<Fatal> : Logical error: 'col.name == prewhere_info->prewhere_column_name'.
<Fatal> : Stack trace (when copying this message, always include the lines below):
0. src/Common/StackTrace.cpp:395: StackTrace::StackTrace() @ 0x000000001521fa24
1. src/Common/Exception.cpp:57: DB::abortOnFailedAssertion(String const&) @ 0x0000000015180295
2. src/Storages/prepareReadingFromFormat.cpp:285: DB::updateFormatPrewhereInfo(DB::ReadFromFormatInfo const&, std::shared_ptr<DB::FilterDAGInfo> const&, std::shared_ptr<DB::PrewhereInfo> const&) @ 0x000000001e08cbac
3. src/Storages/StorageFile.cpp:1784: DB::ReadFromFile::updatePrewhereInfo(std::shared_ptr<DB::PrewhereInfo> const&) @ 0x000000001dd18573
4. src/Processors/QueryPlan/Optimizations/optimizePrewhere.cpp:202: DB::QueryPlanOptimizations::optimizePrewhere(DB::QueryPlan::Node&) @ 0x000000001f2cecf3
5. src/Processors/QueryPlan/Optimizations/optimizeTree.cpp:203: DB::QueryPlanOptimizations::optimizeTreeSecondPass(DB::QueryPlanOptimizationSettings const&, DB::QueryPlan::Node&, std::list<DB::QueryPlan::Node, std::allocator<DB::QueryPlan::Node>>&, DB::QueryPlan&) @ 0x000000001f2c623c
6. src/Processors/QueryPlan/QueryPlan.cpp:569: DB::QueryPlan::optimize(DB::QueryPlanOptimizationSettings const&) @ 0x000000001f1e511f
7. src/Processors/QueryPlan/QueryPlan.cpp:180: DB::QueryPlan::buildQueryPipeline(DB::QueryPlanOptimizationSettings const&, DB::BuildQueryPipelineSettings const&, bool) @ 0x000000001f1e4a40
8. src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:289: DB::InterpreterSelectQueryAnalyzer::buildQueryPipeline() @ 0x000000001b1fb6e5
9. src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:256: DB::InterpreterSelectQueryAnalyzer::execute() @ 0x000000001b1fb3dc
10. src/Interpreters/executeQuery.cpp:1672: 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>>&, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::ImplicitTransactionControlExecutor>, std::function<void ()>, DB::QueryResultDetails&) @ 0x000000001b53c4ed
11. src/Interpreters/executeQuery.cpp:1894: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000001b5371d2
12. src/Server/TCPHandler.cpp:765: DB::TCPHandler::runImpl() @ 0x000000001eb9202a
13. src/Server/TCPHandler.cpp:2861: DB::TCPHandler::run() @ 0x000000001ebacca4
14. base/poco/Net/src/TCPServerConnection.cpp:40: Poco::Net::TCPServerConnection::start() @ 0x0000000024fd27c7
15. base/poco/Net/src/TCPServerDispatcher.cpp:115: Poco::Net::TCPServerDispatcher::run() @ 0x0000000024fd2da5
16. base/poco/Foundation/src/ThreadPool.cpp:205: Poco::PooledThread::run() @ 0x0000000024f7047f
17. base/poco/Foundation/src/Thread_POSIX.cpp:341: Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000024f6dc11
18. ? @ 0x00000000000a3d64
19. __GI___clone3 @ 0x00000000001373bc