Changeset: be502caa7906 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=be502caa7906
Modified Files:
sql/test/subquery/Tests/subquery3.sql
sql/test/subquery/Tests/subquery3.stable.out
Branch: default
Log Message:
Updated subquery3 test with right results
diffs (60 lines):
diff --git a/sql/test/subquery/Tests/subquery3.sql
b/sql/test/subquery/Tests/subquery3.sql
--- a/sql/test/subquery/Tests/subquery3.sql
+++ b/sql/test/subquery/Tests/subquery3.sql
@@ -431,17 +431,18 @@ SELECT
(SELECT outt FROM evilfunction((SELECT MIN(col1))))
FROM another_T;
-- 1
- -- 1
- -- 1
- -- 1
SELECT
- (SELECT outt FROM evilfunction((SELECT MAX(col1) FROM
tbl_ProductSales)))
-FROM another_T;
- -- 1111
- -- 1111
- -- 1111
- -- 1111
+ (SELECT outt FROM evilfunction((SELECT MAX(ColID) FROM
tbl_ProductSales)))
+FROM another_T;
+ -- 4
+ -- 4
+ -- 4
+ -- 4
+
+SELECT
+ (SELECT outt FROM evilfunction((SELECT MAX(t1.col1) FROM
tbl_ProductSales)))
+FROM another_T t1; --error, more than one row returned by a subquery used as
an expression
SELECT
(SELECT outt FROM evilfunction((SELECT MIN(t2.col1) FROM another_T
t2)))
diff --git a/sql/test/subquery/Tests/subquery3.stable.out
b/sql/test/subquery/Tests/subquery3.stable.out
--- a/sql/test/subquery/Tests/subquery3.stable.out
+++ b/sql/test/subquery/Tests/subquery3.stable.out
@@ -436,20 +436,17 @@ stdout of test 'subquery3` in directory
% int # type
% 1 # length
[ 1 ]
-[ 1 ]
-[ 1 ]
-[ 1 ]
#SELECT
# (SELECT outt FROM evilfunction((SELECT MAX(col1) FROM
tbl_ProductSales)))
#FROM another_T;
% .%4 # table_name
% %4 # name
% int # type
-% 4 # length
-[ 1111 ]
-[ 1111 ]
-[ 1111 ]
-[ 1111 ]
+% 1 # length
+[ 4 ]
+[ 4 ]
+[ 4 ]
+[ 4 ]
#SELECT
# (SELECT outt FROM evilfunction((SELECT MIN(t2.col1) FROM another_T
t2)))
#FROM another_T;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
