Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0039136 | Openbravo ERP | A. Platform | public | 2018-08-14 14:06 | 2023-07-04 12:34 |
|
| Reporter | javietxe | |
| Assigned To | Triage Platform Base | |
| Priority | normal | Severity | major | Reproducibility | have not tried |
| Status | new | Resolution | open | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0039136: SERQA 4497: Add support for postgresql jsonb operators in DBSourceManager |
| Description | The DBSourceManager doesn't accept jsonb operators for postgresql. As they are standard for postgres, these operators have to be added.
https://www.postgresql.org/docs/9.4/static/functions-json.html [^] |
| Steps To Reproduce | 1) Put core in "in development" status
2) Execute the following command to create a view using one of the jsonb operators:
CREATE OR REPLACE VIEW ad_test AS
SELECT '{"a": {"b":{"c": "foo"}}}'::json#>'{a,b}' AS t2;
3) Do an export database, note that the view is changed deleting some of the information of the jsonb operator (See attached).
4) Do an update.database -> an error is raised when trying to create the view |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  AD_TEST.xml (165) 2018-08-29 09:46
https://issues.openbravo.com/file_download.php?file_id=12085&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2018-08-14 14:06 | javietxe | New Issue | |
| 2018-08-14 14:06 | javietxe | Assigned To | => platform |
| 2018-08-14 14:06 | javietxe | File Added: OBBUTF_ORDERLINE.xml | |
| 2018-08-14 14:06 | javietxe | OBNetwork customer | => Yes |
| 2018-08-14 14:06 | javietxe | Modules | => Core |
| 2018-08-14 14:06 | javietxe | Resolution time | => 1535407200 |
| 2018-08-14 14:06 | javietxe | Triggers an Emergency Pack | => No |
| 2018-08-29 08:51 | caristu | Type | design defect => feature request |
| 2018-08-29 09:46 | caristu | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=17576#r17576 |
| 2018-08-29 09:46 | caristu | File Deleted: OBBUTF_ORDERLINE.xml | |
| 2018-08-29 09:46 | caristu | File Added: AD_TEST.xml | |
| 2018-08-29 09:46 | caristu | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=17577#r17577 |
| 2018-08-29 09:50 | caristu | Summary | SERQA 4497: Add jsonb operators for postgresql in the DBSourceManager => SERQA 4497: Add support for postgresql jsonb operators in DBSourceManager |
| 2018-08-29 09:50 | caristu | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=17578#r17578 |
| 2022-02-01 08:07 | alostale | Assigned To | platform => Triage Platform Base |