[GitHub] [incubator-shardingsphere] gholly commented on issue #2819: How to turn off keyGenerator feature in 4.0.0-RC1 version

[GitBox <gi...@apache.org>]

gholly 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-521537452
 
 
   I have the same problem.
   
   `
   Hibernate: insert into dd_bank_2 (application_number, company_id, id) values (?, ?, ?)
   2019-08-15 14:47:42.308  INFO 43171 --- [nio-8081-exec-1] ShardingSphere-SQL                       : Rule Type: sharding
   2019-08-15 14:47:42.308  INFO 43171 --- [nio-8081-exec-1] ShardingSphere-SQL                       : **Logic SQL: insert into dd_bank_2 (application_number, company_id, id) values (?, ?, ?)**
   2019-08-15 14:47:42.308  INFO 43171 --- [nio-8081-exec-1] ShardingSphere-SQL                       : SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=dd_bank_2, alias=Optional.absent())]), routeConditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=company_id, tableName=dd_bank_2), operator=EQUAL, compareOperator=null, positionValueMap={}, positionIndexMap={0=1})])])), encryptConditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(tableName=dd_bank_2, quoteCharacter=NONE, schemaNameLength=0), SQLToken(startIndex=22)], parametersIndex=3, logicSQL=null), deleteStatement=false, updateTableAlias={}, updateColumnValues={}, whereStartIndex=0, whereStopIndex=0, whereParameterStartIndex=0, whereParameterEndIndex=0), columnNames=[application_number, company_id, id], values=[InsertValue(columnValues=[org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@3e451f94, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@1d81965d, org.apache.shardingsphere.core.parse.old.parser.expression.SQLPlaceholderExpression@66e4266c])])
   2019-08-15 14:47:42.309  INFO 43171 --- [nio-8081-exec-1] ShardingSphere-SQL                       : **Actual SQL: ds2 ::: insert into dd_bank_2  (application_number, company_id, id) VALUES (?, ?, ?) ::: [12314, 2, 64e25235-e5a1-4005-8a53-8f9659b01709]**
   `
   
   how to turn off id keyGenerator in version 4.0.0-RC1?
   
   the field application_number is my primary key,so i no need id

----------------------------------------------------------------
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


With regards,
Apache Git Services