MonetDB: default - Added the simple vacuum test

[mk]

Changeset: 40c199ec64ad for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=40c199ec64ad
Modified Files:
        sql/src/backends/monet5/sql.mx
        sql/src/test/BugTracker-2010/Tests/All
        sql/src/test/BugTracker-2010/Tests/vacuum.sql
Branch: default
Log Message:

Added the simple vacuum test
This thes performs a basic functionality test over the vacuum calls.
We should not loose information as a result of the operation.


diffs (58 lines):

diff -r 7c23583721e8 -r 40c199ec64ad sql/src/backends/monet5/sql.mx
--- a/sql/src/backends/monet5/sql.mx    Sat Dec 18 13:59:49 2010 +0100
+++ b/sql/src/backends/monet5/sql.mx    Sun Dec 19 11:48:04 2010 +0100
@@ -5132,7 +5132,7 @@
        t->base.rtime = s->base.rtime = tr->rtime = tr->stime;
 
        /* get the deletions BAT*/
-       del = mvc_bind_dbat(m, *sch, *tbl, 2);
+       del = mvc_bind_dbat(m, *sch, *tbl, RD_INS);
 
        for (o = t->columns.set->h; o; o = o->next) {
                sql_delta *d;
@@ -5192,7 +5192,7 @@
        tr = m->session->tr;
 
        /* get the deletions BAT*/
-       del = mvc_bind_dbat(m, *sch, *tbl, 2);
+       del = mvc_bind_dbat(m, *sch, *tbl, RD_INS);
 
        for (o = t->columns.set->h; o && ordered == 0; o = o->next) {
                c = o->data;
diff -r 7c23583721e8 -r 40c199ec64ad sql/src/test/BugTracker-2010/Tests/All
--- a/sql/src/test/BugTracker-2010/Tests/All    Sat Dec 18 13:59:49 2010 +0100
+++ b/sql/src/test/BugTracker-2010/Tests/All    Sun Dec 19 11:48:04 2010 +0100
@@ -83,3 +83,4 @@
 COPY_INTO_with_backslashes.Bug-2748
 wrong_error_message_dropping_view.Bug-2713
 call_function_without_warning.Bug-2752
+vacuum
diff -r 7c23583721e8 -r 40c199ec64ad 
sql/src/test/BugTracker-2010/Tests/vacuum.sql
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/sql/src/test/BugTracker-2010/Tests/vacuum.sql     Sun Dec 19 11:48:04 
2010 +0100
@@ -0,0 +1,25 @@
+-- simple sanity test for vacuum
+
+create table vac1(i int, s string);
+insert into vac1 values(1,'the'), 
(2,'quick'),(3,'brown'),(5,'runs'),(4,'fox'),(6,'over'),(7,'the'),(8,'lazy'),(9,'dog');
+select * from vac1 order by i;
+select * from vac1;
+
+call shrink('sys','vac1');
+select * from vac1;
+
+delete from vac1 where i = 8;
+call shrink('sys','vac1');
+select * from vac1;
+
+delete from vac1 where i = 2;
+call shrink('sys','vac1');
+select * from vac1;
+
+delete from vac1 where i > 6;
+call vacuum('sys','vac1');
+select * from vac1;
+
+drop table vac1;
+
+
_______________________________________________
Checkin-list mailing list
Checkin-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/checkin-list