DBAL-607: [GH-371] DDC-2662 - SQLServer expects the `OVER` clause to only include columns from the `FROM` clause #1821

Closed
doctrinebot opened this Issue Sep 15, 2013 · 4 comments

2 participants

@doctrinebot

Jira issue originally created by user @doctrinebot:

This issue is created automatically through a Github pull request on behalf of Ocramius:

Url: #371

Message:

DDC-2622 - SQLServer expects the OVER clause to only include columns from the FROM clause

As of http://technet.microsoft.com/en-us/library/ms189461.aspx :

`orderbyexpression:

Specifies a column or expression on which to sort. orderbyexpression can only refer to columns made available by the FROM clause. An integer cannot be specified to represent a column name or alias.

That basically means that table aliases used to fetch the selected columns should NOT be included in the OVER clause.

@doctrinebot

Comment created by @ocramius:

Duplicate of DDC-2622

@doctrinebot

Issue was closed with resolution "Duplicate"

@doctrinebot

Comment created by @doctrinebot:

A related Github Pull-Request [GH-371] was closed:
#371

@doctrinebot

Comment created by @doctrinebot:

A related Github Pull-Request [GH-789] was closed:
doctrine/doctrine2#789

@doctrinebot doctrinebot added the Bug label Dec 7, 2015
@Ocramius Ocramius was assigned by doctrinebot Dec 7, 2015
@doctrinebot doctrinebot closed this Dec 7, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment