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:25:40 UTC
[GitHub] [incubator-shardingsphere] huweidada opened a new issue #3998:
4.0.0-RC1 join bug
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:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] huweidada closed issue #3998: 4.0.0-RC1
join bug
Posted by GitBox <gi...@apache.org>.
huweidada closed issue #3998: 4.0.0-RC1 join bug
URL: https://github.com/apache/incubator-shardingsphere/issues/3998
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] SteNicholas commented on issue #3998:
4.0.0-RC1 join bug
Posted by GitBox <gi...@apache.org>.
SteNicholas commented on issue #3998: 4.0.0-RC1 join bug
URL: https://github.com/apache/incubator-shardingsphere/issues/3998#issuecomment-575109630
@huweidada Please use the latest version to confirm this bug.
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] SteNicholas commented on issue #3998:
4.0.0-RC1 join bug
Posted by GitBox <gi...@apache.org>.
SteNicholas commented on issue #3998: 4.0.0-RC1 join bug
URL: https://github.com/apache/incubator-shardingsphere/issues/3998#issuecomment-575417660
@huweidada welcome to make any use issue.
----------------------------------------------------------------
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
[GitHub] [incubator-shardingsphere] huweidada commented on issue #3998:
4.0.0-RC1 join bug
Posted by GitBox <gi...@apache.org>.
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:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] huweidada commented on issue #3998:
4.0.0-RC1 join bug
Posted by GitBox <gi...@apache.org>.
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