Changeset: f7740ecc951c for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f7740ecc951c Added Files: sql/test/json/Tests/books.stable.err sql/test/json/Tests/books.stable.out Branch: default Log Message:
Approve test output diffs (149 lines): diff --git a/sql/test/json/Tests/books.stable.err b/sql/test/json/Tests/books.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/json/Tests/books.stable.err @@ -0,0 +1,35 @@ +stderr of test 'books` in directory 'sql/test/json` itself: + + +# 19:34:44 > +# 19:34:44 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=36709" "--set" "mapi_usock=/var/tmp/mtest-28375/.s.monetdb.36709" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/export/scratch1/mk/current//Linux/var/MonetDB/mTests_sql_test_json" "--set" "mal_listing=0" +# 19:34:44 > + +# builtin opt gdk_dbpath = /export/scratch1/mk/current//Linux/var/monetdb5/dbfarm/demo +# builtin opt gdk_debug = 0 +# builtin opt gdk_vmtrim = yes +# builtin opt monet_prompt = > +# builtin opt monet_daemon = no +# builtin opt mapi_port = 50000 +# builtin opt mapi_open = false +# builtin opt mapi_autosense = false +# builtin opt sql_optimizer = default_pipe +# builtin opt sql_debug = 0 +# cmdline opt gdk_nr_threads = 0 +# cmdline opt mapi_open = true +# cmdline opt mapi_port = 36709 +# cmdline opt mapi_usock = /var/tmp/mtest-28375/.s.monetdb.36709 +# cmdline opt monet_prompt = +# cmdline opt mal_listing = 2 +# cmdline opt gdk_dbpath = /export/scratch1/mk/current//Linux/var/MonetDB/mTests_sql_test_json +# cmdline opt mal_listing = 0 + +# 19:34:44 > +# 19:34:44 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-28375" "--port=36709" +# 19:34:44 > + + +# 19:34:44 > +# 19:34:44 > "Done." +# 19:34:44 > + diff --git a/sql/test/json/Tests/books.stable.out b/sql/test/json/Tests/books.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/json/Tests/books.stable.out @@ -0,0 +1,104 @@ +stdout of test 'books` in directory 'sql/test/json` itself: + + +# 19:34:44 > +# 19:34:44 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=36709" "--set" "mapi_usock=/var/tmp/mtest-28375/.s.monetdb.36709" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/export/scratch1/mk/current//Linux/var/MonetDB/mTests_sql_test_json" "--set" "mal_listing=0" +# 19:34:44 > + +# MonetDB 5 server v11.16.0 +# This is an unreleased version +# Serving database 'mTests_sql_test_json', using 8 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked +# Found 15.629 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2013 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://vienna.ins.cwi.nl:36709/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-28375/.s.monetdb.36709 +# MonetDB/GIS module loaded +# MonetDB/JAQL module loaded +# MonetDB/SQL module loaded + +Ready. + +# 19:34:44 > +# 19:34:44 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-28375" "--port=36709" +# 19:34:44 > + +#create table books(i integer, j json); +#insert into books values( 1, ' { "store": { +# "book": [ +# { "category": "reference", +# "author": "Nigel Rees", +# "title": "Sayings of the Century", +# "price": 8.95 +# }, +# { "category": "fiction", +# "author": "Evelyn Waugh", +# "title": "Sword of Honour", +# "price": 12.99 +# }, +# { "category": "fiction", +# "author": "Herman Melville", +# "title": "Moby Dick", +# "isbn": "0-553-21311-3", +# "price": 8.99 +# }, +# { "category": "fiction", +[ 1 ] +#select * from books; +% sys.books, sys.books # table_name +% i, j # name +% int, json # type +% 1, 716 # length +[ 1, " { \"store\": {\n \"book\": [ \n { \"category\": \"reference\",\n \"author\": \"Nigel Rees\",\n \"title\": \"Sayings of the Century\",\n \"price\": 8.95\n },\n { \"category\": \"fiction\",\n \"author\": \"Evelyn Waugh\",\n \"title\": \"Sword of Honour\",\n \"price\": 12.99\n },\n { \"category\": \"fiction\",\n \"author\": \"Herman Melville\",\n \"title\": \"Moby Dick\",\n \"isbn\": \"0-553-21311-3\",\n \"price\": 8.99\n },\n { \"category\": \"fiction\",\n \"author\": \"J. R. R. Tolkien\",\n \"title\": \"The Lord of the Rings\",\n \"isbn\": \"0-395-19395-8\",\n \"price\": 22.99\n }\n ],\n \"bicycle\": {\n \"color\": \"red\",\n \"price\": 19.95\n }\n }\n}" ] +#SELECT json_filter_all(j,'author') FROM ( +# SELECT json_filter(j,'book') AS j FROM ( +# SELECT json_filter(j,'store') AS j FROM books +# ) AS L1 +#) AS L2; +% sys.L # table_name +% json_filter_all_j # name +% json # type +% 66 # length +[ "[\"Nigel Rees\",\"Evelyn Waugh\",\"Herman Melville\",\"J. R. R. Tolkien\"]" ] +#SELECT json_filter(j,'author') FROM ( +# SELECT json_filter(j,'book') AS j FROM ( +# SELECT json_filter(j,'store') AS j FROM books +# ) AS L1 +#) AS L2; +% sys.L # table_name +% json_filter_j # name +% json # type +% 14 # length +[ "[\"Nigel Rees\"]" ] +#SELECT json_path(j,'..author') FROM books; +% sys.L # table_name +% json_path_j # name +% json # type +% 66 # length +[ "[\"Nigel Rees\",\"Evelyn Waugh\",\"Herman Melville\",\"J. R. R. Tolkien\"]" ] +#SELECT json_path(j,'store.book[*].author') FROM books; +% sys.L # table_name +% json_path_j # name +% json # type +% 66 # length +[ "[\"Nigel Rees\",\"Evelyn Waugh\",\"Herman Melville\",\"J. R. R. Tolkien\"]" ] +#SELECT json_path(j,'..bicycle.price') FROM books; +% sys.L # table_name +% json_path_j # name +% json # type +% 12 # length +[ "[19.95\n ]" ] +#SELECT json_path(j,'store.book.author[1]') FROM books; +% sys.L # table_name +% json_path_j # name +% json # type +% 16 # length +[ "[\"Evelyn Waugh\"]" ] +#drop table books; + +# 19:34:44 > +# 19:34:44 > "Done." +# 19:34:44 > + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
