Invalid Field get from type Int64 to type Int128 in filterPushDown/cloneActionsForFilterPushDown #47865
Description
dell9510 :) set joined_subquery_requires_alias=0
SET joined_subquery_requires_alias = 0
Query id: f07ad367-a11e-447b-8ee9-ff8821b42941
Ok.
0 rows in set. Elapsed: 0.050 sec.
dell9510 :) SELECT '104857.7', k FROM (SELECT toInt128(NULL) AS k FROM system.one GROUP BY toUInt256([toInt256(1048575, toInt128(-9223372036854775807), NULL)], NULL)) INNER JOIN (SELECT toInt128(-2) AS k) AS t USING (k) WHERE k
SELECT
'104857.7',
k
FROM
(
SELECT toInt128(NULL) AS k
FROM system.one
GROUP BY toUInt256([toInt256(1048575, toInt128(-9223372036854775807), NULL)], NULL)
)
INNER JOIN
(
SELECT toInt128(-2) AS k
) AS t USING (k)
WHERE k
Query id: c77b40bf-ff16-47a3-a678-ae4f19bccc09
[dell9510] 2023.03.21 20:34:50.677398 [ 192935 ] {c77b40bf-ff16-47a3-a678-ae4f19bccc09} <Fatal> : Logical error: 'Invalid Field get from type Int64 to type Int128'.
[dell9510] 2023.03.21 20:34:50.858032 [ 217792 ] <Fatal> BaseDaemon: ########################################
[dell9510] 2023.03.21 20:34:50.899801 [ 217792 ] <Fatal> BaseDaemon: (version 23.3.1.2537, build id: 3018790D95A6AA08FB81899667D886CA8AA05445) (from thread 192935) (query_id: c77b40bf-ff16-47a3-a678-ae4f19bccc09) (query: SELECT '104857.7', k FROM (SELECT toInt128(NULL) AS k FROM system.one GROUP BY toUInt256([toInt256(1048575, toInt128(-9223372036854775807), NULL)], NULL)) INNER JOIN (SELECT toInt128(-2) AS k) AS t USING (k) WHERE k) Received signal Aborted (6)
[dell9510] 2023.03.21 20:34:50.954840 [ 217792 ] <Fatal> BaseDaemon:
[dell9510] 2023.03.21 20:34:51.119385 [ 217792 ] <Fatal> BaseDaemon: Stack trace: 0x7f8b9164f8ec 0x7f8b91600ea8 0x7f8b915ea53d 0x22f756c3 0x22f75735 0x22f75b6c 0x19934d57 0x1999588f 0x1a1245d8 0x1a1941dd 0x2cad4b32 0x2ca0892a 0x2ac94de1 0x2afc7b28 0x2e631aad 0x2e63100f 0x2e62fd5f 0x2e5f925b 0x2e542ae8 0x2e5425b3 0x2c223d2b 0x2c759fb7 0x2c755d3b 0x2dd4a44d 0x2dd5d2f2 0x331eee39 0x331ef688 0x33471461 0x3346dd7a 0x3346c915 0x7f8b9164dbb5 0x7f8b916cfd90
[dell9510] 2023.03.21 20:34:51.125702 [ 217792 ] <Fatal> BaseDaemon: 4. ? @ 0x7f8b9164f8ec in ?
[dell9510] 2023.03.21 20:34:51.126362 [ 217792 ] <Fatal> BaseDaemon: 5. raise @ 0x7f8b91600ea8 in ?
[dell9510] 2023.03.21 20:34:51.127734 [ 217792 ] <Fatal> BaseDaemon: 6. abort @ 0x7f8b915ea53d in ?
[dell9510] 2023.03.21 20:34:51.897116 [ 217792 ] <Fatal> BaseDaemon: 7. /home/tavplubix/ch/ClickHouse/src/Common/Exception.cpp:41: DB::abortOnFailedAssertion(String const&) @ 0x22f756c3 in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:34:52.497601 [ 217792 ] <Fatal> BaseDaemon: 8. /home/tavplubix/ch/ClickHouse/src/Common/Exception.cpp:64: DB::handle_error_code(String const&, int, bool, std::vector<void*, std::allocator<void*>> const&) @ 0x22f75735 in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:34:53.452007 [ 217792 ] <Fatal> BaseDaemon: 9. /home/tavplubix/ch/ClickHouse/src/Common/Exception.cpp:92: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x22f75b6c in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:34:54.308080 [ 217792 ] <Fatal> BaseDaemon: 10. /home/tavplubix/ch/ClickHouse/src/Common/Exception.h:55: DB::Exception::Exception(String&&, int, bool) @ 0x19934d57 in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:34:58.766484 [ 217792 ] <Fatal> BaseDaemon: 11. /home/tavplubix/ch/ClickHouse/src/Common/Exception.h:82: DB::Exception::Exception<DB::Field::Types::Which&, DB::Field::Types::Which const&>(int, FormatStringHelperImpl<std::type_identity<DB::Field::Types::Which&>::type, std::type_identity<DB::Field::Types::Which const&>::type>, DB::Field::Types::Which&, DB::Field::Types::Which const&) @ 0x1999588f in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:34:59.092397 [ 217792 ] <Fatal> BaseDaemon: 12. /home/tavplubix/ch/ClickHouse/src/Core/Field.h:876: DB::NearestFieldTypeImpl<std::decay<wide::integer<128ul, int>>::type, void>::Type& DB::Field::get<wide::integer<128ul, int>>() @ 0x1a1245d8 in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:00.019165 [ 217792 ] <Fatal> BaseDaemon: 13. /home/tavplubix/ch/ClickHouse/src/Core/Field.h:462: auto const& DB::Field::get<wide::integer<128ul, int>>() const @ 0x1a1941dd in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:02.508428 [ 217792 ] <Fatal> BaseDaemon: 14. /home/tavplubix/ch/ClickHouse/src/Columns/ColumnVector.h:308: DB::ColumnVector<wide::integer<128ul, int>>::insert(DB::Field const&) @ 0x2cad4b32 in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:03.006488 [ 217792 ] <Fatal> BaseDaemon: 15. /home/tavplubix/ch/ClickHouse/src/Columns/ColumnNullable.cpp:196: DB::ColumnNullable::insert(DB::Field const&) @ 0x2ca0892a in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:03.404607 [ 217792 ] <Fatal> BaseDaemon: 16. /home/tavplubix/ch/ClickHouse/src/DataTypes/IDataType.cpp:59: DB::IDataType::createColumnConst(unsigned long, DB::Field const&) const @ 0x2ac94de1 in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:08.350035 [ 217792 ] <Fatal> BaseDaemon: 17. /home/tavplubix/ch/ClickHouse/src/Interpreters/ActionsDAG.cpp:2001: DB::ActionsDAG::cloneActionsForFilterPushDown(String const&, bool, std::vector<String, std::allocator<String>> const&, std::vector<DB::ColumnWithTypeAndName, std::allocator<DB::ColumnWithTypeAndName>> const&) @ 0x2afc7b28 in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:09.401700 [ 217792 ] <Fatal> BaseDaemon: 18. /home/tavplubix/ch/ClickHouse/src/Processors/QueryPlan/Optimizations/filterPushDown.cpp:118: DB::QueryPlanOptimizations::splitFilter(DB::QueryPlan::Node*, std::vector<String, std::allocator<String>> const&, unsigned long) @ 0x2e631aad in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:10.273270 [ 217792 ] <Fatal> BaseDaemon: 19. /home/tavplubix/ch/ClickHouse/src/Processors/QueryPlan/Optimizations/filterPushDown.cpp:352: DB::QueryPlanOptimizations::tryPushDownFilter(DB::QueryPlan::Node*, std::list<DB::QueryPlan::Node, std::allocator<DB::QueryPlan::Node>>&)::$_1::operator()(DB::JoinKind) const @ 0x2e63100f in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:11.168416 [ 217792 ] <Fatal> BaseDaemon: 20. /home/tavplubix/ch/ClickHouse/src/Processors/QueryPlan/Optimizations/filterPushDown.cpp:374: DB::QueryPlanOptimizations::tryPushDownFilter(DB::QueryPlan::Node*, std::list<DB::QueryPlan::Node, std::allocator<DB::QueryPlan::Node>>&) @ 0x2e62fd5f in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:11.740796 [ 217792 ] <Fatal> BaseDaemon: 21. /home/tavplubix/ch/ClickHouse/src/Processors/QueryPlan/Optimizations/optimizeTree.cpp:85: DB::QueryPlanOptimizations::optimizeTreeFirstPass(DB::QueryPlanOptimizationSettings const&, DB::QueryPlan::Node&, std::list<DB::QueryPlan::Node, std::allocator<DB::QueryPlan::Node>>&) @ 0x2e5f925b in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:12.788982 [ 217792 ] <Fatal> BaseDaemon: 22. /home/tavplubix/ch/ClickHouse/src/Processors/QueryPlan/QueryPlan.cpp:463: DB::QueryPlan::optimize(DB::QueryPlanOptimizationSettings const&) @ 0x2e542ae8 in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:13.729484 [ 217792 ] <Fatal> BaseDaemon: 23. /home/tavplubix/ch/ClickHouse/src/Processors/QueryPlan/QueryPlan.cpp:167: DB::QueryPlan::buildQueryPipeline(DB::QueryPlanOptimizationSettings const&, DB::BuildQueryPipelineSettings const&) @ 0x2e5425b3 in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:15.174501 [ 217792 ] <Fatal> BaseDaemon: 24. /home/tavplubix/ch/ClickHouse/src/Interpreters/InterpreterSelectWithUnionQuery.cpp:388: DB::InterpreterSelectWithUnionQuery::execute() @ 0x2c223d2b in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:16.383538 [ 217792 ] <Fatal> BaseDaemon: 25. /home/tavplubix/ch/ClickHouse/src/Interpreters/executeQuery.cpp:713: DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x2c759fb7 in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:17.818856 [ 217792 ] <Fatal> BaseDaemon: 26. /home/tavplubix/ch/ClickHouse/src/Interpreters/executeQuery.cpp:1160: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x2c755d3b in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:19.229144 [ 217792 ] <Fatal> BaseDaemon: 27. /home/tavplubix/ch/ClickHouse/src/Server/TCPHandler.cpp:420: DB::TCPHandler::runImpl() @ 0x2dd4a44d in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:20.732580 [ 217792 ] <Fatal> BaseDaemon: 28. /home/tavplubix/ch/ClickHouse/src/Server/TCPHandler.cpp:2011: DB::TCPHandler::run() @ 0x2dd5d2f2 in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:21.084879 [ 217792 ] <Fatal> BaseDaemon: 29. /home/tavplubix/ch/ClickHouse/base/poco/Net/src/TCPServerConnection.cpp:43: Poco::Net::TCPServerConnection::start() @ 0x331eee39 in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:21.312826 [ 217792 ] <Fatal> BaseDaemon: 30. /home/tavplubix/ch/ClickHouse/base/poco/Net/src/TCPServerDispatcher.cpp:115: Poco::Net::TCPServerDispatcher::run() @ 0x331ef688 in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:21.485715 [ 217792 ] <Fatal> BaseDaemon: 31. /home/tavplubix/ch/ClickHouse/base/poco/Foundation/src/ThreadPool.cpp:188: Poco::PooledThread::run() @ 0x33471461 in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:21.767334 [ 217792 ] <Fatal> BaseDaemon: 32. /home/tavplubix/ch/ClickHouse/base/poco/Foundation/src/Thread.cpp:46: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x3346dd7a in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:21.999131 [ 217792 ] <Fatal> BaseDaemon: 33. /home/tavplubix/ch/ClickHouse/base/poco/Foundation/src/Thread_POSIX.cpp:335: Poco::ThreadImpl::runnableEntry(void*) @ 0x3346c915 in /home/tavplubix/ch/ClickHouse/cmake-build-debug/programs/clickhouse
[dell9510] 2023.03.21 20:35:22.007930 [ 217792 ] <Fatal> BaseDaemon: 34. ? @ 0x7f8b9164dbb5 in ?
[dell9510] 2023.03.21 20:35:22.009741 [ 217792 ] <Fatal> BaseDaemon: 35. ? @ 0x7f8b916cfd90 in ?
[dell9510] 2023.03.21 20:35:22.010816 [ 217792 ] <Fatal> BaseDaemon: Integrity check of the executable skipped because the reference checksum could not be read.
Exception on client:
Code: 32. DB::Exception: Attempt to read after eof: while receiving packet from localhost:9000. (ATTEMPT_TO_READ_AFTER_EOF)
cc: @KochetovNicolai