0004782: Changes in SQL_Record_Identifier after compilation

Index: src-db/database/sourcedata/AD_TABLE.xml =================================================================== --- src-db/database/sourcedata/AD_TABLE.xml (revision 6681) +++ src-db/database/sourcedata/AD_TABLE.xml (working copy) @@ -185,7 +185,7 @@   <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>  - <SQL_RECORD_IDENTIFIER><![CDATA[**No key found]]></SQL_RECORD_IDENTIFIER> + <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT (SELECT COALESCE(TO_CHAR(MAX(TTT.Name)), TO_CHAR(TT.Name)) FROM AD_Reference_Trl TTT WHERE TTT.AD_Reference_ID=TT.AD_Reference_ID AND TTT.AD_LANGUAGE=L.AD_LANGUAGE) ||' - '||(SELECT NAME FROM AD_REF_LIST_V WHERE AD_Language=L.AD_LANGUAGE AND Value=TT.ValidationType AND AD_Reference_ID=2) FROM AD_Reference TT WHERE TT.AD_Reference_ID=T.AD_Reference_ID) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, AD_Ref_Table T WHERE AD_Reference_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>   <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> </AD_TABLE> @@ -894,7 +894,7 @@   <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>  - <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Value),'')) FROM AD_Message TT WHERE TT.AD_Message_ID=T.AD_Message_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM AD_Language TT WHERE TT.AD_Language=T.AD_Language) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, AD_Message_Trl T WHERE AD_Message_Trl_ID=':c_ID']]></SQL_RECORD_IDENTIFIER> + <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>   <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> </AD_TABLE> @@ -1270,7 +1270,7 @@   <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>  - <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM AD_WF_Node TT WHERE TT.AD_WF_Node_ID=T.AD_WF_Next_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM AD_WF_Node TT WHERE TT.AD_WF_Node_ID=T.AD_WF_Node_ID) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, AD_WF_NodeNext T WHERE AD_WF_NodeNext_ID=':c_ID']]></SQL_RECORD_IDENTIFIER> + <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>   <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> </AD_TABLE> @@ -3399,7 +3399,7 @@   <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>  - <SQL_RECORD_IDENTIFIER><![CDATA[**No key found]]></SQL_RECORD_IDENTIFIER> + <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM AD_Client TT WHERE TT.AD_Client_ID=T.AD_Client_ID) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, AD_ClientInfo T WHERE AD_Client_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>   <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> </AD_TABLE> @@ -3446,7 +3446,7 @@   <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>  - <SQL_RECORD_IDENTIFIER><![CDATA[**No key found]]></SQL_RECORD_IDENTIFIER> + <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM AD_Org TT WHERE TT.AD_Org_ID=T.AD_Org_ID) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, AD_OrgInfo T WHERE AD_Org_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>   <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> </AD_TABLE> @@ -7404,7 +7404,7 @@   <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>  - <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT (SELECT COALESCE(TO_CHAR(MAX(TTT.MsgText)), TO_CHAR(TT.MsgText)) FROM AD_Message_Trl TTT WHERE TTT.AD_Message_ID=TT.AD_Message_ID AND TTT.AD_LANGUAGE=L.AD_LANGUAGE) FROM AD_Message TT WHERE TT.AD_Message_ID=T.AD_Message_ID) ||' - '||TO_CHAR(COALESCE(TO_CHAR(T.Reference),'')) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, AD_Note T WHERE AD_Note_ID=':c_ID']]></SQL_RECORD_IDENTIFIER> + <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>   <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> </AD_TABLE> @@ -7733,7 +7733,7 @@   <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>  - <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT VALUE || ' - ' || TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM AD_Org TT WHERE TT.AD_Org_ID=T.AD_OrgTo_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM C_AcctSchema TT WHERE TT.C_AcctSchema_ID=T.C_AcctSchema_ID) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, C_InterOrg_Acct T WHERE C_InterOrg_Acct_ID=':c_ID']]></SQL_RECORD_IDENTIFIER> + <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>   <DEVELOPMENTSTATUS><![CDATA[NI]]></DEVELOPMENTSTATUS> </AD_TABLE> @@ -9669,7 +9669,7 @@   <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>  - <SQL_RECORD_IDENTIFIER><![CDATA[SELECT TO_CHAR(COALESCE(TO_CHAR(T.DocumentNo),''))||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM C_BPartner TT WHERE TT.C_BPartner_ID=T.C_BPartner_ID) ||' - '||TO_CHAR(COALESCE(TO_CHAR(T.DateReport),'')) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, S_TimeExpense T WHERE S_TimeExpense_ID=':c_ID']]></SQL_RECORD_IDENTIFIER> + <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>   <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> </AD_TABLE> @@ -10099,7 +10099,7 @@   <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>  - <SQL_RECORD_IDENTIFIER><![CDATA[**No key found]]></SQL_RECORD_IDENTIFIER> + <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM AD_User TT WHERE TT.AD_User_ID=T.AD_User_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM R_InterestArea TT WHERE TT.R_InterestArea_ID=T.R_InterestArea_ID) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, R_ContactInterest T WHERE R_ContactInterest_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>   <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> </AD_TABLE> @@ -11622,7 +11622,7 @@   <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>  - <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM S_Resource TT WHERE TT.S_Resource_ID=T.S_Resource_ID) ||' - '||--No key found AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, R_ResourcePlanCost T WHERE R_ResourcePlanCost_ID=':c_ID']]></SQL_RECORD_IDENTIFIER> + <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM S_Resource TT WHERE TT.S_Resource_ID=T.S_Resource_ID) ||' - '||TO_CHAR(COALESCE(TO_CHAR(T.C_CostType_ID),'')) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, R_ResourcePlanCost T WHERE R_ResourcePlanCost_ID=':c_ID']]></SQL_RECORD_IDENTIFIER>   <DEVELOPMENTSTATUS><![CDATA[NI]]></DEVELOPMENTSTATUS> </AD_TABLE> @@ -13072,7 +13072,7 @@   <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>  - <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Value),''))||' - '||(SELECT COALESCE(TO_CHAR(MAX(TTT.Name)), TO_CHAR(TT.Name)) FROM C_ElementValue_Trl TTT WHERE TTT.C_ElementValue_ID=TT.C_ElementValue_ID AND TTT.AD_LANGUAGE=L.AD_LANGUAGE) FROM C_ElementValue TT WHERE TT.C_ElementValue_ID=T.C_ElementValue_ID) ||' - '||(SELECT VALUE || ' - ' || (SELECT COALESCE(TO_CHAR(MAX(TTT.Name)), TO_CHAR(TT.Name)) FROM C_ElementValue_Trl TTT WHERE TTT.C_ElementValue_ID=TT.C_ElementValue_ID AND TTT.AD_LANGUAGE=L.AD_LANGUAGE) FROM C_ElementValue TT WHERE TT.C_ElementValue_ID=T.Account_ID) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, C_ElementValue_Operand T WHERE C_Elementvalue_Operand_ID=':c_ID']]></SQL_RECORD_IDENTIFIER> + <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>   <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> </AD_TABLE> @@ -13502,7 +13502,7 @@   <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>  - <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM C_AcctSchema TT WHERE TT.C_AcctSchema_ID=T.C_AcctSchema_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM AD_Table TT WHERE TT.AD_Table_ID=T.AD_Table_ID) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, C_AcctSchema_Table T WHERE C_Acctschema_Table_ID=':c_ID']]></SQL_RECORD_IDENTIFIER> + <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>   <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> </AD_TABLE> @@ -17986,7 +17986,7 @@   <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>  - <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM C_Period TT WHERE TT.C_Period_ID=T.C_Period_ID) ||' - '||TO_CHAR(COALESCE(TO_CHAR(T.SeqNo),''))||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM C_Budget TT WHERE TT.C_Budget_ID=T.C_Budget_ID) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, C_BudgetLine T WHERE C_Budgetline_ID=':c_ID']]></SQL_RECORD_IDENTIFIER> + <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>   <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> </AD_TABLE> @@ -19976,7 +19976,7 @@   <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>  - <SQL_RECORD_IDENTIFIER><![CDATA[SELECT TO_CHAR(COALESCE(TO_CHAR(T.Name),''))||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM MRP_Planner TT WHERE TT.MRP_Planner_ID=T.MRP_Planner_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM C_BPartner TT WHERE TT.C_BPartner_ID=T.Vendor_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM M_Product_Category TT WHERE TT.M_Product_Category_ID=T.M_Product_Category_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM M_Product TT WHERE TT.M_Product_ID=T.M_Product_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM C_BPartner TT WHERE TT.C_BPartner_ID=T.C_BPartner_ID) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, MRP_Run_Purchase T WHERE MRP_Run_Purchase_ID=':c_ID']]></SQL_RECORD_IDENTIFIER> + <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>   <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> </AD_TABLE> @@ -20023,7 +20023,7 @@   <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>  - <SQL_RECORD_IDENTIFIER><![CDATA[SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),''))||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TTT.Name),'')) FROM MRP_Planner TTT WHERE TTT.MRP_Planner_ID=TT.MRP_Planner_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TTT.Name),'')) FROM C_BPartner TTT WHERE TTT.C_BPartner_ID=TT.Vendor_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TTT.Name),'')) FROM M_Product_Category TTT WHERE TTT.M_Product_Category_ID=TT.M_Product_Category_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TTT.Name),'')) FROM M_Product TTT WHERE TTT.M_Product_ID=TT.M_Product_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TTT.Name),'')) FROM C_BPartner TTT WHERE TTT.C_BPartner_ID=TT.C_BPartner_ID) FROM MRP_Run_Purchase TT WHERE TT.MRP_Run_Purchase_ID=T.MRP_Run_Purchase_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TT.Name),'')) FROM M_Product TT WHERE TT.M_Product_ID=T.M_Product_ID) ||' - '||(SELECT (SELECT TO_CHAR(COALESCE(TO_CHAR(TTT.DocumentNo),'')) FROM M_Requisition TTT WHERE TTT.M_Requisition_ID=TT.M_Requisition_ID) ||' - '||(SELECT TO_CHAR(COALESCE(TO_CHAR(TTT.Name),'')) FROM M_Product TTT WHERE TTT.M_Product_ID=TT.M_Product_ID) ||' - '||TO_CHAR(COALESCE(TO_CHAR(TT.Qty),''))||' - '||TO_CHAR(COALESCE(TO_CHAR(TT.Needbydate),'')) FROM M_Requisitionline TT WHERE TT.M_Requisitionline_ID=T.M_Requisitionline_ID) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, MRP_Run_PurchaseLine T WHERE MRP_Run_Purchaseline_ID=':c_ID']]></SQL_RECORD_IDENTIFIER> + <SQL_RECORD_IDENTIFIER><![CDATA[**]]></SQL_RECORD_IDENTIFIER>   <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> </AD_TABLE>

