Changeset: 1784fc02c31c for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1784fc02c31c
Modified Files:
sql/benchmarks/nobench/Tests/nobench.sql
sql/benchmarks/nobench/Tests/nobench.stable.out
Branch: default
Log Message:
approved output (after fixing query)
diffs (26 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')) =
'GBRDA===';
+select * from bench10 where json.text(json.filter(js,'sparse_000')) =
'GBRDA===';
-- Q10 (replace XXXXX and YYYYY with literal integers):
-- MongoDB:
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
@@ -276,8 +276,8 @@ Ready.
% sys.bench10 # table_name
% js # name
% json # type
-% 0 # length
-[ 'value not yet known ' ]
+% 440 # length
+[ "{\"nested_obj\": {\"num\": 5, \"str\": \"GBRDCMBR\"}, \"sparse_008\":
\"GBRDA===\", \"sparse_009\": \"GBRDA===\", \"dyn2\": false, \"dyn1\":
\"GBRDA===\", \"nested_arr\": [], \"sparse_007\": \"GBRDA===\", \"str2\":
\"GBRDCMBR\", \"str1\": \"GBRDA===\", \"sparse_004\": \"GBRDA===\",
\"sparse_003\": \"GBRDA===\", \"sparse_002\": \"GBRDA===\", \"sparse_001\":
\"GBRDA===\", \"sparse_000\": \"GBRDA===\", \"num\": 0, \"bool\": false,
\"sparse_006\": \"GBRDA===\", \"thousandth\": 0, \"sparse_005\": \"GBRDA===\"}"
]
#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;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
