Import SQLite 3.8.7.4.

third_party/sqlite/src/test/minmax2.test

 # 2007 July 17
 #
 # The author disclaims copyright to this source code.  In place of
 # a legal notice, here is a blessing:
 #
 #    May you do good and not evil.
 #    May you find forgiveness for yourself and forgive others.
 #    May you share freely, never taking more than you give.
 #
 #***********************************************************************
@@ skipping 271 matching lines @@
 # Ticket #658:  Test the min()/max() optimization when the FROM clause
 # is a subquery.
 #
 ifcapable {compound && subquery} {
   do_test minmax2-9.1 {
     execsql {
       SELECT max(rowid) FROM (
         SELECT max(rowid) FROM t4 UNION SELECT max(rowid) FROM t5
       )
     }
-  } {1}
+  } {{}}
   do_test minmax2-9.2 {
     execsql {
       SELECT max(rowid) FROM (
         SELECT max(rowid) FROM t4 EXCEPT SELECT max(rowid) FROM t5
       )
     }
   } {{}}
 } ;# ifcapable compound&&subquery
 
 # If there is a NULL in an aggregate max() or min(), ignore it.  An
@@ skipping 75 matching lines @@
   } {{} {}}
 }
 do_test minmax2-10.12 {
   execsql {
     SELECT min(x), max(x) FROM t6;
   }
 } {{} {}}
 
 
 finish_test