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 2022/11/26 11:25:06 UTC

[GitHub] [shardingsphere] boyjoy1127 opened a new issue, #22442: Why these two cases dosen't execute?

boyjoy1127 opened a new issue, #22442:
URL: https://github.com/apache/shardingsphere/issues/22442

   ## Question
   Two cases in 
   `shardingsphere/test/integration-test/test-suite/src/test/resources/cases/dql/dql-integration-test-cases.xml`
   are not be execute during IT tests.
   ```
   <test-case sql="SELECT * FROM t_order o LEFT JOIN t_merchant m ON o.merchant_id = m.merchant_id WHERE o.user_id = ? ORDER BY o.order_id, 7" db-types="MySQL,PostgreSQL,openGauss" scenario-types="db">
           <assertion parameters="10:int" expected-data-source-name="read_dataset" />
       </test-case>
   
       <test-case sql="SELECT * FROM t_order o RIGHT JOIN t_merchant m ON o.order_id = m.merchant_id WHERE m.country_id = 1 ORDER BY m.merchant_id, 7" db-types="MySQL,PostgreSQL,openGauss" scenario-types="db">
           <assertion expected-data-source-name="read_dataset" />
       </test-case>
   ```
   Below is the content of it-env.properties:
   ```
   it.run.modes=Standalone,Cluster
   it.run.modes=Standalone
   it.run.additional.cases=false
   
   #it.scenarios=db,tbl,readwrite_splitting,encrypt,shadow,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,rdl_empty_rules,empty_rules,sharding_and_encrypt,encrypt_and_readwrite_splitting,encrypt_shadow,readwrite_splitting_and_shadow,sharding_and_shadow,sharding_encrypt_shadow
   it.scenarios=db
   
   # it.cluster.env.type=DOCKER,NATIVE
   it.cluster.env.type=NATIVE
   
   # it.cluster.adapters=jdbc,proxy
   it.cluster.adapters=proxy
   
   # it.cluster.databases=MySQL,PostgreSQL,openGauss
   it.cluster.databases=MySQL
   ```


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

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

[GitHub] [shardingsphere] taojintianxia commented on issue #22442: Why these two cases dosen't execute?

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

   can you distinguish the difference between Docker and Native, please have a try as following if negtive :
   ```
   it.run.modes=Standalone,Cluster
   it.run.modes=Cluster
   it.run.additional.cases=false
   
   #it.scenarios=db,tbl,readwrite_splitting,encrypt,shadow,dbtbl_with_readwrite_splitting,dbtbl_with_readwrite_splitting_and_encrypt,rdl_empty_rules,empty_rules,sharding_and_encrypt,encrypt_and_readwrite_splitting,encrypt_shadow,readwrite_splitting_and_shadow,sharding_and_shadow,sharding_encrypt_shadow
   it.scenarios=db
   
   # it.cluster.env.type=DOCKER,NATIVE
   it.cluster.env.type=DOCKER
   
   # it.cluster.adapters=jdbc,proxy
   it.cluster.adapters=proxy
   
   # it.cluster.databases=MySQL,PostgreSQL,openGauss
   it.cluster.databases=MySQL
   ```
   luanch up the docker destop before you try this test.


-- 
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 #22442: Why these two cases dosen't execute?

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

   @taojintianxia Can you help check 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.

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

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

[GitHub] [shardingsphere] boyjoy1127 closed issue #22442: Why these two cases dosen't execute?

Posted by GitBox <gi...@apache.org>.
boyjoy1127 closed issue #22442: Why these two cases dosen't execute?
URL: https://github.com/apache/shardingsphere/issues/22442


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