Changeset: 65379f699f1e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/65379f699f1e
Added Files:
sql/test/miscellaneous/Tests/analyze_test.test
Modified Files:
sql/test/miscellaneous/Tests/All
Branch: analyze-fix
Log Message:
Testing analyze statement
diffs (157 lines):
diff --git a/sql/test/miscellaneous/Tests/All b/sql/test/miscellaneous/Tests/All
--- a/sql/test/miscellaneous/Tests/All
+++ b/sql/test/miscellaneous/Tests/All
@@ -23,3 +23,4 @@ prepare
rel_push_count_down
NOT_ASSERT?sqlfuncnames
sequences
+analyze_test
diff --git a/sql/test/miscellaneous/Tests/analyze_test.test
b/sql/test/miscellaneous/Tests/analyze_test.test
new file mode 100644
--- /dev/null
+++ b/sql/test/miscellaneous/Tests/analyze_test.test
@@ -0,0 +1,144 @@
+statement ok
+CREATE TABLE sys.mytest (a int, b int, c int)
+
+statement ok rowcount 3
+INSERT INTO sys.mytest VALUES (1,1,3),(1,2,2),(1,3,1)
+
+statement ok rowcount 3
+ANALYZE sys.mytest
+
+query TTTTIITTTTTT nosort
+SELECT "schema", "table", "column", "type", "width", "count", "unique",
"nils", "minval", "maxval", "sorted", "revsorted" FROM sys.statistics('sys',
'mytest') ORDER BY "column_id"
+----
+sys
+mytest
+a
+int
+4
+3
+False
+False
+1
+1
+True
+True
+sys
+mytest
+b
+int
+4
+3
+True
+False
+1
+3
+True
+False
+sys
+mytest
+c
+int
+4
+3
+True
+False
+1
+3
+False
+True
+
+statement ok rowcount 1
+INSERT INTO sys.mytest VALUES (0,3,1)
+
+statement ok rowcount 1
+ANALYZE sys.mytest
+
+query TTTTIITTTTTT nosort
+SELECT "schema", "table", "column", "type", "width", "count", "unique",
"nils", "minval", "maxval", "sorted", "revsorted" FROM sys.statistics('sys',
'mytest') ORDER BY "column_id"
+----
+sys
+mytest
+a
+int
+4
+4
+False
+False
+0
+1
+False
+True
+sys
+mytest
+b
+int
+4
+4
+False
+False
+1
+3
+True
+False
+sys
+mytest
+c
+int
+4
+4
+False
+False
+1
+3
+False
+True
+
+statement ok rowcount 1
+INSERT INTO sys.mytest VALUES (NULL,NULL,NULL)
+
+statement ok rowcount 1
+ANALYZE sys.mytest
+
+query TTTTIITTTTTT nosort
+SELECT "schema", "table", "column", "type", "width", "count", "unique",
"nils", "minval", "maxval", "sorted", "revsorted" FROM sys.statistics('sys',
'mytest') ORDER BY "column_id"
+----
+sys
+mytest
+a
+int
+4
+5
+False
+True
+0
+1
+False
+True
+sys
+mytest
+b
+int
+4
+5
+False
+True
+1
+3
+False
+False
+sys
+mytest
+c
+int
+4
+5
+False
+True
+1
+3
+False
+True
+
+statement ok
+DROP TABLE sys.mytest
+
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
