Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
ID | ||||||||||||
0056059 | ||||||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
feature request | [Openbravo ERP] A. Platform | minor | have not tried | 2024-07-18 13:08 | 2024-07-18 13:30 | |||||||
Reporter | shuehner | View Status | public | |||||||||
Assigned To | Triage Platform Base | |||||||||||
Priority | normal | Resolution | open | Fixed in Version | ||||||||
Status | new | Fix in branch | Fixed in SCM revision | |||||||||
Projection | none | ETA | none | Target Version | ||||||||
OS | Any | Database | Any | Java version | ||||||||
OS Version | Database version | Ant version | ||||||||||
Product Version | SCM revision | |||||||||||
Review Assigned To | ||||||||||||
Web browser | ||||||||||||
Modules | Core | |||||||||||
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 | |||||||||||
Tags | No tags attached. | |||||||||||
Attached Files | ||||||||||||
![]() |
||||||||
|
![]() |
|
(0167131) hgbot (developer) 2024-07-18 13:30 |
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1308 [^] |
![]() |
|||
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 |
Copyright © 2000 - 2009 MantisBT Group |