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