| Category: | Bug report |
Priority: | Normal |
Status: | Assigned |
| Project: | Severity: | Minor |
Resolution: | Open |
|
| Component: | Reproducibility: | Always |
Assigned to: |
This is essentially the same bug as 0001169 but I can't change the category to iReport NB
The query designer attempts to use an output-column alias in the GROUP BY clause which causes a problem with the Oracle JDBC driver. In Oracle you cannot use aliases in the GROUP BY section.
If tried Oracle returns
"Error:SQL problems:ORA-00904: "ALIAS_NAME_HERE": invalid identifier
