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/02/14 15:39:06 UTC

[GitHub] [incubator-shardingsphere] ppourali opened a new issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

ppourali opened a new issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317
 
 
   ## Question
   Hi, I am trying to run the encrypt example from the github repo. The example uses encryption rules to insert rows in the table and then prints them. However, when I run the example I get the following error.
   `
   Exception in thread "main" org.apache.shardingsphere.sql.parser.exception.SQLParsingException: Unsupported SQL of `TRUNCATE TABLE t_user`
   	at org.apache.shardingsphere.sql.parser.core.parser.SQLParserEngine.parse(SQLParserEngine.java:77)
   	at org.apache.shardingsphere.sql.parser.core.SQLParseKernel.parse(SQLParseKernel.java:58)
   	at org.apache.shardingsphere.sql.parser.SQLParseEngine.parse0(SQLParseEngine.java:70)
   	at org.apache.shardingsphere.sql.parser.SQLParseEngine.parse(SQLParseEngine.java:52)
   	at org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.EncryptStatement.getRewriteSQL(EncryptStatement.java:106)
   	at org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.EncryptStatement.executeUpdate(EncryptStatement.java:141)
   	at org.apache.shardingsphere.example.core.jdbc.repository.UserRepositoryImpl.truncateTable(UserRepositoryImpl.java:64)
   	at org.apache.shardingsphere.example.core.jdbc.service.UserServiceImpl.initEnvironment(UserServiceImpl.java:39)
   	at org.apache.shardingsphere.example.core.api.ExampleExecuteTemplate.run(ExampleExecuteTemplate.java:28)
   	at org.apache.shardingsphere.example.encrypt.table.raw.jdbc.JavaConfigurationExampleMain.main(JavaConfigurationExampleMain.java:37)
   `
   
    This error is shown for every single sql statement (insert, update, create table, ...) and I don't understand why. The only thing that I changed in the example is that I changed it from Hikari to postgres driver:
   `
   BasicDataSource dataSource = new BasicDataSource();
   dataSource.setDriverClassName("org.postgresql.Driver");
   dataSource.setUrl("jdbc:postgresql://127.0.0.1:5432/" + dataSourceName);
   dataSource.setUsername(USER);
   dataSource.setPassword(PASS);
   `
   
   I can see that the connection is established successfully. I appreciate if you could kindly helo me with this. 
   
   Thanks,
   Parsa

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

[GitHub] [incubator-shardingsphere] geomonlin removed a comment on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
geomonlin removed a comment on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-590739200
 
 
   I follow your configuration,it‘s normal

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

[GitHub] [incubator-shardingsphere] geomonlin commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
geomonlin commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-590739200
 
 
   I follow your configuration,it‘s normal

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

[GitHub] [incubator-shardingsphere] ppourali commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
ppourali commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-598377091
 
 
   Hi @geomonlin ,
   
   Thanks for following up. I could run my code and it works on my code now. I have no idea why it didn't work on the example though. I'm good now, thanks!
   
   Parsa

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

[GitHub] [incubator-shardingsphere] geomonlin commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
geomonlin commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-590707173
 
 
   Hi, Create SQL for table is different in MySQL and PG. Have you changed the SQL?Maybe you can see this acceptance test code as a guide for PG. 

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

[GitHub] [incubator-shardingsphere] dongzl edited a comment on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
dongzl edited a comment on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-600591780
 
 
   Hi @ppourali , I want to solve this problem, but I try the 4.0.0-RC3, 4.0.0, 4.0.1 and the newest code, They work very well, can you reproduce this problem and help me to solve it, Thanks.

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

[GitHub] [incubator-shardingsphere] geomonlin edited a comment on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
geomonlin edited a comment on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-596348873
 
 
   > Hi,
   > 
   > It is very strange to me too. I feel I am doing something wrong! I cloned the repo, performed mvn eclpse:eclipse to make it for eclipse, then imported the projects as eclipse projects and ran my code. I did not change any thing else. However, when I run the sharding-proxy using "start.bat" and then perform the queries, it will work. So, I guess the problem might be the way the projects were built for eclipse. I can send you the whole workspace if you want though.
   > 
   > Thanks,
   > Parsa
   
   And what is your postgres version?My Version is 10.11.

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

[GitHub] [incubator-shardingsphere] terrymanu commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-586869577
 
 
   What is your version of ShardingSphere?

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

[GitHub] [incubator-shardingsphere] ppourali commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
ppourali commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-587928211
 
 
   Hi terrymanu,
   
   It's 4.0.0. I just cloned the master branch. As mentioned, only _select_ statements can be performed.
   
   Thanks,
   Parsa

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

[GitHub] [incubator-shardingsphere] ppourali commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
ppourali commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-591024671
 
 
   Hi, 
   
   It is very strange to me too. I feel I am doing something wrong! I cloned the repo, performed mvn eclpse:eclipse to make it for eclipse, then imported the projects as eclipse projects and ran my code. I did not change any thing else. However, when I run the sharding-proxy using "start.bat" and then perform the queries, it will work. So, I guess the problem might be the way the projects were built for eclipse. I can send you the whole workspace if you want though.
   
   Thanks,
   Parsa

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

