Changeset: f67870d9120b for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f67870d9120b Added Files: sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.sql Modified Files: sql/test/BugTracker-2014/Tests/All Branch: Oct2014 Log Message:
Add test for bug nil_2dec_lng.Bug-3592 diffs (17 lines): diff --git a/sql/test/BugTracker-2014/Tests/All b/sql/test/BugTracker-2014/Tests/All --- a/sql/test/BugTracker-2014/Tests/All +++ b/sql/test/BugTracker-2014/Tests/All @@ -42,3 +42,4 @@ round-sorted.Bug-3562 locate-offset.Bug-3563 aggr-with-limit.Bug-3498 sign-sorted.Bug-3594 +nil_2dec_lng.Bug-3592 diff --git a/sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.sql b/sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2014/Tests/nil_2dec_lng.Bug-3592.sql @@ -0,0 +1,4 @@ +create table foo_nil_2dec (t timestamp,v decimal(18,9)); +insert into foo_nil_2dec values (now(),42); +insert into foo_nil_2dec values (now(),43); +select (t-(select timestamp '1970-1-1')),v from foo_nil_2dec union all select (t-(select timestamp '1970-1-1')),null from foo_nil_2dec; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
