Opened 17 years ago

Closed 17 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 Changed 17 years ago by Nicklas Nordborg

Status: newassigned

comment:2 Changed 17 years ago by Nicklas Nordborg

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.