yoursweetie opened a new issue, #32848:
URL: https://github.com/apache/doris/issues/32848

   ### 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
   
   branch-2.0 (doris-2.0.7-b1955a9)
   
   ### What's Wrong?
   
   SELECT SQL with sub query and LIKE key words leads to BE crash
   
   ### What You Expected?
   
   work
   
   ### How to Reproduce?
   
   just execute sql as below and we'll find **all** BEs crash
   
   `CREATE table tbl
   (c1 varchar(31), c2 varchar(10))
   ENGINE=OLAP
   DUPLICATE KEY( c1 )
   COMMENT "OLAP" 
   DISTRIBUTED BY HASH( c1 ) BUCKETS  auto
   PROPERTIES (
       "replication_num" = "1" 
   );`
   
   `insert into tbl select 'ab', 'abc';`
   
   `SELECT c2 LIKE 'ab'
   FROM (
       SELECT c2 
       FROM tbl
       EXCEPT 
       SELECT 'ab' c2
   ) AS t1;`
   
   ### Anything Else?
   
   This resulted in all the BE nodes crashing, so I think it might be quite 
urgent.
   
   ### 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-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