You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/10/10 03:00:55 UTC
[GitHub] [doris] vvii opened a new issue, #13232: [Bug] SQL查询 IF子句不支持表达式
vvii opened a new issue, #13232:
URL: https://github.com/apache/doris/issues/13232
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Version
1.1.2-rc05-a8323dae4
### What's Wrong?
提交查询
`select if(dayofweek(CURDATE()) = 1, 7, dayofweek(CURDATE())-1)`
报错
`ERROR 1105 (HY000): RpcException, msg: io.grpc.StatusRuntimeException: UNAVAILABLE: Network closed for unknown reason`
观察到BE节点挂掉，be.out 文件输出
`*** Aborted at 1665370577 (unix time) try "date -d @1665370577" if you are using GNU date ***
*** SIGSEGV address not mapped to object (@0x0) received by PID 3262778 (TID 0x7f3374980700) from PID 0; stack trace: ***
0# doris::signal::(anonymous namespace)::FailureSignalHandler(int, siginfo_t*, void*) at /mnt/disk2/apache-doris/be/src/common/signal_handler.h:420
1# 0x00007F33B544EF00 in /lib64/libc.so.6
2# void doris::vectorized::MutableBlock::merge<doris::vectorized::Block&>(doris::vectorized::Block&) at /mnt/disk2/apache-doris/be/src/vec/core/block.h:379
3# doris::vectorized::VUnionNode::get_next_const(doris::RuntimeState*, doris::vectorized::Block*) at /mnt/disk2/apache-doris/be/src/vec/exec/vunion_node.cpp:193
4# doris::vectorized::VUnionNode::get_next(doris::RuntimeState*, doris::vectorized::Block*, bool*) in /usr/local/services/doris/be/lib/doris_be
5# doris::PlanFragmentExecutor::get_vectorized_internal(doris::vectorized::Block**) at /mnt/disk2/apache-doris/be/src/runtime/plan_fragment_executor.cpp:352
6# doris::PlanFragmentExecutor::open_vectorized_internal() at /mnt/disk2/apache-doris/be/src/runtime/plan_fragment_executor.cpp:301
7# doris::PlanFragmentExecutor::open() in /usr/local/services/doris/be/lib/doris_be
8# doris::FragmentExecState::execute() at /mnt/disk2/apache-doris/be/src/runtime/fragment_mgr.cpp:246
9# doris::FragmentMgr::_exec_actual(std::shared_ptr<doris::FragmentExecState>, std::function<void (doris::PlanFragmentExecutor*)>) at /mnt/disk2/apache-doris/be/src/runtime/fragment_mgr.cpp:478
10# void std::__invoke_impl<void, void (doris::FragmentMgr::*&)(std::shared_ptr<doris::FragmentExecState>, std::function<void (doris::PlanFragmentExecutor*)>), doris::FragmentMgr*&, std::shared_ptr<doris::FragmentExecState>&, std::function<void (doris::PlanFragmentExecutor*)>&>(std::__invoke_memfun_deref, void (doris::FragmentMgr::*&)(std::shared_ptr<doris::FragmentExecState>, std::function<void (doris::PlanFragmentExecutor*)>), doris::FragmentMgr*&, std::shared_ptr<doris::FragmentExecState>&, std::function<void (doris::PlanFragmentExecutor*)>&) at /mnt/disk2/ygl/installs/ldbtools/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/invoke.h:74
11# doris::ThreadPool::dispatch_thread() at /mnt/disk2/apache-doris/be/src/util/threadpool.cpp:578
12# doris::Thread::supervise_thread(void*) at /mnt/disk2/apache-doris/be/src/util/thread.cpp:407
13# start_thread in /lib64/libpthread.so.0
14# __clone in /lib64/libc.so.6`
### What You Expected?
if函数的参数应当支持表达式
### How to Reproduce?
_No response_
### Anything Else?
_No response_
### Are you willing to submit PR?
- [ ] 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-unsubscribe@doris.apache.org.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
[GitHub] [doris] BiteTheDDDDt commented on issue #13232: [Bug] SQL查询 IF子句不支持表达式
Posted by GitBox <gi...@apache.org>.
BiteTheDDDDt commented on issue #13232:
URL: https://github.com/apache/doris/issues/13232#issuecomment-1327177657
经过测试，在目前的master没有这个问题
--
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
[GitHub] [doris] vvii closed issue #13232: [Bug] SQL查询 IF子句不支持表达式
Posted by GitBox <gi...@apache.org>.
vvii closed issue #13232: [Bug] SQL查询 IF子句不支持表达式
URL: https://github.com/apache/doris/issues/13232
--
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
[GitHub] [doris] vvii commented on issue #13232: [Bug] SQL查询 IF子句不支持表达式
Posted by GitBox <gi...@apache.org>.
vvii commented on issue #13232:
URL: https://github.com/apache/doris/issues/13232#issuecomment-1327278580
1.1.
--
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