You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/01/16 11:26:12 UTC

[GitHub] [incubator-shardingsphere] huweidada commented on issue #3998: 4.0.0-RC1 join bug

huweidada commented on issue #3998: 4.0.0-RC1 join bug
URL: https://github.com/apache/incubator-shardingsphere/issues/3998#issuecomment-575108669
 
 
   SELECT 
   	  COUNT(*) 
   	FROM
   	  sku 
   	  INNER JOIN sku_code 
   	  INNER JOIN sku_model 
   	  INNER JOIN model 
   	  INNER JOIN category 
   	    ON sku.id = sku_code.sku_id 
   	    AND sku.id = sku_model.sku_id 
   	    AND sku_model.model_id = model.id 
   	    AND model.category_id = category.id 
        
          
       
        WHERE (  sku.owner_org_id = ?
                   
               
                 
                     and sku_code.owner_org_id = ?
                   
               
                 
                     and sku_model.owner_org_id = ?
                   
               
                 
                     and model.owner_org_id = ?
                   
               
                 
                     and category.owner_org_id = ?
                   
               
                 
                     and sku.name like ? )
           
         
           
             or(  sku.owner_org_id = ?
                   
               
                 
                     and sku_code.owner_org_id = ?
                   
               
                 
                     and sku_model.owner_org_id = ?
                   
               
                 
                     and model.owner_org_id = ?
                   
               
                 
                     and category.owner_org_id = ?
                   
               
                 
                     and sku_code.tenant_uuid_code like ? )

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services