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

nonaggregated column 'mike.features_metrics.value' - fix MySQL 8 error #75

Closed
macbre opened this issue Mar 1, 2019 · 0 comments
Closed

nonaggregated column 'mike.features_metrics.value' - fix MySQL 8 error #75

macbre opened this issue Mar 1, 2019 · 0 comments
Labels
bug Something isn't working
Milestone
v0.2

Comments

@macbre
Copy link
Contributor

macbre commented Mar 1, 2019 •
edited
Loading 

mysql.connector.errors.ProgrammingError: 1055 (42000): Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mike.features_metrics.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

An aggregate function is missing for value column.
@macbre macbre added the bug Something isn't working label Mar 1, 2019
@macbre macbre added this to the v0.2 milestone Mar 1, 2019
macbre added a commit that referenced this issue Mar 2, 2019
@macbre
Storage| get_feature_metrics_history - nonaggregated column 'mike.fea…
4c55d9a 
…tures_metrics.value'

Fixes #75
@macbre macbre mentioned this issue Mar 2, 2019
Merged
@macbre macbre closed this as completed in #76 Mar 2, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
v0.2
Development

No branches or pull requests
1 participant
@macbre