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
| Status: | new → assigned |
|---|
comment:2 Changed 17 years ago by
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
Note: See
TracTickets for help on using
tickets.
(In [2290]) Fixes #246: Postgres doesn't support column aliases in where or having clause