Timeline for Sub query not working as expected trying to order by then group by, MySQL 5.5 vs 5.7
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 20, 2019 at 19:35 | vote | accept | jtlindsey | ||
| Feb 20, 2019 at 19:08 | answer | added | Randi Vertongen | timeline score: 1 | |
| Feb 20, 2019 at 19:02 | comment | added | Jehad Keriaki |
Check this variable in your 5.5 and 5.7 environments: SHOW VARIABLES LIKE "sql_mode". I think you will find "ONLY_FULL_GROUP_BY" in 5.7. You can change it if you want so it works like 5.5
|
|
| Feb 20, 2019 at 18:15 | review | First posts | |||
| Feb 20, 2019 at 23:26 | |||||
| Feb 20, 2019 at 18:11 | history | asked | jtlindsey | CC BY-SA 4.0 |