Notes
(0008842) alostale (manager) 2008-09-02 09:25	In oracle it is working fine, it only happens in PostgreSQL

(0008845) svnbot (reporter) 2008-09-02 09:55	Repository: openbravo Revision: 6728 Author: alostale Date: 2008-09-02 09:55:42 +0200 (Tue, 02 Sep 2008) fixed bug 0004782: column identifier didn't work in postgreSQL --- U branches/r2.5x/src-db/database/model/functions/AD_COLUMN_IDENTIFIER_REF_SQL.xml U branches/r2.5x/src-db/database/sourcedata/AD_TEXTINTERFACES.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=6728&sc=1 [^]

(0107931) hgbot (developer) 2018-11-15 11:50	Repository: erp/pmods/org.openbravo.retail.orderpreparation Changeset: 41d3527f189d4f9abc0d3c63143381bca658d3cd Author: Eduardo Becerra <ebec70 <at> yahoo.com> Date: Mon Oct 22 13:41:43 2018 +0200 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.orderpreparation/rev/41d3527f189d4f9abc0d3c63143381bca658d3cd [^] [BUT ISSUE 4782] Fix Human Readable Log --- M web/org.openbravo.retail.orderpreparation/js/utils.js ---

Issue History
Date Modified	Username	Field	Change
2008-09-01 13:03	iperdomo	New Issue
2008-09-01 13:03	iperdomo	Assigned To	=> alostale
2008-09-01 13:03	iperdomo	sf_bug_id	0 => 2086620
2008-09-01 13:03	iperdomo	File Added: ad_table.diff
2008-09-01 13:03	iperdomo	Regression testing	=> No
2008-09-01 13:03	iperdomo	Tag Attached: UUID project
2008-09-01 13:04	iperdomo	Proposed Solution updated
2008-09-02 08:53	cromero	Status	new => scheduled
2008-09-02 08:53	cromero	fix_in_branch	=> trunk
2008-09-02 09:25	alostale	Note Added: 0008842
2008-09-02 09:55	svnbot	Checkin
2008-09-02 09:55	svnbot	Note Added: 0008845
2008-09-02 09:55	svnbot	Status	scheduled => resolved
2008-09-02 09:55	svnbot	Resolution	open => fixed
2008-09-02 09:55	svnbot	svn_revision	=> 6728
2008-12-15 18:58	psarobe	Status	resolved => closed
2018-11-15 11:50	hgbot	Checkin
2018-11-15 11:50	hgbot	Note Added: 0107931

Relationships [ Relation Graph ] [ Dependency Graph ]