Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0029444 | Openbravo ERP | K. Packaging | public | 2015-03-27 13:47 | 2022-02-01 08:09 |
|
| Reporter | aldoescob | |
| Assigned To | Triage Platform Base | |
| Priority | high | Severity | minor | Reproducibility | always |
| Status | acknowledged | Resolution | open | |
| Platform | | OS | 30 | OS Version | CentOS 6.4 |
| Product Version | 3.0PR14Q3.5 | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | No |
| Web browser | Google Chrome, Mozilla Firefox |
| Modules | Openbravo 3.0 Framework |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0029444: SETOF error due to wrong export of function |
| Description | I created a function RETURNS SETOF record, correctly tested in Postgresql enviroment, but Openbravo's rebuild doesn't recognize it, shows "89504 WARN - SQL Command failed with: ERROR: no se puede usar RETURN QUERY en una función que no ha sido declarada SETOF", a fatal rebiuld ERROR. This funcion have SETOF word, but is exported a "VARCHAR" returns in the xml files.
|
| Steps To Reproduce | try installing a module with function with SETOF sentence, I attach a example,
|
| Proposed Solution | I tried replace "VARCHAR" for "SETOF record" in xml files in .obx package, but Openbravo's rebuild recognizes a "VOID" return in their logs with a fatal ERROR. |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | design defect | 0025433 | | acknowledged | Triage Platform Base | Script export.database changes return type stored procedure | | related to | design defect | 0029492 | | closed | alostale | Wrong export of a view | | related to | feature request | 0052297 | | new | Triage Platform Base | Add SETOF return value |
|
| Attached Files |  RES_SETOF_ERROR.txt (27,239) 2015-03-27 13:47
https://issues.openbravo.com/file_download.php?file_id=7943&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2015-03-27 13:47 | aldoescob | New Issue | |
| 2015-03-27 13:47 | aldoescob | Assigned To | => shuehner |
| 2015-03-27 13:47 | aldoescob | File Added: RES_SETOF_ERROR.txt | |
| 2015-03-27 13:47 | aldoescob | Web browser | => Google Chrome, Mozilla Firefox |
| 2015-03-27 13:47 | aldoescob | Modules | => Openbravo 3.0 Framework |
| 2015-03-27 13:47 | aldoescob | Triggers an Emergency Pack | => No |
| 2015-03-30 13:21 | aldoescob | Issue Monitored: aldoescob | |
| 2015-04-01 14:37 | aldoescob | Issue End Monitor: aldoescob | |
| 2015-05-12 16:46 | shuehner | Assigned To | shuehner => platform |
| 2015-11-10 16:30 | alostale | Relationship added | related to 0029492 |
| 2015-11-10 16:30 | alostale | Status | new => acknowledged |
| 2015-11-11 10:39 | alostale | Relationship added | related to 0025433 |
| 2015-11-11 10:39 | alostale | OBNetwork customer | => No |
| 2015-11-11 10:39 | alostale | Web browser | Google Chrome, Mozilla Firefox => Google Chrome, Mozilla Firefox |
| 2015-11-11 10:39 | alostale | Note Added: 0081678 | |
| 2015-11-11 10:39 | alostale | Type | defect => design defect |
| 2022-02-01 08:09 | alostale | Assigned To | platform => Triage Platform Base |
| 2023-04-29 01:34 | axelmercado | Relationship added | related to 0052297 |