Changeset: eae4d612b86f for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=eae4d612b86f Modified Files: sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.sql sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.stable.out Branch: Jun2016 Log Message:
Remove variable columns from output. diffs (123 lines): diff --git a/sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.sql b/sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.sql --- a/sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.sql +++ b/sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.sql @@ -2,7 +2,7 @@ create table bug3923(i integer); -- skip columns location, count, columnsize. -select "schema", "table", "column", "type", "mode", typewidth, heapsize, hashes, phash, imprints, sorted from storage() where "table"= '_tables'; +select "schema", "table", "column", "type", "mode", typewidth, hashes, phash, imprints, sorted from storage() where "table"= '_tables'; call storagemodelinit(); update storagemodelinput set "count" =10000 where "table" ='bug3923'; @@ -15,7 +15,8 @@ drop table bug3923; crate schema bug3923schema; create table bug3923(i integer); -select * from storage() where "table"= '_tables'; +-- skip columns location, count, columnsize. +select "schema", "table", "column", "type", "mode", typewidth, hashes, phash, imprints, sorted from storage() where "table"= '_tables'; call storagemodelinit(); update storagemodelinput set "count" =10000 where "table" ='bug3923'; diff --git a/sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.stable.out b/sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.stable.out --- a/sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.stable.out +++ b/sql/test/BugTracker-2016/Tests/storagemodel.Bug-3923.stable.out @@ -66,27 +66,27 @@ Ready. # 23:38:44 > #create table bug3923(i integer); -#select "schema", "table", "column", "type", "mode", typewidth, heapsize, hashes, phash, imprints, sorted from storage() where "table"= '_tables'; -% .L, .L, .L, .L, .L, .L, .L, .L, .L, .L, .L # table_name -% schema, table, column, type, mode, typewidth, heapsize, hashes, phash, imprints, sorted # name -% clob, clob, clob, clob, clob, int, bigint, bigint, boolean, bigint, boolean # type -% 3, 7, 13, 8, 8, 2, 5, 1, 5, 1, 5 # length -[ "sys", "_tables", "id", "int", "writable", 4, 0, 0, false, 0, true ] -[ "sys", "_tables", "name", "varchar", "writable", 8, 9712, 0, false, 0, false ] -[ "sys", "_tables", "schema_id", "int", "writable", 4, 0, 0, false, 0, false ] -[ "sys", "_tables", "query", "varchar", "writable", 45, 11157, 0, false, 0, false ] -[ "sys", "_tables", "type", "smallint", "writable", 2, 0, 0, false, 0, false ] -[ "sys", "_tables", "system", "boolean", "writable", 1, 0, 0, false, 0, false ] -[ "sys", "_tables", "commit_action", "smallint", "writable", 2, 0, 0, false, 0, false ] -[ "sys", "_tables", "access", "smallint", "writable", 2, 0, 0, false, 0, true ] -[ "tmp", "_tables", "id", "int", "writable", 4, 0, 0, false, 0, true ] -[ "tmp", "_tables", "name", "varchar", "writable", 1, 8192, 0, false, 0, true ] -[ "tmp", "_tables", "schema_id", "int", "writable", 4, 0, 0, false, 0, true ] -[ "tmp", "_tables", "query", "varchar", "writable", 1, 8192, 0, false, 0, true ] -[ "tmp", "_tables", "type", "smallint", "writable", 2, 0, 0, false, 0, true ] -[ "tmp", "_tables", "system", "boolean", "writable", 1, 0, 0, false, 0, true ] -[ "tmp", "_tables", "commit_action", "smallint", "writable", 2, 0, 0, false, 0, true ] -[ "tmp", "_tables", "access", "smallint", "writable", 2, 0, 0, false, 0, true ] +#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash, imprints, sorted from storage() where "table"= '_tables'; +% .L, .L, .L, .L, .L, .L, .L, .L, .L, .L # table_name +% schema, table, column, type, mode, typewidth, hashes, phash, imprints, sorted # name +% clob, clob, clob, clob, clob, int, bigint, boolean, bigint, boolean # type +% 3, 7, 13, 8, 8, 2, 1, 5, 1, 5 # length +[ "sys", "_tables", "id", "int", "writable", 4, 0, false, 0, true ] +[ "sys", "_tables", "name", "varchar", "writable", 9, 0, false, 0, false ] +[ "sys", "_tables", "schema_id", "int", "writable", 4, 0, false, 0, false ] +[ "sys", "_tables", "query", "varchar", "writable", 55, 0, false, 0, false ] +[ "sys", "_tables", "type", "smallint", "writable", 2, 0, false, 0, false ] +[ "sys", "_tables", "system", "boolean", "writable", 1, 0, false, 0, false ] +[ "sys", "_tables", "commit_action", "smallint", "writable", 2, 0, false, 0, false ] +[ "sys", "_tables", "access", "smallint", "writable", 2, 0, false, 0, true ] +[ "tmp", "_tables", "id", "int", "writable", 4, 0, false, 0, true ] +[ "tmp", "_tables", "name", "varchar", "writable", 1, 0, false, 0, true ] +[ "tmp", "_tables", "schema_id", "int", "writable", 4, 0, false, 0, true ] +[ "tmp", "_tables", "query", "varchar", "writable", 1, 0, false, 0, true ] +[ "tmp", "_tables", "type", "smallint", "writable", 2, 0, false, 0, true ] +[ "tmp", "_tables", "system", "boolean", "writable", 1, 0, false, 0, true ] +[ "tmp", "_tables", "commit_action", "smallint", "writable", 2, 0, false, 0, true ] +[ "tmp", "_tables", "access", "smallint", "writable", 2, 0, false, 0, true ] #update storagemodelinput set "count" =10000 where "table" ='bug3923'; [ 1 ] #update storagemodelinput set "distinct" =10 where "table" ='bug3923' and "column" ='i'; @@ -99,27 +99,27 @@ Ready. [ "sys", "bug3923", "i", "int", 10000, 40000, 0, 0, 1200, true ] #drop table bug3923; #create table bug3923(i integer); -#select * from storage() where "table"= '_tables'; -% ., ., ., ., ., ., ., ., ., ., ., ., ., . # table_name -% schema, table, column, type, mode, location, count, typewidth, columnsize, heapsize, hashes, phash, imprints, sorted # name -% clob, clob, clob, clob, clob, clob, bigint, int, bigint, bigint, bigint, boolean, bigint, boolean # type -% 3, 7, 13, 8, 8, 6, 2, 2, 3, 5, 4, 5, 1, 5 # length -[ "sys", "_tables", "id", "int", "writable", "01/157", 58, 4, 232, 0, 2600, false, 0, false ] -[ "sys", "_tables", "name", "varchar", "writable", "01/160", 58, 8, 116, 9712, 0, false, 0, false ] -[ "sys", "_tables", "schema_id", "int", "writable", "01/161", 58, 4, 232, 0, 0, false, 0, false ] -[ "sys", "_tables", "query", "varchar", "writable", "01/162", 58, 45, 116, 11157, 0, false, 0, false ] -[ "sys", "_tables", "type", "smallint", "writable", "01/163", 58, 2, 116, 0, 0, false, 0, false ] -[ "sys", "_tables", "system", "boolean", "writable", "01/164", 58, 1, 58, 0, 0, false, 0, false ] -[ "sys", "_tables", "commit_action", "smallint", "writable", "01/165", 58, 2, 116, 0, 0, false, 0, false ] -[ "sys", "_tables", "access", "smallint", "writable", "01/166", 58, 2, 116, 0, 0, false, 0, true ] -[ "tmp", "_tables", "id", "int", "writable", "02/236", 0, 4, 0, 0, 0, false, 0, true ] -[ "tmp", "_tables", "name", "varchar", "writable", "02/237", 0, 1, 0, 8192, 0, false, 0, true ] -[ "tmp", "_tables", "schema_id", "int", "writable", "02/240", 0, 4, 0, 0, 0, false, 0, true ] -[ "tmp", "_tables", "query", "varchar", "writable", "02/241", 0, 1, 0, 8192, 0, false, 0, true ] -[ "tmp", "_tables", "type", "smallint", "writable", "02/242", 0, 2, 0, 0, 0, false, 0, true ] -[ "tmp", "_tables", "system", "boolean", "writable", "02/243", 0, 1, 0, 0, 0, false, 0, true ] -[ "tmp", "_tables", "commit_action", "smallint", "writable", "02/244", 0, 2, 0, 0, 0, false, 0, true ] -[ "tmp", "_tables", "access", "smallint", "writable", "02/245", 0, 2, 0, 0, 0, false, 0, true ] +#select "schema", "table", "column", "type", "mode", typewidth, hashes, phash, imprints, sorted from storage() where "table"= '_tables'; +% .L, .L, .L, .L, .L, .L, .L, .L, .L, .L # table_name +% schema, table, column, type, mode, typewidth, hashes, phash, imprints, sorted # name +% clob, clob, clob, clob, clob, int, bigint, boolean, bigint, boolean # type +% 3, 7, 13, 8, 8, 2, 4, 5, 1, 5 # length +[ "sys", "_tables", "id", "int", "writable", 4, 2600, false, 0, false ] +[ "sys", "_tables", "name", "varchar", "writable", 9, 0, false, 0, false ] +[ "sys", "_tables", "schema_id", "int", "writable", 4, 0, false, 0, false ] +[ "sys", "_tables", "query", "varchar", "writable", 54, 0, false, 0, false ] +[ "sys", "_tables", "type", "smallint", "writable", 2, 0, false, 0, false ] +[ "sys", "_tables", "system", "boolean", "writable", 1, 0, false, 0, false ] +[ "sys", "_tables", "commit_action", "smallint", "writable", 2, 0, false, 0, false ] +[ "sys", "_tables", "access", "smallint", "writable", 2, 0, false, 0, true ] +[ "tmp", "_tables", "id", "int", "writable", 4, 0, false, 0, true ] +[ "tmp", "_tables", "name", "varchar", "writable", 1, 0, false, 0, true ] +[ "tmp", "_tables", "schema_id", "int", "writable", 4, 0, false, 0, true ] +[ "tmp", "_tables", "query", "varchar", "writable", 1, 0, false, 0, true ] +[ "tmp", "_tables", "type", "smallint", "writable", 2, 0, false, 0, true ] +[ "tmp", "_tables", "system", "boolean", "writable", 1, 0, false, 0, true ] +[ "tmp", "_tables", "commit_action", "smallint", "writable", 2, 0, false, 0, true ] +[ "tmp", "_tables", "access", "smallint", "writable", 2, 0, false, 0, true ] #update storagemodelinput set "count" =10000 where "table" ='bug3923'; [ 1 ] #update storagemodelinput set "distinct" =10 where "table" ='bug3923' and "column" ='i'; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
