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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0022589
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2012-12-16 02:492013-03-05 18:15
ReporterpjuvaraView Statuspublic 
Assigned ToAugustoMauch 
PrioritynormalResolutionduplicateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0MP17SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0022589: Cannot add SQL based computed column that includes a "less than" character

DescriptionIf you add to a table a SQL based computed column that contains the '<' or '>', any subsequent ant export.database command fails
Steps To ReproduceI am trying to define a computed column that calculates the current depreciated value for an asset.
Following the instructions on http://wiki.openbravo.com/wiki/How_to_create_a_Computed_Column, [^] I added a column to the A_AMORTIZATIONLINE table with the following SQL

(SELECT -SUM(al.amortizationamt)
FROM A_AMORTIZATIONLINE AL, a_amortization a
WHERE al.a_amortization_id = a.a_amortization_id
AND a.acctdate <= NOW() AND al.a_asset_id = A_ASSET_ID)

after having created this column, I execute an ant export.database command and it fails as the '<' character is not allowed.
Proposed SolutionAny special character in the SQL command column should be escaped.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
duplicate of defect 0022062 closedshankarb '<' character in sqllogic for computed columns 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2012-12-16 02:49 pjuvara New Issue
2012-12-16 02:49 pjuvara Assigned To => AugustoMauch
2012-12-16 02:49 pjuvara Modules => Core
2012-12-16 02:49 pjuvara Triggers an Emergency Pack => No
2013-03-05 18:15 AugustoMauch Relationship added duplicate of 0022062
2013-03-05 18:15 AugustoMauch Status new => closed
2013-03-05 18:15 AugustoMauch Resolution open => duplicate


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker