Changeset: 16f1b0087218 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=16f1b0087218
Modified Files:
sql/backends/monet5/generator/Tests/generator03.sql
Branch: default
Log Message:
Remember we need timestamp series as well
diffs (36 lines):
diff --git a/sql/backends/monet5/generator/Tests/generator03.sql
b/sql/backends/monet5/generator/Tests/generator03.sql
--- a/sql/backends/monet5/generator/Tests/generator03.sql
+++ b/sql/backends/monet5/generator/Tests/generator03.sql
@@ -1,12 +1,26 @@
-select cast( '2008-03-01 00:00' as timestamp);
-select cast( '10' as interval second);
+select timestamp '2008-03-01 00:00';
+select cast( '10' as interval hour);
select * from generate_series(
- cast( '2008-03-01 00:00' as timestamp),
- cast( '2008-03-04 12:00' as timestamp),
+ timestamp '2008-03-01 00:00',
+ timestamp '2008-03-04 12:00',
cast( '10' as interval hour));
select * from generate_series(
- cast( '2008-03-01 00:00' as timestamp),
- cast( '2008-03-04 12:00' as timestamp),
+ timestamp '2008-03-01 00:00',
+ timestamp '2008-03-04 12:00',
cast( '1' as interval day));
+
+select * from generate_series(
+ timestamp '2008-03-01 00:00',
+ timestamp '2008-03-04 12:00',
+ cast( '10' as interval hour))
+where value < timestamp '2008-03-22 00:00';
+
+select * from generate_series(
+ timestamp '2008-03-01 00:00',
+ timestamp '2008-03-04 12:00',
+ cast( '10' as interval hour))
+where value > timestamp '2008-03-01 00:00'
+and value < timestamp '2008-03-22 00:00';
+
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
