Update of /cvsroot/monetdb/sql/src/backends/monet4
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv18004/src/backends/monet4

Modified Files:
      Tag: SQL_2-24
        sql_server.mx 
Log Message:
we need to drop declared tables when we leave the scope.
THis fixes bug mdb_starts_with_sql_debug_64.SF-1999354.sql.


U sql_server.mx
Index: sql_server.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/backends/monet4/sql_server.mx,v
retrieving revision 1.198.2.4
retrieving revision 1.198.2.5
diff -u -d -r1.198.2.4 -r1.198.2.5
--- sql_server.mx       28 Jun 2008 10:20:06 -0000      1.198.2.4
+++ sql_server.mx       15 Jul 2008 14:20:32 -0000      1.198.2.5
@@ -139,6 +139,8 @@
 
        .COMMAND mvc_declared_table_column( mvc m, int rs, str tname, str name, 
str typename, int digits, int scale) = mvc_declared_table_column_wrap; "Add the 
colunm to the declared table"
 
+       .COMMAND mvc_drop_declared_table( mvc m, str name) :void = 
mvc_drop_declared_table_wrap; "Drop a declared table" 
+
        .COMMAND mvc_schema_operation(mvc m, Stream s, str w) =
                mvc_export_schema_wrap; "export a schema operation to stream s"
 
@@ -832,6 +834,19 @@
 }
 
 int
+mvc_drop_declared_table_wrap(mvc *M, str name)
+{
+       mvc *m = *(mvc**)M;
+       sql_schema *s = NULL;
+       sql_table *t = NULL;
+
+       s = mvc_bind_schema(m, "%dt%");
+       t = mvc_bind_table(m, s, name);
+       (void)mvc_drop_table(m, s, t, 0);
+       return GDK_SUCCEED;
+}
+
+int
 mvc_result_value_wrap(mvc *M, str tn, str name, str type, int *digits, int 
*scale, ptr p, int mtype)
 {
        if (mvc_result_value(*(mvc **) M, tn, name, type, *digits, *scale, p, 
mtype))


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins

Reply via email to