Changeset: 9ba0fc4e552d for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9ba0fc4e552d Modified Files: sql/backends/monet5/generator/Tests/joins01.sql sql/backends/monet5/generator/Tests/joins01.stable.out Branch: generator Log Message:
Refine the tests for joins over timestamps diffs (55 lines): diff --git a/sql/backends/monet5/generator/Tests/joins01.sql b/sql/backends/monet5/generator/Tests/joins01.sql --- a/sql/backends/monet5/generator/Tests/joins01.sql +++ b/sql/backends/monet5/generator/Tests/joins01.sql @@ -24,9 +24,15 @@ select * from generate_series(timestamp select * from generate_series(timestamp '2008-03-04 18:00',timestamp '2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i and value > timestamp '2008-03-01 11:00'; +select * from generate_series(timestamp '2008-03-04 18:00',timestamp '2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i +and i > timestamp '2008-03-01 11:00'; select * from generate_series(timestamp '2008-03-04 18:00',timestamp '2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i and value > timestamp '2008-03-01 11:00' and value < timestamp '2008-03-01 21:00'; +select * from generate_series(timestamp '2008-03-04 18:00',timestamp '2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i +and i > timestamp '2008-03-01 11:00' +and i < timestamp '2008-03-01 21:00'; + drop table tmp; diff --git a/sql/backends/monet5/generator/Tests/joins01.stable.out b/sql/backends/monet5/generator/Tests/joins01.stable.out --- a/sql/backends/monet5/generator/Tests/joins01.stable.out +++ b/sql/backends/monet5/generator/Tests/joins01.stable.out @@ -113,13 +113,29 @@ Ready. % 26, 26 # length [ 2008-03-01 20:00:00.000000, 2008-03-01 20:00:00.000000 ] #select * from generate_series(timestamp '2008-03-04 18:00',timestamp '2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i -#and value > timestamp '2008-03-01 09:00'; -#and value < timestamp '2008-03-01 20:00'; +#and i > timestamp '2008-03-01 11:00'; +% .x, sys.y # table_name +% value, i # name +% timestamp, timestamp # type +% 26, 26 # length +[ 2008-03-01 20:00:00.000000, 2008-03-01 20:00:00.000000 ] +#select * from generate_series(timestamp '2008-03-04 18:00',timestamp '2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i +#and value > timestamp '2008-03-01 11:00' +#and value < timestamp '2008-03-01 21:00'; % .x, sys.y # table_name % value, i # name % timestamp, timestamp # type % 26, 26 # length -[ 2008-03-01 10:00:00.000000, 2008-03-01 10:00:00.000000 ] +[ 2008-03-01 20:00:00.000000, 2008-03-01 20:00:00.000000 ] +#select * from generate_series(timestamp '2008-03-04 18:00',timestamp '2008-03-01 00:00',cast( '-10' as interval hour)) X, tmp Y where X.value = Y.i +#and i > timestamp '2008-03-01 11:00' +#and i < timestamp '2008-03-01 21:00'; +% .x, sys.y # table_name +% value, i # name +% timestamp, timestamp # type +% 26, 26 # length +[ 2008-03-01 20:00:00.000000, 2008-03-01 20:00:00.000000 ] +#drop table tmp; # 11:37:00 > # 11:37:00 > "Done." _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
