kindess opened a new issue #9321:
URL: https://github.com/apache/shardingsphere/issues/9321
Logic SQL: insert into tb_notice( title,contents,is_draft,is_cancel,
is_send, add_time, is_sys, users,is_delete,user_id, is_attach,type,company_id,
is_sms ) values ( ?,?,?,?,?, ?,?, ?,?,? ?,?,?,? )
SQLStatement:
ShardingInsertOptimizedStatement(super=ShardingConditionOptimizedStatement(tables=Tables(tables=[Table(name=tb_notice,
alias=Optional.absent())], schema=Optional.absent()),
shardingConditions=ShardingConditions(conditions=[ShardingCondition(routeValues=[ListRouteValue(columnName=user_id,
tableName=tb_notice, values=[5])])]),
encryptConditions=EncryptConditions(conditions=[])),
tables=Tables(tables=[Table(name=tb_notice, alias=Optional.absent())],
schema=Optional.absent()),
insertColumns=ShardingInsertColumns(generateKeyColumnName=id,
assistedQueryAndPlainColumnNames=[], regularColumnNames=[title, contents,
is_draft, is_cancel, is_send, add_time, is_sys, users, is_delete, user_id,
is_attach, type, company_id, is_sms]),
values=[InsertValue(assignments=[ParameterMarkerExpressionSegment(startIndex=372,
stopIndex=372, parameterMarkerIndex=0),
ParameterMarkerExpressionSegment(startIndex=387, stopIndex=387,
parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startInde
x=415, stopIndex=415, parameterMarkerIndex=2),
ParameterMarkerExpressionSegment(startIndex=430, stopIndex=430,
parameterMarkerIndex=3), ParameterMarkerExpressionSegment(startIndex=458,
stopIndex=458, parameterMarkerIndex=4),
ParameterMarkerExpressionSegment(startIndex=473, stopIndex=473,
parameterMarkerIndex=5), ParameterMarkerExpressionSegment(startIndex=488,
stopIndex=488, parameterMarkerIndex=6),
ParameterMarkerExpressionSegment(startIndex=503, stopIndex=503,
parameterMarkerIndex=7), ParameterMarkerExpressionSegment(startIndex=518,
stopIndex=518, parameterMarkerIndex=8),
ParameterMarkerExpressionSegment(startIndex=533, stopIndex=533,
parameterMarkerIndex=9), ParameterMarkerExpressionSegment(startIndex=562,
stopIndex=562, parameterMarkerIndex=10),
ParameterMarkerExpressionSegment(startIndex=577, stopIndex=577,
parameterMarkerIndex=11), ParameterMarkerExpressionSegment(startIndex=592,
stopIndex=592, parameterMarkerIndex=12)])],
generatedKey=Optional.of(GeneratedKey(columnName=id, g
enerated=true, generatedValues=[564143474115346433])),
units=[InsertOptimizeResultUnit(columnNames=[title, contents, is_draft,
is_cancel, is_send, add_time, is_sys, users, is_delete, user_id, is_attach,
type, company_id, is_sms, id],
values=[ParameterMarkerExpressionSegment(startIndex=372, stopIndex=372,
parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=387,
stopIndex=387, parameterMarkerIndex=1),
ParameterMarkerExpressionSegment(startIndex=415, stopIndex=415,
parameterMarkerIndex=2), ParameterMarkerExpressionSegment(startIndex=430,
stopIndex=430, parameterMarkerIndex=3),
ParameterMarkerExpressionSegment(startIndex=458, stopIndex=458,
parameterMarkerIndex=4), ParameterMarkerExpressionSegment(startIndex=473,
stopIndex=473, parameterMarkerIndex=5),
ParameterMarkerExpressionSegment(startIndex=488, stopIndex=488,
parameterMarkerIndex=6), ParameterMarkerExpressionSegment(startIndex=503,
stopIndex=503, parameterMarkerIndex=7),
ParameterMarkerExpressionSegment(startIndex
=518, stopIndex=518, parameterMarkerIndex=8),
ParameterMarkerExpressionSegment(startIndex=533, stopIndex=533,
parameterMarkerIndex=9), ParameterMarkerExpressionSegment(startIndex=562,
stopIndex=562, parameterMarkerIndex=10),
ParameterMarkerExpressionSegment(startIndex=577, stopIndex=577,
parameterMarkerIndex=11), ParameterMarkerExpressionSegment(startIndex=592,
stopIndex=592, parameterMarkerIndex=12),
ParameterMarkerExpressionSegment(startIndex=0, stopIndex=0,
parameterMarkerIndex=13)], parameters=[%E5%BC%80%E4%BC%9A110%E5%8F%B7,
%3Cp%3E%E5%BC%80%E4%BC%9A202%3C/p%3E, 0, 0, 1, 2017-06-22 07:07:34.0, false,
2,8,3,4,5,7, 0, 5, 0, %E5%8F%AF%E4%BB%A5%E8%BF%9F%E5%88%B0, 1,
564143474115346433], startIndexOfAppendedParameters=13)])
Actual SQL: oa-notice ::: insert into tb_notice_6 ( title, contents,
is_draft, is_cancel,is_send,add_time,is_sys, users,is_delete,
user_id,is_attach,type,company_id,is_sms , id) values(?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?) ::: [%E5%BC%80%E4%BC%9A110%E5%8F%B7,
%3Cp%3E%E5%BC%80%E4%BC%9A202%3C/p%3E, 0, 0, 1, 2017-06-22 07:07:34.0, false,
2,8,3,4,5,7, 0, 5, 0, %E5%8F%AF%E4%BB%A5%E8%BF%9F%E5%88%B0, 1,
564143474115346433]
----------------------------------------------------------------
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]
