Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016928Openbravo ERPA. Platformpublic2011-04-28 17:402012-04-01 20:37
Reportervmromanos 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS20OS VersionDebian 5.0
Product Version 
Target VersionFixed in Version3.0MP10 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0016928: Tab name first letter in capital validation not working in PostgreSQL
DescriptionThe tab name must start with a capital letter. There is a validation in the AD_TAB_TRG that checks it.

It looks like this validation is only working in Oracle but not in PostgreSQL.

Note: I haven't tested it in the application, but see:
http://builds.openbravo.com/job/int-full-oracle/1845/testReport/ [^] (Oracle, a JUnit properly failed)
http://builds.openbravo.com/job/int-full-pgsql/1837/testReport/ [^] (PG, not JUnit test failed)
Steps To Reproduce
Proposed Solution
Additional Information
Tagscontrib
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-04-28 17:40vmromanosNew Issue
2011-04-28 17:40vmromanosAssigned To => alostale
2011-04-28 17:40vmromanosModules => Core
2011-05-02 11:15alostaleTag Attached: contrib
2011-05-02 11:15alostaleStatusnew => scheduled
2011-05-02 11:15alostalefix_in_branch => pi
2012-03-05 10:37alostaleNote Added: 0046029
2012-03-06 08:45hgbotCheckin
2012-03-06 08:45hgbotNote Added: 0046067
2012-03-06 08:45hgbotStatusscheduled => resolved
2012-03-06 08:45hgbotResolutionopen => fixed
2012-03-06 08:45hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/eff2ac473db75bacf77be609d9ba5d0736eed0a1 [^]
2012-03-14 13:07AugustoMauchNote Added: 0046389
2012-03-14 13:07AugustoMauchStatusresolved => closed
2012-03-14 13:07AugustoMauchFixed in Version => 3.0MP10
2012-04-01 20:37hudsonbotCheckin
2012-04-01 20:37hudsonbotNote Added: 0047042

Notes
(0046029)
alostale   
2012-03-05 10:37   
no regression risk

Test in ora and pg
(0046067)
hgbot   
2012-03-06 08:45   
Repository: erp/devel/pi
Changeset: eff2ac473db75bacf77be609d9ba5d0736eed0a1
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Mar 05 10:36:32 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/eff2ac473db75bacf77be609d9ba5d0736eed0a1 [^]

fixed bug 16928: Tab name validation didn't work in PG

---
M src-db/database/model/triggers/AD_TAB_TRG.xml
---
(0046389)
AugustoMauch   
2012-03-14 13:07   
Code reviewed and fix tested in Oracle and PostgreSQL.

Apparently the 'between' operator of PostgreSQL ignores the case when is applied to strings (both 'C' between 'a' and 'z' and 'c' between 'A' and 'Z' evaluates to true). This does not happen if the character are translated to their ascii value
(0047042)
hudsonbot   
2012-04-01 20:37   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/640de9acc2d5 [^]

Maturity status: Test