153
97%

Ran 18 Jun 2021 03:43PM UTC

Jobs 1

Files 1

Run time 1s

Badge

Embed ▾

pending completion

Build # 153

Build Type

push

travis-ci-com

Committed by

preaction

Commit Message

fix mysql < 5.7.5 with only_full_group_by

From MySQL's docs, versions less than 5.7.5 support SQL-92's version of
GROUP BY, which requires all non-aggregate columns to show up in the
GROUP BY.

> SQL:1999 and later permits such nonaggregates per optional feature T301
> if they are functionally dependent on GROUP BY columns: If such
> a relationship exists between name and custid, the query is legal. This
> would be the case, for example, were custid a primary key of customers.
> MySQL 5.7.5 and later implements detection of functional dependence.
> https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html

Turns out Travis hasn't been testing on 5.6, which explains why it was
working (to my bewilderment, as I know this is an issue).

Thanks @augensalat for reporting this issue!

Fixes #36

Run Details

265 of 273 relevant lines covered (97.07%)

55.77 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
13	153.13 (COVERAGE=1)	18 Jun 2021 03:43PM UTC	0	97.07	Travis Job 153.13

Source Files on build 153

Detailed source file information is not available for this build.

preaction / Minion-Backend-mysql / 153
97%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 153

preaction / Minion-Backend-mysql / 153 97%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 153

preaction / Minion-Backend-mysql / 153
97%

README BADGES
x