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/11/27 07:42:02 UTC

[GitHub] [shardingsphere] zhangleidaniejian opened a new issue #8376: Can I use the like statement to query in shardingsphere JDBC 4? For example: like% XXX%

zhangleidaniejian opened a new issue #8376:
URL: https://github.com/apache/shardingsphere/issues/8376


   
   **Can I use the like statement to query in shardingsphere-JDBC 4? For example: like% XXX%**
   mysql:5.7
   shardingsphere-JDBC 4.1.1
   
   spring.shardingsphere.sharding.tables.writeoff_sales_order.actual-data-nodes = ds0.writeoff_sales_order_$->{0..4}
   spring.shardingsphere.sharding.tables.writeoff_sales_order.table-strategy.inline.sharding-column = order_no
   spring.shardingsphere.sharding.tables.writeoff_sales_order.table-strategy.inline.algorithm-expression = writeoff_sales_order_$->{order_no.toBigInteger() % 5}
   
   spring.shardingsphere.sharding.tables.writeoff_sales_order_detail.actual-data-nodes = ds0.writeoff_sales_order_detail_$->{0..4}
   spring.shardingsphere.sharding.tables.writeoff_sales_order_detail.table-strategy.inline.sharding-column = order_no
   spring.shardingsphere.sharding.tables.writeoff_sales_order_detail.table-strategy.inline.algorithm-expression = writeoff_sales_order_detail_$->{order_no.toBigInteger() % 5}
   
   spring.shardingsphere.sharding.binding-tables = writeoff_sales_order,writeoff_sales_order_detail
   spring.shardingsphere.props.sql.show = true
   
   
   
   ### SQL: SELECT count(0) FROM writeoff_sales_order a LEFT JOIN base_document_category d ON a.order_type = d.code AND d.document_type_code = 'sale_order' WHERE a.del_flag = 0 AND a.order_date >= ? AND a.order_date <= ? AND a.order_no = '%10160586975299994%'
   ### Cause: java.lang.NumberFormatException: For input string: "%"
   
   
   


----------------------------------------------------------------
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] kimmking commented on issue #8376: Can I use the like statement to query in shardingsphere JDBC 4? For example: like% XXX%

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


   what's the type of order_no ?


----------------------------------------------------------------
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 commented on issue #8376: Can I use the like statement to query in shardingsphere JDBC 4? For example: like% XXX%

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


   Can not support


----------------------------------------------------------------
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 #8376: Can I use the like statement to query in shardingsphere JDBC 4? For example: like% XXX%

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


   


----------------------------------------------------------------
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] zhangleidaniejian commented on issue #8376: Can I use the like statement to query in shardingsphere JDBC 4? For example: like% XXX%

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


   bigint


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