Changeset: 69d8d0426874 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=69d8d0426874
Modified Files:
        sql/test/BugTracker-2012/Tests/scalar_subquery_with_alias.Bug-3093.sql
        
sql/test/BugTracker-2012/Tests/scalar_subquery_with_alias.Bug-3093.stable.out
Branch: default
Log Message:

Merge with Apr2019 branch.


diffs (83 lines):

diff --git 
a/sql/test/BugTracker-2012/Tests/scalar_subquery_with_alias.Bug-3093.sql 
b/sql/test/BugTracker-2012/Tests/scalar_subquery_with_alias.Bug-3093.sql
--- a/sql/test/BugTracker-2012/Tests/scalar_subquery_with_alias.Bug-3093.sql
+++ b/sql/test/BugTracker-2012/Tests/scalar_subquery_with_alias.Bug-3093.sql
@@ -10,6 +10,7 @@ SELECT (SELECT COUNT(id) AS cnt1
          WHERE a.id = b.id
        ) AS c2
   FROM test1 a
+  ORDER BY 1, 2
 ;
 
 SELECT (SELECT COUNT(id) AS cnt1 
@@ -20,6 +21,7 @@ SELECT (SELECT COUNT(id) AS cnt1
          WHERE a.id = b.id
        )
   FROM test1 a
+  ORDER BY 1, 2
 ;
 
 SELECT (SELECT COUNT(id) AS cnt1 
@@ -30,6 +32,7 @@ SELECT (SELECT COUNT(id) AS cnt1
          WHERE a.id = b.id
        ) AS c2
   FROM test1 a
+  ORDER BY 1, 2
 ;
 
 SELECT (SELECT COUNT(b.id) AS cnt2 
@@ -40,6 +43,7 @@ SELECT (SELECT COUNT(b.id) AS cnt2
           FROM test1 
        ) AS c1
   FROM test1 a
+  ORDER BY 1, 2
 ;
 
 SELECT (SELECT COUNT(id) AS cnt1 
@@ -50,6 +54,7 @@ SELECT (SELECT COUNT(id) AS cnt1
          WHERE a.id = b.id
        ) AS c2
   FROM test1 a
+  ORDER BY 1, 2
 ;
 
 DROP TABLE test1;
@@ -70,6 +75,7 @@ SELECT (SELECT COUNT(id) AS cnt1
          WHERE a.id = b.id
        ) AS c2
   FROM test1 a
+  ORDER BY 1, 2
 ;
 SELECT (SELECT COUNT(id) AS cnt1 
           FROM test1 
@@ -79,6 +85,7 @@ SELECT (SELECT COUNT(id) AS cnt1
          WHERE a.id = b.id
        )
   FROM test1 a
+  ORDER BY 1, 2
 ;
 
 SELECT (SELECT COUNT(id) AS cnt1 
@@ -89,6 +96,7 @@ SELECT (SELECT COUNT(id) AS cnt1
          WHERE a.id = b.id
        ) AS c2
   FROM test1 a
+  ORDER BY 1, 2
 ;
 
 SELECT (SELECT COUNT(b.id) AS cnt2 
@@ -99,6 +107,7 @@ SELECT (SELECT COUNT(b.id) AS cnt2
           FROM test1 
        ) AS c1
   FROM test1 a
+  ORDER BY 1, 2
 ;
 
 SELECT (SELECT COUNT(id) AS cnt1 
@@ -109,6 +118,7 @@ SELECT (SELECT COUNT(id) AS cnt1
          WHERE a.id = b.id
        ) AS c2
   FROM test1 a
+  ORDER BY 1, 2
 ;
 
 DROP TABLE test1;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to