details: https://code.openbravo.com/erp/devel/pi/rev/c01c1ba1956a changeset: 20297:c01c1ba1956a user: Naiara Martinez <naiara.martinez <at> openbravo.com> date: Wed May 08 18:09:52 2013 +0200 summary: fixed bug 23733: A computed column on M_inout table causing performance problems.
diffstat: src-db/database/sourcedata/AD_COLUMN.xml | 33 ------------------ src-db/database/sourcedata/AD_FIELD.xml | 56 -------------------------------- 2 files changed, 0 insertions(+), 89 deletions(-) diffs (116 lines): diff -r d1a049df1795 -r c01c1ba1956a src-db/database/sourcedata/AD_COLUMN.xml --- a/src-db/database/sourcedata/AD_COLUMN.xml Wed May 08 10:34:45 2013 +0200 +++ b/src-db/database/sourcedata/AD_COLUMN.xml Wed May 08 18:09:52 2013 +0200 @@ -286638,39 +286638,6 @@ <!--9AB3980C9BB144A48043EBC87DBA57D6--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> <!--9AB3980C9BB144A48043EBC87DBA57D6--></AD_COLUMN> -<!--9AFE960A44A147ECAADB875D96399AA2--><AD_COLUMN> -<!--9AFE960A44A147ECAADB875D96399AA2--> <AD_COLUMN_ID><![CDATA[9AFE960A44A147ECAADB875D96399AA2]]></AD_COLUMN_ID> -<!--9AFE960A44A147ECAADB875D96399AA2--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> -<!--9AFE960A44A147ECAADB875D96399AA2--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> -<!--9AFE960A44A147ECAADB875D96399AA2--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> -<!--9AFE960A44A147ECAADB875D96399AA2--> <NAME><![CDATA[Invoice Status]]></NAME> -<!--9AFE960A44A147ECAADB875D96399AA2--> <COLUMNNAME><![CDATA[InvoiceStatus]]></COLUMNNAME> -<!--9AFE960A44A147ECAADB875D96399AA2--> <AD_TABLE_ID><![CDATA[319]]></AD_TABLE_ID> -<!--9AFE960A44A147ECAADB875D96399AA2--> <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID> -<!--9AFE960A44A147ECAADB875D96399AA2--> <FIELDLENGTH><![CDATA[4]]></FIELDLENGTH> -<!--9AFE960A44A147ECAADB875D96399AA2--> <ISKEY><![CDATA[N]]></ISKEY> -<!--9AFE960A44A147ECAADB875D96399AA2--> <ISPARENT><![CDATA[N]]></ISPARENT> -<!--9AFE960A44A147ECAADB875D96399AA2--> <ISMANDATORY><![CDATA[N]]></ISMANDATORY> -<!--9AFE960A44A147ECAADB875D96399AA2--> <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE> -<!--9AFE960A44A147ECAADB875D96399AA2--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER> -<!--9AFE960A44A147ECAADB875D96399AA2--> <SEQNO><![CDATA[450]]></SEQNO> -<!--9AFE960A44A147ECAADB875D96399AA2--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED> -<!--9AFE960A44A147ECAADB875D96399AA2--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> -<!--9AFE960A44A147ECAADB875D96399AA2--> <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN> -<!--9AFE960A44A147ECAADB875D96399AA2--> <AD_ELEMENT_ID><![CDATA[A93D6B07CA89486F9518DD4FBA889EF7]]></AD_ELEMENT_ID> -<!--9AFE960A44A147ECAADB875D96399AA2--> <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR> -<!--9AFE960A44A147ECAADB875D96399AA2--> <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY> -<!--9AFE960A44A147ECAADB875D96399AA2--> <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE> -<!--9AFE960A44A147ECAADB875D96399AA2--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS> -<!--9AFE960A44A147ECAADB875D96399AA2--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> -<!--9AFE960A44A147ECAADB875D96399AA2--> <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT> -<!--9AFE960A44A147ECAADB875D96399AA2--> <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE> -<!--9AFE960A44A147ECAADB875D96399AA2--> <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW> -<!--9AFE960A44A147ECAADB875D96399AA2--> <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION> -<!--9AFE960A44A147ECAADB875D96399AA2--> <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE> -<!--9AFE960A44A147ECAADB875D96399AA2--> <SQLLOGIC><![CDATA[(select C_GETINVOICESTATUSFROMSHIPMENT(m_inout_id) from dual)]]></SQLLOGIC> -<!--9AFE960A44A147ECAADB875D96399AA2--></AD_COLUMN> - <!--9BAEEE4845E238D8E040007F01002420--><AD_COLUMN> <!--9BAEEE4845E238D8E040007F01002420--> <AD_COLUMN_ID><![CDATA[9BAEEE4845E238D8E040007F01002420]]></AD_COLUMN_ID> <!--9BAEEE4845E238D8E040007F01002420--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> diff -r d1a049df1795 -r c01c1ba1956a src-db/database/sourcedata/AD_FIELD.xml --- a/src-db/database/sourcedata/AD_FIELD.xml Wed May 08 10:34:45 2013 +0200 +++ b/src-db/database/sourcedata/AD_FIELD.xml Wed May 08 18:09:52 2013 +0200 @@ -232395,34 +232395,6 @@ <!--8C8CC82B940147AF953DDACB0CF3AB36--> <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> <!--8C8CC82B940147AF953DDACB0CF3AB36--></AD_FIELD> -<!--8CA675BA4E8F45CB837215A124506488--><AD_FIELD> -<!--8CA675BA4E8F45CB837215A124506488--> <AD_FIELD_ID><![CDATA[8CA675BA4E8F45CB837215A124506488]]></AD_FIELD_ID> -<!--8CA675BA4E8F45CB837215A124506488--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> -<!--8CA675BA4E8F45CB837215A124506488--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> -<!--8CA675BA4E8F45CB837215A124506488--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> -<!--8CA675BA4E8F45CB837215A124506488--> <NAME><![CDATA[Invoice Status]]></NAME> -<!--8CA675BA4E8F45CB837215A124506488--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> -<!--8CA675BA4E8F45CB837215A124506488--> <AD_TAB_ID><![CDATA[30576C6ABD12419F9D19D497216FC9B8]]></AD_TAB_ID> -<!--8CA675BA4E8F45CB837215A124506488--> <AD_COLUMN_ID><![CDATA[9AFE960A44A147ECAADB875D96399AA2]]></AD_COLUMN_ID> -<!--8CA675BA4E8F45CB837215A124506488--> <IGNOREINWAD><![CDATA[Y]]></IGNOREINWAD> -<!--8CA675BA4E8F45CB837215A124506488--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> -<!--8CA675BA4E8F45CB837215A124506488--> <DISPLAYLENGTH><![CDATA[0]]></DISPLAYLENGTH> -<!--8CA675BA4E8F45CB837215A124506488--> <ISREADONLY><![CDATA[N]]></ISREADONLY> -<!--8CA675BA4E8F45CB837215A124506488--> <SEQNO><![CDATA[420]]></SEQNO> -<!--8CA675BA4E8F45CB837215A124506488--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE> -<!--8CA675BA4E8F45CB837215A124506488--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> -<!--8CA675BA4E8F45CB837215A124506488--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> -<!--8CA675BA4E8F45CB837215A124506488--> <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION> -<!--8CA675BA4E8F45CB837215A124506488--> <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD> -<!--8CA675BA4E8F45CB837215A124506488--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> -<!--8CA675BA4E8F45CB837215A124506488--> <GRID_SEQNO><![CDATA[80]]></GRID_SEQNO> -<!--8CA675BA4E8F45CB837215A124506488--> <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN> -<!--8CA675BA4E8F45CB837215A124506488--> <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE> -<!--8CA675BA4E8F45CB837215A124506488--> <ISSHOWNINSTATUSBAR><![CDATA[Y]]></ISSHOWNINSTATUSBAR> -<!--8CA675BA4E8F45CB837215A124506488--> <CLIENTCLASS><![CDATA[OBAddPercentageSign]]></CLIENTCLASS> -<!--8CA675BA4E8F45CB837215A124506488--> <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> -<!--8CA675BA4E8F45CB837215A124506488--></AD_FIELD> - <!--8CB852B414BA4B66B20790634D899D85--><AD_FIELD> <!--8CB852B414BA4B66B20790634D899D85--> <AD_FIELD_ID><![CDATA[8CB852B414BA4B66B20790634D899D85]]></AD_FIELD_ID> <!--8CB852B414BA4B66B20790634D899D85--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> @@ -272360,34 +272332,6 @@ <!--EA0A71EA42CA4E8B8842113430A9CF38--> <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> <!--EA0A71EA42CA4E8B8842113430A9CF38--></AD_FIELD> -<!--EA53D6CAE34F40758980090D0CAA4A8A--><AD_FIELD> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <AD_FIELD_ID><![CDATA[EA53D6CAE34F40758980090D0CAA4A8A]]></AD_FIELD_ID> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <ISACTIVE><![CDATA[Y]]></ISACTIVE> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <NAME><![CDATA[Invoice Status]]></NAME> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <AD_TAB_ID><![CDATA[257]]></AD_TAB_ID> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <AD_COLUMN_ID><![CDATA[9AFE960A44A147ECAADB875D96399AA2]]></AD_COLUMN_ID> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <IGNOREINWAD><![CDATA[Y]]></IGNOREINWAD> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <DISPLAYLENGTH><![CDATA[0]]></DISPLAYLENGTH> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <ISREADONLY><![CDATA[N]]></ISREADONLY> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <SEQNO><![CDATA[420]]></SEQNO> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <GRID_SEQNO><![CDATA[80]]></GRID_SEQNO> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <ISSHOWNINSTATUSBAR><![CDATA[Y]]></ISSHOWNINSTATUSBAR> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <CLIENTCLASS><![CDATA[OBAddPercentageSign]]></CLIENTCLASS> -<!--EA53D6CAE34F40758980090D0CAA4A8A--> <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY> -<!--EA53D6CAE34F40758980090D0CAA4A8A--></AD_FIELD> - <!--EA7DA8F5AC8F449C863ACA4A54D627F5--><AD_FIELD> <!--EA7DA8F5AC8F449C863ACA4A54D627F5--> <AD_FIELD_ID><![CDATA[EA7DA8F5AC8F449C863ACA4A54D627F5]]></AD_FIELD_ID> <!--EA7DA8F5AC8F449C863ACA4A54D627F5--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID> ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. This 200-page book is written by three acclaimed leaders in the field. The early access version is available now. Download your free book today! http://p.sf.net/sfu/neotech_d2d_may _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
