Changeset: 24ddecfd353c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=24ddecfd353c
Modified Files:
sql/test/miscellaneous/Tests/view-mul-digits.sql
sql/test/miscellaneous/Tests/view-mul-digits.stable.err
sql/test/miscellaneous/Tests/view-mul-digits.stable.out
Branch: Oct2020
Log Message:
No sums, no upcasting needed
diffs (114 lines):
diff --git a/sql/test/miscellaneous/Tests/view-mul-digits.sql
b/sql/test/miscellaneous/Tests/view-mul-digits.sql
--- a/sql/test/miscellaneous/Tests/view-mul-digits.sql
+++ b/sql/test/miscellaneous/Tests/view-mul-digits.sql
@@ -13,18 +13,18 @@ ROLLBACK;
create schema myschema;
create table myschema.mygroyp(code varchar(10),amount int);
insert into myschema.mygroyp(code,amount)values('a',1),('a',2),('b',3),('b',4);
-select code, cast(sum(amount) as bigint) as eind from myschema.mygroyp group
by code;
+select code, min(amount) as eind from myschema.mygroyp group by code;
-create view myschema.mygroypview as select code, cast(sum(amount) as bigint)
as eind from myschema.mygroyp group by code;
+create view myschema.mygroypview as select code, min(amount) as eind from
myschema.mygroyp group by code;
select * from myschema.mygroypview;
select code, eind from myschema.mygroypview;
select code from myschema.mygroypview;
select eind from myschema.mygroypview;
-select code, cast(sum(eind) as bigint) from myschema.mygroypview group by code;
+select code, min(eind) from myschema.mygroypview group by code;
-select code, cast(sum(eind) as bigint) from myschema.mygroypview;
+select code, min(eind) from myschema.mygroypview;
-- error, cannot use non GROUP BY column 'code' in query results
without an aggregate function
-create view myschema.ups as select code, sum(amount) as eind from
myschema.mygroyp;
+create view myschema.ups as select code, min(amount) as eind from
myschema.mygroyp;
-- error, cannot use non GROUP BY column 'code' in query results
without an aggregate function
create view myschema.ups as select code, amount as eind from myschema.mygroyp
group by code;
-- error, cannot use non GROUP BY column 'amount' in query results
without an aggregate function
diff --git a/sql/test/miscellaneous/Tests/view-mul-digits.stable.err
b/sql/test/miscellaneous/Tests/view-mul-digits.stable.err
--- a/sql/test/miscellaneous/Tests/view-mul-digits.stable.err
+++ b/sql/test/miscellaneous/Tests/view-mul-digits.stable.err
@@ -5,12 +5,12 @@ stderr of test 'view-mul-digits` in dire
# 09:17:14 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=38624" "--set"
"mapi_usock=/var/tmp/mtest-19962/.s.monetdb.38624" "--forcemito"
"--dbpath=/home/ferreira/repositories/MonetDB-Nov2019/BUILD/var/MonetDB/mTests_sql_test_miscellaneous"
"--set" "embedded_r=yes" "--set" "embedded_py=2" "--set" "embedded_c=true"
# 09:17:14 >
-MAPI = (monetdb) /var/tmp/mtest-225757/.s.monetdb.31408
-QUERY = select code, cast(sum(eind) as bigint) from myschema.mygroypview;
+MAPI = (monetdb) /var/tmp/mtest-82078/.s.monetdb.36080
+QUERY = select code, min(eind) from myschema.mygroypview;
ERROR = !SELECT: cannot use non GROUP BY column 'code' in query results
without an aggregate function
CODE = 42000
-MAPI = (monetdb) /var/tmp/mtest-226088/.s.monetdb.37888
-QUERY = create view myschema.ups as select code, sum(amount) as eind from
myschema.mygroyp;
+MAPI = (monetdb) /var/tmp/mtest-82078/.s.monetdb.36080
+QUERY = create view myschema.ups as select code, min(amount) as eind from
myschema.mygroyp;
ERROR = !SELECT: cannot use non GROUP BY column 'code' in query results
without an aggregate function
CODE = 42000
MAPI = (monetdb) /var/tmp/mtest-226088/.s.monetdb.37888
diff --git a/sql/test/miscellaneous/Tests/view-mul-digits.stable.out
b/sql/test/miscellaneous/Tests/view-mul-digits.stable.out
--- a/sql/test/miscellaneous/Tests/view-mul-digits.stable.out
+++ b/sql/test/miscellaneous/Tests/view-mul-digits.stable.out
@@ -81,25 +81,25 @@ stdout of test 'view-mul-digits` in dire
#select code, cast(sum(amount) as bigint) as eind from myschema.mygroyp group
by code;
% myschema.mygroyp, myschema. # table_name
% code, eind # name
-% varchar, bigint # type
+% varchar, int # type
% 1, 1 # length
-[ "a", 3 ]
-[ "b", 7 ]
-#create view myschema.mygroypview as select code, cast(sum(amount) as bigint)
as eind from myschema.mygroyp group by code;
+[ "a", 1 ]
+[ "b", 3 ]
+#create view myschema.mygroypview as select code, min(amount) as eind from
myschema.mygroyp group by code;
#select * from myschema.mygroypview;
% myschema.mygroypview, myschema.mygroypview # table_name
% code, eind # name
-% varchar, bigint # type
+% varchar, int # type
% 1, 1 # length
-[ "a", 3 ]
-[ "b", 7 ]
+[ "a", 1 ]
+[ "b", 3 ]
#select code, eind from myschema.mygroypview;
% myschema.mygroypview, myschema.mygroypview # table_name
% code, eind # name
-% varchar, bigint # type
+% varchar, int # type
% 1, 1 # length
-[ "a", 3 ]
-[ "b", 7 ]
+[ "a", 1 ]
+[ "b", 3 ]
#select code from myschema.mygroypview;
% myschema.mygroypview # table_name
% code # name
@@ -110,18 +110,18 @@ stdout of test 'view-mul-digits` in dire
#select eind from myschema.mygroypview;
% myschema.mygroypview # table_name
% eind # name
-% bigint # type
+% int # type
% 1 # length
+[ 1 ]
[ 3 ]
-[ 7 ]
-#select code, cast(sum(eind) as bigint) from myschema.mygroypview group by
code;
-% myschema.mygroypview, myschema.%3 # table_name
-% code, %3 # name
-% varchar, bigint # type
+#select code, min(eind) from myschema.mygroypview group by code;
+% myschema.mygroypview, myschema.%2 # table_name
+% code, %2 # name
+% varchar, int # type
% 1, 1 # length
-[ "a", 3 ]
-[ "b", 7 ]
-#ROLLBACK;
+[ "a", 1 ]
+[ "b", 3 ]
+#drop schema myschema cascade;
# 09:17:15 >
# 09:17:15 > "Done."
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
