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