0004018: ad_column_identifier don't work in c_location with locations without region selected

Description

In this locations, function returns null.

The problem is in function ad_column_identifier_ref_sql because it return wrong sql.
The sql returned is :
SELECT COALESCE(TO_CHAR(T.Address1), ' ')||' - '||
       COALESCE(TO_CHAR(T.Address2), ' ')||' - '||
       COALESCE(TO_CHAR(T.Postal), ' ')||' - '||
       COALESCE(TO_CHAR(T.City), ' ')||' - '||
       (SELECT COALESCE(TO_CHAR(TT.Name), ' ')
        FROM C_Region TT
        WHERE TT.C_Region_ID=T.C_Region_ID) ||' - '||
      (SELECT (SELECT COALESCE(TO_CHAR(MAX(TTT.Name)), TO_CHAR(TT.Name))
               FROM C_Country_Trl TTT
               WHERE TTT.C_Country_ID=TT.C_Country_ID
               AND TTT.AD_LANGUAGE=L.AD_LANGUAGE)
      FROM C_Country TT
      WHERE TT.C_Country_ID=T.C_Country_ID) ||' - '||
      COALESCE(TO_CHAR(T.IsActive), ' ') AS COLUMN_IDENTIFIER
FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE='es_ES') L, C_Location T
WHERE C_Location_Id=:c_ID

A example of correct sql is:
SELECT TO_CHAR(COALESCE(TO_CHAR(T.Address1),''))||' - '|| TO_CHAR(COALESCE(TO_CHAR(T.Address2),''))||' - '|| TO_CHAR(COALESCE(TO_CHAR(T.Postal),''))||' - '|| TO_CHAR(COALESCE(TO_CHAR(T.City),''))||' - '||
CASE WHEN (SELECT COALESCE(TO_CHAR(TT.Name), ' ')
           FROM C_Region TT WHERE TT.C_Region_ID=T.C_Region_ID)
     IS NULL THEN
           ' '
     ELSE (SELECT COALESCE(TO_CHAR(TT.Name), ' ')
            FROM C_Region TT WHERE TT.C_Region_ID=T.C_Region_ID) END ||' - ' || (SELECT (SELECT COALESCE(TO_CHAR(MAX(TTT.Name)), TO_CHAR(TT.Name))
FROM C_Country_Trl TTT
WHERE TTT.C_Country_ID=TT.C_Country_ID
AND TTT.AD_LANGUAGE=L.AD_LANGUAGE)
FROM C_Country TT WHERE TT.C_Country_ID=T.C_Country_ID)
||' - '||TO_CHAR(COALESCE(TO_CHAR(T.IsActive),'')) AS COLUMN_IDENTIFIER
FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, C_Location T WHERE C_Location_ID=:c_ID

Tags

PostgreSQL

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0003949

2.40

closed

cromero

ad_column_identifier don't work in c_location with locations without region selected

Notes
(0007796) svnbot (reporter) 2008-06-17 14:17	Repository: openbravo Revision: 5104 Author: cromeroherrero Date: 2008-06-17 14:17:43 +0200 (Tue, 17 Jun 2008) Fixed bug 4018: ad_column_identifier don't work in c_location with locations without region selected Added needed COALESCE --- U branches/r2.3x/src-wad/src/org/openbravo/wad/Wad.java --- https://dev.openbravo.com/websvn/openbravo/?rev=5104&sc=1 [^]

Issue History
Date Modified	Username	Field	Change
2008-06-17 13:47	cromero	New Issue
2008-06-17 13:47	cromero	Assigned To	=> cromero
2008-06-17 13:47	cromero	Status	new => scheduled
2008-06-17 14:17	svnbot	Checkin
2008-06-17 14:17	svnbot	Note Added: 0007796
2008-06-17 14:17	svnbot	Status	scheduled => resolved
2008-06-17 14:17	svnbot	Resolution	open => fixed
2008-06-17 14:17	svnbot	svn_revision	=> 5104
2008-06-23 23:26	cromero	Fixed in Version	=> 2.35MP6
2008-06-24 17:02	plujan	Tag Attached: PostgreSQL
2008-12-12 17:51	psarobe	Regression testing	=> No
2008-12-12 17:51	psarobe	Status	resolved => closed