You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/06/14 05:16:14 UTC
[GitHub] [shardingsphere] lonelythinker opened a new issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
lonelythinker opened a new issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028
## Bug Report
### Which version of ShardingSphere did you use?
4.1.1
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Expected behavior
execute sql:INSERT IGNORE INTO article(sharding_key, title, digest, link) VALUES (1567930626785, '哈士奇看到“女神”后，结果忍不住舔屏了', '快进来接受二哈的“洗礼”配乐毫无违和感😂', 'https://mp.weixin.qq.com/s?__biz=MzI2MDA0NTY0MA==&mid=2651076369&idx=3&sn=c6efbfc6e685d75e2d6466d244cf7865');
proxy log:
[INFO ] 12:25:49.242 [ShardingSphere-Command-2] ShardingSphere-SQL - Logic SQL: INSERT IGNORE INTO article(sharding_key, title, digest, link) VALUES (1567930626785, '哈士奇看到“女神”后，结果忍不住舔屏了', '快进来接受二哈的“洗礼”配乐毫无违和感😂', 'https://mp.weixin.qq.com/s?__biz=MzI2MDA0NTY0MA==&mid=2651076369&idx=3&sn=c6efbfc6e685d75e2d6466d244cf7865')
[INFO ] 12:25:49.242 [ShardingSphere-Command-2] ShardingSphere-SQL - Actual SQL: ds_2019 ::: INSERT IGNORE INTO article_09_6(sharding_key, title, digest, link, id) VALUES (1567930626785, '哈士奇看到“女神”后，结果忍不住舔屏了', '快进来接受二哈的“洗礼”配乐毫无违和感😂', 'https://mp.weixin.qq.com/s?__biz=MzI2MDA0NTY0MA==&mid=2651076369&idx=3&sn=c6efbfc6e685d75e2d6466d244cf7865', 478902062378123265)) ---- hint:There are two ')' here
report error:ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
But, when I execute the following sql, everything is ok.(no emoji)
execute sql:INSERT IGNORE INTO article(sharding_key, title, digest, link) VALUES (1567930626785, '哈士奇看到“女神”后，结果忍不住舔屏了', '快进来接受二哈的“洗礼”配乐毫无违和感', 'https://mp.weixin.qq.com/s?__biz=MzI2MDA0NTY0MA==&mid=2651076369&idx=3&sn=c6efbfc6e685d75e2d6466d244cf7865');
proxy log:
[INFO ] 12:25:49.242 [ShardingSphere-Command-2] ShardingSphere-SQL - Logic SQL: INSERT IGNORE INTO article(sharding_key, title, digest, link) VALUES (1567930626785, '哈士奇看到“女神”后，结果忍不住舔屏了', '快进来接受二哈的“洗礼”配乐毫无违和感', 'https://mp.weixin.qq.com/s?__biz=MzI2MDA0NTY0MA==&mid=2651076369&idx=3&sn=c6efbfc6e685d75e2d6466d244cf7865')
[INFO ] 12:25:49.242 [ShardingSphere-Command-2] ShardingSphere-SQL - Actual SQL: ds_2019 ::: INSERT IGNORE INTO article_09_6(sharding_key, title, digest, link, id) VALUES (1567930626785, '哈士奇看到“女神”后，结果忍不住舔屏了', '快进来接受二哈的“洗礼”配乐毫无违和感', 'https://mp.weixin.qq.com/s?__biz=MzI2MDA0NTY0MA==&mid=2651076369&idx=3&sn=c6efbfc6e685d75e2d6466d244cf7865', 478903797431664641) ---- hint:There are only one ')' here
### Actual behavior
insert failed
### Reason analyze (If you can)
Maybe the SqlPaser doesn't work well when the sql contains emoji.
----------------------------------------------------------------
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
[GitHub] [shardingsphere] lonelythinker commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
lonelythinker commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-644690312
Maybe the key generator doesn't work well when the sql contains emoji. I used the key generator which the type is 'SNOWFLAKE' and the column is '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
[GitHub] [shardingsphere] xbkaishui commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
xbkaishui commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-658518116
> > @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.
>
> Now, it has not been fixed, i mean we should fix it in parser.
I got your point. I will try to fix this, but I am not familiar with antlr parser, do you have any ideas ?
----------------------------------------------------------------
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
[GitHub] [shardingsphere] xbkaishui commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
xbkaishui commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-658022411
there is a work version in my [branch ](https://github.com/xbkaishui/shardingsphere/tree/support-local-datetime-411), please have a try and let me know
----------------------------------------------------------------
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
[GitHub] [shardingsphere] jingshanglu commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-658498797
> @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.
Now, it has not been fixed, i mean we should fix it in parser.
----------------------------------------------------------------
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
[GitHub] [shardingsphere] lonelythinker commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
lonelythinker commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-644684853
mysql error:ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
This error is reported by mysql server, because the sql has an extra character ')' at the end.
The error sql is generated by ShardingSphere-SQL, when it contains emoji. So it can't be mysql that's causing this problem.(The character set for the mysql database is utf8mb4.)
----------------------------------------------------------------
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
[GitHub] [shardingsphere] xbkaishui edited a comment on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
xbkaishui edited a comment 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:
users@infra.apache.org
[GitHub] [shardingsphere] xbkaishui commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
xbkaishui commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-658057889
in version 4.1.1, it's no fixed. I will try in master branch
----------------------------------------------------------------
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
[GitHub] [shardingsphere] 171563857 edited a comment on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
171563857 edited a comment on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-657311563
> @jingshanglu I also encountered the same problem，only insert sql contains emoji error，update works well，how to solve this problem?
@BabyStrong I also encountered the same problem，update works well, only insert sql contains emoji error，and update op also
work error after insert op error, i use insert op at first but remove emoji and then use update op contains emoji, it's so tedious
----------------------------------------------------------------
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
[GitHub] [shardingsphere] tristaZero closed issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
tristaZero closed issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028
----------------------------------------------------------------
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
[GitHub] [shardingsphere] tristaZero commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-659797223
Hi @lonelythinker @171563857
I am glad to tell you guys, this issue has been fixed perfectly with the help of @xbkaishui and @jingshanglu
Thanks for your feedback!
Best,
Trista
----------------------------------------------------------------
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
[GitHub] [shardingsphere] 171563857 edited a comment on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
171563857 edited a comment on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-657311563
> @jingshanglu I also encountered the same problem，only insert sql contains emoji error，update works well，how to solve this problem?
@BabyStrong I also encountered the same problem，update works well, only insert sql contains emoji error.
but update op also work error after insert op error.
now, i use insert op at first but remove emoji and then use update op contains emoji, it's so tedious.
----------------------------------------------------------------
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
[GitHub] [shardingsphere] 171563857 commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
171563857 commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-658522292
it's sql parser err, i havn't any idea, sry
just to try another way QAQ
----------------------------------------------------------------
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
[GitHub] [shardingsphere] lonelythinker commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
lonelythinker commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-646976151
I found the key generator doesn't work well when the sql contains some special character such as '𠈌’, not only emoji.
----------------------------------------------------------------
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
[GitHub] [shardingsphere] jingshanglu commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-644496684
@lonelythinker This error is reported by mysql server, shouldn't the emoji be a string?
----------------------------------------------------------------
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
[GitHub] [shardingsphere] xbkaishui edited a comment on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
xbkaishui edited a comment on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-658022411
@jingshanglu @171563857
there is a work version in my [branch ](https://github.com/xbkaishui/shardingsphere/tree/support-local-datetime-411), please have a try and let me know
----------------------------------------------------------------
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
[GitHub] [shardingsphere] xbkaishui commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
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:
users@infra.apache.org
[GitHub] [shardingsphere] 171563857 commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
171563857 commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-657311563
> @jingshanglu I also encountered the same problem，only insert sql contains emoji error，update works well，how to solve this problem?
@BabyStrong I also encountered the same problem，update works well, only insert sql contains emoji error，and update op also
work error after insert op error, i use insert op at first but remove emoji and then use update op contains emoji, it's so contains
----------------------------------------------------------------
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
[GitHub] [shardingsphere] 171563857 commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
171563857 commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-657319076
update op also work error, some like this:
𝓒𝓸𝓬𝓪𝓒𝓸𝓵𝓪
徐学习🦄
----------------------------------------------------------------
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
[GitHub] [shardingsphere] xbkaishui commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
xbkaishui commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-658760829
Hi @jingshanglu , I find the root cause of this issue, please refer [this](https://github.com/antlr/antlr4/blob/master/doc/unicode.md#unicode-code-points-in-lexer-grammars), let's discuss how to fix it.
----------------------------------------------------------------
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
[GitHub] [shardingsphere] jingshanglu commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-658050225
> @jingshanglu @171563857
> there is a work version in my [branch ](https://github.com/xbkaishui/shardingsphere/tree/support-local-datetime-411), please have a try and let me know
It maybe fix in parser, when sql contain emoji, the emoji has more than one byte.
----------------------------------------------------------------
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
[GitHub] [shardingsphere] 171563857 commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
171563857 commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-658517775
> > @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.
>
> Now, it has not been fixed, i mean we should fix it in parser.
how long will it fix ? i maybe choose other solution if it's too long, thx
----------------------------------------------------------------
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
[GitHub] [shardingsphere] BabyStrong commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
BabyStrong commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-657016772
@jingshanglu I also encountered the same problem，only insert sql contains emoji error，update works well，how to solve this problem?
----------------------------------------------------------------
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
[GitHub] [shardingsphere] jingshanglu edited a comment on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
jingshanglu edited a comment on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-658050225
> @jingshanglu @171563857
> there is a work version in my [branch ](https://github.com/xbkaishui/shardingsphere/tree/support-local-datetime-411), please have a try and let me know
It should probably be fixed in parser, when sql contain emoji, the emoji has more than one char.
----------------------------------------------------------------
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
[GitHub] [shardingsphere] 171563857 edited a comment on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
171563857 edited a comment on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-658522292
@xbkaishui
it's sql parser err, i havn't any idea, sry
just to try another way QAQ
----------------------------------------------------------------
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
[GitHub] [shardingsphere] xbkaishui commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
xbkaishui commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-658518518
@171563857, You can try my [branch](https://github.com/xbkaishui/shardingsphere/tree/support-local-datetime-411), it is ok now in version 4.1.1.
----------------------------------------------------------------
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
[GitHub] [shardingsphere] jingshanglu commented on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-644490357
@lonelythinker Can you give complete stack information?
----------------------------------------------------------------
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
[GitHub] [shardingsphere] jingshanglu edited a comment on issue #6028: sharding-proxy 4.1.1 insert sql contains emoji error
Posted by GitBox <gi...@apache.org>.
jingshanglu edited a comment on issue #6028:
URL: https://github.com/apache/shardingsphere/issues/6028#issuecomment-658050225
> @jingshanglu @171563857
> there is a work version in my [branch ](https://github.com/xbkaishui/shardingsphere/tree/support-local-datetime-411), please have a try and let me know
It should probably be fixed in parser, when sql contain emoji, the emoji has more than one byte.
----------------------------------------------------------------
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