kpioneer123 removed a comment on issue #7380:
URL: https://github.com/apache/shardingsphere/issues/7380#issuecomment-707575481
16:13:01.839 INFO [main] ShardingSphere-SQL - Logic SQL: insert into
book_fans (book_id, user_id, fans_type,
punch_start_date, punch_last_date,running_days,total_days)
values (?, ?, ?,
?, ?,?, ?)
ON DUPLICATE KEY UPDATE
book_id=values(book_id),
user_id=values(user_id),
fans_type=values(fans_type),
punch_start_date=values(punch_start_date),
punch_last_date=values(punch_last_date),
running_days=values(running_days),
total_days=values(total_days)
16:13:01.840 INFO [main] ShardingSphere-SQL - SQLStatement:
InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@7980eb2,
tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@15cba6dc),
tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@15cba6dc,
columnNames=[book_id, user_id, fans_type, punch_start_date, punch_last_date,
running_days, total_days],
insertValueContexts=[InsertValueContext(parametersCount=7,
valueExpressions=[ParameterMarkerExpressionSegment(startIndex=129,
stopIndex=129, parameterMarkerIndex=0),
ParameterMarkerExpressionSegment(startIndex=132, stopIndex=132,
parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=135,
stopIndex=135, parameterMarkerIndex=2),
ParameterMarkerExpressionSegment(startIndex=144, stopIndex=144,
parameterMarkerIndex=3), ParameterMarkerExpressionSegment(startIndex=147, stopI
ndex=147, parameterMarkerIndex=4),
ParameterMarkerExpressionSegment(startIndex=149, stopIndex=149,
parameterMarkerIndex=5), ParameterMarkerExpressionSegment(startIndex=152,
stopIndex=152, parameterMarkerIndex=6)], parameters=[100103, 100068863, 0,
20201013, 20201013, 1, 1])], generatedKeyContext=Optional.empty)
16:13:01.840 INFO [main] ShardingSphere-SQL - Actual SQL: master :::
insert into book_fans (book_id, user_id, fans_type,
punch_start_date, punch_last_date,running_days,total_days)
values (?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
book_id=values(book_id),
user_id=values(user_id),
fans_type=values(fans_type),
punch_start_date=values(punch_start_date),
punch_last_date=values(punch_last_date),
running_days=values(running_days),
total_days=values(total_days) ::: [100103, 100068863, 0,
20201013, 20201013, 1, 1]
16:13:01.900 INFO [main] ShardingSphere-SQL - Logic SQL: SELECT * FROM
book_fans WHERE (id ) in ( (?) )
16:13:01.900 INFO [main] ShardingSphere-SQL - SQLStatement:
SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@601c953c,
tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@5ca67657),
tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@5ca67657,
projectionsContext=ProjectionsContext(startIndex=7, stopIndex=7,
distinctRow=false, projections=[ShorthandProjection(owner=Optional.empty,
actualColumns=[ColumnProjection(owner=null, name=id, alias=Optional.empty),
ColumnProjection(owner=null, name=book_id, alias=Optional.empty),
ColumnProjection(owner=null, name=user_id, alias=Optional.empty),
ColumnProjection(owner=null, name=fans_type, alias=Optional.empty),
ColumnProjection(owner=null, name=punch_start_date, alias=Optional.empty),
ColumnProjection(owner=null, name=punch_last_date, alias=Optional.empty),
ColumnProjection(owner=nul
l, name=create_time, alias=Optional.empty), ColumnProjection(owner=null,
name=update_time, alias=Optional.empty), ColumnProjection(owner=null,
name=running_days, alias=Optional.empty), ColumnProjection(owner=null,
name=total_days, alias=Optional.empty)])]),
groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@561f982f,
orderByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.orderby.OrderByContext@3ed79f41,
paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@3ae648d2,
containsSubquery=false)
16:13:01.900 INFO [main] ShardingSphere-SQL - Actual SQL: master :::
SELECT * FROM book_fans WHERE (id ) in ( (?) ) ::: [559]
----------------------------------------------------------------
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]
