Changeset: fb8ef8dcbe2e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fb8ef8dcbe2e Modified Files: sql/test/BugTracker-2017/Tests/crash_after_oidx_on_sys_statistics.Bug-6251.test sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.test Branch: default Log Message:
Analyze statements don't have result sets diffs (142 lines): diff --git a/sql/test/BugTracker-2017/Tests/crash_after_oidx_on_sys_statistics.Bug-6251.test b/sql/test/BugTracker-2017/Tests/crash_after_oidx_on_sys_statistics.Bug-6251.test --- a/sql/test/BugTracker-2017/Tests/crash_after_oidx_on_sys_statistics.Bug-6251.test +++ b/sql/test/BugTracker-2017/Tests/crash_after_oidx_on_sys_statistics.Bug-6251.test @@ -97,98 +97,9 @@ 0 False True -query TIIIIITT rowsort +statement ok -- update the values of: sample, count, unique, nils, minval, maxval, sorted, revsorted of sys.statistics ANALYZE sys.statistics ----- -bigint -8 -4 -4 -4 -0 -True -False -bigint -8 -5 -5 -5 -0 -True -False -bigint -8 -6 -6 -6 -0 -True -False -bigint -8 -7 -7 -1 -0 -True -True -boolean -1 -10 -10 -2 -0 -False -False -boolean -1 -11 -11 -2 -0 -False -False -clob -1 -1 -1 -1 -0 -True -True -clob -1 -8 -8 -5 -1 -False -False -clob -1 -9 -9 -7 -1 -False -False -int -4 -0 -0 -0 -0 -True -True -int -4 -2 -2 -2 -0 -False -True query TIIIIITT rowsort SELECT "type", width, "sample", "count", "unique", nils, sorted, revsorted FROM sys.statistics WHERE "type" <> 'timestamp' ORDER BY column_id diff --git a/sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.test b/sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.test --- a/sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.test +++ b/sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.test @@ -3,10 +3,8 @@ SELECT count(*) = 0 FROM sys.statistics ---- 1 -query I rowsort +statement ok ANALYZE sys ----- -1 query I rowsort SELECT count(*) > 0 FROM sys.statistics WHERE nils <> 0 @@ -23,10 +21,8 @@ SELECT count(*) > 0 FROM sys.statistics ---- 1 -query I rowsort +statement ok ANALYZE tmp ----- -1 query I rowsort SELECT count(*) > 0 FROM sys.statistics WHERE nils <> 0 @@ -43,10 +39,8 @@ SELECT count(*) > 0 FROM sys.statistics ---- 1 -query I rowsort +statement ok ANALYZE profiler ----- -1 query I rowsort SELECT count(*) > 0 FROM sys.statistics WHERE nils <> 0 _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
