Update of /cvsroot/monetdb/sql/src/include
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv21442/src/include
Modified Files:
sql_relation.h
Log Message:
algebra now has insert,update and delete operators.
mostly code moved from sql_updates.mx into rel_bin.mx
In the process, within functions we no longer output 'rows affected'
results of insert, update and deletes.
alter table use update instead insert now (column/idx bat with default
values is generated by the storage layer).
create user, now uses the table_funcs interface
same holds for granting and revoking privileges on tables.
This was needed to remove dependency on old insert/delete code.
U sql_relation.h
Index: sql_relation.h
===================================================================
RCS file: /cvsroot/monetdb/sql/src/include/sql_relation.h,v
retrieving revision 1.30
retrieving revision 1.31
diff -u -d -r1.30 -r1.31
--- sql_relation.h 12 Dec 2008 22:28:25 -0000 1.30
+++ sql_relation.h 21 Dec 2008 19:38:22 -0000 1.31
@@ -66,7 +66,7 @@
#define HAS_NO_NIL 64
#define EXP_INTERN 128
-#define MAXOPS 16
+#define MAXOPS 20
typedef enum operator_type {
op_basetable = 0,
@@ -83,8 +83,10 @@
op_inter,
op_except,
op_groupby, /* currently includes the projection (aggr) */
- op_topn
- /* TODO op_modify (ie insert, update, delete) */
+ op_topn,
+ op_insert, /* insert(l=table, r insert expressions) */
+ op_update, /* update(l=table, r update expressions) */
+ op_delete /* delete(l=table, r delete expression) */
} operator_type;
#define is_column(et) \
@@ -115,6 +117,8 @@
((rel->op == op_project && rel->r) || rel->op == op_topn)
#define is_topn(op) \
(op == op_topn)
+#define is_modify(op) \
+ (op == op_insert || op == op_update || op == op_delete)
/* NO NIL semantics of aggr operations */
#define has_no_nil(e) \
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
