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 2021/06/03 03:10:29 UTC
[GitHub] [shardingsphere] menghaoranss opened a new issue #10630: Create table SQL rewrite error with encrypt
menghaoranss opened a new issue #10630:
URL: https://github.com/apache/shardingsphere/issues/10630
```
[INFO ] 2021-06-03 10:56:12.015 [ShardingSphere-Command-1] ShardingSphere-SQL - Logic SQL: create table t_encrypt(user_id varchar(32), order_id varchar(32))
[INFO ] 2021-06-03 10:56:12.015 [ShardingSphere-Command-1] ShardingSphere-SQL - SQLStatement: MySQLCreateTableStatement(containsNotExistClause=false)
[INFO ] 2021-06-03 10:56:12.015 [ShardingSphere-Command-1] ShardingSphere-SQL - Actual SQL: ds_2 ::: create table t_encryptuser_cipher varchar(32),user_plain varchar(32),order_cipher varchar(32))
[ERROR] 2021-06-03 10:56:12.017 [ShardingSphere-Command-1] o.a.s.p.f.c.CommandExecutorTask - Exception occur:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'varchar(32),user_plain varchar(32),order_cipher varchar(32))' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
```
--
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] menghaoranss closed issue #10630: Create table SQL rewrite error with encrypt
Posted by GitBox <gi...@apache.org>.
menghaoranss closed issue #10630:
URL: https://github.com/apache/shardingsphere/issues/10630
--
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