Changeset: e21bad0f10c1 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e21bad0f10c1
Added Files:
sql/test/BugTracker-2015/Tests/crash_timestamp_convert.Bug-3816.sql
sql/test/BugTracker-2015/Tests/timestamp_convert.Bug-3815.sql
Modified Files:
sql/test/BugTracker-2015/Tests/All
Branch: Jul2015
Log Message:
added tests for bug 3815 and bug 3816
diffs (28 lines):
diff --git a/sql/test/BugTracker-2015/Tests/All
b/sql/test/BugTracker-2015/Tests/All
--- a/sql/test/BugTracker-2015/Tests/All
+++ b/sql/test/BugTracker-2015/Tests/All
@@ -65,6 +65,8 @@ string_split.Bug-3564
not-like-without-wildcard.Bug-3811
copy_into.Bug-3813
select-tilde-arg.Bug-3814
+timestamp_convert.Bug-3815
+crash_timestamp_convert.Bug-3816
crash_in_reduce_groupby.Bug-3818
duplicate-constraint.Bug-3820
case_type.Bug-3821
diff --git
a/sql/test/BugTracker-2015/Tests/crash_timestamp_convert.Bug-3816.sql
b/sql/test/BugTracker-2015/Tests/crash_timestamp_convert.Bug-3816.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2015/Tests/crash_timestamp_convert.Bug-3816.sql
@@ -0,0 +1,1 @@
+SELECT timestamp_to_str(current_timestamp, '%Q');
diff --git a/sql/test/BugTracker-2015/Tests/timestamp_convert.Bug-3815.sql
b/sql/test/BugTracker-2015/Tests/timestamp_convert.Bug-3815.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2015/Tests/timestamp_convert.Bug-3815.sql
@@ -0,0 +1,5 @@
+SELECT CONVERT( CONVERT( (str_to_timestamp('2015-10-01', '%Y-%m-%d') -
str_to_timestamp('2015-09-30', '%Y-%m-%d')), BIGINT) /86400, BIGINT);
+
+SELECT CONVERT( (str_to_timestamp('2015-10-01', '%Y-%m-%d') -
str_to_timestamp('2015-09-30', '%Y-%m-%d'))/86400, BIGINT);
+
+SELECT (str_to_timestamp('2015-10-01', '%Y-%m-%d') -
str_to_timestamp('2015-09-30', '%Y-%m-%d'))/86400.0;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
