[COMMIT LOGREPORT] service/all/lib/tests DerivedSchemaTest.pm,1.5,1.6

[Francis J. Lacoste]

Update of /cvsroot/logreport/service/all/lib/tests
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19008/all/lib/tests

Modified Files:
	DerivedSchemaTest.pm 
Log Message:
Do not delete records in the derived schemas when records in the base
schemas is deleted (only delete the links). One might want to keep the
derived information for longer period than the base information.


Index: DerivedSchemaTest.pm
===================================================================
RCS file: /cvsroot/logreport/service/all/lib/tests/DerivedSchemaTest.pm,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -r1.5 -r1.6
--- DerivedSchemaTest.pm	8 Oct 2004 18:12:54 -0000	1.5
+++ DerivedSchemaTest.pm	17 Jun 2005 20:22:13 -0000	1.6
@@ -202,7 +202,7 @@
     my $main_trigger_sql = <<EOS;
 CREATE TRIGGER "dlf_test-derived_delete_trigger" AFTER DELETE ON dlf_test
 BEGIN
-    DELETE FROM "dlf_test-derived" WHERE dlf_id IN ( SELECT src_id FROM "dlf_test-derived_links" WHERE src_id = old.dlf_id );
+    DELETE FROM "dlf_test-derived_links" WHERE src_id = old.dlf_id;
 END
 EOS
     chomp $main_trigger_sql;

-- 
To UNSUBSCRIBE, email to commit-request at logreport.org with a subject of 
"unsubscribe". Trouble? Send an email with subject "help" to 
commit-request at logreport.org