jacktengg opened a new issue, #15475: URL: https://github.com/apache/doris/issues/15475
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 1.1.5-rc02 ### What's Wrong? be coredump: ``` start time: Wed Dec 28 14:39:27 CST 2022 WARNING: Logging before InitGoogleLogging() is written to STDERR I1228 14:39:28.347211 23199 env.cpp:46] Env init successfully. *** Query id: 0-0 *** *** Aborted at 1672209667 (unix time) try "date -d @1672209667" if you are using GNU date *** *** SIGSEGV unkown detail explain (@0x0) received by PID 23199 (TID 0x7ff93e1b0700) from PID 0; stack trace: *** 0# doris::signal::(anonymous namespace)::FailureSignalHandler(int, siginfo_t*, void*) at /root/1.2-lts/be/src/common/signal_handler.h:428 1# 0x00007FF966F86400 in /lib64/libc.so.6 2# doris::vectorized::IAggregateFunctionHelper<doris::vectorized::AggregateFunctionCountNotNullUnary>::add_batch(unsigned long, char**, unsigned long, doris::vectorized::IColumn const**, doris::vectorized::Arena*) const at /root/1.2-lts/be/src/vec/aggregate_functions/aggregate_function.h:151 3# doris::vectorized::AggFnEvaluator::execute_batch_add(doris::vectorized::Block*, unsigned long, char**, doris::vector ized::Arena*) at /root/1.2-lts/be/src/vec/exprs/vectorized _agg_fn.cpp:131 4# doris::vectorized::AggregationNode::_pre_agg_with_serialized_key(doris::vectorized::Block*, doris::vectorized::Block*) at /root/1.2-lts/be/src/vec/exec/vaggregation_node.cpp: 804 5# std::_Function_handler<doris::Status (doris::vectorized::Block*, doris::vectorized::Block*), std::_Bind_result<doris::Status, doris::Status (doris::vectorized::AggregationNod e::*(doris::vectorized::AggregationNode*, std::_Placeholder<1>, std::_Placeholder<2>))(doris::vectorized::Block*, doris::vectorized::Block*)> >::_M_invoke(std::_Any_data const&, doris::vectorized::Block*&&, doris::vectorized::Block*&&) at /var/local/ldb-toolchain/include/c++/11/bits/std_function.h:293 6# doris::vectorized::AggregationNode::get_next(doris::RuntimeState*, doris::vectorized::Block*, bool*) at /root/1.2-lts/be/src/vec/exec/vaggregation_node.cpp:401 7# doris::PlanFragmentExecutor::get_vectorized_internal(doris::vectorized::Block**) at /root /1.2-lts/be/src/runtime/plan_fragment_executor.cpp:352 8# doris::PlanFragmentExecutor::open_vectorized_internal() at /root/1.2-lts/be/src/runtime/plan_fragment_executor.cpp:301 9# doris::PlanFragmentExecutor::open() at /root/1.2-lts/be/src/runtime/plan_fragment_executor.cpp:259 10# doris::FragmentExecState::execute() at /root/1.2-lts/be/src/runtime/fragment_mgr.cpp:249 11# doris::FragmentMgr::_exec_actual(std::shared_ptr<doris::FragmentExecState>, std::function<void (doris::PlanFragmentExecutor*)>) at /root/1.2-lts/be/src/runtime/fragment_mgr.c pp:487 12# std::_Function_handler<void (), std::_Bind_result<void, void (doris::FragmentMgr::*(doris::FragmentMgr*, std::shared_ptr<doris::FragmentExecState>, std::function<void (doris: :PlanFragmentExecutor*)>))(std::shared_ptr<doris::FragmentExecState>, std::function<void (doris::PlanFragmentExecutor*)>)> >::_M_invoke(std::_Any_data const&) at /var/local/ldb-t oolchain/include/c++/11/bits/std_function.h:291 13# doris::ThreadPool::dispatch _thread() at /root/1.2-lts/be/src/util/threadpool.cpp:578 14# doris::Thread::supervise_thread(void*) at /root/1.2-lts/be/src/util/thread.cpp:407 15# start_thread in /lib64/libpthread.so.0 16# clone in /lib64/libc.so.6 ``` schema and sql: ``` CREATE DATABASE demo; USE demo;CREATE TABLE `call` ( `seq` varchar(128) NOT NULL, `charge_time` datetime NOT NULL, `view_time` datetime NULL, `create_time` datetime NULL ) UNIQUE KEY(seq, charge_time) PARTITION BY RANGE(charge_time)() DISTRIBUTED BY HASH(seq) PROPERTIES ( "dynamic_partition.enable" = "true", "dynamic_partition.time_unit" = "MONTH", "dynamic_partition.time_zone" = "Asia/Shanghai", "dynamic_partition.start" = "-3", "dynamic_partition.end" = "3", "dynamic_partition.prefix" = "dms_call_dev", "dynamic_partition.buckets" = "8", "dynamic_partition.replication_num" = "1" ); show partitions from call; INSERT INTO call (seq, charge_time, view_time, create_time) VALUES ('1', '2022-12-01 00:00:00', '2022-12-01 00:00:00','2022-12-01 00:00:00'); INSERT INTO call (seq, charge_time, view_time, create_time) VALUES ('2', '2022-12-02 00:00:00', '2022-12-02 00:00:00','2022-12-02 00:00:00'); SELECT * FROM call;select DATE_FORMAT(c.charge_time, '%Y-%m-%d') as date, COUNT(view_time is not null or null)as chakenTotal from call c where DATE_FORMAT(c.charge_time, '%Y-%m-%d') >= "2022-12-01" and DATE_FORMAT(c.charge_time, '%Y-%m-%d') <= "2022-12-02" GROUP by DATE_FORMAT(c.charge_time, '%Y-%m-%d') order by date DESC limit 10; ``` ### What You Expected? sql execute OK. ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
