Changeset: bdff2217856f for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=bdff2217856f Modified Files: sql/test/BugTracker-2014/Tests/current_timestamp.Bug-3427.sql Branch: Jan2014 Log Message:
current_timestamp.Bug-3427: completed test: now() can be used for / assigned to both time & timestamp current_timestamp can be used for / assigned to both time & timestamp current_time can only be used for / assigned to time, but not to timestamp: "ERROR = !types timetz(7,0) and timestamp(7,0) are not equal" diffs (17 lines): diff --git a/sql/test/BugTracker-2014/Tests/current_timestamp.Bug-3427.sql b/sql/test/BugTracker-2014/Tests/current_timestamp.Bug-3427.sql --- a/sql/test/BugTracker-2014/Tests/current_timestamp.Bug-3427.sql +++ b/sql/test/BugTracker-2014/Tests/current_timestamp.Bug-3427.sql @@ -23,8 +23,13 @@ drop table x; declare t timestamp; declare tt time; set t = now(); +set t = current_timestamp; set t = current_time; set tt = now(); set tt = current_time; +set tt = current_timestamp; create table d(t timestamp default current_time, i integer); +drop table d; +create table d(t time default current_timestamp, i integer); +drop table d; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
