Opened 18 years ago

Closed 18 years ago

#246 closed defect (fixed)

Postgres doesn't support column aliases in where or having clause

Reported by: Nicklas Nordborg Owned by: Nicklas Nordborg
Priority: critical Milestone: BASE 2.0 RC2
Component: core Version:
Keywords: Cc:

Description

This is not considered in the Query API:s SelectedExpression object which just outputs the alias. Column aliases are supported in the group by and order by parts.

The SelectedExpression object is used in some parts of the analysis in BASE so these parts will not work when using Postgres.

We must check the database dialect for information if aliases are allowed or not.

Change History (2)

comment:1 by Nicklas Nordborg, 18 years ago

Status: newassigned

comment:2 by Nicklas Nordborg, 18 years ago

Resolution: fixed
Status: assignedclosed

(In [2290]) Fixes #246: Postgres doesn't support column aliases in where or having clause

Note: See TracTickets for help on using tickets.