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/07/05 11:48:32 UTC
[GitHub] [doris] yinzhijian opened a new issue, #10625: [Bug](vec) "where column like NULL" statement in vectorized engine will cause BE coredump
yinzhijian opened a new issue, #10625:
URL: https://github.com/apache/doris/issues/10625
### 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
master
### What's Wrong?
Executing the "where column like NULL" statement in vec engine will cause BE coredump
```SQL
select * from table where username like NULL
```
```c++
*** Aborted at 1657021225 (unix time) try "date -d @1657021225" if you are using GNU date ***
*** SIGABRT unkown detail explain (@0x20c0000ae8e) received by PID 44686 (TID 0x7f2d367d5700) from PID 44686; stack trace: ***
0# doris::signal::(anonymous namespace)::FailureSignalHandler(int, siginfo_t*, void*) at be/src/common/signal_handler.h:407
1# 0x00007F2D5233D570 in /lib64/libc.so.6
2# gsignal in /lib64/libc.so.6
3# __GI_abort in /lib64/libc.so.6
4# __gnu_cxx::__verbose_terminate_handler() [clone .cold] in be/lib/palo_be
5# __cxxabiv1::__terminate(void (*)()) in be/lib/palo_be
6# 0x00007F2D5E6B8321 in be/lib/palo_be
7# 0x00007F2D5E6B8475 in be/lib/palo_be
8# doris::vectorized::ColumnNullable const* typeid_cast<doris::vectorized::ColumnNullable const*, doris::vectorized::IColumn const>(doris::vectorized::IColumn const*) at /h
ome/disk4/yintao03/baidu/bdg/doris/core/be/src/vec/common/typeid_cast.h:60
9# doris::vectorized::ColumnNullable const* doris::vectorized::check_and_get_column<doris::vectorized::ColumnNullable>(doris::vectorized::IColumn const&) at /home/disk4/yin
tao03/baidu/bdg/doris/core/be/src/vec/columns/column.h:525
10# doris::vectorized::Block::filter_block(doris::vectorized::Block*, int, int) at be/src/vec/core/block.cpp:627
11# doris::vectorized::VExprContext::filter_block(doris::vectorized::VExprContext*, doris::vectorized::Block*, int) at be/src/vec/e
xprs/vexpr_context.cpp:126
12# doris::vectorized::VOlapScanner::get_block(doris::RuntimeState*, doris::vectorized::Block*, bool*) at be/src/vec/exec/volap_sca
nner.cpp:297
13# doris::vectorized::VOlapScanNode::scanner_thread(doris::vectorized::VOlapScanner*) at be/src/vec/exec/volap_scan_node.cpp:509
14# void std::__invoke_impl<void, void (doris::vectorized::VOlapScanNode::*&)(doris::vectorized::VOlapScanner*), doris::vectorized::VOlapScanNode*&, doris::vectorized::VOlap
Scanner*&>(std::__invoke_memfun_deref, void (doris::vectorized::VOlapScanNode::*&)(doris::vectorized::VOlapScanner*), doris::vectorized::VOlapScanNode*&, doris::vectorized::
VOlapScanner*&) atpalo-toolchain/ldb_toolchain/include/c++/11/bits/invoke.h:74
15# std::__invoke_result<void (doris::vectorized::VOlapScanNode::*&)(doris::vectorized::VOlapScanner*), doris::vectorized::VOlapScanNode*&, doris::vectorized::VOlapScanner*&
>::type std::__invoke<void (doris::vectorized::VOlapScanNode::*&)(doris::vectorized::VOlapScanner*), doris::vectorized::VOlapScanNode*&, doris::vectorized::VOlapScanner*&>(v
oid (doris::vectorized::VOlapScanNode::*&)(doris::vectorized::VOlapScanner*), doris::vectorized::VOlapScanNode*&, doris::vectorized::VOlapScanner*&) at /home/disk4/yintao03/
baidu/bdg/doris/palo-toolchain/ldb_toolchain/include/c++/11/bits/invoke.h:97
16# void std::_Bind<void (doris::vectorized::VOlapScanNode::*(doris::vectorized::VOlapScanNode*, doris::vectorized::VOlapScanner*))(doris::vectorized::VOlapScanner*)>::__cal
l<void, , 0ul, 1ul>(std::tuple<>&&, std::_Index_tuple<0ul, 1ul>) atpalo-toolchain/ldb_toolchain/include/c++/11/functional:422
17# void std::_Bind<void (doris::vectorized::VOlapScanNode::*(doris::vectorized::VOlapScanNode*, doris::vectorized::VOlapScanner*))(doris::vectorized::VOlapScanner*)>::opera
tor()<, void>() atpalo-toolchain/ldb_toolchain/include/c++/11/functional:505
18# void std::__invoke_impl<void, std::_Bind<void (doris::vectorized::VOlapScanNode::*(doris::vectorized::VOlapScanNode*, doris::vectorized::VOlapScanner*))(doris::vectorize
d::VOlapScanner*)>&>(std::__invoke_other, std::_Bind<void (doris::vectorized::VOlapScanNode::*(doris::vectorized::VOlapScanNode*, doris::vectorized::VOlapScanner*))(doris::v
ectorized::VOlapScanner*)>&) atpalo-toolchain/ldb_toolchain/include/c++/11/bits/invoke.h:61
```
### What You Expected?
return result like rowset engine
### 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] stalary commented on issue #10625: [Bug](vec) "where column like NULL" statement in vectorized engine will cause BE coredump
Posted by GitBox <gi...@apache.org>.
stalary commented on issue #10625:
URL: https://github.com/apache/doris/issues/10625#issuecomment-1175635501
In mysql, `[42000][1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'like null' at line 1`, It seems that this syntax is not allowed, does it meet your requirements to forbid it directly at the sql parse?
--
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
Re: [I] [Bug](vec) "where column like NULL" statement in vectorized engine will cause BE coredump [doris]
Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman closed issue #10625: [Bug](vec) "where column like NULL" statement in vectorized engine will cause BE coredump
URL: https://github.com/apache/doris/issues/10625
--
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