Changeset: 61abc2517100 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=61abc2517100
Modified Files:
sql/test/BugTracker-2016/Tests/storagemodel.sql
sql/test/BugTracker-2016/Tests/storagemodel.stable.out
Branch: Mar2018
Log Message:
Update test to make output stable
This reliefs us to create Windows, FreeBSD and Darwin specific outputs
diffs (56 lines):
diff --git a/sql/test/BugTracker-2016/Tests/storagemodel.sql
b/sql/test/BugTracker-2016/Tests/storagemodel.sql
--- a/sql/test/BugTracker-2016/Tests/storagemodel.sql
+++ b/sql/test/BugTracker-2016/Tests/storagemodel.sql
@@ -2,7 +2,7 @@
create table bug3923(i integer);
-- skip columns: location, count, columnsize, sorted.
-select "schema", "table", "column", "type", "mode", case when typewidth <= 64
then typewidth else 99 end as typewidth, hashes, phash, imprints from
storage('sys','_tables');
+select "schema", "table", "column", "type", "mode", case when typewidth < 14
then typewidth else 99 end as typewidth, hashes, phash, imprints from
storage('sys','_tables');
call storagemodelinit();
update storagemodelinput set "count" =10000 where "table" ='bug3923';
@@ -18,7 +18,7 @@ set schema bug3923schema;
create table bug3923(i integer);
-- skip columns: location, count, columnsize, sorted.
-select "schema", "table", "column", "type", "mode", case when typewidth <= 64
then typewidth else 99 end as typewidth, hashes, phash, imprints from
sys.storage('sys','_tables');
+select "schema", "table", "column", "type", "mode", case when typewidth < 14
then typewidth else 99 end as typewidth, hashes, phash, imprints from
sys.storage('sys','_tables');
call sys.storagemodelinit();
update sys.storagemodelinput set "count" =10000 where "table" ='bug3923';
diff --git a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
--- a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
+++ b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
@@ -66,13 +66,13 @@ Ready.
# 23:38:44 >
#create table bug3923(i integer);
-#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints from storage('sys','_tables');
+#select "schema", "table", "column", "type", "mode", case when typewidth < 14
then typewidth else 99 end as typewidth, hashes, phash, imprints from
storage('sys','_tables');
% .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3 # table_name
% schema, table, column, type, mode, typewidth, hashes, phash,
imprints # name
% clob, clob, clob, clob, clob, int, bigint, boolean,
bigint # type
% 3, 7, 13, 8, 8, 2, 1, 5, 1 # length
[ "sys", "_tables", "id", "int", "writable", 4, 0,
false, 0 ]
-[ "sys", "_tables", "name", "varchar", "writable", 14,
0, false, 0 ]
+[ "sys", "_tables", "name", "varchar", "writable", 99,
0, false, 0 ]
[ "sys", "_tables", "schema_id", "int", "writable", 4,
0, false, 0 ]
[ "sys", "_tables", "query", "varchar", "writable",
99, 0, false, 0 ]
[ "sys", "_tables", "type", "smallint", "writable", 2,
0, false, 0 ]
@@ -91,13 +91,13 @@ Ready.
[ "sys", "bug3923", "i", "int", 10000, 40000, 0, 0,
1200, true, true, NULL, 0 ]
#drop table bug3923;
#create table bug3923(i integer);
-#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash,
imprints from storage('sys','_tables');
+#select "schema", "table", "column", "type", "mode", case when typewidth < 14
then typewidth else 99 end as typewidth, hashes, phash, imprints from
storage('sys','_tables');
% .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3, .L3 # table_name
% schema, table, column, type, mode, typewidth, hashes, phash,
imprints # name
% clob, clob, clob, clob, clob, int, bigint, boolean,
bigint # type
% 3, 7, 13, 8, 8, 2, 1, 5, 1 # length
[ "sys", "_tables", "id", "int", "writable", 4, 0,
false, 0 ]
-[ "sys", "_tables", "name", "varchar", "writable", 14,
0, false, 0 ]
+[ "sys", "_tables", "name", "varchar", "writable", 99,
0, false, 0 ]
[ "sys", "_tables", "schema_id", "int", "writable", 4,
0, false, 0 ]
[ "sys", "_tables", "query", "varchar", "writable",
99, 0, false, 0 ]
[ "sys", "_tables", "type", "smallint", "writable", 2,
0, false, 0 ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
