Changeset: 6965ede4a2bb for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6965ede4a2bb
Modified Files:
sql/test/json/Tests/shop.sql
sql/test/json/Tests/shop.stable.out
Branch: default
Log Message:
Approve output
diffs (35 lines):
diff --git a/sql/test/json/Tests/shop.sql b/sql/test/json/Tests/shop.sql
--- a/sql/test/json/Tests/shop.sql
+++ b/sql/test/json/Tests/shop.sql
@@ -43,9 +43,9 @@ SELECT json.text(json.filter(j,'book.aut
-- a single author from the book store
SELECT * FROM books
-WHERE json.text(json.filter(j,'book.author')) = 'Nigel Rise';
+WHERE json.text(json.filter(j,'book.author')) = 'Nigel Rees';
SELECT * FROM books
-WHERE json.text(json.filter(j,'..author')) = 'Nigel Rise';
+WHERE json.text(json.filter(j,'..author')) = 'Nigel Rees';
-- numeric calculations
SELECT * FROM books
diff --git a/sql/test/json/Tests/shop.stable.out
b/sql/test/json/Tests/shop.stable.out
--- a/sql/test/json/Tests/shop.stable.out
+++ b/sql/test/json/Tests/shop.stable.out
@@ -124,14 +124,14 @@ Ready.
% sys.books, sys.books # table_name
% i, j # name
% int, json # type
-% 1, 0 # length
+% 1, 155 # length
[ 1, " { \n \"book\": \n { \"category\": \"reference\",\n
\"author\": \"Nigel Rees\",\n \"title\": \"Sayings of the Century\",\n
\"price\": 8.95\n }}" ]
#SELECT * FROM books
#WHERE json.text(json.filter(j,'..author')) = 'Nigel Rise';
% sys.books, sys.books # table_name
% i, j # name
% int, json # type
-% 1, 0 # length
+% 1, 155 # length
[ 1, " { \n \"book\": \n { \"category\": \"reference\",\n
\"author\": \"Nigel Rees\",\n \"title\": \"Sayings of the Century\",\n
\"price\": 8.95\n }}" ]
#SELECT * FROM books
#WHERE json.number(json.filter(j,'book.price')) >= 12.99;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
