lcz-helloworld opened a new issue, #14852:
URL: https://github.com/apache/doris/issues/14852

   ### 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
   
   1.1.4-rc01-8890a58dc/doris-1.1.5-3e0a2d9
   
   ### What's Wrong?
   
   当where条件为find_in_set('0', ids)>0 or find_in_set('1', ids)>0  ....    or 
find_in_set('220', ids)>0 sql执行正常. 当or find_in_set('221', ids)>0 为错误临界值. 
错误为Caused by: java.sql.SQLException: RpcException, msg: send fragments failed. 
io.grpc.StatusRuntimeException: UNAVAILABLE: Network closed for unknown reason, 
host:  .
   
   ### What You Expected?
   
   or条件拼接find_in_set函数不受数量限制
   
   ### How to Reproduce?
   
   执行类似sql: 
   select
        *
   from
        (
        select
                1 as ids) a
   where
        find_in_set('0', ids)>0
        or find_in_set('1', ids)>0
        or find_in_set('2', ids)>0
        or find_in_set('3', ids)>0
        or find_in_set('4', ids)>0
        or find_in_set('5', ids)>0
        or find_in_set('6', ids)>0
        or find_in_set('7', ids)>0
        or find_in_set('8', ids)>0
        or find_in_set('9', ids)>0
        or find_in_set('10', ids)>0
        or find_in_set('11', ids)>0
        or find_in_set('12', ids)>0
        or find_in_set('13', ids)>0
        or find_in_set('14', ids)>0
        or find_in_set('15', ids)>0
        or find_in_set('16', ids)>0
        or find_in_set('17', ids)>0
        or find_in_set('18', ids)>0
        or find_in_set('19', ids)>0
        or find_in_set('20', ids)>0
        or find_in_set('21', ids)>0
        or find_in_set('22', ids)>0
        or find_in_set('23', ids)>0
        or find_in_set('24', ids)>0
        or find_in_set('25', ids)>0
        or find_in_set('26', ids)>0
        or find_in_set('27', ids)>0
        or find_in_set('28', ids)>0
        or find_in_set('29', ids)>0
        or find_in_set('30', ids)>0
        or find_in_set('31', ids)>0
        or find_in_set('32', ids)>0
        or find_in_set('33', ids)>0
        or find_in_set('34', ids)>0
        or find_in_set('35', ids)>0
        or find_in_set('36', ids)>0
        or find_in_set('37', ids)>0
        or find_in_set('38', ids)>0
        or find_in_set('39', ids)>0
        or find_in_set('40', ids)>0
        or find_in_set('41', ids)>0
        or find_in_set('42', ids)>0
        or find_in_set('43', ids)>0
        or find_in_set('44', ids)>0
        or find_in_set('45', ids)>0
        or find_in_set('46', ids)>0
        or find_in_set('47', ids)>0
        or find_in_set('48', ids)>0
        or find_in_set('49', ids)>0
        or find_in_set('50', ids)>0
        or find_in_set('51', ids)>0
        or find_in_set('52', ids)>0
        or find_in_set('53', ids)>0
        or find_in_set('54', ids)>0
        or find_in_set('55', ids)>0
        or find_in_set('56', ids)>0
        or find_in_set('57', ids)>0
        or find_in_set('58', ids)>0
        or find_in_set('59', ids)>0
        or find_in_set('60', ids)>0
        or find_in_set('61', ids)>0
        or find_in_set('62', ids)>0
        or find_in_set('63', ids)>0
        or find_in_set('64', ids)>0
        or find_in_set('65', ids)>0
        or find_in_set('66', ids)>0
        or find_in_set('67', ids)>0
        or find_in_set('68', ids)>0
        or find_in_set('69', ids)>0
        or find_in_set('70', ids)>0
        or find_in_set('71', ids)>0
        or find_in_set('72', ids)>0
        or find_in_set('73', ids)>0
        or find_in_set('74', ids)>0
        or find_in_set('75', ids)>0
        or find_in_set('76', ids)>0
        or find_in_set('77', ids)>0
        or find_in_set('78', ids)>0
        or find_in_set('79', ids)>0
        or find_in_set('80', ids)>0
        or find_in_set('81', ids)>0
        or find_in_set('82', ids)>0
        or find_in_set('83', ids)>0
        or find_in_set('84', ids)>0
        or find_in_set('85', ids)>0
        or find_in_set('86', ids)>0
        or find_in_set('87', ids)>0
        or find_in_set('88', ids)>0
        or find_in_set('89', ids)>0
        or find_in_set('90', ids)>0
        or find_in_set('91', ids)>0
        or find_in_set('92', ids)>0
        or find_in_set('93', ids)>0
        or find_in_set('94', ids)>0
        or find_in_set('95', ids)>0
        or find_in_set('96', ids)>0
        or find_in_set('97', ids)>0
        or find_in_set('98', ids)>0
        or find_in_set('99', ids)>0
        or find_in_set('100', ids)>0
        or find_in_set('101', ids)>0
        or find_in_set('102', ids)>0
        or find_in_set('103', ids)>0
        or find_in_set('104', ids)>0
        or find_in_set('105', ids)>0
        or find_in_set('106', ids)>0
        or find_in_set('107', ids)>0
        or find_in_set('108', ids)>0
        or find_in_set('109', ids)>0
        or find_in_set('110', ids)>0
        or find_in_set('111', ids)>0
        or find_in_set('112', ids)>0
        or find_in_set('113', ids)>0
        or find_in_set('114', ids)>0
        or find_in_set('115', ids)>0
        or find_in_set('116', ids)>0
        or find_in_set('117', ids)>0
        or find_in_set('118', ids)>0
        or find_in_set('119', ids)>0
        or find_in_set('120', ids)>0
        or find_in_set('121', ids)>0
        or find_in_set('122', ids)>0
        or find_in_set('123', ids)>0
        or find_in_set('124', ids)>0
        or find_in_set('125', ids)>0
        or find_in_set('126', ids)>0
        or find_in_set('127', ids)>0
        or find_in_set('128', ids)>0
        or find_in_set('129', ids)>0
        or find_in_set('130', ids)>0
        or find_in_set('131', ids)>0
        or find_in_set('132', ids)>0
        or find_in_set('133', ids)>0
        or find_in_set('134', ids)>0
        or find_in_set('135', ids)>0
        or find_in_set('136', ids)>0
        or find_in_set('137', ids)>0
        or find_in_set('138', ids)>0
        or find_in_set('139', ids)>0
        or find_in_set('140', ids)>0
        or find_in_set('141', ids)>0
        or find_in_set('142', ids)>0
        or find_in_set('143', ids)>0
        or find_in_set('144', ids)>0
        or find_in_set('145', ids)>0
        or find_in_set('146', ids)>0
        or find_in_set('147', ids)>0
        or find_in_set('148', ids)>0
        or find_in_set('149', ids)>0
        or find_in_set('150', ids)>0
        or find_in_set('151', ids)>0
        or find_in_set('152', ids)>0
        or find_in_set('153', ids)>0
        or find_in_set('154', ids)>0
        or find_in_set('155', ids)>0
        or find_in_set('156', ids)>0
        or find_in_set('157', ids)>0
        or find_in_set('158', ids)>0
        or find_in_set('159', ids)>0
        or find_in_set('160', ids)>0
        or find_in_set('161', ids)>0
        or find_in_set('162', ids)>0
        or find_in_set('163', ids)>0
        or find_in_set('164', ids)>0
        or find_in_set('165', ids)>0
        or find_in_set('166', ids)>0
        or find_in_set('167', ids)>0
        or find_in_set('168', ids)>0
        or find_in_set('169', ids)>0
        or find_in_set('170', ids)>0
        or find_in_set('171', ids)>0
        or find_in_set('172', ids)>0
        or find_in_set('173', ids)>0
        or find_in_set('174', ids)>0
        or find_in_set('175', ids)>0
        or find_in_set('176', ids)>0
        or find_in_set('177', ids)>0
        or find_in_set('178', ids)>0
        or find_in_set('179', ids)>0
        or find_in_set('180', ids)>0
        or find_in_set('181', ids)>0
        or find_in_set('182', ids)>0
        or find_in_set('183', ids)>0
        or find_in_set('184', ids)>0
        or find_in_set('185', ids)>0
        or find_in_set('186', ids)>0
        or find_in_set('187', ids)>0
        or find_in_set('188', ids)>0
        or find_in_set('189', ids)>0
        or find_in_set('190', ids)>0
        or find_in_set('191', ids)>0
        or find_in_set('192', ids)>0
        or find_in_set('193', ids)>0
        or find_in_set('194', ids)>0
        or find_in_set('195', ids)>0
        or find_in_set('196', ids)>0
        or find_in_set('197', ids)>0
        or find_in_set('198', ids)>0
        or find_in_set('199', ids)>0
        or find_in_set('200', ids)>0
        or find_in_set('201', ids)>0
        or find_in_set('202', ids)>0
        or find_in_set('203', ids)>0
        or find_in_set('204', ids)>0
        or find_in_set('205', ids)>0
        or find_in_set('206', ids)>0
        or find_in_set('207', ids)>0
        or find_in_set('208', ids)>0
        or find_in_set('209', ids)>0
        or find_in_set('210', ids)>0
        or find_in_set('211', ids)>0
        or find_in_set('212', ids)>0
        or find_in_set('213', ids)>0
        or find_in_set('214', ids)>0
        or find_in_set('215', ids)>0
        or find_in_set('216', ids)>0
        or find_in_set('217', ids)>0
        or find_in_set('218', ids)>0
        or find_in_set('219', ids)>0
        or find_in_set('220', ids)>0
        or find_in_set('221', ids)>0
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [X] 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-unsubscr...@doris.apache.org.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