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/10/14 09:31:04 UTC

[GitHub] [shardingsphere] z3sm opened a new issue #7789: Did the shardingshpere support sql contains 'and find_in_set()' and 'and exists()'

z3sm opened a new issue #7789:
URL: https://github.com/apache/shardingsphere/issues/7789


   ## Question
   
   I got  a sql ,there has function'find_in_set' and 'and exists':
   Wether or not supported this case?
   
   ```
   insert into table_insert(code, bno, is_confirm)
   SELECT t.code,
          ?,
          '0'
   FROM table_select t where
           AND t.columna = ?
           AND t.columnb = ?
           AND ( find_in_set(?, t.columnc) )
           AND EXISTS 
       (SELECT 1
       FROM table_exists ts
       WHERE ts.rule_id = t.rule_id
               AND ts.stage = ?
               AND ts.model = ? )
   ```


----------------------------------------------------------------
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] terrymanu closed issue #7789: Did the shardingshpere support sql contains 'and find_in_set()' and 'and exists()'

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


   


----------------------------------------------------------------
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] z3sm commented on issue #7789: Did the shardingshpere support sql contains 'and find_in_set()' and 'and exists()'

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


   the 'table_isnert' and 'table_select' is broadcast-tables table


----------------------------------------------------------------
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] tristaZero commented on issue #7789: Did the shardingshpere support sql contains 'and find_in_set()' and 'and exists()'

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


   Hi @z3sm 4.x is unsupported, but the master branch for 5.x release is likely to cover this case, I guess.
   Hi @strongduanmu do you think this SQL is in our `insert...select` supported list?


----------------------------------------------------------------
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] z3sm edited a comment on issue #7789: Did the shardingshpere support sql contains 'and find_in_set()' and 'and exists()'

Posted by GitBox <gi...@apache.org>.
z3sm edited a comment on issue #7789:
URL: https://github.com/apache/shardingsphere/issues/7789#issuecomment-708288759


   the 'table_insert' and 'table_select' is binding tables


----------------------------------------------------------------
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] strongduanmu edited a comment on issue #7789: Did the shardingshpere support sql contains 'and find_in_set()' and 'and exists()'

Posted by GitBox <gi...@apache.org>.
strongduanmu edited a comment on issue #7789:
URL: https://github.com/apache/shardingsphere/issues/7789#issuecomment-709786152


   > Hi @z3sm 4.x is unsupported, but the master branch for 5.x release is likely to cover this case, I guess.
   > Hi @strongduanmu do you think this SQL is in our `insert...select` supported list?
   
   @z3sm Hi, the `insert ... select ...` statement is already supported in the master branch, you can use `sharding-proxy` for testing. 😀
   
   You can also provide your configuration, and I will test the scenario that `insert ... select ...` statement includes `exists` subquery.
   


----------------------------------------------------------------
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] strongduanmu commented on issue #7789: Did the shardingshpere support sql contains 'and find_in_set()' and 'and exists()'

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


   > Hi @z3sm 4.x is unsupported, but the master branch for 5.x release is likely to cover this case, I guess.
   > Hi @strongduanmu do you think this SQL is in our `insert...select` supported list?
   
   @z3sm Hi, the `insert ... select ...` statement is already supported in the master branch, you can use `sharding-proxy` for testing. 😀
   


----------------------------------------------------------------
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] z3sm edited a comment on issue #7789: Did the shardingshpere support sql contains 'and find_in_set()' and 'and exists()'

Posted by GitBox <gi...@apache.org>.
z3sm edited a comment on issue #7789:
URL: https://github.com/apache/shardingsphere/issues/7789#issuecomment-708288759






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