[sql] Import SQLite 3.17.0.

third_party/sqlite/src/test/json103.test

 # 2015-12-30
 #
 # 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 42 matching lines @@
 
 do_execsql_test json103-210 {
   SELECT json_group_object(c,a) FROM t1
    WHERE rowid BETWEEN 31 AND 39 AND rowid%2==1;
 } {{{"n31":32.5,"n33":33,"n35":35,"n37":null,"n39":"orange"}}}
 do_execsql_test json103-220 {
   SELECT b, json_group_object(c,a) FROM t1
    WHERE rowid<7 GROUP BY b ORDER BY b;
 } {0 {{"n3":3,"n6":6}} 1 {{"n1":1,"n4":4}} 2 {{"n2":2,"n5":5}}}
 
-
+# ticket https://www.sqlite.org/src/info/f45ac567eaa9f93c 2016-01-30
+# Invalid JSON generated by json_group_array() 
+#
+# The underlying problem is a failure to reset Mem.eSubtype
+#
+do_execsql_test json103-300 {
+  DROP TABLE IF EXISTS t1;
+  CREATE TABLE t1(x);
+  INSERT INTO t1 VALUES(1),('abc');
+  SELECT
+     json_group_array(x),
+     json_group_array(json_object('x',x))
+    FROM t1;
+} {{[1,"abc"]} {[{"x":1},{"x":"abc"}]}}
 
 finish_test