Changeset: b267a664e7b2 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b267a664e7b2 Added Files: sql/test/BugTracker-2014/Tests/current_timestamp.Bug-3427.sql Modified Files: sql/test/BugTracker-2014/Tests/All Branch: Jan2014 Log Message:
Added the test on current_timestamp conformity diffs (43 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 @@ -2,3 +2,4 @@ nested_common_table_exp.Bug-3417 query-crash.Bug-3418 groupby.Bug-3421 groupby_distict.Bug-3423 +current_timestamp.Bug-3427.sql diff --git a/sql/test/BugTracker-2014/Tests/current_timestamp.Bug-3427.sql b/sql/test/BugTracker-2014/Tests/current_timestamp.Bug-3427.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2014/Tests/current_timestamp.Bug-3427.sql @@ -0,0 +1,30 @@ +create table x( +i integer, +t timestamp, +tn timestamp default null, +td timestamp default now(), +tc timestamp default current_timestamp); + +insert into x(i,t) values(0,now()); +select * from x; +drop table x; + +create table x( +i integer, +t time, +tn time default null, +td time default now(), +tc time default current_time); + +insert into x(i,t) values(0,now()); +select * from x; +drop table x; + +declare t timestamp; +declare tt time; +set t = now(); +set t = current_time; +set tt = now(); +set tt = current_time; + +create table d(t timestamp default current_time, i integer); _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
