Changeset: 5dfc73cd57a2 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5dfc73cd57a2 Modified Files: sql/test/BugTracker-2013/Tests/nested_concat_query.Bug-3408.sql sql/test/BugTracker-2013/Tests/nested_concat_query.Bug-3408.stable.out Branch: default Log Message:
fixed test and approved output diffs (44 lines): diff --git a/sql/test/BugTracker-2013/Tests/nested_concat_query.Bug-3408.sql b/sql/test/BugTracker-2013/Tests/nested_concat_query.Bug-3408.sql --- a/sql/test/BugTracker-2013/Tests/nested_concat_query.Bug-3408.sql +++ b/sql/test/BugTracker-2013/Tests/nested_concat_query.Bug-3408.sql @@ -2,6 +2,7 @@ declare datem integer; declare dateh integer; declare dated integer; declare stamp varchar(32); +select stamp; /* set datem = right(concat('00',cast(EXTRACT(MINUTE FROM localtimestamp()) as varchar(2))), 2); @@ -13,7 +14,7 @@ set datem = '12'; set dateh = '11'; set dated = '10'; -set stamp = concat(concat(concat(concat(concat('2013-11-', dated), ' '), dateh), ':'), datem), ':30.000000'); +set stamp = concat(concat(concat(concat(concat(concat('2013-11-', dated), ' '), dateh), ':'), datem), ':30.000000'); select stamp; diff --git a/sql/test/BugTracker-2013/Tests/nested_concat_query.Bug-3408.stable.out b/sql/test/BugTracker-2013/Tests/nested_concat_query.Bug-3408.stable.out --- a/sql/test/BugTracker-2013/Tests/nested_concat_query.Bug-3408.stable.out +++ b/sql/test/BugTracker-2013/Tests/nested_concat_query.Bug-3408.stable.out @@ -58,10 +58,16 @@ Ready. #declare dateh integer; #declare dated integer; #declare stamp varchar(32); -#set datem = right(concat('00',cast(EXTRACT(MINUTE FROM localtimestamp()) as varchar(2))), 2); -#set dateh = right(concat('00',cast(EXTRACT(HOUR FROM localtimestamp()) as varchar(2))), 2); -#set dated = right(concat('00',cast(EXTRACT(DAY FROM localtimestamp()) as varchar(2))), 2); -#set stamp = concat(concat(concat(concat(concat('2013-11-', dated), ' '), dateh), ':'), datem), ':30.000000'); +#select stamp; +% .L # table_name +% single_value # name +% varchar # type +% 0 # length +[ NULL ] +#set datem = '12'; +#set dateh = '11'; +#set dated = '10'; +#set stamp = concat(concat(concat(concat(concat(concat('2013-11-', dated), ' '), dateh), ':'), datem), ':30.000000'); #select stamp; % .L # table_name % single_value # name _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list