Changeset: b11251d2f28b for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b11251d2f28b
Modified Files:
sql/test/BugTracker-2016/Tests/groupby_on_column_expression.Bug-3832.stable.err
sql/test/BugTracker-2016/Tests/groupby_on_column_expression.Bug-3832.stable.out
Branch: default
Log Message:
approved output
diffs (48 lines):
diff --git
a/sql/test/BugTracker-2016/Tests/groupby_on_column_expression.Bug-3832.stable.err
b/sql/test/BugTracker-2016/Tests/groupby_on_column_expression.Bug-3832.stable.err
---
a/sql/test/BugTracker-2016/Tests/groupby_on_column_expression.Bug-3832.stable.err
+++
b/sql/test/BugTracker-2016/Tests/groupby_on_column_expression.Bug-3832.stable.err
@@ -29,6 +29,12 @@ stderr of test 'groupby_on_column_expres
# 15:59:52 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-2690" "--port=36841"
# 15:59:52 >
+MAPI = (monetdb) /var/tmp/mtest-30389/.s.monetdb.37867
+QUERY = SELECT LEFT("State", 3) AS "State", SUM("Sales") AS "Sales" FROM
test3832 GROUP BY LEFT("State", 3);
+ERROR = !syntax error, unexpected LEFT in: "select left("State", 3) as
"State", sum("Sales") as "Sales" from test3832 group"
+MAPI = (monetdb) /var/tmp/mtest-30389/.s.monetdb.37867
+QUERY = SELECT RTRIM(name) as nametrimmed, COUNT(*) as count, MAX(pos) as
max_pos, MIN(pos) as min_pos FROM fields GROUP BY RTRIM(name) ORDER BY
RTRIM(name);
+ERROR = !syntax error, unexpected '(', expecting SCOLON in: "select
rtrim(name) as nametrimmed, count(*) as count, max(pos) as max_pos, min(p"
# 15:59:52 >
diff --git
a/sql/test/BugTracker-2016/Tests/groupby_on_column_expression.Bug-3832.stable.out
b/sql/test/BugTracker-2016/Tests/groupby_on_column_expression.Bug-3832.stable.out
---
a/sql/test/BugTracker-2016/Tests/groupby_on_column_expression.Bug-3832.stable.out
+++
b/sql/test/BugTracker-2016/Tests/groupby_on_column_expression.Bug-3832.stable.out
@@ -77,12 +77,6 @@ Ready.
% 3, 24 # length
[ "Tex", 200 ]
[ "Tex", 250 ]
-#SELECT LEFT("State", 3) AS "State", SUM("Sales") AS "Sales" FROM test3832
GROUP BY LEFT("State", 3);
-% sys.L2, sys.L5 # table_name
-% State, Sales # name
-% varchar, double # type
-% 3, 24 # length
-[ "Tex", 450 ]
#SELECT LEFT("State", 3) AS "State3", SUM("Sales") AS "Sales" FROM test3832
GROUP BY "State3";
% sys.L2, sys.L5 # table_name
% State3, Sales # name
@@ -142,15 +136,6 @@ Ready.
[ "c3", 2, 3, 3 ]
[ "c4", 2, 4, 4 ]
[ "c4", 2, 4, 4 ]
-#SELECT RTRIM(name) as nametrimmed, COUNT(*) as count, MAX(pos) as max_pos,
MIN(pos) as min_pos FROM fields GROUP BY RTRIM(name) ORDER BY RTRIM(name);
-% sys.L2, sys.L5, sys.L10, sys.L13 # table_name
-% nametrimmed, count, max_pos, min_pos # name
-% varchar, bigint, int, int # type
-% 2, 1, 1, 1 # length
-[ "c1", 4, 1, 1 ]
-[ "c2", 4, 2, 2 ]
-[ "c3", 4, 3, 3 ]
-[ "c4", 4, 4, 4 ]
#SELECT RTRIM(name) as nametrimmed, COUNT(*) as count, MAX(pos) as max_pos,
MIN(pos) as min_pos FROM fields GROUP BY nametrimmed ORDER BY nametrimmed;
% sys.L2, sys.L5, sys.L10, sys.L13 # table_name
% nametrimmed, count, max_pos, min_pos # name
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
