0004034: Register_data.xsql fails con compile

Description

     [java] 5917 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/Register/Register_data.xsql processed
     [java] 5922 [main] ERROR org.openbravo.data.Sqlc - SQL error in query:
     [java] SELECT COALESCE(AD_Registration_Info.Isregistrationactive, 'N') AS Isregistrationactive,
     [java] AD_Registration_Info.Registration_ID,
     [java] AD_Registration_Info.Contactfirstname,
     [java] AD_Registration_Info.ContactLastName,
     [java] AD_Registration_Info.Contactjobtitle,
     [java] AD_Registration_Info.Contactphone,
     [java] AD_Registration_Info.Contactemail,
     [java] AD_Registration_Info.Companyname,
     [java] AD_Registration_Info.Companywebsite,
     [java] AD_Registration_Info.Companycountry,
     [java] (CASE WHEN AD_Registration_Info.Companycountry IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR((CASE WHEN tableTRL1.Name IS NULL THEN TO_CHAR(table1.Name) ELSE TO_CHAR(tableTRL1.Name) END)), ''))),'') ) END) AS CompanycountryR,
     [java] AD_Registration_Info.Companyindustry,
     [java] (CASE WHEN AD_Registration_Info.Companyindustry IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(list1.name),'') ) END) AS CompanyindustryR,
     [java] AD_Registration_Info.Companynum_Employees,
     [java] (CASE WHEN AD_Registration_Info.Companynum_Employees IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(list2.name),'') ) END) AS Companynum_EmployeesR,
     [java] COALESCE(AD_Registration_Info.Wanttopartner, 'N') AS Wanttopartner,
     [java] COALESCE(AD_Registration_Info.Isevaluating, 'N') AS Isevaluating,
     [java] AD_Registration_Info.Comments,
     [java] COALESCE(AD_Registration_Info.Contactme, 'N') AS Contactme,
     [java] COALESCE(AD_Registration_Info.OB_Vision, 'N') AS OB_Vision,
     [java] COALESCE(AD_Registration_Info.OB_Development, 'N') AS OB_Development,
     [java] COALESCE(AD_Registration_Info.OB_Development_Announce, 'N') AS OB_Development_Announce,
     [java] COALESCE(AD_Registration_Info.OB_Commits, 'N') AS OB_Commits,
     [java] AD_Registration_Info.Registernow,
     [java] AD_Registration_Info.AD_Org_ID,
     [java] AD_Registration_Info.AD_Client_ID,
     [java] AD_Registration_Info.AD_Registration_Info_ID,
     [java] COALESCE(AD_Registration_Info.IsActive, 'N') AS IsActive,
     [java] AD_Registration_Info.Postpone_Date,
     [java]
     [java] '' AS TR_BGCOLOR, '' as total_count,
     [java] AD_Registration_Info.Created,
     [java] AD_Registration_Info.CreatedBy,
     [java] AD_Registration_Info.Updated,
     [java] AD_Registration_Info.UpdatedBy, ? AS LANGUAGE, '' AS AD_USER_CLIENT, '' AS AD_ORG_CLIENT
     [java] FROM AD_Registration_Info left join (select C_Country_ID, Name from C_Country) table1 on (AD_Registration_Info.Companycountry = table1.C_Country_ID) left join (select C_Country_ID,AD_Language, Name from C_Country_TRL) tableTRL1 on (table1.C_Country_ID = tableTRL1.C_Country_ID and tableTRL1.AD_Language = ?) left join ad_ref_list_v list1 on (AD_Registration_Info.Companyindustry = list1.value and list1.ad_reference_id = 1000300003 and list1.ad_language = ?) left join ad_ref_list_v list2 on (AD_Registration_Info.Companynum_Employees = list2.value and list2.ad_reference_id = 1000300001 and list2.ad_language = ?)
     [java] WHERE 2=2
     [java] AND 1=1
     [java] AND AD_Registration_Info.AD_Client_ID IN ('1')
     [java] AND AD_Registration_Info.AD_Org_ID IN ('1')
     [java]
     [java] ORDER BY 1, 1
     [java]
     [java] Exception:org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = numeric
     [java] org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = numeric

Steps To Reproduce

Check out r5133 and run ant "install.source"

Notes
(0007822) jpabloae (reporter) 2008-06-18 09:37	The changes made to the Register window / table don't work in PostgreSQL.

(0007825) jpabloae (reporter) 2008-06-18 09:44	Confusion with duplicates: 4036 as marked as dup of this, but then as marked as resolved by a svnbot commit. To make this easier, let's mark this one as duplicate.

Issue History
Date Modified	Username	Field	Change
2008-06-18 08:33	jpabloae	New Issue
2008-06-18 08:33	jpabloae	Assigned To	=> cromero
2008-06-18 08:33	jpabloae	sf_bug_id	0 => 1996751
2008-06-18 09:37	jpabloae	Note Added: 0007822
2008-06-18 09:44	jpabloae	Status	new => closed
2008-06-18 09:44	jpabloae	Note Added: 0007825
2008-06-18 09:44	jpabloae	Duplicate ID	0 => 4036
2008-06-18 09:44	jpabloae	Resolution	open => duplicate

Relationships [ Relation Graph ] [ Dependency Graph ]