You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "lljqy (via GitHub)" <gi...@apache.org> on 2023/03/22 13:34:55 UTC
[GitHub] [doris] lljqy opened a new issue, #18036: SQL中的"OR"条件大于217个时，集群的所有BE都会宕机
lljqy opened a new issue, #18036:
URL: https://github.com/apache/doris/issues/18036
### 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
doris版本1.1.5
### What's Wrong?
操作系统: 欧拉2.0
单机配置：cpu 96核心，内存1T
例如有一张表：t_product（明细模型）
其中有5个字段，id, addr, name, price, number
当我执行：SELECT * FROM t_product WHERE id = 1 OR id = 2 OR id = 3 ...... OR id = 220时，BE全部宕机
### What You Expected?
正常情况应该是返回 id 在 1 ~ 220 之间的记录
### How to Reproduce?
SELECT * FROM t_product WHERE id = 1 OR id = 2 OR id = 3 ...... OR id = 220（其中OR条件有220个）
### Anything Else?
暂无
### 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] cambyzju commented on issue #18036: SQL中的"OR"条件大于217个时，集群的所有BE都会宕机
Posted by "cambyzju (via GitHub)" <gi...@apache.org>.
cambyzju commented on issue #18036:
URL: https://github.com/apache/doris/issues/18036#issuecomment-1482562464
> 为什么不用 id in () 呢 ？
如果OR里面的条件更复杂一点，应该是没有办法用IN的。
--
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] cambyzju commented on issue #18036: SQL中的"OR"条件大于217个时，集群的所有BE都会宕机
Posted by "cambyzju (via GitHub)" <gi...@apache.org>.
cambyzju commented on issue #18036:
URL: https://github.com/apache/doris/issues/18036#issuecomment-1482564465
用1.1版本复现了一下，看着是create_tree_from_thrift递归调用，导致了栈溢出
<img width="1279" alt="image" src="https://user-images.githubusercontent.com/10771715/227494246-69999467-26e7-4c59-8698-637d11c05e74.png">
--
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] yangzhg closed issue #18036: SQL中的"OR"条件大于217个时，集群的所有BE都会宕机
Posted by "yangzhg (via GitHub)" <gi...@apache.org>.
yangzhg closed issue #18036: SQL中的"OR"条件大于217个时，集群的所有BE都会宕机
URL: https://github.com/apache/doris/issues/18036
--
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] cambyzju commented on issue #18036: SQL中的"OR"条件大于217个时，集群的所有BE都会宕机
Posted by "cambyzju (via GitHub)" <gi...@apache.org>.
cambyzju commented on issue #18036:
URL: https://github.com/apache/doris/issues/18036#issuecomment-1484646385
https://github.com/apache/doris/pull/17314 already add limit to prevent stack overflow
--
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] stevqin commented on issue #18036: SQL中的"OR"条件大于217个时，集群的所有BE都会宕机
Posted by "stevqin (via GitHub)" <gi...@apache.org>.
stevqin commented on issue #18036:
URL: https://github.com/apache/doris/issues/18036#issuecomment-1482403452
为什么不用 id in () 呢 ？
--
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