Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0049823Openbravo ERPA. Platformpublic2022-07-18 09:442022-07-18 13:58
Reporterjarmendariz 
Assigned Tojarmendariz 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR22Q4 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0049823: Remove unneeded case change in query parameter
DescriptionMethod selectTableName in ReferencedTables_data.xsql converts to lower case the ad_table_id parameter it receives. As this parameter is an identifier (an UUID), there is no need to do this conversion.
Steps To ReproduceSee description
Proposed SolutionRemove the lower() in the where clause:

where lower(ad_table_id) = lower(?)
Additional Information
TagsNo tags attached.
Relationships
related to defect 0049485 closed Triage Platform Base Improve error messages after clicking a link 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-07-18 09:44jarmendarizNew Issue
2022-07-18 09:44jarmendarizAssigned To => jarmendariz
2022-07-18 09:44jarmendarizOBNetwork customer => No
2022-07-18 09:44jarmendarizModules => Core
2022-07-18 09:44jarmendarizTriggers an Emergency Pack => No
2022-07-18 09:48jarmendarizRelationship addedrelated to 0049485
2022-07-18 10:00hgbotMerge Request Status => open
2022-07-18 10:00hgbotNote Added: 0139373
2022-07-18 13:58hgbotMerge Request Statusopen => approved
2022-07-18 13:58hgbotResolutionopen => fixed
2022-07-18 13:58hgbotStatusnew => closed
2022-07-18 13:58hgbotFixed in Version => PR22Q4
2022-07-18 13:58hgbotNote Added: 0139389
2022-07-18 13:58hgbotNote Added: 0139390

Notes
(0139373)
hgbot   
2022-07-18 10:00   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/648 [^]
(0139389)
hgbot   
2022-07-18 13:58   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/648 [^]
(0139390)
hgbot   
2022-07-18 13:58   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 5bade3f1515b87f4d10c89d24f22d2efe41235be
Author: Javier Armendáriz <javier.armendariz@openbravo.com>
Date: 18-07-2022 09:59:29
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/5bade3f1515b87f4d10c89d24f22d2efe41235be [^]

Fixed ISSUE-49823: Removed unneeded lower case transformation to table ID query

---
M src/org/openbravo/erpCommon/utility/ReferencedTables_data.xsql
---