Changeset: 50c9e6989459 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=50c9e6989459 Added Files: sql/backends/monet5/generator/Tests/joins00.sql Modified Files: sql/backends/monet5/generator/Tests/All Branch: default Log Message:
Add tests for joins over series diffs (30 lines): diff --git a/sql/backends/monet5/generator/Tests/All b/sql/backends/monet5/generator/Tests/All --- a/sql/backends/monet5/generator/Tests/All +++ b/sql/backends/monet5/generator/Tests/All @@ -2,3 +2,5 @@ generator00 generator01 generator02 generator03 + +joins00 diff --git a/sql/backends/monet5/generator/Tests/joins00.sql b/sql/backends/monet5/generator/Tests/joins00.sql new file mode 100644 --- /dev/null +++ b/sql/backends/monet5/generator/Tests/joins00.sql @@ -0,0 +1,16 @@ +-- To be done tests. +-- Using an 'int' rather then a 'tinyint' calls for casting the generated values first +-- The two join cases illustrate how a join could be optimized by 'looking' up the correct value. + +create table tmp(i tinyint); +insert into tmp values(3),(4),(5); +select * from tmp; + +select * from generate_series(0,10,2) X, tmp Y where X.value = Y.i; +select * from generate_series(0,10,2) X, tmp Y where Y.i = X.value; + +select * from generate_series(0,10,2) X, tmp Y where X.value = Y.i and value <5; + +select * from generate_series(0,10,2) as X, tmp Y where X.value = Y.i and value <7 and value >3; + +drop table tmp; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
