details: https://code.openbravo.com/erp/devel/pi/rev/a98b85433a15
changeset: 27536:a98b85433a15
user: Asier Lostalé <asier.lostale <at> openbravo.com>
date: Mon Sep 07 13:13:46 2015 +0200
summary: fixed bug 30737: broken ad_table_navigation_mod_trg for updates
ad_table_navigation_mod_trg trigger had a coalesce that was mxing types
(varchar and numeric) which is not allowed raising an error in when this
code was exectued.
Fixed by completely removing this colasce as it was in seqNo column which
is mandatory.
diffstat:
src-db/database/model/triggers/AD_TABLE_NAVIGATION_MOD_TRG.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r fcdcb8232dfb -r a98b85433a15
src-db/database/model/triggers/AD_TABLE_NAVIGATION_MOD_TRG.xml
--- a/src-db/database/model/triggers/AD_TABLE_NAVIGATION_MOD_TRG.xml Thu Sep
03 17:13:57 2015 +0200
+++ b/src-db/database/model/triggers/AD_TABLE_NAVIGATION_MOD_TRG.xml Mon Sep
07 13:13:46 2015 +0200
@@ -69,7 +69,7 @@
COALESCE(:NEW.AD_Client_ID , '.') != COALESCE(:OLD.AD_Client_ID , '.')
OR
COALESCE(:NEW.AD_Org_ID , '.') != COALESCE(:OLD.AD_Org_ID , '.') OR
COALESCE(:NEW.IsActive , '.') != COALESCE(:OLD.IsActive , '.') OR
- COALESCE(:NEW.SeqNo , '.') != COALESCE(:OLD.SeqNo , '.') OR
+ :NEW.SeqNo != :OLD.SeqNo OR
COALESCE(:NEW.AD_Tab_ID , '.') != COALESCE(:OLD.AD_Tab_ID , '.') OR
COALESCE(:NEW.HqlLogic , '.') != COALESCE(:OLD.HqlLogic , '.') OR
COALESCE(:NEW.AD_Table_ID , '.') != COALESCE(:OLD.AD_Table_ID , '.'))
THEN
------------------------------------------------------------------------------
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
