Changeset: 75d5935232f2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=75d5935232f2 Modified Files: sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.sql sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.stable.out Branch: Mar2018 Log Message:
We don't care about specific counts. diffs (150 lines): diff --git a/sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.sql b/sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.sql --- a/sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.sql +++ b/sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.sql @@ -1,19 +1,19 @@ -SELECT count(*) FROM sys.statistics; +SELECT count(*) = 0 FROM sys.statistics; ANALYZE sys; -SELECT count(*) FROM sys.statistics WHERE nils <> 0; -SELECT count(*) FROM sys.statistics WHERE nils <> 0 AND (minval = 'nil' OR maxval = 'nil'); -SELECT count(*) FROM sys.statistics WHERE count > 0 AND (minval = 'nil' OR maxval = 'nil'); +SELECT count(*) > 0 FROM sys.statistics WHERE nils <> 0; +SELECT count(*) > 0 FROM sys.statistics WHERE nils <> 0 AND (minval = 'nil' OR maxval = 'nil'); +SELECT count(*) > 0 FROM sys.statistics WHERE count > 0 AND (minval = 'nil' OR maxval = 'nil'); ANALYZE tmp; -SELECT count(*) FROM sys.statistics WHERE nils <> 0; -SELECT count(*) FROM sys.statistics WHERE nils <> 0 AND (minval = 'nil' OR maxval = 'nil'); -SELECT count(*) FROM sys.statistics WHERE count > 0 AND (minval = 'nil' OR maxval = 'nil'); +SELECT count(*) > 0 FROM sys.statistics WHERE nils <> 0; +SELECT count(*) > 0 FROM sys.statistics WHERE nils <> 0 AND (minval = 'nil' OR maxval = 'nil'); +SELECT count(*) > 0 FROM sys.statistics WHERE count > 0 AND (minval = 'nil' OR maxval = 'nil'); ANALYZE profiler; -SELECT count(*) FROM sys.statistics WHERE nils <> 0; -SELECT count(*) FROM sys.statistics WHERE nils <> 0 AND (minval = 'nil' OR maxval = 'nil'); -SELECT count(*) FROM sys.statistics WHERE count > 0 AND (minval = 'nil' OR maxval = 'nil'); +SELECT count(*) > 0 FROM sys.statistics WHERE nils <> 0; +SELECT count(*) > 0 FROM sys.statistics WHERE nils <> 0 AND (minval = 'nil' OR maxval = 'nil'); +SELECT count(*) > 0 FROM sys.statistics WHERE count > 0 AND (minval = 'nil' OR maxval = 'nil'); -- DELETE FROM sys.statistics; diff --git a/sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.stable.out b/sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.stable.out --- a/sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.stable.out +++ b/sql/test/BugTracker-2017/Tests/statistics_nils_not_eq_zero.Bug-6331.stable.out @@ -68,64 +68,64 @@ Ready. #SELECT count(*) FROM sys.statistics; % sys.L4 # table_name -% L3 # name -% bigint # type -% 1 # length -[ 0 ] -#SELECT count(*) FROM sys.statistics WHERE nils <> 0; +% L4 # name +% boolean # type +% 5 # length +[ true ] +#SELECT count(*) > 0 FROM sys.statistics WHERE nils <> 0; % sys.L4 # table_name -% L3 # name -% bigint # type -% 1 # length -[ 6 ] -#SELECT count(*) FROM sys.statistics WHERE nils <> 0 AND (minval = 'nil' OR maxval = 'nil'); +% L4 # name +% boolean # type +% 5 # length +[ true ] +#SELECT count(*) > 0 FROM sys.statistics WHERE nils <> 0 AND (minval = 'nil' OR maxval = 'nil'); % sys.L4 # table_name -% L3 # name -% bigint # type -% 1 # length -[ 4 ] -#SELECT count(*) FROM sys.statistics WHERE count > 0 AND (minval = 'nil' OR maxval = 'nil'); +% L4 # name +% boolean # type +% 5 # length +[ true ] +#SELECT count(*) > 0 FROM sys.statistics WHERE count > 0 AND (minval = 'nil' OR maxval = 'nil'); % sys.L4 # table_name -% L3 # name -% bigint # type -% 1 # length -[ 4 ] -#SELECT count(*) FROM sys.statistics WHERE nils <> 0; +% L4 # name +% boolean # type +% 5 # length +[ true ] +#SELECT count(*) > 0 FROM sys.statistics WHERE nils <> 0; % sys.L4 # table_name -% L3 # name -% bigint # type -% 1 # length -[ 6 ] -#SELECT count(*) FROM sys.statistics WHERE nils <> 0 AND (minval = 'nil' OR maxval = 'nil'); +% L4 # name +% boolean # type +% 5 # length +[ true ] +#SELECT count(*) > 0 FROM sys.statistics WHERE nils <> 0 AND (minval = 'nil' OR maxval = 'nil'); % sys.L4 # table_name -% L3 # name -% bigint # type -% 1 # length -[ 4 ] -#SELECT count(*) FROM sys.statistics WHERE count > 0 AND (minval = 'nil' OR maxval = 'nil'); +% L4 # name +% boolean # type +% 5 # length +[ true ] +#SELECT count(*) > 0 FROM sys.statistics WHERE count > 0 AND (minval = 'nil' OR maxval = 'nil'); % sys.L4 # table_name -% L3 # name -% bigint # type -% 1 # length -[ 4 ] -#SELECT count(*) FROM sys.statistics WHERE nils <> 0; +% L4 # name +% boolean # type +% 5 # length +[ true ] +#SELECT count(*) > 0 FROM sys.statistics WHERE nils <> 0; % sys.L4 # table_name -% L3 # name -% bigint # type -% 1 # length -[ 6 ] -#SELECT count(*) FROM sys.statistics WHERE nils <> 0 AND (minval = 'nil' OR maxval = 'nil'); +% L4 # name +% boolean # type +% 5 # length +[ true ] +#SELECT count(*) > 0 FROM sys.statistics WHERE nils <> 0 AND (minval = 'nil' OR maxval = 'nil'); % sys.L4 # table_name -% L3 # name -% bigint # type -% 1 # length -[ 4 ] -#SELECT count(*) FROM sys.statistics WHERE count > 0 AND (minval = 'nil' OR maxval = 'nil'); +% L4 # name +% boolean # type +% 5 # length +[ true ] +#SELECT count(*) > 0 FROM sys.statistics WHERE count > 0 AND (minval = 'nil' OR maxval = 'nil'); % sys.L4 # table_name -% L3 # name -% bigint # type -% 1 # length -[ 4 ] +% L4 # name +% boolean # type +% 5 # length +[ true ] # 13:40:17 > # 13:40:17 > "Done." _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
