Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0039136Openbravo ERPA. Platformpublic2018-08-14 14:062018-08-29 09:50
javietxe 
platform 
normalmajorhave not tried
newopen 
5
 
 
Core
No
0039136: SERQA 4497: Add support for postgresql jsonb operators in DBSourceManager
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 [^]
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
No tags attached.
xml AD_TEST.xml (165) 2018-08-29 09:46
https://issues.openbravo.com/file_download.php?file_id=12085&type=bug
Issue History
2018-08-14 14:06javietxeNew Issue
2018-08-14 14:06javietxeAssigned To => platform
2018-08-14 14:06javietxeFile Added: OBBUTF_ORDERLINE.xml
2018-08-14 14:06javietxeModules => Core
2018-08-14 14:06javietxeTriggers an Emergency Pack => No
2018-08-29 08:51caristuTypedesign defect => feature request
2018-08-29 09:46caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=17576#r17576
2018-08-29 09:46caristuFile Deleted: OBBUTF_ORDERLINE.xml
2018-08-29 09:46caristuFile Added: AD_TEST.xml
2018-08-29 09:46caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=17577#r17577
2018-08-29 09:50caristuSummarySERQA 4497: Add jsonb operators for postgresql in the DBSourceManager => SERQA 4497: Add support for postgresql jsonb operators in DBSourceManager
2018-08-29 09:50caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=17578#r17578

There are no notes attached to this issue.