Package gudusoft.gsqlparser.resolver2.scope

Class OrderByScope

Object

gudusoft.gsqlparser.resolver2.scope.AbstractScope

gudusoft.gsqlparser.resolver2.scope.OrderByScope

All Implemented Interfaces:

IScope

public class OrderByScope
extends AbstractScope

Scope for ORDER BY clause.

Visibility rules: - Can access SELECT list columns (by name or alias) - Can access SELECT list positional references (ORDER BY 1, 2, etc.) - In some databases, can also access columns from FROM clause directly - Can reference aggregate functions in SELECT list

Example:

 SELECT department, COUNT(*) as emp_count
 FROM employees
 GROUP BY department
 ORDER BY emp_count DESC,  -- Can use SELECT list alias
          department ASC,  -- Can use SELECT list column
          1                -- Can use positional reference
 

The ORDER BY scope primarily delegates to SELECT scope, but may also access FROM scope depending on database vendor.

Field Summary

Fields inherited from class gudusoft.gsqlparser.resolver2.scope.AbstractScope

node, parent, scopeType

Constructor Summary

Constructors

Constructor	Description
OrderByScope(IScope parent, TOrderBy orderByNode)

Method Summary

Modifier and Type	Method	Description
IScope	getFromScope()	Get the FROM scope.
TOrderBy	getOrderByNode()
IScope	getSelectScope()	Get the SELECT scope.
void	setFromScope(IScope fromScope)	Set the FROM scope for column resolution.
void	setSelectScope(IScope selectScope)	Set the SELECT scope for alias resolution.
String	toString()

Methods inherited from class gudusoft.gsqlparser.resolver2.scope.AbstractScope

addChild, fullyQualify, getChildren, getNode, getParent, getScopeType, getVisibleNamespaces, isWithin, resolve, resolveTable

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Details

OrderByScope

public OrderByScope(IScope parent,
 TOrderBy orderByNode)

Method Details

setSelectScope

public void setSelectScope(IScope selectScope)

Set the SELECT scope for alias resolution. ORDER BY can reference SELECT list columns and aliases.

Parameters:

selectScope - the SELECT scope

setFromScope

public void setFromScope(IScope fromScope)

Set the FROM scope for column resolution. In some databases, ORDER BY can reference FROM clause columns directly.

Parameters:

fromScope - the FROM scope

getSelectScope

public IScope getSelectScope()

Get the SELECT scope.

Returns:

the SELECT scope, or null if not set

getFromScope

public IScope getFromScope()

Get the FROM scope.

Returns:

the FROM scope, or null if not set

getOrderByNode

public TOrderBy getOrderByNode()

toString

public String toString()

Overrides:

toString in class AbstractScope