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.

Sign up for GitHub

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

Jump to bottom

[bug]backquote with count(*) problem #8544

Closed
ttamatt opened this issue Sep 17, 2018 · 2 comments
Closed

[bug]backquote with count(*) problem #8544

ttamatt opened this issue Sep 17, 2018 · 2 comments
Assignees
@luigidellaquila
Labels
bug
Milestone
3.0.8

Comments

@ttamatt
Copy link

ttamatt commented Sep 17, 2018 •
edited
Loading

OrientDB Version: Latest Snapshot

Java Version: 1.8

OS: Centos 6.8

FAILED SQL

SELECT name as `name` , count(*) FROM V WHERE name IN ['Jack', 'Rose'] GROUP BY name LIMIT -1

SUCCESSFUL SQL

SELECT name as `name`   FROM V WHERE name IN ['Jack', 'Rose'] GROUP BY name LIMIT -1

Expected behavior

PROPERTIES
Jack
Rose

Actual behavior

Empty data

When I tried to use backquote with count(*), it doesn't return anything, but using name alone is okay, may you find the reason please?

Thanks,
Matt
luigidellaquila added a commit that referenced this issue Sep 17, 2018
@luigidellaquila
Fix SQL aggregate projections together with back-tick quoted aliases
ccbfdcc 
Resolves: #8544
@luigidellaquila luigidellaquila self-assigned this Sep 17, 2018
@luigidellaquila
Copy link
Member

Hi @ttamatt

I just pushed a fix, it will be released with 3.0.8

Thanks

Luigi

@luigidellaquila luigidellaquila added this to the 3.0.8 milestone Sep 17, 2018
@ttamatt
Copy link
Author

ttamatt commented Sep 18, 2018

Thanks！

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@luigidellaquila luigidellaquila

Labels
bug
Milestone
3.0.8
Development

No branches or pull requests
2 participants
@luigidellaquila @ttamatt