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 2019/06/19 12:47:31 UTC
[GitHub] [incubator-shardingsphere] wangjing112 opened a new issue #2587:
Update not data sharding on 4.0.0.RC2
wangjing112 opened a new issue #2587: Update not data sharding on 4.0.0.RC2
URL: https://github.com/apache/incubator-shardingsphere/issues/2587
My table config:
```
shardingRule:
tables:
t_role_info:
actualDataNodes: r_game_sub${0..1}.t_role_info${0..2}
databaseStrategy:
inline:
shardingColumn: roleId
algorithmExpression: r_game_sub${roleId % 2}
tableStrategy:
inline:
shardingColumn: roleId
algorithmExpression: t_role_info${roleId % 3}
keyGenerator:
type: SNOWFLAKE
column: roleId
```
But when i exec update sql the sql log is:
```
2019-06-19 20:41:07,720 INFO [ShardingSphere-SQL] Rule Type: sharding
2019-06-19 20:41:07,720 INFO [ShardingSphere-SQL] Logic SQL: update t_role_info set activeTime=?, head=?, headBorderId=?, level=?, lockReason=?, lockTime=?, sex=?, status=?, type=?, vipLevel=?, langStr=? where roleId=?
2019-06-19 20:41:07,720 INFO [ShardingSphere-SQL] SQLStatement: UpdateStatement(super=DMLStatement(super=AbstractSQLStatement(sqlSegments=[TableSegment(startIndex=7, stopIndex=17, name=t_role_info, quoteCharacter=NONE, owner=Optional.absent(), alias=Optional.absent()), ColumnSegment(startIndex=23, stopIndex=32, name=activeTime, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=37, stopIndex=40, name=head, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=45, stopIndex=56, name=headBorderId, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=61, stopIndex=65, name=level, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=70, stopIndex=79, name=lockReason, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=84, stopIndex=91, name=lockTime, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=96, stopIndex=98, name=sex, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=103, stopIndex=108, name=status, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=113, stopIndex=116, name=type, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=121, stopIndex=128, name=vipLevel, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=133, stopIndex=139, name=langStr, quoteCharacter=NONE, owner=Optional.absent()), ColumnSegment(startIndex=149, stopIndex=154, name=roleId, quoteCharacter=NONE, owner=Optional.absent()), org.apache.shardingsphere.core.parse.sql.segment.dml.assignment.SetAssignmentsSegment@55358433, org.apache.shardingsphere.core.parse.sql.segment.dml.WhereSegment@72f74525, org.apache.shardingsphere.core.parse.sql.segment.dml.predicate.OrPredicateSegment@666e5b2a], tables=Tables(tables=[Table(name=t_role_info, alias=Optional.absent())]), logicSQL=update t_role_info set activeTime=?, head=?, headBorderId=?, level=?, lockReason=?, lockTime=?, sex=?, status=?, type=?, vipLevel=?, langStr=? where roleId=?, parametersCount=12), shardingConditions=Conditions(orConditions=[AndCondition(conditions=[Condition(column=Column(name=roleId, tableName=t_role_info), predicateSegment=org.apache.shardingsphere.core.parse.sql.segment.dml.predicate.PredicateSegment@6ac94217, operator=EQUAL, positionValueMap={}, positionIndexMap={0=11})])]), encryptConditions=Conditions(orConditions=[])), assignments={Column(name=activeTime, tableName=t_role_info)=org.apache.shardingsphere.core.parse.sql.segment.dml.expr.simple.ParameterMarkerExpressionSegment@13244761, Column(name=head, tableName=t_role_info)=org.apache.shardingsphere.core.parse.sql.segment.dml.expr.simple.ParameterMarkerExpressionSegment@5bb2e64d, Column(name=headBorderId, tableName=t_role_info)=org.apache.shardingsphere.core.parse.sql.segment.dml.expr.simple.ParameterMarkerExpressionSegment@4f11411a, Column(name=level, tableName=t_role_info)=org.apache.shardingsphere.core.parse.sql.segment.dml.expr.simple.ParameterMarkerExpressionSegment@6fe87b15, Column(name=lockReason, tableName=t_role_info)=org.apache.shardingsphere.core.parse.sql.segment.dml.expr.simple.ParameterMarkerExpressionSegment@5e4636c6, Column(name=lockTime, tableName=t_role_info)=org.apache.shardingsphere.core.parse.sql.segment.dml.expr.simple.ParameterMarkerExpressionSegment@128a33cd, Column(name=sex, tableName=t_role_info)=org.apache.shardingsphere.core.parse.sql.segment.dml.expr.simple.ParameterMarkerExpressionSegment@57d6b917, Column(name=status, tableName=t_role_info)=org.apache.shardingsphere.core.parse.sql.segment.dml.expr.simple.ParameterMarkerExpressionSegment@7b4a502b, Column(name=type, tableName=t_role_info)=org.apache.shardingsphere.core.parse.sql.segment.dml.expr.simple.ParameterMarkerExpressionSegment@14d5b982, Column(name=vipLevel, tableName=t_role_info)=org.apache.shardingsphere.core.parse.sql.segment.dml.expr.simple.ParameterMarkerExpressionSegment@5782e48e, Column(name=langStr, tableName=t_role_info)=org.apache.shardingsphere.core.parse.sql.segment.dml.expr.simple.ParameterMarkerExpressionSegment@357ee168}, whereStartIndex=143, whereStopIndex=156, whereParameterStartIndex=11, whereParameterEndIndex=11)
2019-06-19 20:41:07,721 INFO [ShardingSphere-SQL] Actual SQL: r_game_sub0 ::: update t_role_info0 set activeTime=?, head=?, headBorderId=?, level=?, lockReason=?, lockTime=?, sex=?, status=?, type=?, vipLevel=?, langStr=? where roleId=? ::: [2019-06-19 20:38:01.0, 0, 0, 1, , 0, 0, 1, 1, 0, cn, 464170103659832306]
2019-06-19 20:41:07,721 INFO [ShardingSphere-SQL] Actual SQL: r_game_sub0 ::: update t_role_info1 set activeTime=?, head=?, headBorderId=?, level=?, lockReason=?, lockTime=?, sex=?, status=?, type=?, vipLevel=?, langStr=? where roleId=? ::: [2019-06-19 20:38:01.0, 0, 0, 1, , 0, 0, 1, 1, 0, cn, 464170103659832306]
2019-06-19 20:41:07,721 INFO [ShardingSphere-SQL] Actual SQL: r_game_sub0 ::: update t_role_info2 set activeTime=?, head=?, headBorderId=?, level=?, lockReason=?, lockTime=?, sex=?, status=?, type=?, vipLevel=?, langStr=? where roleId=? ::: [2019-06-19 20:38:01.0, 0, 0, 1, , 0, 0, 1, 1, 0, cn, 464170103659832306]
2019-06-19 20:41:07,722 INFO [ShardingSphere-SQL] Actual SQL: r_game_sub1 ::: update t_role_info0 set activeTime=?, head=?, headBorderId=?, level=?, lockReason=?, lockTime=?, sex=?, status=?, type=?, vipLevel=?, langStr=? where roleId=? ::: [2019-06-19 20:38:01.0, 0, 0, 1, , 0, 0, 1, 1, 0, cn, 464170103659832306]
2019-06-19 20:41:07,722 INFO [ShardingSphere-SQL] Actual SQL: r_game_sub1 ::: update t_role_info1 set activeTime=?, head=?, headBorderId=?, level=?, lockReason=?, lockTime=?, sex=?, status=?, type=?, vipLevel=?, langStr=? where roleId=? ::: [2019-06-19 20:38:01.0, 0, 0, 1, , 0, 0, 1, 1, 0, cn, 464170103659832306]
2019-06-19 20:41:07,722 INFO [ShardingSphere-SQL] Actual SQL: r_game_sub1 ::: update t_role_info2 set activeTime=?, head=?, headBorderId=?, level=?, lockReason=?, lockTime=?, sex=?, status=?, type=?, vipLevel=?, langStr=? where roleId=? ::: [2019-06-19 20:38:01.0, 0, 0, 1, , 0, 0, 1, 1, 0, cn, 464170103659832306]
```
----------------------------------------------------------------
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