Changeset: 4ae40ed61267 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4ae40ed61267
Modified Files:
sql/backends/monet5/generator/Tests/generator03.sql
sql/backends/monet5/generator/Tests/generator03.stable.out
sql/backends/monet5/generator/Tests/joins01.sql
Branch: generator
Log Message:
Pinning the source of the errors
It seems that point and range selection over the (descending)
time series does not work properly.
Solution to be found.
diffs (135 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
@@ -36,6 +36,36 @@ where value > timestamp '2008-03-01 00:0
and value < timestamp '2008-03-03 00:00';
select * from generate_series(
+ timestamp '2008-03-04 18:00',
+ timestamp '2008-03-01 00:00',
+ cast( '-10' as interval hour));
+
+select * from generate_series(
+ timestamp '2008-03-04 18:00',
+ timestamp '2008-03-01 00:00',
+ cast( '-10' as interval hour))
+where 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))
+where value = timestamp '2008-03-01 10:00' ;
+
+select * from generate_series(
+ timestamp '2008-03-04 18:00',
+ timestamp '2008-03-01 00:00',
+ cast( '-10' as interval hour))
+where 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))
+where value > timestamp '2008-03-01 11:00'
+and value < timestamp '2008-03-01 21:00';
+
+select * from generate_series(
timestamp '2008-03-01 00:00',
timestamp '2008-03-04 12:00',
cast( '10' as interval hour))
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
@@ -114,6 +114,70 @@ Ready.
[ 2008-03-02 06:00:00.000000 ]
[ 2008-03-02 16:00:00.000000 ]
#select * from generate_series(
+# timestamp '2008-03-04 18:00',
+# timestamp '2008-03-01 00:00',
+# cast( '-10' as interval hour));
+% . # table_name
+% value # name
+% timestamp # type
+% 26 # length
+[ 2008-03-04 18:00:00.000000 ]
+[ 2008-03-04 08:00:00.000000 ]
+[ 2008-03-03 22:00:00.000000 ]
+[ 2008-03-03 12:00:00.000000 ]
+[ 2008-03-03 02:00:00.000000 ]
+[ 2008-03-02 16:00:00.000000 ]
+[ 2008-03-02 06:00:00.000000 ]
+[ 2008-03-01 20: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))
+#where value > timestamp '2008-03-01 11:00' ;
+% . # table_name
+% value # name
+% timestamp # type
+% 26 # length
+[ 2008-03-04 08:00:00.000000 ]
+[ 2008-03-03 22:00:00.000000 ]
+[ 2008-03-03 12:00:00.000000 ]
+[ 2008-03-03 02:00:00.000000 ]
+[ 2008-03-02 16:00:00.000000 ]
+[ 2008-03-02 06: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))
+#where value = timestamp '2008-03-01 10:00' ;
+% . # table_name
+% value # name
+% timestamp # type
+% 26 # length
+[ 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))
+#where value < timestamp '2008-03-01 11:00' ;
+% . # table_name
+% value # name
+% timestamp # type
+% 26 # length
+[ 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))
+#where value > timestamp '2008-03-01 11:00'
+#and value < timestamp '2008-03-01 21:00';
+% . # table_name
+% value # name
+% timestamp # type
+% 26 # length
+[ 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))
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
@@ -17,6 +17,8 @@ select * from generate_series(timestamp
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';
+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';
+
-- negative range
select * from generate_series(timestamp '2008-03-04 18:00',timestamp
'2008-03-01 00:00',cast( '-10' as interval hour)) X;
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;
@@ -27,6 +29,8 @@ 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 where 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 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
