GabrielBrascher opened a new issue #5175:
URL: https://github.com/apache/cloudstack/issues/5175
<!--
Verify first that your issue/request is not already reported on GitHub.
Also test if the latest release and main branch are affected too.
Always add information AFTER of these HTML comments, but no need to delete
the comments.
-->
##### ISSUE TYPE
<!-- Pick one below and delete the rest -->
* Enhancement Request
##### COMPONENT NAME
<!--
Categorize the issue, e.g. API, VR, VPN, UI, etc.
-->
~~~
DB
~~~
##### CLOUDSTACK VERSION
<!--
New line separated list of affected versions, commit ID for issues on main
branch.
-->
~~~
4.15.0.0, 4.15.1.0-RC3, 4.16
~~~
##### CONFIGURATION
<!--
Information about the configuration if relevant, e.g. basic network,
advanced networking, etc. N/A otherwise
-->
##### OS / ENVIRONMENT
<!--
Information about the environment if relevant, N/A otherwise
-->
```
mysql --version
mysql Ver 14.14 Distrib 5.7.34, for Linux (x86_64)
```
##### SUMMARY
<!-- Explain the problem/feature briefly -->
Seems to be related to MySQL only; MariaDB looks to be working fine. After
some MySQL configurations to "disable" `only_full_group_by` then the select
works.
This might be more a documentation than a cloudstack issue, but it is
important to raise and track alternatives to solve/mitigate it.
This could bring problems to unaware users.
Bear in mind that the CloudStack mgmt/UI seems to be all good, even with the
selects that failed; thus this is a minor issue.
##### STEPS TO REPRODUCE
<!--
For bugs, show exactly how to reproduce the problem, using a minimal
test-case. Use Screenshots if accurate.
For new features, show how the feature would be used.
-->
<!-- Paste example playbooks or commands between quotes below -->
~~~
Run a MySQL 'select' query on disk_offering_view or service_offering_view
~~~
<!-- You can also paste gist.github.com links for larger files -->
##### EXPECTED RESULTS
<!-- What did you expect to happen when running the steps above? -->
~~~
Select offerings views in MySQL
~~~
##### ACTUAL RESULTS
<!-- What actually happened? -->
<!-- Paste verbatim command output between quotes below -->
~~~
mysql> select * from disk_offering_view limit 1;
ERROR 1055 (42000): Expression #34 of SELECT list is not in GROUP BY clause
and contains nonaggregated column 'cloud.vsphere_storage_policy.value' which is
not functionally dependent on columns in GROUP BY clause; this is incompatible
with sql_mode=only_full_group_by
mysql> select * from service_offering_view limit 1;
ERROR 1055 (42000): Expression #34 of SELECT list is not in GROUP BY clause
and contains nonaggregated column 'cloud.vsphere_storage_policy.value' which is
not functionally dependent on columns in GROUP BY clause; this is incompatible
with sql_mode=only_full_group_by
~~~
Might be related to
[schema-41400to41500.sql#L423](https://github.com/apache/cloudstack/blob/bf6266188c89a5487383f216333ae10e878d2c10/engine/schema/src/main/resources/META-INF/db/schema-41400to41500.sql#L423).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
