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/07/02 05:39:12 UTC

[GitHub] [shardingsphere] JiekerTime opened a new issue #11105: SQL rewriting problems in encrypt scenarios

JiekerTime opened a new issue #11105:
URL: https://github.com/apache/shardingsphere/issues/11105


   ### Which version of ShardingSphere did you use?
   5.0.0-RC1-SNAPSHOT
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   Both
   
   ### Expected behavior
   ‘ALTER TABLE t_user_details DROP COLUMN number’ executed normally.
   
   ### Actual behavior
   `[ERROR] 2021-07-02 05:18:01.665 [ShardingSphere-ScenarioExecutorPool-jdbc-encrypt-H2-0] o.a.s.t.i.junit.watcher.ITWatcher - Error case: assertExecuteUpdate[jdbc: encrypt -> H2 -> Literal -> ALTER TABLE t_user_details DROP COLUMN number], message: org.h2.jdbc.JdbcSQLException: Column "DROP" not found; SQL statement:
   ALTER TABLE t_user_details DROP COLUMN number_cipher  , DROP COLUMN number_plain  [42122-196]`
   
   ### Reason analyze (If you can)
   DROP is repeatedly written in EncryptAlterTableTokenGenerator.getDropColumnTokens:
   ![image](https://user-images.githubusercontent.com/76552510/124225202-9ab36900-db39-11eb-8a24-9b9bdfe723d7.png)
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
   You can reproduce the issue from the integration test of the DDL, the corresponding statements are marked.
   


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

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] strongduanmu commented on issue #11105: SQL rewriting problems in encrypt scenarios

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #11105:
URL: https://github.com/apache/shardingsphere/issues/11105#issuecomment-880562052


   @arthasking123 Welcome.


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

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] JiekerTime commented on issue #11105: SQL rewriting problems in encrypt scenarios

Posted by GitBox <gi...@apache.org>.
JiekerTime commented on issue #11105:
URL: https://github.com/apache/shardingsphere/issues/11105#issuecomment-873865661


   > @JiekerTime hi bro, The problem is that the SQL syntax h2 is not supported. You can look at this: https://www.h2database.com/html/commands.html#alter_table_drop_column And You can specify db-types="MySQL" in ddl-integration-test-cases.xml, and modify scenario-types="dbtbl_with_readwrite_splitting,readwrite_splitting". Can you submit a PR?
   
   Modified the main text: "The current problem does not occur in the H2 scenario", you can reproduce the problem by uncommenting 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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] zjcnb commented on issue #11105: SQL rewriting problems in encrypt scenarios

Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #11105:
URL: https://github.com/apache/shardingsphere/issues/11105#issuecomment-873821880


   @JiekerTime  hi bro, The problem is that the SQL syntax h2 is not supported. You can look at this: https://www.h2database.com/html/commands.html#alter_table_drop_column And You can specify db-types="MySQL" in ddl-integration-test-cases.xml, and modify scenario-types="dbtbl_with_readwrite_splitting,readwrite_splitting". Can you submit a PR?


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

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] JiekerTime commented on issue #11105: SQL rewriting problems in encrypt scenarios

Posted by GitBox <gi...@apache.org>.
JiekerTime commented on issue #11105:
URL: https://github.com/apache/shardingsphere/issues/11105#issuecomment-903557858


   problem fixed! so closed.


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

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] zjcnb commented on issue #11105: SQL rewriting problems in encrypt scenarios

Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #11105:
URL: https://github.com/apache/shardingsphere/issues/11105#issuecomment-872916464


   > @zjcnb Assigned, if you have any questions, please ping me.
   
   ok


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

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] strongduanmu commented on issue #11105: SQL rewriting problems in encrypt scenarios

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #11105:
URL: https://github.com/apache/shardingsphere/issues/11105#issuecomment-872905513


   @zjcnb Assigned, if you have any questions, please ping me.


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

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] zjcnb commented on issue #11105: SQL rewriting problems in encrypt scenarios

Posted by GitBox <gi...@apache.org>.
zjcnb commented on issue #11105:
URL: https://github.com/apache/shardingsphere/issues/11105#issuecomment-872904785


   Assign it to me, please


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

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] arthasking123 commented on issue #11105: SQL rewriting problems in encrypt scenarios

Posted by GitBox <gi...@apache.org>.
arthasking123 commented on issue #11105:
URL: https://github.com/apache/shardingsphere/issues/11105#issuecomment-880546635


   I'll try to fix it because I wrote the code :)


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

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] JiekerTime closed issue #11105: SQL rewriting problems in encrypt scenarios

Posted by GitBox <gi...@apache.org>.
JiekerTime closed issue #11105:
URL: https://github.com/apache/shardingsphere/issues/11105


   


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

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org