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

SQL parser can not tell the difference of '~id =1' and '~(id =1)' #302

Closed
sunsun314 opened this issue Oct 23, 2017 · 3 comments
Closed

SQL parser can not tell the difference of '~id =1' and '~(id =1)' #302

sunsun314 opened this issue Oct 23, 2017 · 3 comments
Assignees
Labels
Druid Parser Function resolve problem has been fixed by developer sql-coverage verified issue's resolve was verified by tester
Milestone

Comments

@sunsun314
Copy link
Contributor

Steps:
  use dble to exec the sql " select * from suntest where ~ id = 1;" ,4 result
  find the record mysql node exec the same sql one by one every result is 0 result
Reason:
  Druid has some error in parse '~',wait new druid version to release
  https://github.com/alibaba/druid/pull/2056

@sunsun314
Copy link
Contributor Author

wait until update the druid import in dble

@sunsun314 sunsun314 reopened this Dec 27, 2017
@yanhuqing666 yanhuqing666 added the resolve problem has been fixed by developer label Oct 11, 2018
@yanhuqing666 yanhuqing666 added this to the 2.18.11.0 milestone Oct 11, 2018
@FlyingMao FlyingMao added the verified issue's resolve was verified by tester label Oct 31, 2018
@FlyingMao FlyingMao assigned FlyingMao and unassigned yexiaoli88 Oct 31, 2018
@FlyingMao
Copy link

verified version:
5.6.29-dble-9.9.9.9-359645c-20181029082136

@FlyingMao
Copy link

for tester:
suggest autotest position: sqls/select/expression.sql (reference line 62、64)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Druid Parser Function resolve problem has been fixed by developer sql-coverage verified issue's resolve was verified by tester
Projects
None yet
Development

No branches or pull requests

6 participants