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 , 18 years ago
| Status: | new → assigned |
|---|
comment:2 by , 18 years ago
| 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