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

2020-01-16 Thread GitBox 
huweidada commented on issue #3998: 4.0.0-RC1 join bug
URL: 
https://github.com/apache/incubator-shardingsphere/issues/3998#issuecomment-575415479
 
 
   switch 4.0.0 version，the bug disappear.
   thanks!
   @SteNicholas


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

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

2020-01-16 Thread GitBox 
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:
us...@infra.apache.org


With regards,
Apache Git Services