zkzong commented on issue #11072: URL: https://github.com/apache/shardingsphere/issues/11072#issuecomment-872654276
> Can you set this configuration "spring.shardingsphere.props.sql.show=true", and provider the log. ``` -------------- Process Success Begin --------------- ---------------------------- Insert Data ---------------------------- [INFO ] 2021-07-02 09:43:48,367 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,367 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@685d7ba5, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@16d41725), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@16d41725, columnNames=[user_id, address_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=58, stopIndex=58, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=2)], parameters=[1, 1, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,367 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_0 (user_id, address_id, status) VALUES (?, ?, ?); ::: [1, 1, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,367 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_1 (user_id, address_id, status) VALUES (?, ?, ?); ::: [1, 1, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,445 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,445 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@2e45a357, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@389a5022), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@389a5022, columnNames=[order_id, user_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=67, stopIndex=67, parameterMarkerIndex=2)], parameters=[1, 1, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,445 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_item_1 (order_id, user_id, status) VALUES (?, ?, ?); ::: [1, 1, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,451 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,451 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@685d7ba5, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@53cb0bcb), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@53cb0bcb, columnNames=[user_id, address_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=58, stopIndex=58, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=2)], parameters=[2, 2, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,451 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_0 (user_id, address_id, status) VALUES (?, ?, ?); ::: [2, 2, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,451 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_1 (user_id, address_id, status) VALUES (?, ?, ?); ::: [2, 2, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,459 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,459 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@2e45a357, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@684372d0), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@684372d0, columnNames=[order_id, user_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=67, stopIndex=67, parameterMarkerIndex=2)], parameters=[2, 2, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,459 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_item_0 (order_id, user_id, status) VALUES (?, ?, ?); ::: [2, 2, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,464 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,464 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@685d7ba5, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@7574d4ad), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@7574d4ad, columnNames=[user_id, address_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=58, stopIndex=58, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=2)], parameters=[3, 3, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,464 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_0 (user_id, address_id, status) VALUES (?, ?, ?); ::: [3, 3, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,464 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_1 (user_id, address_id, status) VALUES (?, ?, ?); ::: [3, 3, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,471 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,471 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@2e45a357, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@6060146b), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@6060146b, columnNames=[order_id, user_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=67, stopIndex=67, parameterMarkerIndex=2)], parameters=[3, 3, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,471 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_item_1 (order_id, user_id, status) VALUES (?, ?, ?); ::: [3, 3, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,476 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,476 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@685d7ba5, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@1af677f8), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@1af677f8, columnNames=[user_id, address_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=58, stopIndex=58, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=2)], parameters=[4, 4, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,476 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_0 (user_id, address_id, status) VALUES (?, ?, ?); ::: [4, 4, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,476 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_1 (user_id, address_id, status) VALUES (?, ?, ?); ::: [4, 4, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,486 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,486 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@2e45a357, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@2dcd0e41), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@2dcd0e41, columnNames=[order_id, user_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=67, stopIndex=67, parameterMarkerIndex=2)], parameters=[4, 4, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,486 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_item_0 (order_id, user_id, status) VALUES (?, ?, ?); ::: [4, 4, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,491 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,491 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@685d7ba5, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@5940b14e), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@5940b14e, columnNames=[user_id, address_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=58, stopIndex=58, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=2)], parameters=[5, 5, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,491 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_0 (user_id, address_id, status) VALUES (?, ?, ?); ::: [5, 5, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,491 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_1 (user_id, address_id, status) VALUES (?, ?, ?); ::: [5, 5, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,500 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,500 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@2e45a357, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@66d3b881), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@66d3b881, columnNames=[order_id, user_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=67, stopIndex=67, parameterMarkerIndex=2)], parameters=[5, 5, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,500 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_item_1 (order_id, user_id, status) VALUES (?, ?, ?); ::: [5, 5, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,505 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,505 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@685d7ba5, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@74431b9c), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@74431b9c, columnNames=[user_id, address_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=58, stopIndex=58, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=2)], parameters=[6, 6, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,505 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_0 (user_id, address_id, status) VALUES (?, ?, ?); ::: [6, 6, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,505 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_1 (user_id, address_id, status) VALUES (?, ?, ?); ::: [6, 6, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,514 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,514 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@2e45a357, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@3e0a9b1d), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@3e0a9b1d, columnNames=[order_id, user_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=67, stopIndex=67, parameterMarkerIndex=2)], parameters=[6, 6, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,514 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_item_0 (order_id, user_id, status) VALUES (?, ?, ?); ::: [6, 6, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,519 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,519 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@685d7ba5, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@240a2619), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@240a2619, columnNames=[user_id, address_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=58, stopIndex=58, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=2)], parameters=[7, 7, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,519 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_0 (user_id, address_id, status) VALUES (?, ?, ?); ::: [7, 7, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,519 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_1 (user_id, address_id, status) VALUES (?, ?, ?); ::: [7, 7, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,529 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,529 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@2e45a357, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@5d1a859c), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@5d1a859c, columnNames=[order_id, user_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=67, stopIndex=67, parameterMarkerIndex=2)], parameters=[7, 7, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,529 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_item_1 (order_id, user_id, status) VALUES (?, ?, ?); ::: [7, 7, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,535 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,536 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@685d7ba5, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@3070f3e6), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@3070f3e6, columnNames=[user_id, address_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=58, stopIndex=58, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=2)], parameters=[8, 8, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,536 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_0 (user_id, address_id, status) VALUES (?, ?, ?); ::: [8, 8, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,536 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_1 (user_id, address_id, status) VALUES (?, ?, ?); ::: [8, 8, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,544 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,545 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@2e45a357, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@21516c88), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@21516c88, columnNames=[order_id, user_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=67, stopIndex=67, parameterMarkerIndex=2)], parameters=[8, 8, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,545 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_item_0 (order_id, user_id, status) VALUES (?, ?, ?); ::: [8, 8, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,550 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,550 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@685d7ba5, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@4fc6e776), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@4fc6e776, columnNames=[user_id, address_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=58, stopIndex=58, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=2)], parameters=[9, 9, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,550 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_0 (user_id, address_id, status) VALUES (?, ?, ?); ::: [9, 9, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,550 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_1 (user_id, address_id, status) VALUES (?, ?, ?); ::: [9, 9, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,560 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,560 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@2e45a357, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@e01a26b), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@e01a26b, columnNames=[order_id, user_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=67, stopIndex=67, parameterMarkerIndex=2)], parameters=[9, 9, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,560 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_item_1 (order_id, user_id, status) VALUES (?, ?, ?); ::: [9, 9, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,565 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order (user_id, address_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,565 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@685d7ba5, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@314b7945), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@314b7945, columnNames=[user_id, address_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=58, stopIndex=58, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=2)], parameters=[10, 10, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,565 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_0 (user_id, address_id, status) VALUES (?, ?, ?); ::: [10, 10, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,565 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_1 (user_id, address_id, status) VALUES (?, ?, ?); ::: [10, 10, INSERT_TEST] [INFO ] 2021-07-02 09:43:48,576 --main-- [ShardingSphere-SQL] Logic SQL: INSERT INTO t_order_item (order_id, user_id, status) VALUES (?, ?, ?); [INFO ] 2021-07-02 09:43:48,576 --main-- [ShardingSphere-SQL] SQLStatement: InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@2e45a357, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@4aa22cc2), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@4aa22cc2, columnNames=[order_id, user_id, status], insertValueContexts=[InsertValueContext(parametersCount=3, valueExpressions=[ParameterMarkerExpressionSegment(startIndex=61, stopIndex=61, parameterMarkerIndex=0), ParameterMarkerExpressionSegment(startIndex=64, stopIndex=64, parameterMarkerIndex=1), ParameterMarkerExpressionSegment(startIndex=67, stopIndex=67, parameterMarkerIndex=2)], parameters=[10, 10, INSERT_TEST])], generatedKeyContext=Optional.empty) [INFO ] 2021-07-02 09:43:48,576 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: INSERT INTO t_order_item_0 (order_id, user_id, status) VALUES (?, ?, ?); ::: [10, 10, INSERT_TEST] ---------------------------- Print Order Data ----------------------- [INFO ] 2021-07-02 09:43:48,601 --main-- [ShardingSphere-SQL] Logic SQL: SELECT * FROM t_order; [INFO ] 2021-07-02 09:43:48,601 --main-- [ShardingSphere-SQL] SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@7b1a30e5, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@1de7f898), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@1de7f898, projectionsContext=ProjectionsContext(startIndex=7, stopIndex=7, distinctRow=false, projections=[ShorthandProjection(owner=Optional.empty, actualColumns=[ColumnProjection(owner=null, name=order_id, alias=Optional.empty), ColumnProjection(owner=null, name=user_id, alias=Optional.empty), ColumnProjection(owner=null, name=address_id, alias=Optional.empty), ColumnProjection(owner=null, name=status, alias=Optional.empty)])]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@34fcd292, orderByContext=org.apache.shardingsphere.sql. parser.binder.segment.select.orderby.OrderByContext@63db743d, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@496cedbb, containsSubquery=false) [INFO ] 2021-07-02 09:43:48,601 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: SELECT * FROM t_order_0; [INFO ] 2021-07-02 09:43:48,601 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: SELECT * FROM t_order_1; Order(orderId=1, userId=1, addressId=1, status=INSERT_TEST) Order(orderId=2, userId=2, addressId=2, status=INSERT_TEST) Order(orderId=3, userId=3, addressId=3, status=INSERT_TEST) Order(orderId=4, userId=4, addressId=4, status=INSERT_TEST) Order(orderId=5, userId=5, addressId=5, status=INSERT_TEST) Order(orderId=6, userId=6, addressId=6, status=INSERT_TEST) Order(orderId=7, userId=7, addressId=7, status=INSERT_TEST) Order(orderId=8, userId=8, addressId=8, status=INSERT_TEST) Order(orderId=9, userId=9, addressId=9, status=INSERT_TEST) Order(orderId=10, userId=10, addressId=10, status=INSERT_TEST) Order(orderId=1, userId=1, addressId=1, status=INSERT_TEST) Order(orderId=2, userId=2, addressId=2, status=INSERT_TEST) Order(orderId=3, userId=3, addressId=3, status=INSERT_TEST) Order(orderId=4, userId=4, addressId=4, status=INSERT_TEST) Order(orderId=5, userId=5, addressId=5, status=INSERT_TEST) Order(orderId=6, userId=6, addressId=6, status=INSERT_TEST) Order(orderId=7, userId=7, addressId=7, status=INSERT_TEST) Order(orderId=8, userId=8, addressId=8, status=INSERT_TEST) Order(orderId=9, userId=9, addressId=9, status=INSERT_TEST) Order(orderId=10, userId=10, addressId=10, status=INSERT_TEST) ---------------------------- Print OrderItem Data ------------------- [INFO ] 2021-07-02 09:43:48,654 --main-- [ShardingSphere-SQL] Logic SQL: SELECT i.* FROM t_order o, t_order_item i WHERE o.order_id = i.order_id; [INFO ] 2021-07-02 09:43:48,654 --main-- [ShardingSphere-SQL] SQLStatement: SelectStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.SelectStatement@6a6d1ff3, tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@64b73e0a), tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@64b73e0a, projectionsContext=ProjectionsContext(startIndex=7, stopIndex=9, distinctRow=false, projections=[ShorthandProjection(owner=Optional[i], actualColumns=[ColumnProjection(owner=i, name=order_item_id, alias=Optional.empty), ColumnProjection(owner=i, name=order_id, alias=Optional.empty), ColumnProjection(owner=i, name=user_id, alias=Optional.empty), ColumnProjection(owner=i, name=status, alias=Optional.empty)])]), groupByContext=org.apache.shardingsphere.sql.parser.binder.segment.select.groupby.GroupByContext@57c6feea, orderByContext=org.apache.shardingsphere.sql.parser.binde r.segment.select.orderby.OrderByContext@3b57f915, paginationContext=org.apache.shardingsphere.sql.parser.binder.segment.select.pagination.PaginationContext@39c7fb0b, containsSubquery=false) [INFO ] 2021-07-02 09:43:48,654 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: SELECT i.* FROM t_order_0 o, t_order_item_1 i WHERE o.order_id = i.order_id; [INFO ] 2021-07-02 09:43:48,654 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: SELECT i.* FROM t_order_0 o, t_order_item_0 i WHERE o.order_id = i.order_id; [INFO ] 2021-07-02 09:43:48,654 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: SELECT i.* FROM t_order_1 o, t_order_item_1 i WHERE o.order_id = i.order_id; [INFO ] 2021-07-02 09:43:48,654 --main-- [ShardingSphere-SQL] Actual SQL: ds ::: SELECT i.* FROM t_order_1 o, t_order_item_0 i WHERE o.order_id = i.order_id; OrderItem(orderItemId=1, orderId=1, userId=1, status=INSERT_TEST) OrderItem(orderItemId=2, orderId=3, userId=3, status=INSERT_TEST) OrderItem(orderItemId=3, orderId=5, userId=5, status=INSERT_TEST) OrderItem(orderItemId=4, orderId=7, userId=7, status=INSERT_TEST) OrderItem(orderItemId=5, orderId=9, userId=9, status=INSERT_TEST) OrderItem(orderItemId=1, orderId=2, userId=2, status=INSERT_TEST) OrderItem(orderItemId=2, orderId=4, userId=4, status=INSERT_TEST) OrderItem(orderItemId=3, orderId=6, userId=6, status=INSERT_TEST) OrderItem(orderItemId=4, orderId=8, userId=8, status=INSERT_TEST) OrderItem(orderItemId=5, orderId=10, userId=10, status=INSERT_TEST) OrderItem(orderItemId=1, orderId=1, userId=1, status=INSERT_TEST) OrderItem(orderItemId=2, orderId=3, userId=3, status=INSERT_TEST) OrderItem(orderItemId=3, orderId=5, userId=5, status=INSERT_TEST) OrderItem(orderItemId=4, orderId=7, userId=7, status=INSERT_TEST) OrderItem(orderItemId=5, orderId=9, userId=9, status=INSERT_TEST) OrderItem(orderItemId=1, orderId=2, userId=2, status=INSERT_TEST) OrderItem(orderItemId=2, orderId=4, userId=4, status=INSERT_TEST) OrderItem(orderItemId=3, orderId=6, userId=6, status=INSERT_TEST) OrderItem(orderItemId=4, orderId=8, userId=8, status=INSERT_TEST) OrderItem(orderItemId=5, orderId=10, userId=10, status=INSERT_TEST) -------------- Process Success Finish -------------- ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
