Openbravo Issue Tracking System - Openbravo ERP | |||||||||||||||||||
| View Issue Details | |||||||||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||||||||||||
| 0035393 | Openbravo ERP | A. Platform | public | 2017-03-01 10:26 | 2017-03-02 14:06 | ||||||||||||||
| Reporter | aferraz | ||||||||||||||||||
| Assigned To | platform | ||||||||||||||||||
| Priority | normal | Severity | major | Reproducibility | always | ||||||||||||||
| Status | closed | Resolution | duplicate | ||||||||||||||||
| Platform | OS | 30 | OS Version | Professional Appliance | |||||||||||||||
| Product Version | |||||||||||||||||||
| Target Version | Fixed in Version | ||||||||||||||||||
| Merge Request Status | |||||||||||||||||||
| Review Assigned To | |||||||||||||||||||
| OBNetwork customer | |||||||||||||||||||
| Web browser | |||||||||||||||||||
| Modules | Core | ||||||||||||||||||
| Support ticket | |||||||||||||||||||
| Regression level | |||||||||||||||||||
| Regression date | |||||||||||||||||||
| Regression introduced in release | |||||||||||||||||||
| Regression introduced by commit | |||||||||||||||||||
| Triggers an Emergency Pack | No | ||||||||||||||||||
| Summary | 0035393: IN clause in view not properly exported using postgresql | ||||||||||||||||||
| Description | IN clause in view not properly exported using postgresql | ||||||||||||||||||
| Steps To Reproduce | Open c_invoice_candidate_v view with pgAdmin. Change in the view: (o.docstatus = 'CO' OR o.docstatus = 'CL' OR o.docstatus = 'IP') with: o.docstatus IN ('CO', 'CL', 'IP') Save it and run ant export.database. Check view is correctly exported. Revert previous change. Change in the view: AND ( dt.docsubtypeso <> 'ON' AND dt.docsubtypeso <> 'OB' AND dt.docsubtypeso <> 'WR' ) with: AND dt.docsubtypeso NOT IN ('ON', 'OB', 'WR') Save it and run ant export.database. Check view is correctly exported. Revert previous change. Now, make both changes together in the view, export them and check they are not correctly exported: Instead of: o.docstatus IN ('CO', 'CL', 'IP') we get: (o.docstatus IN ('CO', 'CL', 'IP'])) Instead of: AND dt.docsubtypeso NOT IN ('ON', 'OB', 'WR') we get: (dt.docsubtypeso <> ALL (ARRAY['ON', 'OB', 'WR')) | ||||||||||||||||||
| Proposed Solution | |||||||||||||||||||
| Additional Information | |||||||||||||||||||
| Tags | No tags attached. | ||||||||||||||||||
| Relationships |
| ||||||||||||||||||
| Attached Files | |||||||||||||||||||
| Issue History | |||||||||||||||||||
| Date Modified | Username | Field | Change | ||||||||||||||||
| 2017-03-01 10:26 | aferraz | New Issue | |||||||||||||||||
| 2017-03-01 10:26 | aferraz | Assigned To | => platform | ||||||||||||||||
| 2017-03-01 10:26 | aferraz | Modules | => Core | ||||||||||||||||
| 2017-03-01 10:26 | aferraz | Triggers an Emergency Pack | => No | ||||||||||||||||
| 2017-03-01 10:28 | aferraz | Relationship added | related to 0035341 | ||||||||||||||||
| 2017-03-02 14:06 | alostale | Relationship added | duplicate of 0029492 | ||||||||||||||||
| 2017-03-02 14:06 | alostale | Status | new => closed | ||||||||||||||||
| 2017-03-02 14:06 | alostale | Resolution | open => duplicate | ||||||||||||||||
| There are no notes attached to this issue. |