Yulei-Yang opened a new pull request, #34975:
URL: https://github.com/apache/doris/pull/34975

   ## Proposed changes
   
   <!--Describe your changes.-->
   
   Steps to reproduce:
   1. create a table test_table contains a timestamp type column which named 
create_time, and insert some rows.
   2. create a doris jdbc catalog pointer the above mysql server.
   3. run doris sql: set enable_nereids_planner=false; select case when 
create_time = '0000-00-00 00:00:00' then '' else create_time end from 
jdbc.db.test_table;
   
   then you will got be core error:
   ERROR 1105 (HY000): RpcException, msg: org.apache.doris.rpc.RpcException: 
io.grpc.StatusRuntimeException: UNAVAILABLE: Network closed for unknown reason
   
   error in be.out
   ```sql
    1# 0x00007F3A6DD33400 in /lib64/libc.so.6
    2# gsignal in /lib64/libc.so.6
    3# abort in /lib64/libc.so.6
    4# __gnu_cxx::__verbose_terminate_handler() [clone .cold] at 
../../../../libstdc++-v3/libsupc++/vterminate.cc:75
    5# __cxxabiv1::__terminate(void (*)()) at 
../../../../libstdc++-v3/libsupc++/eh_terminate.cc:48
    6# 0x00005588299AADC1 in /data/d12/output/be/lib/doris_be
    7# 0x00005588299AAF14 in /data/d12/output/be/lib/doris_be
    8# 0x0000558824A99D2E in /data/d12/output/be/lib/doris_be
    9# 0x0000558824A99E86 in /data/d12/output/be/lib/doris_be
   10# doris::Status doris::vectorized::FunctionCase<false, 
true>::execute_get_when_null<doris::vectorized::ColumnString>(std:
   :shared_ptr<doris::vectorized::IDataType const> const&, 
doris::vectorized::Block&, std::vector<unsigned long, std::allocato
   r<unsigned long> > const&, unsigned long, unsigned long) [clone .isra.0] at 
/data/d12/be/src/vec/functions/function_case.h:
   354
   11# doris::vectorized::FunctionCase<false, 
true>::execute_impl(doris_udf::FunctionContext*, doris::vectorized::Block&, std:
   :vector<unsigned long, std::allocator<unsigned long> > const&, unsigned 
long, unsigned long) at /data/d12/be/src/vec/functi
   ons/function_case.h:377
   12# 
doris::vectorized::PreparedFunctionImpl::execute_without_low_cardinality_columns(doris_udf::FunctionContext*,
 doris::ve
   ctorized::Block&, std::vector<unsigned long, std::allocator<unsigned long> > 
const&, unsigned long, unsigned long, bool) at
    /data/d12/be/src/vec/functions/function.cpp:244
   13# 
doris::vectorized::PreparedFunctionImpl::execute(doris_udf::FunctionContext*, 
doris::vectorized::Block&, std::vector<un
   signed long, std::allocator<unsigned long> > const&, unsigned long, unsigned 
long, bool) at /data/d12/be/src/vec/functions/
   function.cpp:267
   14# doris::vectorized::VCaseExpr::execute(doris::vectorized::VExprContext*, 
doris::vectorized::Block*, int*) at /data/d12/be/src/vec/exprs/vcase_expr.cpp:90
   15# 
doris::vectorized::VExprContext::get_output_block_after_execute_exprs(std::vector<doris::vectorized::VExprContext*,
 std::allocator<doris::vectorized::VExprContext*> > const&, 
doris::vectorized::Block const&, doris::Status&) at 
/data/d12/be/src/vec/exprs/vexpr_context.cpp:148
   16# 
doris::vectorized::VMysqlResultWriter::append_block(doris::vectorized::Block&) 
at /data/d12/be/src/vec/sink/vmysql_result_writer.cpp:459
   17# doris::vectorized::VResultSink::send(doris::RuntimeState*, 
doris::vectorized::Block*) at /data/d12/be/src/vec/sink/vresult_sink.cpp:96
   ```
   
   while when using nereids planer,
   fe throw analysis error: ERROR 1105 (HY000): errCode = 2, detailMessage = 
Unexpected exception: Table name [jdbc2.db1.mc_work_contact_employee_1] is 
invalid.
   
   so make legacy planer act like nereids.
    
   ## Further comments
   
   If this is a relatively large or complex change, kick off the discussion at 
[d...@doris.apache.org](mailto:d...@doris.apache.org) by explaining why you 
chose the solution you did and what alternatives you considered, etc...
   
   


-- 
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

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

Reply via email to