Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0010709 | Openbravo ERP | A. Platform | public | 2009-09-23 10:54 | 2009-10-22 00:00 |
|
| Reporter | sathiyan | |
| Assigned To | marvintm | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 20 | OS Version | Ubuntu 9.04 |
| Product Version | pi | |
| 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 | No |
|
| Summary | 0010709: variable is misinterpreted by DBSource Manager if variable name with suffix TYPE |
| Description | if we use the variable name with suffix of TYPE, For instance the variable name in our trigger is EM_ACCDEF_TYPE, It is interpreted like EM_ACCDEF_--TYPE when we apply ant task of update.database (or install.source).
We have attached trigger xml (ACCDEF_INVOICE_TRG.xml).
The complete code of interpreted by dbsourcemanager:
CREATE FUNCTION ACCDEF_INVOICE_TRG()
RETURNS trigger
AS $BODY$ DECLARE
BEGIN
IF AD_isTriggerEnabled()='N' THEN IF TG_OP = 'DELETE' THEN RETURN OLD; ELSE RETURN NEW; END IF;
END IF;
IF TG_OP = 'UPDATE' THEN
IF(OLD.DOCSTATUS='CO' AND (OLD.EM_ACCDEF_--TYPE IS NULL AND NEW.EM_ACCDEF_TYPE IS NOT NULL) OR (OLD.EM_ACCDEF_TYPE IS NOT NULL AND NEW.EM_ACCDEF_TYPE IS NULL)) THEN
RAISE EXCEPTION '%', 'Document processed/posted'; --OBTG:-20501--
END IF;
END IF;
IF TG_OP = 'DELETE' THEN
IF(OLD.DOCSTATUS='CO') THEN
RAISE EXCEPTION '%', 'Document processed/posted'; --OBTG:-20501--
END IF;
END IF;
IF TG_OP = 'DELETE' THEN RETURN OLD; ELSE RETURN NEW; END IF; |
| Steps To Reproduce | |
| Proposed Solution | Refine regular expresion to require a blank space before the 'type' |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files |  ACCDEF_INVOICE_TRG.xml (773) 2009-09-23 10:54
https://issues.openbravo.com/file_download.php?file_id=1772&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2009-09-23 10:54 | sathiyan | New Issue | |
| 2009-09-23 10:54 | sathiyan | Assigned To | => rafaroda |
| 2009-09-23 10:54 | sathiyan | File Added: ACCDEF_INVOICE_TRG.xml | |
| 2009-09-23 12:43 | iciordia | Assigned To | rafaroda => marvintm |
| 2009-09-23 12:45 | iciordia | Priority | normal => urgent |
| 2009-09-23 12:45 | iciordia | Steps to Reproduce Updated | |
| 2009-09-23 15:20 | shuehner | Issue Monitored: shuehner | |
| 2009-09-28 11:53 | hgbot | Checkin | |
| 2009-09-28 11:53 | hgbot | Note Added: 0020394 | |
| 2009-09-28 11:53 | hgbot | Status | new => resolved |
| 2009-09-28 11:53 | hgbot | Resolution | open => fixed |
| 2009-09-28 11:53 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/178bd53e1b9b8dce1afe03e408236ed9cf8a4fa1 [^] |
| 2009-09-29 14:18 | hgbot | Checkin | |
| 2009-09-29 14:18 | hgbot | Note Added: 0020519 | |
| 2009-09-29 14:18 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/178bd53e1b9b8dce1afe03e408236ed9cf8a4fa1 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/178bd53e1b9b8dce1afe03e408236ed9cf8a4fa1 [^] |
| 2009-10-21 15:26 | plujan | Status | resolved => closed |
| 2009-10-22 00:00 | anonymous | sf_bug_id | 0 => 2883559 |