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
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to