Changeset: e07ac506cad2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e07ac506cad2 Modified Files: sql/test/subquery/Tests/subquery3.sql Branch: linear-hashing Log Message:
Cardinality mismatches with order by queries crashing the server :( I'm looking into them, maybe a cardinality check is missing. diffs (18 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 @@ -409,6 +409,14 @@ SELECT col1 FROM another_T WHERE (col2, SELECT col1 FROM another_T WHERE (col2, col3) IN (VALUES(1,2,3)); -- error, too many columns in the subquery +SELECT * FROM integers i1 ORDER BY SUM(i); --column "i1.i" must appear in the GROUP BY clause or be used in an aggregate function + +SELECT i FROM integers i1 ORDER BY SUM(i); --column "i1.i" must appear in the GROUP BY clause or be used in an aggregate function + +SELECT * FROM integers i1 ORDER BY (SELECT SUM(i1.i) FROM integers i2); --column "i1.i" must appear in the GROUP BY clause or be used in an aggregate function + +SELECT i FROM integers i1 ORDER BY (SELECT SUM(i1.i) FROM integers i2); --column "i1.i" must appear in the GROUP BY clause or be used in an aggregate function + CREATE FUNCTION evilfunction(input INT) RETURNS TABLE (outt INT) BEGIN RETURN TABLE(SELECT input); END; SELECT _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
