[GitHub] [shardingsphere] xbkaishui commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error

[GitBox]

xbkaishui commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-658145473


   @jingshanglu 
   still have error in master branch. please check this log
   
   [INFO ] 20:11:50.578 [ShardingSphere-Command-4] ShardingSphere-SQL - Logic 
SQL: INSERT INTO t_user_third_account ( third_account_id,nickname) 
values(10+,'璐小果🍎我😀𪚥徐学习學習~🙋‍♀️𝓒𝓸𝓬𝓪𝓒𝓸𝓵𝓪asdfas!【】［］@#$%^123123d,.');
   [INFO ] 20:11:50.578 [ShardingSphere-Command-4] ShardingSphere-SQL - 
SQLStatement: 
InsertStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.InsertStatement@ffa2a23,
 
tablesContext=TablesContext(tables=[SimpleTableSegment(tableName=TableNameSegment(startIndex=12,
 stopIndex=31, identifier=IdentifierValue(value=t_user_third_account, 
quoteCharacter=NONE)), owner=Optional.empty, alias=Optional.empty)])), 
tablesContext=TablesContext(tables=[SimpleTableSegment(tableName=TableNameSegment(startIndex=12,
 stopIndex=31, identifier=IdentifierValue(value=t_user_third_account, 
quoteCharacter=NONE)), owner=Optional.empty, alias=Optional.empty)]), 
columnNames=[third_account_id, nickname], 
insertValueContexts=[InsertValueContext(parametersCount=0, 
valueExpressions=[LiteralExpressionSegment(startIndex=69, stopIndex=71, 
literals=10), LiteralExpressionSegment(startIndex=73, stopIndex=124, 
literals=璐小果🍎我😀𪚥徐学习學習~🙋‍♀️𝓒𝓸𝓬𝓪𝓒𝓸𝓵𝓪asdfas!【】［］@#$%^123123d,.)], parameters=[])], 
onDuplicateKeyUpdateValueContext=null, generatedKeyContext=Optional.empty)
   [INFO ] 20:11:50.579 [ShardingSphere-Command-4] ShardingSphere-SQL - Actual 
SQL: ds_0 ::: INSERT INTO t_user_third_account ( third_account_id,nickname) 
values(10, '璐小果🍎我😀𪚥徐学习學習~🙋‍♀️𝓒𝓸𝓬𝓪𝓒𝓸𝓵𝓪asdfas!【】［］@#$%^123123d,.')^123123d,.');
   
   It seems parser issue. 
   
   


----------------------------------------------------------------
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:
us...@infra.apache.org