Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

regexp support #356

Closed
denghc0607 opened this issue Sep 5, 2017 · 1 comment
Closed

regexp support #356

denghc0607 opened this issue Sep 5, 2017 · 1 comment

Comments

@denghc0607
Copy link

Please answer these questions before submitting your issue. Thanks!

Which version of Sharding-Jdbc do you using?

1.5.3

Expected behavior

Actual behavior

Steps to reproduce the behavior

Please provide the reproduce example codes (such as github link) if possible.

my sql as below:
select * from resourcetable where TITLE REGEXP 'abc' order by UPDTIME desc limit 0,1
sharding-columns : UPDTIME
the question is that when i use this sql to query resourcetable ,i got two records from two different Physical tables, so limit 0,1 doesn't work

terrymanu added a commit that referenced this issue Sep 6, 2017
@terrymanu
Copy link
Member

fixed at 1.5.4

# for free to join this conversation on GitHub. Already have an account? # to comment
Projects
None yet
Development

No branches or pull requests

2 participants