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

   ### 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
   
   2.02
   
   ### What's Wrong?
   
   select
     order0_.id as id
     order0_.station_id as station_id
   from
     t_order order0_
   where
     order0_.station_id = '2112164070562641600014'
     and (
       order0_.station_id = '2112164070562641600014'
       or order0_.station_id = '2112164070562549300039'
       or order0_.station_id = '2112164070562619500024'
       or order0_.station_id = '2112164070562600100032'
       or order0_.station_id = '2112164070562579400043'
     )
     and order0_.created_date >= '2023-12-19 00:00:00.0'
   limit
     20
   
   ### What You Expected?
   
   
   id | station_id
   -- | --
   2312170295217756705375 | 2112164070562549300039
   2312170295217776005379 | 2112164070562549300039
   2312170295217789605383 | 2112164070562549300039
   2312170295217811605387 | 2112164070562549300039
   2312170295217840905391 | 2112164070562549300039
   2312170295217865805395 | 2112164070562549300039
   2312170295217884805399 | 2112164070562549300039
   2312170295217914005303 | 2112164070562549300039
   2312170295217930805307 | 2112164070562549300039
   2312170295217948905311 | 2112164070562549300039
   2312170295747840405346 | 2112164070562641600014
   2312170295747859205352 | 2112164070562641600014
   2312170295747877205356 | 2112164070562641600014
   2312170295747898705360 | 2112164070562641600014
   2312170295766345805365 | 2112164070562641600014
   2312170295766365005369 | 2112164070562641600014
   2312170295766384705373 | 2112164070562641600014
   2312170295766400705377 | 2112164070562641600014
   2312170295880049405349 | 2112164070562641600014
   2312170295880083905353 | 2112164070562641600014
   
   结果station_id应该都是  2112164070562641600014
   
   ### 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to