Changeset: b54c5dd74d34 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b54c5dd74d34
Modified Files:
sql/benchmarks/nobench/Tests/nobench.sql
sql/benchmarks/nobench/Tests/nobench.stable.err
sql/benchmarks/nobench/Tests/nobench.stable.out
Branch: default
Log Message:
Update the result
It still contains an error to be looked into in a more broader perspective.
diffs (116 lines):
diff --git a/sql/benchmarks/nobench/Tests/nobench.sql
b/sql/benchmarks/nobench/Tests/nobench.sql
--- a/sql/benchmarks/nobench/Tests/nobench.sql
+++ b/sql/benchmarks/nobench/Tests/nobench.sql
@@ -93,7 +93,7 @@ select * from bench10 where json.text(js
-- db["nobench_main"].find({ "sparse_XXX" : YYYYY })
-- Argo/SQL:
-- SELECT * FROM nobench_main WHERE sparse_XXX = YYYYY;
-select * from bench10 where json.text(json.filter(js,'parse_000')) =
'tobedefined';
+select * from bench10 where json.text(json.filter(js,'parse_000')) =
'GBRDA===';
-- Q10 (replace XXXXX and YYYYY with literal integers):
-- MongoDB:
diff --git a/sql/benchmarks/nobench/Tests/nobench.stable.err
b/sql/benchmarks/nobench/Tests/nobench.stable.err
--- a/sql/benchmarks/nobench/Tests/nobench.stable.err
+++ b/sql/benchmarks/nobench/Tests/nobench.stable.err
@@ -28,7 +28,7 @@ stderr of test 'nobench` in directory 's
# 13:08:13 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-28559" "--port=33349"
# 13:08:13 >
-MAPI = (monetdb) /var/tmp/mtest-24220/.s.monetdb.30760
+MAPI = (monetdb) /var/tmp/mtest-22468/.s.monetdb.30918
QUERY = select cast(json.text(json.filter(js,'dyn1')) as integer) from bench10;
ERROR = !conversion of string 'GBRDA===' to type int failed.
diff --git a/sql/benchmarks/nobench/Tests/nobench.stable.out
b/sql/benchmarks/nobench/Tests/nobench.stable.out
--- a/sql/benchmarks/nobench/Tests/nobench.stable.out
+++ b/sql/benchmarks/nobench/Tests/nobench.stable.out
@@ -108,6 +108,21 @@ Ready.
[ "[]" ]
[ "[\"GBRDA===\",\"GBRDA===\"]" ]
[ "[]" ]
+#select json.filter(js,'..sparse_000,..sparse_110') from bench10;
+% sys.L # table_name
+% filter_js # name
+% json # type
+% 12 # length
+[ "[]" ]
+[ "[]" ]
+[ "[]" ]
+[ "[]" ]
+[ "[]" ]
+[ "[]" ]
+[ "[]" ]
+[ "[]" ]
+[ "[\"GBRDA===\"]" ]
+[ "[]" ]
#select json.filter(js,'str1') from bench10;
% sys.L # table_name
% filter_js # name
@@ -228,21 +243,52 @@ Ready.
[ 2 ]
[ NULL ]
[ 6 ]
-#select json.text(json.filter(js,'dyn1')) from bench10;
+#select * from bench10 where json.number(json.filter(js,'dyn1')) between 0.0
and 3.0;
+% sys.bench10 # table_name
+% js # name
+% json # type
+% 465 # length
+[ "{\"nested_obj\": {\"num\": 8, \"str\": \"GBRDCMBQGA======\"},
\"sparse_035\": \"GBRDCMI=\", \"dyn2\": true, \"dyn1\": 3, \"nested_arr\":
[\"check\", \"it\", \"the\"], \"str2\": \"GBRDCMBQGA======\", \"str1\":
\"GBRDCMI=\", \"thousandth\": 3, \"sparse_036\": \"GBRDCMI=\", \"sparse_037\":
\"GBRDCMI=\", \"sparse_034\": \"GBRDCMI=\", \"num\": 3, \"bool\": true,
\"sparse_033\": \"GBRDCMI=\", \"sparse_030\": \"GBRDCMI=\", \"sparse_031\":
\"GBRDCMI=\", \"sparse_032\": \"GBRDCMI=\", \"sparse_038\": \"GBRDCMI=\",
\"sparse_039\": \"GBRDCMI=\"}" ]
+[ "{\"sparse_018\": \"GBRDC===\", \"nested_obj\": {\"num\": 6, \"str\":
\"GBRDCMJQ\"}, \"dyn2\": \"GBRDC===\", \"dyn1\": 1, \"nested_arr\":
[\"button-down\"], \"sparse_010\": \"GBRDC===\", \"str2\": \"GBRDCMJQ\",
\"str1\": \"GBRDC===\", \"sparse_013\": \"GBRDC===\", \"sparse_014\":
\"GBRDC===\", \"sparse_015\": \"GBRDC===\", \"sparse_016\": \"GBRDC===\",
\"sparse_017\": \"GBRDC===\", \"num\": 1, \"bool\": true, \"sparse_011\":
\"GBRDC===\", \"thousandth\": 1, \"sparse_019\": \"GBRDC===\", \"sparse_012\":
\"GBRDC===\"}" ]
+[ "{\"nested_obj\": {\"num\": 7, \"str\": \"GBRDCMJR\"}, \"dyn2\": 2,
\"dyn1\": 2, \"nested_arr\": [\"she\", \"beyond\"], \"str2\": \"GBRDCMJR\",
\"str1\": \"GBRDCMA=\", \"thousandth\": 2, \"sparse_025\": \"GBRDCMA=\",
\"sparse_024\": \"GBRDCMA=\", \"sparse_027\": \"GBRDCMA=\", \"num\": 2,
\"bool\": false, \"sparse_020\": \"GBRDCMA=\", \"sparse_023\": \"GBRDCMA=\",
\"sparse_022\": \"GBRDCMA=\", \"sparse_021\": \"GBRDCMA=\", \"sparse_029\":
\"GBRDCMA=\", \"sparse_028\": \"GBRDCMA=\", \"sparse_026\": \"GBRDCMA=\"}" ]
+#select json.filter(js,'nested_arr') from bench10;
% sys.L # table_name
-% text_filter_js # name
-% clob # type
-% 8 # length
-[ "9" ]
-[ "7" ]
-[ "8" ]
-[ "5" ]
-[ "3" ]
-[ "4" ]
-[ "1" ]
-[ "2" ]
-[ "GBRDA===" ]
-[ "6" ]
+% filter_js # name
+% json # type
+% 59 # length
+[ "[[\"especially\"]]" ]
+[ "[[\"its\", \"for\", \"if\", \"he\", \"questions\", \"to\", \"put\"]]"
]
+[ "[[]]" ]
+[ "[[\"the\", \"state\", \"aware\", \"''\", \"the\"]]" ]
+[ "[[\"check\", \"it\", \"the\"]]" ]
+[ "[[\"potatoes\", \"a\", \"to\", \"authentic\"]]" ]
+[ "[[\"button-down\"]]" ]
+[ "[[\"she\", \"beyond\"]]" ]
+[ "[[]]" ]
+[ "[[\"to\", \"interrupted\", \"some\", \"daily\", \"has\", \"averages\"]]"
]
+#select * from bench10 where json.text(json.filter(js,'nested_arr')) = 'check
it the';
+% sys.bench10 # table_name
+% js # name
+% json # type
+% 465 # length
+[ "{\"nested_obj\": {\"num\": 8, \"str\": \"GBRDCMBQGA======\"},
\"sparse_035\": \"GBRDCMI=\", \"dyn2\": true, \"dyn1\": 3, \"nested_arr\":
[\"check\", \"it\", \"the\"], \"str2\": \"GBRDCMBQGA======\", \"str1\":
\"GBRDCMI=\", \"thousandth\": 3, \"sparse_036\": \"GBRDCMI=\", \"sparse_037\":
\"GBRDCMI=\", \"sparse_034\": \"GBRDCMI=\", \"num\": 3, \"bool\": true,
\"sparse_033\": \"GBRDCMI=\", \"sparse_030\": \"GBRDCMI=\", \"sparse_031\":
\"GBRDCMI=\", \"sparse_032\": \"GBRDCMI=\", \"sparse_038\": \"GBRDCMI=\",
\"sparse_039\": \"GBRDCMI=\"}" ]
+#select * from bench10 where json.text(json.filter(js,'parse_000')) =
'GBRDA===';
+% sys.bench10 # table_name
+% js # name
+% json # type
+% 0 # length
+[ 'value not yet known ' ]
+#select f.h, count(*) from (
+# select json.filter(js,'..thousanth') as g,
json.number(json.filter(js,'num')) as h from bench10 where
json.number(json.filter(js,'num')) between 0.0 and 3.0 ) as f
+#group by f.h;
+% sys.f, sys.L1 # table_name
+% h, L1 # name
+% double, wrd # type
+% 24, 1 # length
+[ 3, 1 ]
+[ 1, 1 ]
+[ 2, 1 ]
+[ 0, 1 ]
#drop table bench10;
# 13:08:14 >
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
