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

SELECT statement sum(value) as value doesn't work properly #1307

Closed
githubmanticore opened this issue Aug 1, 2023 · 1 comment
Closed

SELECT statement sum(value) as value doesn't work properly #1307

githubmanticore opened this issue Aug 1, 2023 · 1 comment

Comments

@githubmanticore
Copy link
Contributor

Manticore 6.0.3 0098ac0d7@230308 dev (columnar 2.0.3 a1c8367@230307) (secondary 2.0.3 a1c8367@230307)

select sum(value) as value from metrics limit 10; 
ERROR 1064 (42000): index metrics: parse error: unknown column: value 

But in version Manticore 5.0.2 348514c86@220530 dev (columnar 1.15.4 2fef34e@220522) (secondary 1.15.4 2fef34e@220522) it was worked

mysql> select sum(value) as value from metrics limit 10; 
+------------+ 
| value      | 
+------------+ 
| 1409743430 | 
+------------+ 
@githubmanticore
Copy link
Contributor Author

githubmanticore commented Aug 1, 2023

➤ Stan commented:

fixed at 18a04c1 and now aggregate could alias existed attribute

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