Changeset: 63a0b477fd2e for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=63a0b477fd2e
Modified Files:
sql/test/mosaic/Tests/All
sql/test/mosaic/Tests/compressionRLE.sql
sql/test/mosaic/Tests/compressionRLE.stable.out
Branch: mosaic
Log Message:
test safe/restore
diffs (196 lines):
diff --git a/sql/test/mosaic/Tests/All b/sql/test/mosaic/Tests/All
--- a/sql/test/mosaic/Tests/All
+++ b/sql/test/mosaic/Tests/All
@@ -1,5 +1,6 @@
compression
compressionRLE
+compressionRLE2
xqueries
xqueries_rle
xqueries_delta
diff --git a/sql/test/mosaic/Tests/compressionRLE.sql
b/sql/test/mosaic/Tests/compressionRLE.sql
--- a/sql/test/mosaic/Tests/compressionRLE.sql
+++ b/sql/test/mosaic/Tests/compressionRLE.sql
@@ -104,17 +104,3 @@ explain select f from tmp3RLE;
explain select t from tmp3RLE;
select * from tmp3RLE;
-select * from storage where "table" = 'tmp3rle';
-select count(*) from tmp3RLE;
-
-alter table tmp3RLE alter column i set storage NULL;
-alter table tmp3RLE alter column b set storage NULL;
-alter table tmp3RLE alter column f set storage NULL;
-alter table tmp3RLE alter column t set storage NULL;
-explain select * from tmp3RLE;
-select * from tmp3RLE;
-
-alter table tmp3RLE set read write;
---select * from tmp3RLE;
-
-drop table tmp3RLE;
diff --git a/sql/test/mosaic/Tests/compressionRLE.stable.out
b/sql/test/mosaic/Tests/compressionRLE.stable.out
--- a/sql/test/mosaic/Tests/compressionRLE.stable.out
+++ b/sql/test/mosaic/Tests/compressionRLE.stable.out
@@ -273,161 +273,6 @@ end user.s13_1;
[ 8, false, 0.317, 2014-08-23 11:34:54.000000 ]
[ 9, false, 0.317, 2014-08-23 11:34:54.000000 ]
[ 10, false, 0.317, 2014-08-23 11:34:54.000000 ]
-#select * from storage where "table" = 'tmp3rle';
-% .storage, .storage, .storage, .storage, .storage,
.storage, .storage, .storage, .storage, .storage,
.storage, .storage, .storage, .storage, .storage #
table_name
-% schema, table, column, type, mode, location, count,
typewidth, columnsize, heapsize, hashes, phash, imprints,
sorted, compress # name
-% clob, clob, clob, clob, clob, clob, bigint, int, bigint,
bigint, bigint, boolean, bigint, boolean, boolean # type
-% 3, 7, 1, 9, 8, 7, 2, 1, 3, 1,
1, 5, 1, 5, 5 # length
-[ "sys", "tmp3rle", "i", "int", "readonly", "13/1306",
86, 4, 344, 0, 0, false, 0, false, false ]
-[ "sys", "tmp3rle", "b", "boolean", "readonly",
"13/1322", 86, 1, 86, 0, 0, false, 0, false,
false ]
-[ "sys", "tmp3rle", "f", "real", "readonly", "13/1323",
86, 4, 344, 0, 0, false, 0, false, false ]
-[ "sys", "tmp3rle", "t", "timestamp", "readonly",
"13/1324", 86, 8, 688, 0, 0, false, 0, true,
false ]
-#select count(*) from tmp3RLE;
-% sys.L1 # table_name
-% L1 # name
-% wrd # type
-% 2 # length
-[ 86 ]
-#alter table tmp3 alter column i set storage NULL;
-#alter table tmp3 alter column b set storage NULL;
-#alter table tmp3 alter column f set storage NULL;
-#alter table tmp3 alter column t set storage NULL;
-#explain select * from tmp3;
-% .explain # table_name
-% mal # name
-% clob # type
-% 88 # length
-function user.s21_1{autoCommit=true}():void;
- X_57:void := querylog.define("explain select * from
tmp3rle;","sequential_pipe",39);
- X_20 := bat.new(nil:oid,nil:str);
- X_28 := bat.append(X_20,"sys.tmp3rle");
- X_36 := bat.append(X_28,"sys.tmp3rle");
- X_43 := bat.append(X_36,"sys.tmp3rle");
- X_50 := bat.append(X_43,"sys.tmp3rle");
- X_23 := bat.new(nil:oid,nil:str);
- X_30 := bat.append(X_23,"i");
- X_37 := bat.append(X_30,"b");
- X_44 := bat.append(X_37,"f");
- X_51 := bat.append(X_44,"t");
- X_24 := bat.new(nil:oid,nil:str);
- X_31 := bat.append(X_24,"int");
- X_38 := bat.append(X_31,"boolean");
- X_45 := bat.append(X_38,"real");
- X_52 := bat.append(X_45,"timestamp");
- X_25 := bat.new(nil:oid,nil:int);
- X_33 := bat.append(X_25,32);
- X_40 := bat.append(X_33,1);
- X_47 := bat.append(X_40,24);
- X_54 := bat.append(X_47,7);
- X_27 := bat.new(nil:oid,nil:int);
- X_35 := bat.append(X_27,0);
- X_42 := bat.append(X_35,0);
- X_49 := bat.append(X_42,0);
- X_56 := bat.append(X_49,0);
- X_2 := sql.mvc();
- X_3:bat[:oid,:oid] := sql.tid(X_2,"sys","tmp3rle");
- X_6:bat[:oid,:int] := sql.bind(X_2,"sys","tmp3rle","i",0);
- X_9 := mosaic.leftfetchjoin(X_3,X_6);
- X_10:bat[:oid,:bit] := sql.bind(X_2,"sys","tmp3rle","b",0);
- X_12 := mosaic.leftfetchjoin(X_3,X_10);
- X_13:bat[:oid,:flt] := sql.bind(X_2,"sys","tmp3rle","f",0);
- X_15 := mosaic.leftfetchjoin(X_3,X_13);
- X_16:bat[:oid,:timestamp] := sql.bind(X_2,"sys","tmp3rle","t",0);
- X_18 := mosaic.leftfetchjoin(X_3,X_16);
- sql.resultSet(X_50,X_51,X_52,X_54,X_56,X_9,X_12,X_15,X_18);
-end user.s21_1;
-#select * from tmp3RLE;
-% sys.tmp3rle, sys.tmp3rle, sys.tmp3rle, sys.tmp3rle # table_name
-% i, b, f, t # name
-% int, boolean, real, timestamp # type
-% 2, 5, 15, 26 # length
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 2, false, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 3, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 2, false, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 3, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 2, false, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 3, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 0, false, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 5, false, 0.317, 2014-08-23 11:34:54.000000 ]
-[ 6, false, 0.317, 2014-08-23 11:34:54.000000 ]
-[ 7, false, 0.317, 2014-08-23 11:34:54.000000 ]
-[ 8, false, 0.317, 2014-08-23 11:34:54.000000 ]
-[ 9, false, 0.317, 2014-08-23 11:34:54.000000 ]
-[ 10, false, 0.317, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 1, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 2, false, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 3, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 2, false, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 3, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 2, false, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 3, true, 0.314, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 4, true, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 0, false, 0.316, 2014-08-23 11:34:54.000000 ]
-[ 5, false, 0.317, 2014-08-23 11:34:54.000000 ]
-[ 6, false, 0.317, 2014-08-23 11:34:54.000000 ]
-[ 7, false, 0.317, 2014-08-23 11:34:54.000000 ]
-[ 8, false, 0.317, 2014-08-23 11:34:54.000000 ]
-[ 9, false, 0.317, 2014-08-23 11:34:54.000000 ]
-[ 10, false, 0.317, 2014-08-23 11:34:54.000000 ]
-#alter table tmp3 set read write;
# 21:09:37 >
# 21:09:37 > "Done."
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
