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

Reply via email to