7
69%
master: 69%

Ran 27 Sep 2013 01:23AM UTC

Files 261

Run time –

Badge

Embed ▾

Committed 27 Sep 2013 01:15AM UTC coverage: 86.736% (-0.003%) from 86.739%

Job # DB=sqlite

Build Type

Pull #801

travis-ci

Committed by

flip111

Commit Message

Update SqlWalker.php fixed wrong GROUP BY clause on SQL Server platform

Without this patch a query would like like:
```
SELECT c0_.Country AS sclr0
FROM Continent c0_ WITH (NOLOCK)
WHERE c0_.Country = 38
GROUP BY sclr0
```
Using the column alias in the GROUP BY clause. However this is not allowed on SQL Server. References:
1. http://stackoverflow.com/a/3841804
2. http://technet.microsoft.com/en-us/library/ms189499.aspx (Logical Processing Order of the SELECT statement)

The correct query should be:
```
SELECT c0_.Country AS sclr0
FROM Continent c0_ WITH (NOLOCK)
WHERE c0_.Country = 38
GROUP BY c0_.Country
```

Pull Request Pull Request #801: Update SqlWalker.php fixed wrong GROUP BY clause on SQL Server platform

Coverage Stats

12516 of 14430 relevant lines covered (86.74%)

84.58 hits per line

doctrine / doctrine2 / 2040 / 7
69%
master: 69%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 2040.7 (DB=sqlite)

doctrine / doctrine2 / 2040 / 7 69% master: 69%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Source Files on job 2040.7 (DB=sqlite)

doctrine / doctrine2 / 2040 / 7
69%
master: 69%

README BADGES
x