Some of the EFQ tests fail with:

Exception thrown: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

This is a case of core outputting an invalid SQL query, but we can probably workaround it.

CommentFileSizeAuthor
#1 986760-order-by-group-by-clause.patch3.33 KBdamien tournoud

Comments

damien tournoud’s picture

damien tournoud commented
Status: Active » Needs review
StatusFileSize
new 986760-order-by-group-by-clause.patch3.33 KB

Suggested patch. This makes the EFQ tests pass.

ben.bunk’s picture

ben.bunk commented

Will test this shortly.

ben.bunk’s picture

ben.bunk commented

I have tested this to fix this related bug #1013396: User list query fails on SQL Server

damien tournoud’s picture

damien tournoud commented
Status: Needs review » Fixed

Committed to HEAD.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.