[DiscordArchive] <@109652764488892416> do you know which sql files / queries create an issue with "ONLY_FULL_GROUP_BY
[DiscordArchive] <@109652764488892416> do you know which sql files / queries create an issue with "ONLY_FULL_GROUP_BY
Original source
<@109652764488892416> do you know which sql files / queries create an issue with "ONLY_FULL_GROUP_BY" ?
rektbyfaith
01-28-2019, 05:14 PM #1Archived author: Barbz • Posted: 2019-01-28T17:14:21.907000+00:00
Original source
<@109652764488892416> do you know which sql files / queries create an issue with "ONLY_FULL_GROUP_BY" ?
Original source
maybe we can fix them
rektbyfaith
01-28-2019, 05:14 PM #2Archived author: Barbz • Posted: 2019-01-28T17:14:31.737000+00:00
Original source
maybe we can fix them
Original source
<@307220419021373440> if you are speaking about mysql 5.7 modes, we "fixed" them all already. The problem is that those are in the base files (or older updates) so the fix will be effective only when we squash all the db updates
rektbyfaith
01-28-2019, 05:26 PM #3Archived author: Shin • Posted: 2019-01-28T17:26:40.516000+00:00
Original source
<@307220419021373440> if you are speaking about mysql 5.7 modes, we "fixed" them all already. The problem is that those are in the base files (or older updates) so the fix will be effective only when we squash all the db updates
Original source
you added the missing "group by" to the queries?
rektbyfaith
01-28-2019, 05:27 PM #4Archived author: Barbz • Posted: 2019-01-28T17:27:35.644000+00:00
Original source
you added the missing "group by" to the queries?
Original source
any commit in mind so I can have a look (curiosity)?
rektbyfaith
01-28-2019, 05:28 PM #5Archived author: Barbz • Posted: 2019-01-28T17:28:16.211000+00:00
Original source
any commit in mind so I can have a look (curiosity)?
Original source
Part of some DB backports, changing the default value of some tables. Not about group by iirc
rektbyfaith
01-28-2019, 05:29 PM #6Archived author: Shin • Posted: 2019-01-28T17:29:40.550000+00:00
Original source
Part of some DB backports, changing the default value of some tables. Not about group by iirc
Original source
from what i've gathered the issue is:
"apparently it's because we have SELECT statements missing "group by" so it means we don't do it the proper way"
rektbyfaith
01-28-2019, 05:30 PM #7Archived author: Barbz • Posted: 2019-01-28T17:30:35.498000+00:00
Original source
from what i've gathered the issue is:
"apparently it's because we have SELECT statements missing "group by" so it means we don't do it the proper way"
Original source
or update statements
rektbyfaith
01-28-2019, 05:30 PM #8Archived author: Barbz • Posted: 2019-01-28T17:30:46.647000+00:00
Original source
or update statements
Original source
or another query type
rektbyfaith
01-28-2019, 05:30 PM #9Archived author: Barbz • Posted: 2019-01-28T17:30:52.142000+00:00
Original source
or another query type
Original source
Mh.. Not sure
rektbyfaith
01-28-2019, 05:37 PM #10Archived author: Shin • Posted: 2019-01-28T17:37:58.939000+00:00
Original source
Mh.. Not sure