huweidada opened a new issue #3998: 4.0.0-RC1 join bug
URL: https://github.com/apache/incubator-shardingsphere/issues/3998
 
 
   SELECT 
          COUNT(*) 
        FROM
          sku_25 
          INNER JOIN sku_code_25 
          INNER JOIN sku_model_25 
          INNER JOIN model_25 
          INNER JOIN category_25 
            ON sku_25.id = sku_code_25.sku_id 
            AND sku_25.id = sku_model_25.sku_id 
            AND sku_model_25.model_id = model_25.id 
            AND model_25.category_id = category_25.id 
        
          
       
        WHERE (  sku_25.owner_org_id = ?
                   
               
                 
                     and sku_code_25.owner_org_id = ?
                   
               
                 
                     and sku_model_25.owner_org_id = ?
                   
               
                 
                     and model_25.owner_org_id = ?
                   
               
                 
                     and category_25.owner_org_id = ?
                   
               
                 
                     and sku.name like ? )
           
         
           
             or(  sku_25.owner_org_id = ?
                   
               
                 
                     and sku_code_25.owner_org_id = ?
                   
               
                 
                     and sku_model_25.owner_org_id = ?
                   
               
                 
                     and model_25.owner_org_id = ?
                   
               
                 
                     and category_25.owner_org_id = ?
                   
               
                 
                     and sku_code.tenant_uuid_code like ? )
   
   
   sku.name rewrite fail

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services

Reply via email to