details: https://code.openbravo.com/erp/devel/pi/rev/f4eb6b0d41e0
changeset: 28706:f4eb6b0d41e0
user: Naroa Iriarte <naroa.iriarte <at> openbravo.com>
date: Tue Mar 08 10:56:37 2016 +0100
summary: fixed issue 32152: Some colums were modified even with no modules in
devel.
The AllowSorting and AllowFiltering columns were modified even with no module
in development.
That behavior is not correct and the AD_COLUMN_MOD_TRG.xml trigger has been
modified to handle
this situation. Now if there is no module in development and the old value of
these columns is
not the same as the new one (if it has been modified) an error is shown.
diffstat:
src-db/database/model/triggers/AD_COLUMN_MOD_TRG.xml | 2 ++
1 files changed, 2 insertions(+), 0 deletions(-)
diffs (12 lines):
diff -r 1e5083005e09 -r f4eb6b0d41e0
src-db/database/model/triggers/AD_COLUMN_MOD_TRG.xml
--- a/src-db/database/model/triggers/AD_COLUMN_MOD_TRG.xml Tue Mar 08
11:21:24 2016 +0100
+++ b/src-db/database/model/triggers/AD_COLUMN_MOD_TRG.xml Tue Mar 08
10:56:37 2016 +0100
@@ -112,6 +112,8 @@
COALESCE(:NEW.imagewidth , 1) != COALESCE(:OLD.imagewidth , 1) OR
COALESCE(:NEW.imageheight , 1) != COALESCE(:OLD.imageheight , 1) OR
COALESCE(:NEW.isusedsequence , '.') != COALESCE(:OLD.isusedsequence ,
'.') OR
+ COALESCE(:NEW.AllowSorting, '.') != COALESCE(:OLD.AllowSorting, '.') OR
+ COALESCE(:NEW.AllowFiltering, '.') != COALESCE(:OLD.AllowFiltering,
'.') OR
1=2) THEN
RAISE_APPLICATION_ERROR(-20000, '@20532@');
END IF;
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://makebettercode.com/inteldaal-eval
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
