[GitHub] [doris] wen-hemin opened a new issue, #16946: [Bug] In join sql, When the field type of the where condition is char, rollup cannot be hit

[via GitHub]

wen-hemin opened a new issue, #16946:
URL: https://github.com/apache/doris/issues/16946

   ### 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
   
   0.14
   
   ### What's Wrong?
   
   When the type of field abc in table t1 is char, join sql cannot hit rollup.
   
   table: t1
   dt    int
   abc char(2)
   gtv  int
   
   cannot hit rollup:
   select t1.dt,
          sum(t1.gtv)
     from table1 t1
    inner join table2 t2
       on t1.dt = t2.dt
    where t1.dt between 20221001 and 20221010 and t1.abc >= 'R1'
    group by t1.dt;
   
   
   char changed to varchar, same sql as above, can hit rollup:
   
   table: t1
   dt    int
   abc varchar(2)
   gtv  int
   
   ### What You Expected?
   
   char type does not affect rollup routing
   
   ### 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-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