Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0046240 | Openbravo ERP | A. Platform | public | 2021-04-09 14:44 | 2022-02-01 07:24 |
| Reporter | mtaal | ||||
| 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 | No | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0046240: dbsourcemanager export database model does not support postgresql typecasting | ||||
| Description | In postgresql you can do things like this: WHERE dt.date_actual > (now() - '2 years'::interval) When using this in a materialized view and exporting it through the reporting server export action (which uses dbsourcemanager) it removes the '::interval' causing incorrect sql to be stored in our source code repos. We have to manually repair the sql before pushing. I saw the same with other type casting. This can also give trouble when calling postgresql functions as without type inference the function is not recognized. | ||||
| Steps To Reproduce | A simple example mv which would go wrong. Not sure if the dbsourcemanager out of the box exports materialized views. -- DROP MATERIALIZED VIEW public.m_test_export; CREATE MATERIALIZED VIEW public.m_test_export TABLESPACE pg_default AS SELECT o.ad_org_id FROM c_order o WHERE o.created > (now() - '2 years'::interval) WITH NO DATA; ALTER TABLE public.m_test_export OWNER TO tad; | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2021-04-09 14:44 | mtaal | New Issue | |||
| 2021-04-09 14:44 | mtaal | Assigned To | => platform | ||
| 2021-04-09 14:44 | mtaal | OBNetwork customer | => No | ||
| 2021-04-09 14:44 | mtaal | Modules | => Core | ||
| 2021-04-09 14:44 | mtaal | Triggers an Emergency Pack | => No | ||
| 2022-02-01 07:24 | alostale | Assigned To | platform => Triage Platform Base | ||
| There are no notes attached to this issue. |