Changeset: 25a6c9da726d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/25a6c9da726d
Modified Files:
sql/test/BugTracker-2016/Tests/storagemodel.test
Branch: Jul2021
Log Message:
Attempting to make test deterministic
diffs (255 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
@@ -1,8 +1,8 @@
statement ok
create table bug3923(i integer)
-query TTTTTIIII 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')
+query TTTTTITTI rowsort
+select "schema", "table", "column", "type", "mode", case when typewidth < 14
then typewidth else 99 end as typewidth, hashes > 0, phash, imprints from
storage('sys','_tables')
----
sys
_tables
@@ -10,8 +10,8 @@ access
smallint
writable
2
-0
-0
+False
+False
0
sys
_tables
@@ -19,8 +19,8 @@ commit_action
smallint
writable
2
-0
-0
+False
+False
0
sys
_tables
@@ -28,8 +28,8 @@ id
int
writable
4
-0
-0
+False
+False
0
sys
_tables
@@ -37,8 +37,8 @@ name
varchar
writable
99
-0
-0
+False
+False
0
sys
_tables
@@ -46,8 +46,8 @@ query
varchar
writable
99
-0
-0
+False
+False
0
sys
_tables
@@ -55,8 +55,8 @@ schema_id
int
writable
4
-0
-0
+False
+False
0
sys
_tables
@@ -64,8 +64,8 @@ system
boolean
writable
1
-0
-0
+False
+False
0
sys
_tables
@@ -73,20 +73,20 @@ type
smallint
writable
2
-0
-0
+False
+False
0
statement ok
call storagemodelinit()
-statement ok
+statement ok rowcount 1
update storagemodelinput set "count" =10000 where "table" ='bug3923'
-statement ok
+statement ok rowcount 1
update storagemodelinput set "distinct" =10 where "table" ='bug3923' and
"column" ='i'
-query TTTTIIIIIIIII rowsort
+query TTTTIIIIIITTT rowsort
select * from storagemodel where "table" = 'bug3923'
----
sys
@@ -99,9 +99,9 @@ 8312
0
2000
0
-1
+True
NULL
-1
+True
statement ok
drop table bug3923
@@ -115,8 +115,8 @@ set schema bug3923schema
statement ok
create table bug3923(i integer)
-query TTTTTIIII 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')
+query TTTTTITTI rowsort
+select "schema", "table", "column", "type", "mode", case when typewidth < 14
then typewidth else 99 end as typewidth, hashes > 0, phash, imprints from
sys.storage('sys','_tables')
----
sys
_tables
@@ -124,8 +124,8 @@ access
smallint
writable
2
-0
-0
+False
+False
0
sys
_tables
@@ -133,8 +133,8 @@ commit_action
smallint
writable
2
-0
-0
+False
+False
0
sys
_tables
@@ -142,8 +142,8 @@ id
int
writable
4
-0
-0
+False
+False
0
sys
_tables
@@ -151,8 +151,8 @@ name
varchar
writable
99
-0
-0
+False
+False
0
sys
_tables
@@ -160,8 +160,8 @@ query
varchar
writable
99
-0
-0
+False
+False
0
sys
_tables
@@ -169,8 +169,8 @@ schema_id
int
writable
4
-0
-0
+False
+False
0
sys
_tables
@@ -178,8 +178,8 @@ system
boolean
writable
1
-820
-0
+True
+False
0
sys
_tables
@@ -187,20 +187,20 @@ type
smallint
writable
2
-0
-0
+False
+False
0
statement ok
call sys.storagemodelinit()
-statement ok
+statement ok rowcount 1
update sys.storagemodelinput set "count" =10000 where "table" ='bug3923'
-statement ok
+statement ok rowcount 1
update sys.storagemodelinput set "distinct" =10 where "table" ='bug3923' and
"column" ='i'
-query TTTTIIIIIIIII rowsort
+query TTTTIIIIIITTT rowsort
select * from sys.storagemodel where "table" = 'bug3923'
----
bug3923schema
@@ -213,9 +213,9 @@ 8312
0
2000
0
-1
+True
NULL
-1
+True
statement ok
drop table bug3923
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
