Aggregated query without group by results errors when performing LCM actions unless the sql_mode value is changed.
Change-Id: I91c6ef71f22d32cf401a5113ae4e28e1ab554bb6
Issue-ID: APPC-878
Signed-off-by: Aaron Hay <ah415j@att.com>
master.cnf: |
# Apply this config only on the master.
[mysqld]
+ sql_mode = "NO_ENGINE_SUBSTITUTION"
log-bin
[localpathprefix]
master
slave.cnf: |
# Apply this config only on slaves.
[mysqld]
+ sql_mode = "NO_ENGINE_SUBSTITUTION"
super-read-only
[localpathprefix]
slave