AlbertTao commented on issue #2319: Insert error when field name was a keyword URL: https://github.com/apache/incubator-shardingsphere/issues/2319#issuecomment-489393908 When I use select statement, the result is correct. ``` [main] INFO ShardingSphere-SQL - Logic SQL: select id, `desc` from ts_order [main] INFO ShardingSphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=ts_order, alias=Optional.absent())]), routeConditions=Conditions(orCondition=OrCondition(andConditions=[])), encryptConditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(tableName=ts_order, quoteCharacter=NONE, schemaNameLength=0)], parametersIndex=0, logicSQL=select id, `desc` from ts_order)), containStar=false, firstSelectItemStartIndex=7, selectListStopIndex=16, groupByLastIndex=0, items=[CommonSelectItem(expression=id, alias=Optional.absent()), CommonSelectItem(expression=desc, alias=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subqueryStatement=null, subqueryStatements=[], subqueryConditions=[]) [main] INFO ShardingSphere-SQL - Actual SQL: ds_0 ::: select id, `desc` from ts_order_0000 [main] INFO ShardingSphere-SQL - Actual SQL: ds_0 ::: select id, `desc` from ts_order_0001 ```
---------------------------------------------------------------- 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
