View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0016330 | mantisbt | db oracle | public | 2013-08-27 05:57 | 2014-12-08 00:34 |
Reporter | dregad | Assigned To | dregad | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Target Version | 1.3.0-beta.1 | Fixed in Version | 1.3.0-beta.1 | ||
Summary | 0016330: html_status_percentage_legend() causes error ORA-00923 | ||||
Description | When displaying my_view_page.php on Oracle with $g_status_percentage_legend = ON, an SQL error occurs Database query failed. Error received from database was 923: ORA-00923: FROM keyword not found where expected for the query: SELECT status, COUNT(*) number | ||||
Additional Information | This occurs with latest trunk of oracle branch (commit 7c0dcd771) | ||||
Tags | No tags attached. | ||||
MantisBT: master 6bb680b9 2013-08-27 01:59 Details Diff |
Don't use reserved SQL keyword as column alias Using 'number' as alias for column in html_status_percentage_legend() function causes error ORA-00923 when displaying my_view_page.php on Oracle. Fixes 0016330 |
Affected Issues 0016330 |
|
mod - core/helper_api.php | Diff File |