Changeset: d8e7e06eff2e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d8e7e06eff2e Modified Files: sql/test/analytics/Tests/analytics16.sql sql/test/analytics/Tests/analytics16.stable.out Branch: statistics-analytics Log Message:
Approved output diffs (88 lines): diff --git a/sql/test/analytics/Tests/analytics16.sql b/sql/test/analytics/Tests/analytics16.sql --- a/sql/test/analytics/Tests/analytics16.sql +++ b/sql/test/analytics/Tests/analytics16.sql @@ -127,4 +127,13 @@ select covar_samp(NULL, NULL) from analy select covar_pop(NULL, NULL) from analytics group by aa, bb; select corr(NULL, NULL) from analytics group by aa, bb; + +select (select corr(a1.aa, a2.aa) + corr(a2.aa, a1.aa) from analytics a2) from analytics a1; +select (select corr(a1.aa + a2.aa, a1.aa + a2.aa) from analytics a2) from analytics a1; +select corr(a1.aa, a1.bb) from analytics a1 where a1.bb > (select corr(a1.aa, a2.aa) + corr(a2.aa, a1.aa) from analytics a2); +select corr(a1.aa, a1.bb) from analytics a1 where a1.bb > (select corr(a1.aa + a2.aa, a1.aa + a2.aa) from analytics a2); +select corr(a1.aa, a1.bb) from analytics a1 where a1.bb > (select corr(a1.aa, a2.aa) + corr(a2.aa, a1.aa) from analytics a2) group by bb; +select corr(a1.aa, a1.bb) from analytics a1 where a1.bb > (select corr(a1.aa + a2.aa, a1.aa + a2.aa) from analytics a2) group by bb; +select corr(a1.aa, a1.bb) from analytics a1 group by bb having a1.bb > (select corr(MAX(a1.aa) + a2.aa, MIN(a1.aa) + a2.aa) from analytics a2); + rollback; diff --git a/sql/test/analytics/Tests/analytics16.stable.out b/sql/test/analytics/Tests/analytics16.stable.out --- a/sql/test/analytics/Tests/analytics16.stable.out +++ b/sql/test/analytics/Tests/analytics16.stable.out @@ -1250,6 +1250,67 @@ stdout of test 'analytics16` in director [ NULL ] [ NULL ] [ NULL ] +#select (select corr(a1.aa, a2.aa) + corr(a2.aa, a1.aa) from analytics a2) from analytics a1; +% .%3 # table_name +% %3 # name +% double # type +% 24 # length +[ NULL ] +[ NULL ] +[ NULL ] +[ NULL ] +[ NULL ] +[ NULL ] +[ NULL ] +[ NULL ] +[ NULL ] +[ NULL ] +#select (select corr(a1.aa + a2.aa, a1.aa + a2.aa) from analytics a2) from analytics a1; +% .%1 # table_name +% %1 # name +% double # type +% 24 # length +[ 1 ] +[ 1 ] +[ 1 ] +[ 1 ] +[ NULL ] +[ 1 ] +[ 1 ] +[ 1 ] +[ 1 ] +[ NULL ] +#select corr(a1.aa, a1.bb) from analytics a1 where a1.bb > (select corr(a1.aa, a2.aa) + corr(a2.aa, a1.aa) from analytics a2); +% sys.%4 # table_name +% %4 # name +% double # type +% 24 # length +[ NULL ] +#select corr(a1.aa, a1.bb) from analytics a1 where a1.bb > (select corr(a1.aa + a2.aa, a1.aa + a2.aa) from analytics a2); +% sys.%2 # table_name +% %2 # name +% double # type +% 24 # length +[ 0.3758141918 ] +#select corr(a1.aa, a1.bb) from analytics a1 where a1.bb > (select corr(a1.aa, a2.aa) + corr(a2.aa, a1.aa) from analytics a2) group by bb; +% sys.%4 # table_name +% %4 # name +% double # type +% 24 # length +#select corr(a1.aa, a1.bb) from analytics a1 where a1.bb > (select corr(a1.aa + a2.aa, a1.aa + a2.aa) from analytics a2) group by bb; +% sys.%2 # table_name +% %2 # name +% double # type +% 24 # length +[ NULL ] +[ NULL ] +#select corr(a1.aa, a1.bb) from analytics a1 group by bb having a1.bb > (select corr(MAX(a1.aa) + a2.aa, MIN(a1.aa) + a2.aa) from analytics a2); +% sys.%1 # table_name +% %1 # name +% double # type +% 24 # length +[ NULL ] +[ NULL ] #rollback; # 18:06:22 > _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
