Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0016928
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2011-04-28 17:402012-04-01 20:37
ReportervmromanosView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version3.0MP10
StatusclosedFix in branchpiFixed in SCM revisioneff2ac473db7
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_12
OS VersionDebian 5.0Database version8.3.8Ant version1.7.0
Product VersionSCM revision 
Merge Request Status
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
Summary

0016928: 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)
Tagscontrib
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0046029)
alostale (viewer)
2012-03-05 10:37

 no regression risk

Test in ora and pg
(0046067)
hgbot (developer)
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 (administrator)
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 (viewer)
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

- Issue History
Date Modified Username Field Change
2011-04-28 17:40 vmromanos New Issue
2011-04-28 17:40 vmromanos Assigned To => alostale
2011-04-28 17:40 vmromanos Modules => Core
2011-04-28 17:40 vmromanos OBNetwork customer => No
2011-05-02 11:15 alostale Tag Attached: contrib
2011-05-02 11:15 alostale Status new => scheduled
2011-05-02 11:15 alostale fix_in_branch => pi
2012-03-05 10:37 alostale Note Added: 0046029
2012-03-06 08:45 hgbot Checkin
2012-03-06 08:45 hgbot Note Added: 0046067
2012-03-06 08:45 hgbot Status scheduled => resolved
2012-03-06 08:45 hgbot Resolution open => fixed
2012-03-06 08:45 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/eff2ac473db75bacf77be609d9ba5d0736eed0a1 [^]
2012-03-14 13:07 AugustoMauch Note Added: 0046389
2012-03-14 13:07 AugustoMauch Status resolved => closed
2012-03-14 13:07 AugustoMauch Fixed in Version => 3.0MP10
2012-04-01 20:37 hudsonbot Checkin
2012-04-01 20:37 hudsonbot Note Added: 0047042

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker