Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0039136
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. Platformmajorhave not tried2018-08-14 14:062023-07-04 12:34
ReporterjavietxeView Statuspublic 
Assigned ToTriage Platform Base 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0039136: SERQA 4497: Add support for postgresql jsonb operators in DBSourceManager

DescriptionThe 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 Reproduce1) 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
TagsNo tags attached.
Attached Filesxml file icon AD_TEST.xml [^] (165 bytes) 2018-08-29 09:46

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- 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 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 View Revisions
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 View Revisions
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 View Revisions
2022-02-01 08:07 alostale Assigned To platform => Triage Platform Base


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker