Fix für redmine #483

[kivitendo-erp.git] / sql / Pg-upgrade2 / delete_cvars_on_trans_deletion_add_shipto.sql

diff --git a/sql/Pg-upgrade2/delete_cvars_on_trans_deletion_add_shipto.sql b/sql/Pg-upgrade2/delete_cvars_on_trans_deletion_add_shipto.sql
index ab1d1a4f55eab76712aaa6ac2d0bd708f6cdc717..d2f887b4368d8b462580d2a87a4e6f27a9a5685c 100644 (file)
--- a/sql/Pg-upgrade2/delete_cvars_on_trans_deletion_add_shipto.sql
+++ b/sql/Pg-upgrade2/delete_cvars_on_trans_deletion_add_shipto.sql
@@ -4,7 +4,7 @@
 
 -- 1.6 Alle benutzerdefinierten Variablen löschen, für die es keine
 -- Einträge in shipto mehr gibt.
-DELETE FROM custom_variables WHERE EXISTS
+DELETE FROM custom_variables WHERE id IN
   (SELECT cv.id FROM custom_variables cv LEFT JOIN custom_variable_configs cvc ON (cv.config_id = cvc.id)
    WHERE module LIKE 'ShipTo'
      AND NOT EXISTS (SELECT shipto_id FROM shipto WHERE shipto_id = cv.trans_id));