为提高效率，请提供以下信息，问题描述清晰能够更快得到解决：
[TiDB 版本] 4.0.10
[问题描述]
表如下
CREATE TABLE `store_daily_config` (
`dt` timestamp NOT NULL ,
`store_id` varchar(32) NOT NULL,
`store_rules` text NOT NULL,
`enable_realtime` tinyint(1) NOT NULL DEFAULT '1',
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`dt`,`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
执行如下 SQL:
SELECT count(1) FROM store_daily_config WHERE dt = (SELECT max(dt) FROM store_daily_config);
会报错
ERROR 1105 (HY000): [FLASH:Coprocessor:BadRequest] Invalid MySQL Time literal tp: MysqlTime
val: "\031\250\351\000\000\000\000\000"
sig: Unspecified
field_type {
tp: 7
flag: 4227
flen: 19
decimal: 0
collate: 63
charset: "binary"
}
强制走 tikv 可正常执行
查询日志，tiflash 报错如下:
[] [“DAGDriver: void DB::DAGDriver::execute() [with bool batch = true]: [FLASH:Coprocessor:BadRequest] Invalid MySQL Time literal tp: MysqlTime\ val: “\031\250\351\000\000\000\000\000”\ sig: Unspecified\ field_type {\ tp: 7\ flag: 4227\ flen: 19\ decimal: 0\ collate: 63\ charset: “binary”\ }\ \ 0. bin/tiflash/tiflash(StackTrace::StackTrace()+0x15) [0x34db7d5]\ 1. bin/tiflash/tiflash(DB::TiFlashException::TiFlashException(std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, DB::TiFlashError const&)+0x34) [0x3db5134]\ 2. bin/tiflash/tiflash(DB::decodeLiteral(tipb::Expr const&)+0x2652) [0x70c6662]\ 3. bin/tiflash/tiflash(DB::DAGExpressionAnalyzer::getActions[abi:cxx11](tipb::Expr const&, std::shared_ptrDB::ExpressionActions&, bool)+0x74) [0x711c594]\ 4. bin/tiflash/tiflash(DB::DAGExpressionAnalyzer::getActions[abi:cxx11](tipb::Expr const&, std::shared_ptrDB::ExpressionActions&, bool)+0x5bc) [0x711cadc]\ 5. bin/tiflash/tiflash(DB::DAGExpressionAnalyzer::appendWhere(DB::ExpressionActionsChain&, std::vector<tipb::Expr const*, std::allocator<tipb::Expr const*> > const&, std::__cxx11::basic_string<char, std::char_traits, std::allocator >&)+0xd2) [0x7121022]\ 6. bin/tiflash/tiflash(DB::DAGQueryBlockInterpreter::analyzeExpressions()+0x16c) [0x7102afc]\ 7. bin/tiflash/tiflash(DB::DAGQueryBlockInterpreter::executeImpl(DB::Pipeline&)+0xa6) [0x710bf26]\ 8. bin/tiflash/tiflash(DB::DAGQueryBlockInterpreter::execute()+0x35) [0x710c435]\ 9. bin/tiflash/tiflash(DB::InterpreterDAG::executeQueryBlock(DB::DAGQueryBlock&, std::vector<std::unordered_map<std::__cxx11::basic_string<char, std::char_traits, std::allocator >, DB::SubqueryForSet, std::hash<std::__cxx11::basic_string<char, std::char_traits, std::allocator > >, std::equal_to<std::__cxx11::basic_string<char, std::char_traits, std::allocator > >, std::allocator<std::pair<std::__cxx11::basic_string<char, std::char_traits, std::allocator > const, DB::SubqueryForSet> > >, std::allocator<std::unordered_map<std::__cxx11::basic_string<char, std::char_traits, std::allocator >, DB::SubqueryForSet, std::hash<std::__cxx11::basic_string<char, std::char_traits, std::allocator > >, std::equal_to<std::__cxx11::basic_string<char, std::char_traits, std::allocator > >, std::allocator<std::pair<std::__cxx11::basic_string<char, std::char_traits, std::allocator > const, DB::SubqueryForSet> > > > >&)+0xdca) [0x70d899a]\ 10. bin/tiflash/tiflash(DB::InterpreterDAG::execute()+0x77) [0x70d9237]\ 11. bin/tiflash/tiflash() [0x688d820]\ 12. bin/tiflash/tiflash(DB::executeQuery(DB::DAGQuerySource&, DB::Context&, bool, DB::QueryProcessingStage::Enum)+0x63) [0x688eab3]\ 13. bin/tiflash/tiflash(DB::DAGDriver::execute()+0x194) [0x70be434]\ 14. bin/tiflash/tiflash(DB::BatchCoprocessorHandler::execute()+0x4ba) [0x70ead4a]\ 15. bin/tiflash/tiflash(DB::FlashService::BatchCoprocessor(grpc_impl::ServerContext*, coprocessor::BatchRequest const*, grpc_impl::ServerWritercoprocessor::BatchResponse)+0x6a0) [0x70a6d20]\ 16. bin/tiflash/tiflash(std::_Function_handler<grpc::Status (tikvpb::Tikv::Service, grpc_impl::ServerContext*, coprocessor::BatchRequest const*, grpc_impl::ServerWritercoprocessor::BatchResponse), std::_Mem_fn<grpc::Status (tikvpb::Tikv::Service::)(grpc_impl::ServerContext*, coprocessor::BatchRequest const*, grpc_impl::ServerWritercoprocessor::BatchResponse)> >::_M_invoke(std::_Any_data const&, tikvpb::Tikv::Service&&, grpc_impl::ServerContext*&&, coprocessor::BatchRequest const*&&, grpc_impl::ServerWritercoprocessor::BatchResponse&&)+0x38) [0x7843fc8]\ 17. bin/tiflash/tiflash(grpc::Status grpc::internal::CatchingFunctionHandler<grpc::internal::ServerStreamingHandler<tikvpb::Tikv::Service, coprocessor::BatchRequest, coprocessor::BatchResponse>::RunHandler(grpc::internal::MethodHandler::HandlerParameter const&)::{lambda()#1}>(grpc::internal::ServerStreamingHandler<tikvpb::Tikv::Service, coprocessor::BatchRequest, coprocessor::BatchResponse>::RunHandler(grpc::internal::MethodHandler::HandlerParameter const&)::{lambda()#1}&&)+0x53) [0x7899813]\ 18. bin/tiflash/tiflash(grpc::internal::ServerStreamingHandler<tikvpb::Tikv::Service, coprocessor::BatchRequest, coprocessor::BatchResponse>::RunHandler(grpc::internal::MethodHandler::HandlerParameter const&)+0xac) [0x789996c]\ 19. bin/tiflash/tiflash(grpc_impl::Server::SyncRequest::CallData::ContinueRunAfterInterception()+0x160) [0x7921070]\ 20. bin/tiflash/tiflash(grpc_impl::Server::SyncRequestThreadManager::DoWork(void, bool, bool)+0x42f) [0x792262f]\ 21. bin/tiflash/tiflash(grpc::ThreadManager::MainWorkLoop()+0x9a) [0x792826a]\ 22. bin/tiflash/tiflash(grpc::ThreadManager::WorkerThread::Run()+0xb) [0x792834b]\ 23. bin/tiflash/tiflash() [0x7c9fc32]\ 24. /lib64/libpthread.so.0(+0x7e24) [0x7f0cbecfde24]\ 25. /lib64/libc.so.6(clone+0x6c) [0x7f0cbe725bac]\ ”] [thread_id=16942646]
若提问为性能优化、故障排查类问题，请下载脚本运行。终端输出的打印结果，请务必全选并复制粘贴上传。