Openbravo Issue Tracking System - Openbravo ERP | ||||||||||||
| View Issue Details | ||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0056059 | Openbravo ERP | A. Platform | public | 2024-07-18 13:08 | 2024-07-18 13:30 | |||||||
| Reporter | shuehner | |||||||||||
| Assigned To | Triage Platform Base | |||||||||||
| Priority | normal | Severity | minor | 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 | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Support ticket | ||||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0056059: Oracle Cleanup: Remove oracle specific rownum in queries | |||||||||||
| Description | Several select queries have split code-path for postgres related to pagination On Postgres we use LIMIT and OFFSET syntax On Oracle we used ROWNUM as extra column and filtering on that. With oracle support gone we can just remove the Oracle specific code making it more readable. | |||||||||||
| Steps To Reproduce | Look at for example https://gitlab.com/openbravo/product/openbravo/-/blob/master/src/org/openbravo/erpCommon/info/BusinessPartnerMultiple.java?ref_type=heads#L427 [^] https://gitlab.com/openbravo/product/openbravo/-/blob/master/src/org/openbravo/erpCommon/info/BusinessPartnerMultiple_data.xsql?ref_type=heads#L64 [^] for the rownum, oraLimit1, oraLimit2 parameters to support this | |||||||||||
| Proposed Solution | Remove the extra code specific to supporting oracle | |||||||||||
| Additional Information | ||||||||||||
| Tags | No tags attached. | |||||||||||
| Relationships |
| |||||||||||
| Attached Files | ||||||||||||
| Issue History | ||||||||||||
| Date Modified | Username | Field | Change | |||||||||
| 2024-07-18 13:08 | shuehner | New Issue | ||||||||||
| 2024-07-18 13:08 | shuehner | Assigned To | => Triage Platform Base | |||||||||
| 2024-07-18 13:08 | shuehner | Modules | => Core | |||||||||
| 2024-07-18 13:08 | shuehner | Triggers an Emergency Pack | => No | |||||||||
| 2024-07-18 13:08 | shuehner | Relationship added | blocks 0053658 | |||||||||
| 2024-07-18 13:30 | hgbot | Note Added: 0167131 | ||||||||||
| Notes | |||||
|
|
|||||
|
|
||||