[GitHub] [incubator-shardingsphere] geomonlin edited a comment on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
geomonlin edited a comment on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-596345034
 
 
   > Hi,
   > 
   > It is very strange to me too. I feel I am doing something wrong! I cloned the repo, performed mvn eclpse:eclipse to make it for eclipse, then imported the projects as eclipse projects and ran my code. I did not change any thing else. However, when I run the sharding-proxy using "start.bat" and then perform the queries, it will work. So, I guess the problem might be the way the projects were built for eclipse. I can send you the whole workspace if you want though.
   > 
   > Thanks,
   > Parsa
   
   Sorry I didn't notice the message. that's good, you can put the whole workspace Revised on GitHub,  Your ShardingSphere version is sharding-jdbc 4.0.0. Right?

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

[GitHub] [incubator-shardingsphere] geomonlin commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
geomonlin commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-598013724
 
 
   @ppourali Hi, Have you solved 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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] ppourali closed issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
ppourali closed issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317
 
 
   

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

[GitHub] [incubator-shardingsphere] geomonlin edited a comment on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
geomonlin edited a comment on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-596345034
 
 
   > Hi,
   > 
   > It is very strange to me too. I feel I am doing something wrong! I cloned the repo, performed mvn eclpse:eclipse to make it for eclipse, then imported the projects as eclipse projects and ran my code. I did not change any thing else. However, when I run the sharding-proxy using "start.bat" and then perform the queries, it will work. So, I guess the problem might be the way the projects were built for eclipse. I can send you the whole workspace if you want though.
   > 
   > Thanks,
   > Parsa
   
   Sorry I didn't notice the message. that's good, you can put the whole workspace Revised on GitHub,  I want to see your configuration, Your ShardingSphere version is sharding-jdbc 4.0.0. Right?

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

[GitHub] [incubator-shardingsphere] geomonlin edited a comment on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
geomonlin edited a comment on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-590707173
 
 
   Hi, Create SQL for table is different in MySQL and PG. Have you changed the SQL?Maybe you can see this [acceptance test](https://github.com/apache/incubator-shardingsphere-acceptance-test) code as a guide for PG. 

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

[GitHub] [incubator-shardingsphere] terrymanu commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-590686912
 
 
   Sorry, just ignore last message, you just the official example

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

[GitHub] [incubator-shardingsphere] dongzl commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
dongzl commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-600591780
 
 
   Hi @ppourali , I want to solve this problem, but I try the 4.0.0-RC3, 4.0.0, 4.0.1 and the newest code, They work very well, can you reproduce this problem, Thanks.

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

[GitHub] [incubator-shardingsphere] ppourali commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
ppourali commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-601511023
 
 
   Hi @dongzl 
   Unfortunately, I don't have access to the machine on which this issue occurred. There must be something wrong on my side. Thanks for following up though. I think we can close this 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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] geomonlin commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
geomonlin commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-598491762
 
 
   Ok, The example is using mysql. Some SQL statements are different, will be some impact.

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

[GitHub] [incubator-shardingsphere] terrymanu commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-590686222
 
 
   Got it, it should be a bug, I will resolve 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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] terrymanu commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-590686533
 
 
   Can you provide your rule configuration? It looks like using encrypt only?

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

[GitHub] [incubator-shardingsphere] geomonlin commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
geomonlin commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-596348873
 
 
   > Hi,
   > 
   > It is very strange to me too. I feel I am doing something wrong! I cloned the repo, performed mvn eclpse:eclipse to make it for eclipse, then imported the projects as eclipse projects and ran my code. I did not change any thing else. However, when I run the sharding-proxy using "start.bat" and then perform the queries, it will work. So, I guess the problem might be the way the projects were built for eclipse. I can send you the whole workspace if you want though.
   > 
   > Thanks,
   > Parsa
   
   And what is your postgres version?

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

[GitHub] [incubator-shardingsphere] ppourali edited a comment on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
ppourali edited a comment on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-601511023
 
 
   Hi @dongzl 
   Unfortunately, I don't have access to the machine on which this issue occurred. I tried again on another machine and it is working. There could be something wrong on my side. Thanks for following up though. I think we can close this 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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] geomonlin commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
geomonlin commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-596345034
 
 
   > Hi,
   > 
   > It is very strange to me too. I feel I am doing something wrong! I cloned the repo, performed mvn eclpse:eclipse to make it for eclipse, then imported the projects as eclipse projects and ran my code. I did not change any thing else. However, when I run the sharding-proxy using "start.bat" and then perform the queries, it will work. So, I guess the problem might be the way the projects were built for eclipse. I can send you the whole workspace if you want though.
   > 
   > Thanks,
   > Parsa
   
   Sorry I didn't notice the message, that's good. You can put the whole workspace Revised on GitHub,  Your ShardingSphere version is sharding-jdbc 4.0.0. Right?

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

[GitHub] [incubator-shardingsphere] terrymanu edited a comment on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
terrymanu edited a comment on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-590686533
 
 
   Can you provide your rule configuration? It looks like using encrypt only, is 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


With regards,
Apache Git Services

[GitHub] [incubator-shardingsphere] geomonlin commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error

Posted by GitBox <gi...@apache.org>.
geomonlin commented on issue #4317: Use encrypt-raw-jdbc-example fails because of "Unsupport SQL of " error
URL: https://github.com/apache/incubator-shardingsphere/issues/4317#issuecomment-590783297
 
 
   I followed your configuration and modify the create table SQL statement `CREATE TABLE IF NOT EXISTS t_user (user_id BIGSERIAL NOT NULL, user_name VARCHAR(200), user_name_plain VARCHAR(200), pwd VARCHAR(200), assisted_query_pwd VARCHAR(200), PRIMARY KEY (user_id));
          ` It's successful execution. Maybe you can try it. Can you give more details to  reproduce 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


With regards,
Apache Git Services