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 2020/10/13 08:18:32 UTC
[GitHub] [shardingsphere] kpioneer123 removed a comment on issue #7380: shardingsphere conflict with seata
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:
users@infra.apache.org