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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0022589

Openbravo ERP

A. Platform

public

2012-12-16 02:49

2013-03-05 18:15

Reporter

pjuvara

Assigned To

AugustoMauch

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

duplicate

Platform

OS Version

Product Version

3.0MP17

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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

Description

If you add to a table a SQL based computed column that contains the '<' or '>', any subsequent ant export.database command fails

Steps To Reproduce

I 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 Solution

Any special character in the SQL command column should be escaped.

Additional Information