yangjwInRiver commented on issue #2819: How to turn off keyGenerator feature in 4.0.0-RC1 version URL: https://github.com/apache/incubator-shardingsphere/issues/2819#issuecomment-521184558 ``` Logic SQL: INSERT INTO t_account_record ( id, record_no, order_no, account_no, trade_type, amount, fee_rate, trade_time, complete_time, channel_type, channel_no, fund_direction, status, owner_type, track, gmt8_create ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 2019-08-14 17:52:45.242 INFO 10800 --- [nio-9036-exec-1] ShardingSphere-SQL : SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=t_account_record, alias=Optional.absent())]), routeConditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=record_no, tableName=t_account_record), operator=EQUAL, compareOperator=null, positionValueMap={}, positionIndexMap={0=1}), Condition(column=Column(name=account_no, tableName=t_account_record), operator=EQUAL, compareOperator=null, positionValueMap={}, positionIndexMap={0=3}), Condition(column=Column(name=gmt8_create, tableName=t_account_record), operator=EQUAL, compareOperator=null, positionValueMap={}, positionIndexMap={0=15})])])), encryptConditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(tableName=t_account_record, quoteCharacter=NONE, schemaNameLength=0), SQLToken(startIndex=30)], parametersIndex=16, logicSQL=INSERT INTO t_account_record ( id, record_no, order_no, account_no, trade_type, amount, fee_rate, trade_time, complete_time, channel_type, channel_no, fund_direction, status, owner_type, track, gmt8_create ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )), deleteStatement=false, updateTableAlias={}, updateColumnValues={}, whereStartIndex=0, whereStopIndex=0, whereParameterStartIndex=0, whereParameterEndIndex=0), columnNames=[id, record_no, order_no, account_no, trade_type, amount, fee_rate, trade_time, complete_time, channel_type, channel_no, fund_direction, status, owner_type, track, gmt8_create], values=[InsertValue(columnValues=[org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@c11dc0e, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@bfdb2da, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@23494c60, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@24ed7bbd, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@261e2282, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@40932ff9, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@295051c7, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@662ff7c3, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@31f2c3b6, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@6847de96, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@43327430, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@5aba027a, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@7d7295e8, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@2b1747be, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@7b543518, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@717741da])]) 2019-08-14 17:52:45.242 INFO 10800 --- [nio-9036-exec-1] ShardingSphere-SQL : Actual SQL: master ::: INSERT INTO t_account_record_201908 (id, record_no, order_no, account_no, trade_type, amount, fee_rate, trade_time, complete_time, channel_type, channel_no, fund_direction, status, owner_type, track, gmt8_create) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ::: [1161576361672871937, RD1161576357721800769201908, PR76650-1618005454-2093736587, AT1161537493854584848, 2, 6.00, 0, 2019-08-14 17:52:34.0, 2019-08-14 17:52:39.389, 4, AT22, 1, 1, 3, TK1161576357679857730, 2019-08-14 17:52:39.391] 2019-08-14 17:52:45.249 INFO 10800 --- [nio-9036-exec-1] ShardingSphere-SQL : Rule Type: sharding 2019-08-14 17:52:45.249 INFO 10800 --- [nio-9036-exec-1] ShardingSphere-SQL : Logic SQL: INSERT INTO t_account_record ( id, record_no, order_no, account_no, trade_type, amount, fee_rate, trade_time, complete_time, channel_type, channel_no, fund_direction, status, owner_type, track, gmt8_create ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 2019-08-14 17:52:45.249 INFO 10800 --- [nio-9036-exec-1] ShardingSphere-SQL : SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=t_account_record, alias=Optional.absent())]), routeConditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=record_no, tableName=t_account_record), operator=EQUAL, compareOperator=null, positionValueMap={}, positionIndexMap={0=1}), Condition(column=Column(name=account_no, tableName=t_account_record), operator=EQUAL, compareOperator=null, positionValueMap={}, positionIndexMap={0=3}), Condition(column=Column(name=gmt8_create, tableName=t_account_record), operator=EQUAL, compareOperator=null, positionValueMap={}, positionIndexMap={0=15})])])), encryptConditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(tableName=t_account_record, quoteCharacter=NONE, schemaNameLength=0), SQLToken(startIndex=30)], parametersIndex=16, logicSQL=INSERT INTO t_account_record ( id, record_no, order_no, account_no, trade_type, amount, fee_rate, trade_time, complete_time, channel_type, channel_no, fund_direction, status, owner_type, track, gmt8_create ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )), deleteStatement=false, updateTableAlias={}, updateColumnValues={}, whereStartIndex=0, whereStopIndex=0, whereParameterStartIndex=0, whereParameterEndIndex=0), columnNames=[id, record_no, order_no, account_no, trade_type, amount, fee_rate, trade_time, complete_time, channel_type, channel_no, fund_direction, status, owner_type, track, gmt8_create], values=[InsertValue(columnValues=[org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@c11dc0e, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@bfdb2da, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@23494c60, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@24ed7bbd, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@261e2282, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@40932ff9, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@295051c7, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@662ff7c3, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@31f2c3b6, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@6847de96, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@43327430, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@5aba027a, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@7d7295e8, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@2b1747be, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@7b543518, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@717741da])]) 2019-08-14 17:52:45.249 INFO 10800 --- [nio-9036-exec-1] ShardingSphere-SQL : Actual SQL: master ::: INSERT INTO t_account_record_201908 (id, record_no, order_no, account_no, trade_type, amount, fee_rate, trade_time, complete_time, channel_type, channel_no, fund_direction, status, owner_type, track, gmt8_create) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ::: [1161576382317236225, RD1161576357721800769201908, PR76650-1618005454-2093736587, AT22, 4, 6.00, 0, 2019-08-14 17:52:34.0, 2019-08-14 17:52:39.389, 4, AT1161537493854584848, 3, 1, 2, TK1161576357679857730, 2019-08-14 17:52:39.392] ```
---------------------------------------------------------------- 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] With regards, Apache Git Services
