[GitHub] [incubator-doris] zbtzbtzbt commented on issue #6499: [Enhance] add a rewrite rule of compoundPredicate 'OR' 'AND'

[GitBox <gi...@apache.org>]

zbtzbtzbt commented on issue #6499:
URL: https://github.com/apache/incubator-doris/issues/6499#issuecomment-906892387


   here is the origin SQL，the parameters received by BI tool is not sure，when front-end interface did not receive parameters，it will use default value as -2 to make the subExpr it‘s true.
   `````
   select shop_id,sum(view_shop_pv) as view_shop_pv
     from rpt_ad_shop_view_overall_rank
   where partition_date between #startDate and #endDate
     and (-2 = #city_id or city_id = #city_id)
     and (-2 = #district_id or district_id = #district_id)
     and (-2 = #region_id or region_id = #region_id)
     and (-2 = #cat0_id or cat0_id = #cat0_id)
     and (-2 = #cat1_id or cat1_id = #cat1_id)
     and (-2 = #star_range or star_range = #star_range)
   group by shop_id
   order by view_shop_pv desc
   limit 100
   `````


-- 
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