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 2021/12/15 09:06:53 UTC
[GitHub] [shardingsphere] sandynz opened a new issue #14091: Verify scaling PostgreSQL updated record migration on incremental stage if update is ignored then improve it
sandynz opened a new issue #14091:
URL: https://github.com/apache/shardingsphere/issues/14091
## Bug Report
### Which version of ShardingSphere did you use?
master branch
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Expected behavior
Updated record should be migrated to target database.
### Reason analyze (If you can)
In `PostgreSQLScalingSQLBuilder.buildConflictSQL`, `ON CONFLICT` it `DO NOTHING`
```
private String buildConflictSQL(final DataRecord dataRecord) {
StringBuilder result = new StringBuilder(" ON CONFLICT (");
for (Column each : RecordUtil.extractPrimaryColumns(dataRecord)) {
result.append(each.getName()).append(",");
}
result.setLength(result.length() - 1);
result.append(") DO NOTHING");
return result.toString();
}
```
It seems cause issue, verification is needed for now.
`MySQLScalingSQLBuilder.buildDuplicateUpdateSQL` works.
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
### Example codes for reproduce this issue (such as a github link).
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] ReyYang commented on issue #14091: Verify scaling PostgreSQL updated record migration on incremental stage if update is ignored then improve it
Posted by GitBox <gi...@apache.org>.
ReyYang commented on issue #14091:
URL: https://github.com/apache/shardingsphere/issues/14091#issuecomment-994549918
Can i take this ? Thanks
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] ReyYang commented on issue #14091: Verify scaling PostgreSQL updated record migration on incremental stage if update is ignored then improve it
Posted by GitBox <gi...@apache.org>.
ReyYang commented on issue #14091:
URL: https://github.com/apache/shardingsphere/issues/14091#issuecomment-997782044
Hello, after my actual inspection, I found that no problems were found in the incremental update of the current situation. I look forward to your reply.
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] sandynz commented on issue #14091: Verify scaling PostgreSQL updated record migration on incremental stage if update is ignored then improve it
Posted by GitBox <gi...@apache.org>.
sandynz commented on issue #14091:
URL: https://github.com/apache/shardingsphere/issues/14091#issuecomment-997843718
@ReyYang That's ok. Thanks
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] sandynz closed issue #14091: Verify scaling PostgreSQL updated record migration on incremental stage if update is ignored then improve it
Posted by GitBox <gi...@apache.org>.
sandynz closed issue #14091:
URL: https://github.com/apache/shardingsphere/issues/14091
--
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.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org