291277058 opened a new issue #6551:
URL: https://github.com/apache/shardingsphere/issues/6551
Does shardingsphere support table chose when use update sql.In my point, i
think update sql can chose the right table by the strategy field,doed not need
update all of it.,But i got the follow result.Does some body can explain it for
me about it,thanks.
`2020-07-31 07:05:07.823 info 1172 --- [nio-8080-exec-5] ShardingSphere-SQL
: Rule Type: sharding
2020-07-31 07:05:07.823 info 1172 --- [nio-8080-exec-5] ShardingSphere-SQL :
Logic SQL: update order_item set app_id=?, create_date=?, order_info=?,
orderno=?, original_price=?, pay_date=?, pay_source=?, price=?, product_list=?,
source_orderno=?, status=?, user_id=? where id=?
2020-07-31 07:05:07.825 info 1172 --- [nio-8080-exec-5] ShardingSphere-SQL :
SQLStatement: DMLStatement(super=AbstractSQLStatement(type=DML,
tables=Tables(tables=[Table(name=order_item, alias=Optional.absent())]),
routeConditions=Conditions(orCondition=OrCondition(andConditions=[])),
encryptConditions=Conditions(orCondition=OrCondition(andConditions=[])),
sqlTokens=[TableToken(tableName=order_item, quoteCharacter=NONE,
schemaNameLength=0)], parametersIndex=13, logicSQL=update order_item set
app_id=?, create_date=?, order_info=?, orderno=?, original_price=?, pay_date=?,
pay_source=?, price=?, product_list=?, source_orderno=?, status=?, user_id=?
where id=?), deleteStatement=false, updateTableAlias={order_item=order_item},
updateColumnValues={Column(name=app_id,
tableName=order_item)=org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@78553a80,
Column(name=create_date,
tableName=order_item)=org.apache.shardingsphere.core.parse.old.parser.expression.SQ
LPlaceholderExpression@63a63f17, Column(name=order_info,
tableName=order_item)=org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@2c07b787,
Column(name=orderno,
tableName=order_item)=org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@61248ad2,
Column(name=original_price,
tableName=order_item)=org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@30742d4c,
Column(name=pay_date,
tableName=order_item)=org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@6278f2d2,
Column(name=pay_source,
tableName=order_item)=org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@7352ca95,
Column(name=price,
tableName=order_item)=org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@36e5bc37,
Column(name=product_list,
tableName=order_item)=org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpressio
n@276ae9ea, Column(name=source_orderno,
tableName=order_item)=org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@22171b7,
Column(name=status,
tableName=order_item)=org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@67421504,
Column(name=user_id,
tableName=order_item)=org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@7c5d19df},
whereStartIndex=179, whereStopIndex=188, whereParameterStartIndex=12,
whereParameterEndIndex=12)
2020-07-31 07:05:07.825 info 1172 --- [nio-8080-exec-5] ShardingSphere-SQL :
Actual SQL: master ::: update order_item20207 set app_id=?, create_date=?,
order_info=?, orderno=?, original_price=?, pay_date=?, pay_source=?, price=?,
product_list=?, source_orderno=?, status=?, user_id=? where id=? :::
[9b035964-c491-4ce5-b727-3929772e8b96, 2020-07-31 07:05:00.166, {},
202007310705005, 0.0, 2020-07-31 07:05:06.428, google, 0.0,
{"purchaseTimeMillis":"1596179102735","purchaseState":0,"consumptionState":0,"developerPayload":"","orderId":"GPA.3354-6366-5211-19811","purchaseType":0,"acknowledgementState":1,"kind":"androidpublisher#productPurchase","obfuscatedExternalAccountId":"202007310705005","obfuscatedExternalProfileId":"{\"skuType\":\"inapp\"}"},
GPA.3354-6366-5211-19811, 10, edf14b79-87a2-4bfe-9cc7-2ea20e7a7a5a,
2c9fb08a73a386e40173a3b032080004]
2020-07-31 07:05:07.825 info 1172 --- [nio-8080-exec-5] ShardingSphere-SQL :
Actual SQL: master ::: update order_item20211 set app_id=?, create_date=?,
order_info=?, orderno=?, original_price=?, pay_date=?, pay_source=?, price=?,
product_list=?, source_orderno=?, status=?, user_id=? where id=? :::
[9b035964-c491-4ce5-b727-3929772e8b96, 2020-07-31 07:05:00.166, {},
202007310705005, 0.0, 2020-07-31 07:05:06.428, google, 0.0,
{"purchaseTimeMillis":"1596179102735","purchaseState":0,"consumptionState":0,"developerPayload":"","orderId":"GPA.3354-6366-5211-19811","purchaseType":0,"acknowledgementState":1,"kind":"androidpublisher#productPurchase","obfuscatedExternalAccountId":"202007310705005","obfuscatedExternalProfileId":"{\"skuType\":\"inapp\"}"},
GPA.3354-6366-5211-19811, 10, edf14b79-87a2-4bfe-9cc7-2ea20e7a7a5a,
2c9fb08a73a386e40173a3b032080004]
2020-07-31 07:05:07.827 info 1172 --- [nio-8080-exec-5] ShardingSphere-SQL :
Actual SQL: master ::: update order_item20217 set app_id=?, create_date=?,
order_info=?, orderno=?, original_price=?, pay_date=?, pay_source=?, price=?,
product_list=?, source_orderno=?, status=?, user_id=? where id=? :::
[9b035964-c491-4ce5-b727-3929772e8b96, 2020-07-31 07:05:00.166, {},
202007310705005, 0.0, 2020-07-31 07:05:06.428, google, 0.0,
{"purchaseTimeMillis":"1596179102735","purchaseState":0,"consumptionState":0,"developerPayload":"","orderId":"GPA.3354-6366-5211-19811","purchaseType":0,"acknowledgementState":1,"kind":"androidpublisher#productPurchase","obfuscatedExternalAccountId":"202007310705005","obfuscatedExternalProfileId":"{\"skuType\":\"inapp\"}"},
GPA.3354-6366-5211-19811, 10, edf14b79-87a2-4bfe-9cc7-2ea20e7a7a5a,
2c9fb08a73a386e40173a3b032080004]
2020-07-31 07:05:07.827 info 1172 --- [nio-8080-exec-5] ShardingSphere-SQL :
Actual SQL: master ::: update order_item20221 set app_id=?, create_date=?,
order_info=?, orderno=?, original_price=?, pay_date=?, pay_source=?, price=?,
product_list=?, source_orderno=?, status=?, user_id=? where id=? :::
[9b035964-c491-4ce5-b727-3929772e8b96, 2020-07-31 07:05:00.166, {},
202007310705005, 0.0, 2020-07-31 07:05:06.428, google, 0.0,
{"purchaseTimeMillis":"1596179102735","purchaseState":0,"consumptionState":0,"developerPayload":"","orderId":"GPA.3354-6366-5211-19811","purchaseType":0,"acknowledgementState":1,"kind":"androidpublisher#productPurchase","obfuscatedExternalAccountId":"202007310705005","obfuscatedExternalProfileId":"{\"skuType\":\"inapp\"}"},
GPA.3354-6366-5211-19811, 10, edf14b79-87a2-4bfe-9cc7-2ea20e7a7a5a,
2c9fb08a73a386e40173a3b032080004]
2020-07-31 07:05:07.827 info 1172 --- [nio-8080-exec-5] ShardingSphere-SQL :
Actual SQL: master ::: update order_item20227 set app_id=?, create_date=?,
order_info=?, orderno=?, original_price=?, pay_date=?, pay_source=?, price=?,
product_list=?, source_orderno=?, status=?, user_id=? where id=? :::
[9b035964-c491-4ce5-b727-3929772e8b96, 2020-07-31 07:05:00.166, {},
202007310705005, 0.0, 2020-07-31 07:05:06.428, google, 0.0,
{"purchaseTimeMillis":"1596179102735","purchaseState":0,"consumptionState":0,"developerPayload":"","orderId":"GPA.3354-6366-5211-19811","purchaseType":0,"acknowledgementState":1,"kind":"androidpublisher#productPurchase","obfuscatedExternalAccountId":"202007310705005","obfuscatedExternalProfileId":"{\"skuType\":\"inapp\"}"},
GPA.3354-6366-5211-19811, 10, edf14b79-87a2-4bfe-9cc7-2ea20e7a7a5a,
2c9fb08a73a386e40173a3b032080004]`
----------------------------------------------------------------
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:
[email protected]
