Zatomsmasher opened a new issue #2277: ERROR when tried to import sql file into 
a  sharding-proxy system
URL: https://github.com/apache/incubator-shardingsphere/issues/2277
 
 
   ## Bug Report
   
   **For English only**, other languages will not accept.
   
   Before report a bug, make sure you have:
   
   - Searched open and closed [GitHub 
issues](https://github.com/sharding-sphere/sharding-sphere/issues).
   - Read documentation: [ShardingSphere 
Doc](http://shardingsphere.io/document/current/en/overview/).
   
   Please pay attention on issues you submitted, because we maybe need more 
details. 
   If no response **more than 7 days** and we cannot reproduce it on current 
information, we will **close it**.
   
   Please answer these questions before submitting your issue. Thanks!
   
   ### Which version of ShardingSphere did you use?
   ShardingSphere 3.1.0
   ### Which project did you use? Sharding-JDBC or Sharding-Proxy?
   Sharding-Proxy
   ### Expected behavior
   import data from sql file
   ### Actual behavior
   get ERROR
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule 
configuration, when exception occur etc.
   1. use mysqldump  to get the sql file
    e.g. mysqldump  -uroot -p database table > table.sql
   2.use mysql CLI cilent to sharding-proxy and source the sql file
   mysql -u root -p -P 3307 -h 127.0.0.1 
   mysql>source table.sql
   then I got this error:
   mysql> source /usr/local/mysql/table.sql
   ERROR 3054 (HY000): Unknown exception: SQL syntax error, expected token is 
'RIGHT_PAREN', actual token is 'INT', literals is 'int'.
   ERROR 3054 (HY000): Unknown exception: SQL syntax error, expected token is 
'RIGHT_PAREN', actual token is 'IDENTIFIER', literals is 'java'.
   ERROR 3054 (HY000): Unknown exception: SQL syntax error, expected token is 
'RIGHT_PAREN', actual token is 'INT', literals is 'int'.
   ERROR 3054 (HY000): Unknown exception: SQL syntax error, expected token is 
'RIGHT_PAREN', actual token is 'INT', literals is 'int'.
   ERROR 3054 (HY000): Unknown exception: SQL syntax error, expected token is 
'RIGHT_PAREN', actual token is 'INT', literals is 'int'.
   ERROR 3054 (HY000): Unknown exception: SQL syntax error, expected token is 
'RIGHT_PAREN', actual token is 'INT', literals is 'int'.
   

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

Reply via email to