Changeset: a57b57cf388e for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a57b57cf388e Modified Files: sql/backends/monet5/generator/Tests/generator03.stable.out sql/backends/monet5/generator/Tests/joins01.stable.out Branch: generator Log Message:
Accept generators output. The cases considered all produce the expected results. diffs (57 lines): diff --git a/sql/backends/monet5/generator/Tests/generator03.stable.out b/sql/backends/monet5/generator/Tests/generator03.stable.out --- a/sql/backends/monet5/generator/Tests/generator03.stable.out +++ b/sql/backends/monet5/generator/Tests/generator03.stable.out @@ -97,7 +97,6 @@ Ready. % value # name % timestamp # type % 26 # length -[ 2008-03-02 00:00:00.000000 ] [ 2008-03-01 14:00:00.000000 ] #select * from generate_series( # timestamp '2008-03-01 00:00', 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 @@ -61,7 +61,6 @@ Ready. % 26, 26 # length [ 2008-03-01 00:00:00.000000, 2008-03-01 00:00:00.000000 ] [ 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-01 00:00',timestamp '2008-03-04 12:00',cast( '10' as interval hour)) X, tmp Y where Y.i = X.value and value < timestamp '2008-03-01 20:00'; % .x, sys.y # table_name % value, i # name @@ -69,7 +68,6 @@ Ready. % 26, 26 # length [ 2008-03-01 00:00:00.000000, 2008-03-01 00:00:00.000000 ] [ 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-01 00:00',timestamp '2008-03-04 12:00',cast( '10' as interval hour)) as X, tmp Y where X.value = Y.i and value < timestamp '2008-03-01 20:00' and value > timestamp '200-03-01 00:00'; % .x, sys.y # table_name % value, i # name @@ -77,6 +75,13 @@ Ready. % 26, 26 # length [ 2008-03-01 00:00:00.000000, 2008-03-01 00:00:00.000000 ] [ 2008-03-01 10:00:00.000000, 2008-03-01 10:00:00.000000 ] +#select * from generate_series(timestamp '2008-03-01 00:00',timestamp '2008-03-04 12:00',cast( '10' as interval hour)) as X, tmp Y where X.value = Y.i and i < timestamp '2008-03-01 20:00' and i > timestamp '200-03-01 00:00'; +% .x, sys.y # table_name +% value, i # name +% timestamp, timestamp # type +% 26, 26 # length +[ 2008-03-01 00:00:00.000000, 2008-03-01 00:00:00.000000 ] +[ 2008-03-01 10:00:00.000000, 2008-03-01 10: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; % .x # table_name % value # name @@ -119,6 +124,12 @@ Ready. % 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 where value > timestamp '2008-03-01 11:00' and value < timestamp '2008-03-01 21:00'; +% .x # table_name +% value # name +% timestamp # type +% 26 # length +[ 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'; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
