Changeset: 32275b9b7eda for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=32275b9b7eda
Modified Files:
sql/test/BugTracker-2016/Tests/storagemodel.test
Branch: unlock
Log Message:
approved output
diffs (truncated from 359 to 300 lines):
diff --git a/sql/test/BugTracker-2016/Tests/storagemodel.test
b/sql/test/BugTracker-2016/Tests/storagemodel.test
--- a/sql/test/BugTracker-2016/Tests/storagemodel.test
+++ b/sql/test/BugTracker-2016/Tests/storagemodel.test
@@ -4,10 +4,154 @@ create table bug3923(i integer)
query TTTTTIITI rowsort
select "schema", "table", "column", "type", "mode", case when typewidth < 14
then typewidth else 99 end as typewidth, hashes, phash, imprints from
storage('sys','_tables')
----
-72 values hashing to 4c5e9b1e4afb42c5e62c76d7b0862af9
+sys
+_tables
+access
+smallint
+writable
+2
+0
+False
+0
+sys
+_tables
+commit_action
+smallint
+writable
+2
+0
+False
+0
+sys
+_tables
+id
+int
+writable
+4
+0
+False
+0
+sys
+_tables
+name
+varchar
+writable
+99
+0
+False
+0
+sys
+_tables
+query
+varchar
+writable
+99
+0
+False
+0
+sys
+_tables
+schema_id
+int
+writable
+4
+0
+False
+0
+sys
+_tables
+system
+boolean
+writable
+1
+0
+False
+0
+sys
+_tables
+type
+smallint
+writable
+2
+0
+False
+0
-statement ok
+query TTTTTIITI rowsort
call storagemodelinit()
+----
+sys
+_tables
+access
+smallint
+writable
+2
+0
+False
+0
+sys
+_tables
+commit_action
+smallint
+writable
+2
+0
+False
+0
+sys
+_tables
+id
+int
+writable
+4
+0
+False
+0
+sys
+_tables
+name
+varchar
+writable
+99
+0
+False
+0
+sys
+_tables
+query
+varchar
+writable
+99
+0
+False
+0
+sys
+_tables
+schema_id
+int
+writable
+4
+0
+False
+0
+sys
+_tables
+system
+boolean
+writable
+1
+0
+False
+0
+sys
+_tables
+type
+smallint
+writable
+2
+0
+False
+0
statement ok
update storagemodelinput set "count" =10000 where "table" ='bug3923'
@@ -18,7 +162,19 @@ update storagemodelinput set "distinct"
query TTTTIIIIIITTT rowsort
select * from storagemodel where "table" = 'bug3923'
----
-13 values hashing to c499d6faa21698d5f67e25ef85e898e1
+sys
+bug3923
+i
+int
+10000
+10000
+8312
+0
+2000
+0
+True
+True
+True
statement ok
drop table bug3923
@@ -35,10 +191,154 @@ create table bug3923(i integer)
query TTTTTIITI rowsort
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')
----
-72 values hashing to 4c5e9b1e4afb42c5e62c76d7b0862af9
+sys
+_tables
+access
+smallint
+writable
+2
+0
+False
+0
+sys
+_tables
+commit_action
+smallint
+writable
+2
+0
+False
+0
+sys
+_tables
+id
+int
+writable
+4
+0
+False
+0
+sys
+_tables
+name
+varchar
+writable
+99
+0
+False
+0
+sys
+_tables
+query
+varchar
+writable
+99
+0
+False
+0
+sys
+_tables
+schema_id
+int
+writable
+4
+0
+False
+0
+sys
+_tables
+system
+boolean
+writable
+1
+0
+False
+0
+sys
+_tables
+type
+smallint
+writable
+2
+0
+False
+0
-statement ok
+query TTTTTIITI rowsort
call sys.storagemodelinit()
+----
+sys
+_tables
+access
+smallint
+writable
+2
+0
+False
+0
+sys
+_tables
+commit_action
+smallint
+writable
+2
+0
+False
+0
+sys
+_tables
+id
+int
+writable
+4
+0
+False
+0
+sys
+_tables
+name
+varchar
+writable
+99
+0
+False
+0
+sys
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
