[GitHub] [incubator-doris] tinkerrrr opened a new issue #6427: grouping set cause BE crash

[GitBox <gi...@apache.org>]

tinkerrrr opened a new issue #6427:
URL: https://github.com/apache/incubator-doris/issues/6427


   **Describe the bug**
   SQL:
   
   ```sql
   SELECT a.date_col AS date_col,
          TIMESTAMPDIFF(DAY, a.date_col, b.date_col) AS date_distance,
          COUNT(DISTINCT a.xxid)
   FROM
   	SELECT date_col, xxid FROM a LEFT JOIN b ON a.xxid = b.xxid
   		AND a.date_col <= b.date_col
   GROUP BY 
   	GROUPING sets((date_col, date_distance), (date_col))
   ```
   BE crash:
   
   ```
   *** Aborted at 1628693887 (unix time) try "date -d @1628693887" if you are using GNU date ***
   PC: @           0xe6b0f2 doris::SlotRef::get_datetime_val()
   *** SIGSEGV (@0x0) received by PID 133707 (TID 0x7f1259f81700) from PID 0; stack trace: ***
       @     0x7f129a510060 (unknown)
       @           0xe6b0f2 doris::SlotRef::get_datetime_val()
       @           0xee8e0c doris::IfExpr::get_datetime_val()
       @           0xe506e1 doris::ExprContext::get_value()
       @           0xe678b0 doris::ScalarFnCall::interpret_eval<>()
       @           0xe505e4 doris::ExprContext::get_value()
       @          0x1714471 doris::PartitionedHashTableCtx::EvalRow()
       @          0x16c48da doris::PartitionedAggregationNode::EvalAndHashPrefetchGroup<>()
       @          0x16c4168 doris::PartitionedAggregationNode::ProcessBatchStreaming()
       @          0x16bcd68 doris::PartitionedAggregationNode::GetRowsStreaming()
       @          0x16c0451 doris::PartitionedAggregationNode::GetNextInternal()
       @          0x16c05ff doris::PartitionedAggregationNode::get_next()
       @          0x1199e4f doris::PlanFragmentExecutor::get_next_internal()
       @          0x119b311 doris::PlanFragmentExecutor::open_internal()
       @          0x119bbc0 doris::PlanFragmentExecutor::open()
       @          0x111c18e doris::FragmentExecState::execute()
       @          0x111f4b6 doris::FragmentMgr::_exec_actual()
       @          0x112540c std::_Function_handler<>::_M_invoke()
       @          0x12aeef2 doris::ThreadPool::dispatch_thread()
       @          0x12a6d58 doris::Thread::supervise_thread()
       @     0x7f129a2c74a4 start_thread
       @     0x7f129a5c5d0f (unknown)
   ```
   


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org