gudusoft.gsqlparser.resolver2.scope

Class HavingScope

Object

gudusoft.gsqlparser.resolver2.scope.AbstractScope

gudusoft.gsqlparser.resolver2.scope.HavingScope

All Implemented Interfaces:

IScope

public class HavingScope
extends AbstractScope

Scope for HAVING clause.

Visibility rules: - Can access GROUP BY columns - Can access aggregate functions - Can access SELECT list aliases (in some databases) - Cannot access non-aggregated columns not in GROUP BY

Example:

 SELECT department, COUNT(*) as emp_count
 FROM employees
 GROUP BY department
 HAVING COUNT(*) > 10  -- Can use aggregates
    OR emp_count > 10  -- Can use SELECT list alias (database-dependent)
 

The HAVING scope has access to: - GROUP BY scope (for grouped columns) - SELECT scope (for SELECT list aliases, database-dependent)

Field Summary

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

node, parent, scopeType

Constructor Summary

Constructors

Constructor and Description
HavingScope(IScope parent, TExpression havingCondition)

Method Summary

Modifier and Type	Method and Description
IScope	getGroupByScope() Get the GROUP BY scope.
TExpression	getHavingCondition()
IScope	getSelectScope() Get the SELECT scope.
void	setGroupByScope(IScope groupByScope) Set the GROUP BY 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 Object

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

Constructor Detail

HavingScope

public HavingScope(IScope parent,
                   TExpression havingCondition)

Method Detail

setGroupByScope

public void setGroupByScope(IScope groupByScope)

Set the GROUP BY scope for column resolution. HAVING can reference columns that appear in GROUP BY.

Parameters:

groupByScope - the GROUP BY scope

setSelectScope

public void setSelectScope(IScope selectScope)

Set the SELECT scope for alias resolution. HAVING can reference SELECT list aliases in some databases.

Parameters:

selectScope - the SELECT scope

getGroupByScope

public IScope getGroupByScope()

Get the GROUP BY scope.

Returns:

the GROUP BY scope, or null if not set

getSelectScope

public IScope getSelectScope()

Get the SELECT scope.

Returns:

the SELECT scope, or null if not set

getHavingCondition

public TExpression getHavingCondition()

toString

public String toString()

Overrides:

toString in class AbstractScope