2040
69%

Ran 27 Sep 2013 01:15AM UTC

Jobs 9

Files 262

Run time –

Badge

Embed ▾

pending completion

Build # 2040

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

Run Details

12708 of 14438 relevant lines covered (88.02%)

793.95 hits per line

Uncovered Existing Lines

Lines	Coverage	File
4	100.0	Doctrine/ORM/Query/AST/Functions/TrimFunction.php
4	100.0	Doctrine/ORM/Tools/EntityGenerator.php
44	100.0	Doctrine/ORM/Query/SqlWalker.php

Jobs

ID	Job ID	Ran	Coverage
1	2040.1 (DB=mysql)	27 Sep 2013 01:06AM UTC	87.4	Travis Job 2040.1
2	2040.2 (DB=mysql)	27 Sep 2013 01:06AM UTC	87.52	Travis Job 2040.2
3	2040.3 (DB=mysql)	27 Sep 2013 01:09AM UTC	87.64	Travis Job 2040.3
4	2040.4 (DB=pgsql)	27 Sep 2013 01:12AM UTC	87.7	Travis Job 2040.4
5	2040.5 (DB=pgsql)	27 Sep 2013 01:13AM UTC	87.82	Travis Job 2040.5
6	2040.6 (DB=pgsql)	27 Sep 2013 01:17AM UTC	87.87	Travis Job 2040.6
7	2040.7 (DB=sqlite)	27 Sep 2013 01:17AM UTC	86.74	Travis Job 2040.7
8	2040.8 (DB=sqlite)	27 Sep 2013 01:20AM UTC	86.86	Travis Job 2040.8
9	2040.9 (DB=sqlite)	27 Sep 2013 01:20AM UTC	86.91	Travis Job 2040.9

Source Files on build 2040

Detailed source file information is not available for this build.

doctrine / doctrine2 / 2040
69%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 2040

doctrine / doctrine2 / 2040 69%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 2040

doctrine / doctrine2 / 2040
69%

README BADGES
x