Skip to content
New issue

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

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

Already on GitHub? Sign in 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

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

No branches or pull requests

2 participants