Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0024983 | Openbravo ERP | A. Platform | public | 2013-10-21 12:40 | 2014-05-22 06:24 |
|
| Reporter | daniOpenbravo | |
| Assigned To | AugustoMauch | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | new | Resolution | open | |
| Platform | | OS | 30 | OS Version | 13.04 |
| Product Version | 3.0MP18.3 | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | Google Chrome |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0024983: Aliases in computed columns. |
| Description | A computed column was created in order to calculate some custom operations in a window. When computed column is created, we must fill "sql logic" field in. The problem is that some sql queries that necessary have the union of one or more subqueries which have an alias, are translated by a process with character "." that brings an error when executing the query in the application: "Could not execute query".
|
| Steps To Reproduce | - Create a computed column.
- Fill in "sql logic" field with a sql statement that contains alias in subqueries. (Example query attached).
- After compiling, open window that contains the field of the computed column with the query.
- An error is shown: "Could not execute query".
|
| Proposed Solution | After investigating, we realized that parsed sql statement takes alias from subqueries and denotes them like "name_.alias" (in my example: project0_.alias) and the database does not recognize it as a permitted alias.
I attach an example query and parsed query.
You can reproduce sql query in "Pi". In parsed query there are some customized alias that we have not deleted because it does not matter. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  ConsultaSQLgen (875) 2013-10-21 12:41
https://issues.openbravo.com/file_download.php?file_id=6453&type=bug
consultaParseada (7,110) 2013-10-21 12:41
https://issues.openbravo.com/file_download.php?file_id=6454&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2013-10-21 12:40 | daniOpenbravo | New Issue | |
| 2013-10-21 12:40 | daniOpenbravo | Assigned To | => AugustoMauch |
| 2013-10-21 12:40 | daniOpenbravo | Web browser | => Google Chrome |
| 2013-10-21 12:40 | daniOpenbravo | Modules | => Core |
| 2013-10-21 12:40 | daniOpenbravo | Triggers an Emergency Pack | => No |
| 2013-10-21 12:41 | daniOpenbravo | File Added: ConsultaSQLgen | |
| 2013-10-21 12:41 | daniOpenbravo | File Added: consultaParseada | |
| 2014-05-04 16:03 | Practics | Issue Monitored: Practics | |
| 2014-05-22 06:24 | eintelau | Issue Monitored: eintelau | |