Update of /cvsroot/monetdb/sql/src/server
In directory sc8-pr-cvs16:/tmp/cvs-serv10693

Modified Files:
        sql_mvc.mx 
Log Message:
changes to implement UPDATE/DELETE cascade.
The implementation of UPDATE/DELETE cascade operations is covered by the tests:
sql/src/test/Update_Delete_Action/

Note: Only some of these tests should be green after this checkin. There are 
still some issues to resolve.


Index: sql_mvc.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/server/sql_mvc.mx,v
retrieving revision 1.178
retrieving revision 1.179
diff -u -d -r1.178 -r1.179
--- sql_mvc.mx  28 Mar 2007 14:54:23 -0000      1.178
+++ sql_mvc.mx  17 Apr 2007 10:34:54 -0000      1.179
@@ -105,7 +105,7 @@
        unsigned int depth;     /* depth of the current expression */
        int label;              /* numbers for relational projection labels */
        list *called_triggers;  /* protection against recursive triggers */
-       list *cascade_action;  /* protection against recursive cascade action*/
+       list *cascade_action;  /* protection against recursive cascade actions 
*/
 
        int opt_stats[MAXSTATS];/* keep statistics about optimizer rewrites */
 
@@ -184,7 +184,6 @@
 
 /*dependency control*/
 extern void mvc_create_dependency(mvc *m, int id, int depend_id, int 
depend_type);
-extern void mvc_drop_dependencies(mvc *m, int depend_id);
 extern void mvc_create_dependencies(mvc *m, list *id_l, sqlid depend_id, int 
dep_type);
 extern int mvc_check_dependency(mvc * m, int id, int type);
 extern int mvc_connect_catalog(mvc *m, char *server, int port, char *db, char 
*db_alias, char *user, char *passwd, char *lng);
@@ -1038,7 +1037,7 @@
                fprintf(stderr, "mvc_drop_idx %s %s\n", s->base.name, name);
 
        m->type = Q_SCHEMA;
-       sql_trans_drop_idx(m->session->tr, s, name, -1);
+       sql_trans_drop_idx(m->session->tr, s, name, -1, 0);
 }
 
 sql_trigger * 
@@ -1070,7 +1069,7 @@
                fprintf(stderr, "mvc_drop_trigger %s %s\n", s->base.name, name);
 
        m->type = Q_SCHEMA;
-       sql_trans_drop_trigger(m->session->tr, s, name, -1);
+       sql_trans_drop_trigger(m->session->tr, s, name, -1, 0);
 }
 
 
@@ -1181,16 +1180,6 @@
 }
 
 void
-mvc_drop_dependencies(mvc *m, int depend_id)
-{
-       if (mvc_debug)
-               fprintf(stderr, "mvc_drop_dependencies on %d\n", depend_id);
-       m->type = Q_SCHEMA;
-
-       sql_trans_drop_dependencies(m->session->tr, depend_id);
-}
-
-void
 mvc_create_dependencies(mvc *m, list *id_l, sqlid depend_id, int dep_type)
 {
        node *n = id_l->h;


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins

Reply via email to