Started by user Jim Borden [EnvInject] - Loading node environment variables. Building remotely on couchbase-lite-net-validation in workspace C:\UberJenkins\workspace\mobile-n1ql-test > C:\Program Files\Git\bin\git.exe rev-parse --is-inside-work-tree # timeout=10 Fetching changes from the remote Git repository > C:\Program Files\Git\bin\git.exe config remote.origin.url https://github.com/couchbaselabs/mobile-n1ql-tester # timeout=10 Fetching upstream changes from https://github.com/couchbaselabs/mobile-n1ql-tester > C:\Program Files\Git\bin\git.exe --version # timeout=10 > C:\Program Files\Git\bin\git.exe fetch --tags --force --progress https://github.com/couchbaselabs/mobile-n1ql-tester +refs/heads/*:refs/remotes/origin/* > C:\Program Files\Git\bin\git.exe rev-parse "refs/remotes/origin/main^{commit}" # timeout=10 > C:\Program Files\Git\bin\git.exe rev-parse "refs/remotes/origin/origin/main^{commit}" # timeout=10 Checking out Revision e009cc4844db05092daa3442397926b6918807c5 (refs/remotes/origin/main) > C:\Program Files\Git\bin\git.exe config core.sparsecheckout # timeout=10 > C:\Program Files\Git\bin\git.exe checkout -f e009cc4844db05092daa3442397926b6918807c5 Commit message: "Don't try to create scratch db if it already exists" > C:\Program Files\Git\bin\git.exe rev-list --no-walk e009cc4844db05092daa3442397926b6918807c5 # timeout=10 Set build name. New build name is 'LC d4d710b96e41c67e3b65aa7bcbdaae5b1bae4590' [mobile-n1ql-test] $ powershell.exe -NonInteractive -ExecutionPolicy ByPass "& 'C:\Users\ADMINI~1\AppData\Local\Temp\jenkins1500254925768997372.ps1'" Microsoft (R) Build Engine version 16.8.3+39993bd9d for .NET Copyright (C) Microsoft Corporation. All rights reserved. Determining projects to restore... All projects are up-to-date for restore. N1QLQueryHarness -> C:\UberJenkins\workspace\mobile-n1ql-test\N1QLQueryHarness\bin\Release\net5.0\N1QLQueryHarness.dll Build succeeded. 0 Warning(s) 0 Error(s) Time Elapsed 00:00:02.36 From https://github.com/couchbase/query * branch master -> FETCH_HEAD df4fa9a0..bb2bea20 master -> origin/master Updating df4fa9a0..bb2bea20 Fast-forward CMakeLists.txt | 2 +- build.sh | 2 +- datastore/couchbase/couchbase.go | 7 ++++- datastore/couchbase/dictionary_ee.go | 14 +++++++-- datastore/couchbase/system_keyspace_ee.go | 51 ++++++++++++++++--------------- datastore/privilege.go | 8 +++-- expression/func_advisor.go | 9 ++++++ go.mod | 4 +-- go.sum | 12 ++++---- parser/n1ql/n1ql.go | 44 ++++++++++++++++---------- parser/n1ql/n1ql.y | 15 ++++++--- plan/plan.go | 4 +++ plan/scan_distinct.go | 5 +++ plan/scan_index.go | 4 +++ plan/scan_index2.go | 4 +++ plan/scan_index3.go | 4 +++ plan/scan_index_count.go | 4 +++ plan/scan_index_count2.go | 4 +++ plan/scan_index_count_distinct.go | 4 +++ plan/scan_intersect.go | 5 +++ plan/scan_intersect_ord.go | 5 +++ plan/scan_primary.go | 4 +++ plan/scan_primary3.go | 4 +++ plan/scan_union.go | 17 +++++++++++ plan/search_ftsindex.go | 4 +++ planner/build_scan.go | 5 ++- planner/build_scan_or.go | 17 +++++++++-- planner/build_scan_secondary.go | 2 +- server/http/service_request.go | 35 ++------------------- server/request.go | 12 +------- test/bucket_create.sh | 2 +- 31 files changed, 203 insertions(+), 110 deletions(-) Downloading LiteCore (SHA d4d710b96e41c67e3b65aa7bcbdaae5b1bae4590)... Converting server query data... 2021-3-30 07:00:58.435-07:00 [8]| INFO) [Database] (Startup) [8] CouchbaseLite/2.8.4 (.NET; Microsoft Windows 10.0.19041) Build/8 LiteCore/2.8.4 (7) Commit/6f01e8d5 == Processed 723 queries, of which 258 were used == Running queries... {Thread #05} [PASS] select custId, count(*) as c from orders where test_id = "agg_func" group by custId order by c, custId {Thread #04} [PASS] SELECT DISTINCT custId FROM orders where test_id = "agg_func" ORDER BY custId {Thread #06} [FAIL] SELECT categories, ROUND(SUM(unitPrice), 2) AS totprice FROM product WHERE test_id = "agg_func" AND ANY reviewList IN reviewList SATISFIES reviewList LIKE "%0" END GROUP BY categories HAVING ROUND(SUM(unitPrice), 2) ORDER BY categories LIMIT 5 {Thread #06} Expected: {Thread #06} [ { "categories": [ "All Sports & Outdoors" ], "totprice": 809.77 }, { "categories": [ "Appliances" ], "totprice": 11502.98 }, { "categories": [ "Arts, Crafts & Sewing" ], "totprice": 2854.93 }, { "categories": [ "Baby" ], "totprice": 2677.96 }, { "categories": [ "Bedding & Bath" ], "totprice": 71.97 } ] {Thread #06} Actual: {Thread #06} [ { "categories": [ "Baby" ], "totprice": 2677.96 }, { "categories": [ "Golf" ], "totprice": 691.71 }, { "categories": [ "Cycling" ], "totprice": 6440.65 }, { "categories": [ "Luggage" ], "totprice": 2772.86 }, { "categories": [ "Watches" ], "totprice": 961.73 } ] {Thread #06} [PASS] SELECT product.categories CATG, COUNT(*) AS numprods FROM product WHERE test_id = "agg_func" GROUP BY product.categories HAVING COUNT(*) BETWEEN 15 and 30 ORDER BY CATG, numprods LIMIT 3 {Thread #05} [PASS] SELECT MIN(unitPrice) AS min, MAX(unitPrice) AS max, ROUND(AVG(unitPrice),5) AS avg, ROUND(SUM(unitPrice),5) AS sum, COUNT(unitPrice) AS count FROM product where test_id = "agg_func" ORDER BY min {Thread #06} [FAIL] SELECT product.categories AS CATG, COUNT (*) AS numprods FROM product WHERE test_id = "agg_func" GROUP BY product.categories ORDER BY CATG,numprods LIMIT 3 {Thread #06} Expected: {Thread #06} [ { "CATG": [ "All Sports & Outdoors" ], "numprods": 39 }, { "CATG": [ "Appliances" ], "numprods": 78 }, { "CATG": [ "Arts, Crafts & Sewing" ], "numprods": 37 } ] {Thread #06} Actual: {Thread #06} [ { "CATG": [ "Baby" ], "numprods": 9 }, { "CATG": [ "Golf" ], "numprods": 20 }, { "CATG": [ "Cycling" ], "numprods": 40 } ] {Thread #06} [FAIL] SELECT product.categories AS CATG, COUNT (*) AS numprods FROM product WHERE test_id = "agg_func" GROUP BY product.categories ORDER BY numprods,CATG LIMIT 3 {Thread #06} Expected: {Thread #06} [ { "CATG": [ "Exercise & Fitness" ], "numprods": 5 }, { "CATG": [ "Bedding & Bath" ], "numprods": 7 }, { "CATG": [ "Outdoor Recreation" ], "numprods": 7 } ] {Thread #06} Actual: {Thread #06} [ { "CATG": [ "Exercise & Fitness" ], "numprods": 5 }, { "CATG": [ "Watches" ], "numprods": 7 }, { "CATG": [ "Bedding & Bath" ], "numprods": 7 } ] {Thread #05} [PASS] SELECT color as product_color, MIN(unitPrice) AS min, MAX(unitPrice) AS max, ROUND(AVG(unitPrice),5) AS avg, ROUND(SUM(unitPrice),5) AS sum, COUNT(unitPrice) AS count FROM product where test_id = "agg_func" GROUP BY color ORDER BY min, avg limit 5 {Thread #05} [PASS] SELECT color as product_colori, MIN(unitPrice) AS min, MAX(unitPrice) AS max, ROUND(AVG(unitPrice),5) AS avg, ROUND(SUM(unitPrice),5) AS sum, COUNT(unitPrice) AS count FROM product where test_id = "agg_func" GROUP BY color HAVING count(unitPrice) > 34 ORDER BY min, avg {Thread #06} [PASS] SELECT array_Agg(id) from orders where test_id = "agg_func" {Thread #06} [FAIL] SELECT orderlines[1], count(*) AS count FROM orders where test_id = "agg_func" GROUP BY orderlines[1] ORDER BY count {Thread #06} Expected: {Thread #06} [ { "$1": { "productId": "tea111", "qty": 1 }, "count": 1 }, { "$1": { "productId": "sugar22", "qty": 1 }, "count": 3 } ] {Thread #06} Actual: {Thread #06} [ { "*": { "productId": "tea111", "qty": 1 }, "count": 1 }, { "*": { "productId": "sugar22", "qty": 1 }, "count": 3 } ] {Thread #06} [PASS] SELECT orderlines, count(*) AS count FROM orders where test_id = "agg_func" GROUP BY orderlines ORDER BY orderlines {Thread #06} [PASS] select orderlines as O, count(*) as count from orders where ANY ord IN orderlines SATISFIES ord.productId = "tea111" END AND test_id = "agg_func" GROUP BY orderlines HAVING ARRAY_LENGTH(orderlines) >=2 ORDER BY O {Thread #06} [PASS] SELECT customerId AS Cid , ccInfo.cardNumber AS CaNum , ccInfo.cardType AS CaTyp, firstName AS fnam FROM customer WHERE state = "CA" AND test_id="alias_func" ORDER BY CaNum, Cid LIMIT 3 {Thread #04} [PASS] select firstName, lastName FROM customer WHERE lastName = "Casper" AND test_id="alias_func" ORDER BY customerId {Thread #05} [PASS] SELECT firstName AS _1 FROM customer WHERE test_id="alias_func" ORDER BY _1, customerId limit 3 {Thread #04} [PASS] select lastName AS le_derniere_nom FROM customer WHERE lastName = "Casper" AND test_id="alias_func" ORDER BY le_derniere_nom {Thread #05} [PASS] SELECT customerId AS Cid, length(customerId) AS len FROM customer WHERE test_id="alias_func" ORDER BY len, Cid DESC limit 3 {Thread #04} [PASS] SELECT customer.firstName FROM customer WHERE lastName = "Casper" AND test_id="alias_func" {Thread #04} [PASS] SELECT customer.firstName AS explicit_name FROM customer WHERE lastName = "Casper" AND test_id="alias_func" {Thread #05} [PASS] SELECT customerId AS `$1`, ccInfo.cardType FROM customer WHERE test_id="alias_func" ORDER BY `$1` LIMIT 3 {Thread #04} [PASS] SELECT cust.firstName AS explicit_name FROM customer AS cust WHERE lastName = "Casper" AND test_id="alias_func" {Thread #05} [PASS] SELECT customerId AS `$2`, ccInfo.cardType FROM customer WHERE test_id="alias_func" ORDER BY customerId LIMIT 3 {Thread #04} [PASS] SELECT firstName FROM customer AS cust WHERE lastName = "Casper" AND test_id="alias_func" {Thread #04} [PASS] SELECT customer.firstName AS explicit_name FROM customer AS cust WHERE lastName = "Casper" AND test_id="alias_func" {Thread #05} [PASS] SELECT customerId AS `$A`, customerId AS `A$`, customerId AS `_A`, customerId AS `A_` FROM customer WHERE test_id="alias_func" ORDER BY customerId limit 3 {Thread #04} [PASS] SELECT ccInfo, firstName FROM customer WHERE lastName="Casper" AND test_id="alias_func" {Thread #04} [PASS] SELECT ccInfo.cardExpiry FROM customer WHERE lastName = "Casper" AND test_id="alias_func" {Thread #05} [PASS] SELECT ccInfo.cardExpiry AS exp, state AS _state, firstName AS fname FROM customer WHERE test_id="alias_func" ORDER BY fname DESC, exp LIMIT 3 {Thread #05} [PASS] SELECT C.customerId AS Cid, C.emailAddress AS _email, C.lastName AS L FROM customer AS C WHERE test_id="alias_func" ORDER BY emailAddress, Cid limit 3 {Thread #05} [PASS] SELECT customerId from purchase WHERE ANY buy IN purchase.lineItems SATISFIES buy.product="product85" END AND test_id="any_func" ORDER BY customerId, lineItems.count LIMIT 2 {Thread #04} [PASS] SELECT customerId from purchase WHERE EVERY buy IN purchase.lineItems SATISFIES buy.product="product85" END AND test_id="any_func" ORDER BY customerId, lineItems.count LIMIT 2 {Thread #06} [PASS] SELECT customerId from purchase WHERE EVERY buy IN purchase.lineItems SATISFIES buy.product="product85" AND buy.count =2 END AND test_id="any_func" ORDER BY customerId, lineItems.count LIMIT 2 {Thread #05} [PASS] SELECT customerId from purchase WHERE ANY buy IN purchase.lineItems SATISFIES buy.product="product85" AND buy.count =2 END AND test_id="any_func" ORDER BY customerId, lineItems.count LIMIT 2 {Thread #05} [PASS] SELECT customerId from purchase WHERE ANY buy IN purchase.lineItems SATISFIES buy.product="product85" AND buy.count =2 AND customerId= "customer187" END AND test_id="any_func" ORDER BY customerId, lineItems.count LIMIT 2 {Thread #06} [PASS] SELECT customerId from purchase WHERE EVERY buy IN purchase.lineItems SATISFIES buy.product="product85" AND buy.count =2 AND customerId= "customer187" END AND test_id="any_func" ORDER BY customerId, lineItems.count LIMIT 2 {Thread #04} [PASS] SELECT purchaseId FROM purchase WHERE ANY buy IN purchase.lineItems SATISFIES buy.count>4 END AND test_id="any_func" ORDER BY purchaseId limit 3 {Thread #06} [PASS] SELECT purchaseId FROM purchase WHERE EVERY buy IN purchase.lineItems SATISFIES buy.count>4 END AND test_id="any_func" ORDER BY purchaseId limit 3 {Thread #07} [PASS] SELECT purchaseId from purchase WHERE lineItems[0].product = "product32" AND ANY sale IN purchase.lineItems SATISFIES sale.count > 4 END AND test_id="any_func" ORDER BY purchaseId {Thread #06} [PASS] SELECT purchaseId from purchase WHERE lineItems[0].product = "product32" AND EVERY sale IN purchase.lineItems SATISFIES sale.count > 4 END AND test_id="any_func" ORDER BY purchaseId {Thread #07} [PASS] SELECT purchaseId FROM purchase WHERE ANY sale in purchase.lineItems satisfies sale.count > 4 END AND test_id="any_func" ORDER BY purchaseId LIMIT 5 {Thread #06} [PASS] SELECT purchaseId FROM purchase WHERE EVERY sale in purchase.lineItems satisfies sale.count > 4 END AND test_id="any_func" ORDER BY purchaseId LIMIT 5 {Thread #04} [PASS] SELECT purchaseId, customerId FROM purchase WHERE ANY sale IN purchase.lineItems SATISFIES sale.product < purchase.purchaseId END AND test_id="any_func" ORDER BY purchaseId LIMIT 3 {Thread #06} [PASS] SELECT purchaseId, customerId FROM purchase WHERE EVERY sale IN purchase.lineItems SATISFIES sale.product < purchase.purchaseId END AND test_id="any_func" ORDER BY purchaseId LIMIT 3 {Thread #06} [FAIL] SELECT CASE WHEN 1+1=3 THEN 7+7 WHEN 2+2=5 THEN 8+8 END FROM scratch {Thread #06} Expected: {Thread #06} [ { "$1": null } ] {Thread #06} Actual: {Thread #06} [ {} ] {Thread #06} [PASS] SELECT CASE WHEN 1+1=3 THEN 7+7 WHEN 2+2=5 THEN 8+8 ELSE 9+9 END FROM scratch {Thread #06} [PASS] SELECT CASE WHEN 1+1=3 THEN 7+7 WHEN 2+2=4 THEN 8+8 ELSE 9+9 END FROM scratch {Thread #06} [PASS] SELECT CASE WHEN 1+1=2 THEN 7+7 WHEN 2+2=4 THEN 8+8 ELSE 9+9 END FROM scratch {Thread #06} Failed to create query for 'SELECT CASE WHEN `shipped-on` IS NOT MISSING THEN `shipped-on` ELSE "not-shipped-yet" END AS shipped FROM orders WHERE test_id="case_func" ORDER BY shipped'... {Thread #06} ...LiteCore InvalidQuery, "operation must be a string" {Thread #06} [PASS] SELECT GREATEST(rating,3) as gr FROM review WHERE test_id="comp_func" ORDER BY customerId, productId LIMIT 4 {Thread #07} [PASS] SELECT GREATEST(rating, 2) as gr FROM review WHERE test_id="comp_func" ORDER BY customerId, productId LIMIT 4 {Thread #04} [PASS] SELECT LEAST(rating,3) as gr FROM review WHERE test_id="comp_func" ORDER BY customerId, productId LIMIT 4 {Thread #04} [PASS] SELECT LEAST(rating, 2) as gr FROM review WHERE test_id="comp_func" ORDER BY customerId, productId LIMIT 4 {Thread #04} [PASS] select GREATEST(customerId,"customer3") AS gr from review WHERE test_id="comp_func" ORDER by productId,customerId LIMIT 4 {Thread #04} [PASS] select LEAST(customerId,"customer3") AS gr from review WHERE test_id="comp_func" ORDER by productId,customerId LIMIT 4 {Thread #04} [PASS] select LEAST("Yes" , 99) AS A FROM scratch {Thread #04} [PASS] select GREATEST ("Yes" , 99) AS A FROM scratch {Thread #04} Failed to create query for 'select `between`(10,5,15),`between`(10,15,25) FROM scratch'... {Thread #04} ...LiteCore InvalidQuery, "N1QL syntax error near character 17" {Thread #04} ...elect `between`(10,5,15),`betw... {Thread #04} ^ {Thread #04} [PASS] SELECT IFMISSING(`shipped-on`,"MISSING") as mis FROM orders WHERE test_id="cond_unkn_func" ORDER BY mis {Thread #04} [PASS] SELECT IFNULL(`shipped-on`,"NULL") as nu FROM orders WHERE test_id="cond_unkn_func" ORDER BY nu {Thread #04} [PASS] SELECT IFMISSINGORNULL(`shipped-on`,"NOT THERE") as m_or_n FROM orders WHERE test_id="cond_unkn_func" ORDER BY m_or_n {Thread #04} [PASS] SELECT NULLIF(orderlines[0].qty, 2) as n_if FROM orders WHERE test_id="cond_unkn_func" ORDER BY n_if {Thread #04} [PASS] SELECT NULLIF(orderlines[0].qty , 1) as n_if FROM orders WHERE id>"1235" AND test_id="cond_unkn_func" ORDER BY n_if {Thread #04} [PASS] SELECT MISSINGIF(orderlines[0].qty , 1) as n_if FROM orders WHERE id>"1235" AND test_id="cond_unkn_func" ORDER BY n_if {Thread #04} [PASS] SELECT MISSINGIF(orderlines[0].qty, 2) as n_if FROM orders WHERE test_id="cond_unkn_func" ORDER BY n_if {Thread #05} [PASS] SELECT MISSINGIF(null,"n1ql") FROM scratch {Thread #05} [PASS] SELECT MISSINGIF(missing,"n1ql") FROM scratch {Thread #05} [PASS] SELECT MISSINGIF(12,"n1ql") FROM scratch {Thread #05} [PASS] SELECT NULLIF(null,"n1ql") FROM scratch {Thread #05} [PASS] SELECT NULLIF(missing,"n1ql") FROM scratch {Thread #05} [PASS] SELECT NULLIF(12,"n1ql") FROM scratch {Thread #05} [PASS] select STR_TO_MILLIS("2015-01-01T16:00:00-08:00") FROM scratch {Thread #05} [PASS] select STR_TO_UTC("2006-01-02T15:04:05Z") FROM scratch {Thread #05} [PASS] select `shipped-on` as a from orders where test_id = "datefunc" order by a {Thread #05} [PASS] select str_to_utc(millis_to_str(1463284740000)) FROM scratch {Thread #05} [PASS] select str_to_millis('2016-12-03T08:00:00Z'), str_to_millis('2015-12-03T08:00:00Z') FROM scratch {Thread #05} [PASS] SELECT ord.orderlines[0] AS ol FROM orders AS ord WHERE test_id="from_func" ORDER BY ol, id {Thread #05} [PASS] select orderlines[0].productId AS productId from orders AS olz WHERE test_id="from_func" order by productId {Thread #05} [PASS] select orderlines[0].productId as pId from orders where orderlines[0].productId = "tea111" AND test_id="from_func" order by pId {Thread #05} [PASS] SELECT orderlines[0] olz FROM orders WHERE orderlines[0].qty > 1 AND test_id="from_func" ORDER BY olz.qty {Thread #05} [PASS] SELECT orderlines[0].hello AS hello FROM orders olz WHERE test_id="from_func" ORDER BY hello {Thread #05} [PASS] SELECT orderlines[1].productId AS pId1s FROM orders WHERE test_id="from_func" ORDER BY pId1s, id {Thread #05} [PASS] SELECT woot.custId, woot.id FROM orders AS woot WHERE test_id="from_func" ORDER BY woot.custId {Thread #05} [PASS] select 9223372036854775807, -9223372036854775807 FROM scratch {Thread #05} [PASS] select big, little from orders where test_id="select_big_int" and type="value" {Thread #05} [PASS] select big from orders where test_id="select_big_int" and type="value" {Thread #05} [PASS] select little from orders where test_id="select_big_int" and type="value" {Thread #05} [PASS] select sum(num) as total, type from orders where test_id="select_big_int" and type="aggr" group by type {Thread #05} [PASS] select count(1) as total from orders where test_id="select_big_int" and num > 90 {Thread #04} [PASS] SELECT META(customer).id AS metadata FROM customer WHERE test_id="meta_func" ORDER BY metadata limit 5 {Thread #06} [PASS] SELECT 1+1 AS result FROM scratch {Thread #06} [PASS] SELECT 1-1 AS result FROM scratch {Thread #06} [PASS] SELECT 2*3 AS result FROM scratch {Thread #06} [PASS] SELECT 10/2 AS result FROM scratch {Thread #06} [PASS] SELECT 25%5 AS result FROM scratch {Thread #06} [PASS] SELECT "hello" || " " || "world" AS result FROM scratch {Thread #06} [PASS] SELECT -3 AS result FROM scratch {Thread #06} [FAIL] SELECT 1/0 AS result FROM scratch {Thread #06} Expected: {Thread #06} [ { "result": null } ] {Thread #06} Actual: {Thread #06} [ {} ] {Thread #06} [FAIL] SELECT -1/0 AS result FROM scratch {Thread #06} Expected: {Thread #06} [ { "result": null } ] {Thread #06} Actual: {Thread #06} [ {} ] {Thread #06} [FAIL] SELECT 0/0 AS result FROM scratch {Thread #06} Expected: {Thread #06} [ { "result": null } ] {Thread #06} Actual: {Thread #06} [ {} ] {Thread #04} [PASS] select abs(-4.599) FROM scratch {Thread #04} [PASS] select abs(0.0) FROM scratch {Thread #04} [PASS] select acos(1.0) FROM scratch {Thread #04} [PASS] select acos(-1.0) FROM scratch {Thread #04} [FAIL] select acos(3) FROM scratch {Thread #04} Expected: {Thread #04} [ { "$1": "NaN" } ] {Thread #04} Actual: {Thread #04} [ {} ] {Thread #04} [FAIL] SELECT atan(unitPrice/10) as uP FROM product where test_id = "numberfunc" ORDER BY uP ASC limit 20 {Thread #04} Expected: {Thread #04} [ { "uP": 0.06889080874642887 }, { "uP": 0.14007658329218683 }, { "uP": 0.14007658329218683 }, { "uP": 0.14399642170889201 }, { "uP": 0.2345992293193999 }, { "uP": 0.2487398113528484 }, { "uP": 0.26743628138366415 }, { "uP": 0.2868633495226784 }, { "uP": 0.2868633495226784 }, { "uP": 0.33578367316270535 }, { "uP": 0.3464405674298596 }, { "uP": 0.3464405674298596 }, { "uP": 0.349092133951802 }, { "uP": 0.349092133951802 }, { "uP": 0.3543799191234378 }, { "uP": 0.37098779993526965 }, { "uP": 0.37359085803573183 }, { "uP": 0.3796440109929201 }, { "uP": 0.3796440109929201 }, { "uP": 0.3796440109929201 } ] {Thread #04} Actual: {Thread #04} [ { "uP": 0.0 }, { "uP": 0.0 }, { "uP": 0.06889080874642887 }, { "uP": 0.14007658329218683 }, { "uP": 0.14007658329218683 }, { "uP": 0.14399642170889201 }, { "uP": 0.2345992293193999 }, { "uP": 0.2487398113528484 }, { "uP": 0.26743628138366415 }, { "uP": 0.2868633495226784 }, { "uP": 0.2868633495226784 }, { "uP": 0.33578367316270535 }, { "uP": 0.3464405674298596 }, { "uP": 0.3464405674298596 }, { "uP": 0.349092133951802 }, { "uP": 0.349092133951802 }, { "uP": 0.3543799191234378 }, { "uP": 0.37098779993526965 }, { "uP": 0.37359085803573183 }, { "uP": 0.3796440109929201 } ] {Thread #06} [FAIL] SELECT atan2(unitPrice,10) as uP FROM product where test_id = "numberfunc" ORDER BY uP DESC limit 20 {Thread #06} Expected: {Thread #06} [ { "uP": 1.5664485092008225 }, { "uP": 1.56412531167943 }, { "uP": 1.5627964334585938 }, { "uP": 1.5616596550701336 }, { "uP": 1.5616596550701336 }, { "uP": 1.5595921883125596 }, { "uP": 1.5587630684753162 }, { "uP": 1.5582968215479926 }, { "uP": 1.5576391913221408 }, { "uP": 1.5565115842075 }, { "uP": 1.5541309253756899 }, { "uP": 1.5541309253756899 }, { "uP": 1.5541033866692802 }, { "uP": 1.5517146736035938 }, { "uP": 1.5508933080412368 }, { "uP": 1.5507985929736883 }, { "uP": 1.5506536012522596 }, { "uP": 1.5497817449111084 }, { "uP": 1.5491990805519646 }, { "uP": 1.5485282932515472 } ] {Thread #06} Actual: {Thread #06} [ { "uP": 1.5019055180484677 }, { "uP": 1.4307197435027097 }, { "uP": 1.4307197435027097 }, { "uP": 1.4267999050860045 }, { "uP": 1.3361970974754966 }, { "uP": 1.3220565154420483 }, { "uP": 1.3033600454112324 }, { "uP": 1.2839329772722183 }, { "uP": 1.2839329772722183 }, { "uP": 1.2350126536321913 }, { "uP": 1.224355759365037 }, { "uP": 1.224355759365037 }, { "uP": 1.2217041928430945 }, { "uP": 1.2217041928430945 }, { "uP": 1.2164164076714588 }, { "uP": 1.199808526859627 }, { "uP": 1.197205468759165 }, { "uP": 1.1911523158019766 }, { "uP": 1.1911523158019766 }, { "uP": 1.1911523158019766 } ] {Thread #08} [PASS] select cos(PI()/2) FROM scratch {Thread #08} [PASS] select cos(PI()) FROM scratch {Thread #08} [PASS] select sin(PI()/2) FROM scratch {Thread #08} [PASS] select sin(PI()) FROM scratch {Thread #08} [PASS] select tan(PI()/2) FROM scratch {Thread #08} [PASS] select tan(PI()) FROM scratch {Thread #08} [FAIL] SELECT tan(unitPrice/100) as UP FROM product where test_id = "numberfunc" AND tan(unitPrice/100) > 2 ORDER BY UP limit 10 {Thread #08} Expected: {Thread #08} [ { "UP": 2.0138325604867267 }, { "UP": 2.0492077751446085 }, { "UP": 2.11975014418718 }, { "UP": 2.1718671324329257 }, { "UP": 2.1718671324329257 }, { "UP": 2.224986052180472 }, { "UP": 2.442509351723311 }, { "UP": 2.442509351723311 }, { "UP": 2.569868594555587 }, { "UP": 2.571390221570827 } ] {Thread #08} Actual: {Thread #08} [ { "UP": 2.0138325604867267 }, { "UP": 2.0492077751446085 }, { "UP": 2.1718671324329257 }, { "UP": 2.1718671324329257 }, { "UP": 2.4425093517233107 }, { "UP": 2.4425093517233107 }, { "UP": 2.5698685945555866 }, { "UP": 2.5713902215708275 }, { "UP": 2.5713902215708275 }, { "UP": 2.5713902215708275 } ] {Thread #08} [PASS] SELECT cos(unitPrice) as sc FROM product where test_id = "numberfunc" ORDER BY sc limit 5 {Thread #08} [PASS] SELECT sin(unitPrice) as sc FROM product where test_id = "numberfunc" ORDER BY sc limit 5 {Thread #08} [PASS] select ceil(1.4) FROM scratch {Thread #08} [PASS] SELECT CEIL(unitPrice+0.5) as sc FROM product where test_id = "numberfunc" ORDER BY sc desc limit 10 {Thread #08} [PASS] select PI() FROM scratch {Thread #08} [PASS] select E() FROM scratch {Thread #08} [PASS] select POWER(E(),2) FROM scratch {Thread #08} [PASS] select LN(POWER(E(),2)) FROM scratch {Thread #08} [PASS] select EXP(2) FROM scratch {Thread #08} [PASS] select LN(EXP(2)) FROM scratch {Thread #08} [PASS] select LOG(EXP(10)) FROM scratch {Thread #08} [PASS] select LOG(POWER(10,34)) FROM scratch {Thread #08} [PASS] select DEGREES(PI()) FROM scratch {Thread #08} [PASS] select DEGREES(PI()/2) FROM scratch {Thread #08} [PASS] select DEGREES(-PI()/2) FROM scratch {Thread #08} [PASS] select RADIANS(90) FROM scratch {Thread #08} [PASS] select RADIANS(-180) FROM scratch {Thread #08} [PASS] select RADIANS(PI()) FROM scratch {Thread #08} [PASS] SELECT FLOOR(unitPrice+0.5) as sc FROM product where test_id = "numberfunc" ORDER BY sc limit 5 {Thread #08} [PASS] select floor(1.7) FROM scratch {Thread #08} [PASS] select POWER(12,2) FROM scratch {Thread #08} [PASS] SELECT power(unitPrice,2) as sc FROM product where test_id = "numberfunc" ORDER BY sc desc limit 10 {Thread #08} [PASS] SELECT power(unitPrice,2) as sc FROM product where test_id = "numberfunc" ORDER BY sc asc limit 10 {Thread #04} [FAIL] SELECT ROUND(12+0.5) as rnd FROM scratch {Thread #04} Expected: {Thread #04} [ { "rnd": 12 } ] {Thread #04} Actual: {Thread #04} [ { "rnd": 13.0 } ] {Thread #04} [PASS] select round(1.2343534) FROM scratch {Thread #04} [PASS] select round(1.8343534) FROM scratch {Thread #04} [PASS] select round(1.8343534,0) FROM scratch {Thread #04} [PASS] select round(1.8343534,3) FROM scratch {Thread #04} [PASS] select round(8.8343534,-1) FROM scratch {Thread #04} [PASS] select round(1.8343534,-1) FROM scratch {Thread #04} [PASS] select sign(-1034.992445) FROM scratch {Thread #04} [PASS] select sign(1034.992445) FROM scratch {Thread #04} [PASS] select sign(0.292445) FROM scratch {Thread #04} [PASS] select sign(0.0000111) FROM scratch {Thread #04} [PASS] select sign(0.0) FROM scratch {Thread #04} [PASS] SELECT TRUNC(unitPrice+0.5) as trun FROM product where test_id = "numberfunc" ORDER BY trun limit 5 {Thread #08} [PASS] select sqrt(unitPrice) as sq FROM product where test_id = "numberfunc" ORDER BY sq desc limit 10 {Thread #08} [PASS] select sqrt(0) FROM scratch {Thread #08} [FAIL] select sqrt(-1) FROM scratch {Thread #08} Expected: {Thread #08} [ { "$1": "NaN" } ] {Thread #08} Actual: {Thread #08} [ {} ] {Thread #08} [PASS] select trunc(-2.2544,2) FROM scratch {Thread #08} [PASS] select trunc(0.2544,3) FROM scratch {Thread #08} [PASS] select cos(unitPrice) as sc from product where sc > 1 limit 1 {Thread #07} [FAIL] SELECT orderlines[0] FROM orders WHERE test_id="order_func" ORDER BY orderlines[0].productId, orderlines[0].qty ASC LIMIT 10 OFFSET 2 {Thread #07} Expected: {Thread #07} [ { "$1": { "productId": "coffee01", "qty": 2 } }, { "$1": { "productId": "tea111", "qty": 1 } } ] {Thread #07} Actual: {Thread #07} [ { "*": { "productId": "coffee01", "qty": 2 } }, { "*": { "productId": "tea111", "qty": 1 } } ] {Thread #06} [PASS] SELECT id, (orderlines[0].qty + orderlines[1].qty) AS totquant FROM orders WHERE test_id="order_func" ORDER BY totquant, id {Thread #07} [FAIL] SELECT orderlines[0] FROM orders WHERE test_id="order_func" ORDER BY orderlines[0].productId, orderlines[0].qty DESC LIMIT 10 OFFSET 2 {Thread #07} Expected: {Thread #07} [ { "$1": { "productId": "coffee01", "qty": 1 } }, { "$1": { "productId": "tea111", "qty": 1 } } ] {Thread #07} Actual: {Thread #07} [ { "*": { "productId": "coffee01", "qty": 1 } }, { "*": { "productId": "tea111", "qty": 1 } } ] {Thread #07} [FAIL] SELECT orderlines[0] FROM orders WHERE test_id="order_func" ORDER BY orderlines[0].productId, orderlines[0].qty ASC LIMIT 10 {Thread #07} Expected: {Thread #07} [ { "$1": { "productId": "coffee01", "qty": 1 } }, { "$1": { "productId": "coffee01", "qty": 1 } }, { "$1": { "productId": "coffee01", "qty": 2 } }, { "$1": { "productId": "tea111", "qty": 1 } } ] {Thread #07} Actual: {Thread #07} [ { "*": { "productId": "coffee01", "qty": 1 } }, { "*": { "productId": "coffee01", "qty": 1 } }, { "*": { "productId": "coffee01", "qty": 2 } }, { "*": { "productId": "tea111", "qty": 1 } } ] {Thread #07} [PASS] SELECT orderlines[0] FROM orders WHERE test_id="order_func" ORDER BY orderlines[0].productId, orderlines[0].qty ASC LIMIT 0 OFFSET 2 {Thread #07} [PASS] SELECT orderlines[0] FROM orders WHERE test_id="order_func" ORDER BY orderlines[0].productId, orderlines[0].qty DESC LIMIT 0 {Thread #06} [PASS] SELECT id, (orderlines[0].qty + orderlines[1].qty) FROM orders WHERE test_id="order_func" ORDER BY totquant, id {Thread #07} [PASS] SELECT orderlines[0] FROM orders WHERE test_id="order_func" ORDER BY orderlines[0].productId, orderlines[0].qty ASC LIMIT 0 OFFSET 0 {Thread #07} [PASS] SELECT orderlines[0] FROM orders WHERE test_id="order_func" ORDER BY orderlines[0].productId, orderlines[0].qty ASC LIMIT -1 OFFSET 0 {Thread #06} [PASS] SELECT id, (orderlines[0].qty + orderlines[1].qty) AS totquant FROM orders WHERE test_id="order_func" ORDER BY totquant DESC, id ASC {Thread #07} [PASS] SELECT orderlines[0] FROM orders WHERE test_id="order_func" ORDER BY orderlines[0].productId, orderlines[0].qty DESC LIMIT -1 {Thread #06} [FAIL] SELECT orderlines[1] FROM orders WHERE test_id="order_func" ORDER BY orderlines[1].qty, orderlines[1].productId {Thread #06} Expected: {Thread #06} [ { "$1": { "productId": "sugar22", "qty": 1 } }, { "$1": { "productId": "sugar22", "qty": 1 } }, { "$1": { "productId": "sugar22", "qty": 1 } }, { "$1": { "productId": "tea111", "qty": 1 } } ] {Thread #06} Actual: {Thread #06} [ { "*": { "productId": "sugar22", "qty": 1 } }, { "*": { "productId": "sugar22", "qty": 1 } }, { "*": { "productId": "sugar22", "qty": 1 } }, { "*": { "productId": "tea111", "qty": 1 } } ] {Thread #07} [PASS] SELECT orderlines[0] FROM orders WHERE test_id="order_func" ORDER BY orderlines[0].productId, orderlines[0].qty ASC OFFSET 4 {Thread #06} [FAIL] SELECT orderlines[0] FROM orders WHERE test_id="order_func" ORDER BY orderlines[0].productId, orderlines[0].qty ASC LIMIT 1 {Thread #06} Expected: {Thread #06} [ { "$1": { "productId": "coffee01", "qty": 1 } } ] {Thread #06} Actual: {Thread #06} [ { "*": { "productId": "coffee01", "qty": 1 } } ] {Thread #07} [PASS] SELECT orderlines[0] FROM orders WHERE test_id="order_func" ORDER BY orderlines[0].productId, orderlines[0].qty ASC OFFSET 8192 LIMIT 1 {Thread #07} [FAIL] SELECT orderlines[0] FROM orders WHERE test_id="order_func" ORDER BY orderlines[0].productId, orderlines[0].qty ASC LIMIT 1 OFFSET 2 {Thread #07} Expected: {Thread #07} [ { "$1": { "productId": "coffee01", "qty": 2 } } ] {Thread #07} Actual: {Thread #07} [ { "*": { "productId": "coffee01", "qty": 2 } } ] {Thread #07} [PASS] SELECT id, custId, orderlines[0].productId AS pId FROM orders WHERE test_id="order_func" ORDER BY pId, custId {Thread #08} [PASS] SELECT 1+1 as two FROM scratch {Thread #06} [PASS] SELECT DISTINCT orderlines[0].productId AS pId FROM orders WHERE test_id="select_func" ORDER BY pId {Thread #08} [PASS] SELECT custId, id FROM orders WHERE test_id="select_func" ORDER BY id {Thread #07} [PASS] select id, orderlines FROM orders WHERE test_id="select_func" order by id {Thread #07} [PASS] SELECT `shipped-on` FROM orders WHERE test_id="select_func" ORDER BY `shipped-on` {Thread #07} [PASS] SELECT orderlines[0].productId FROM orders WHERE test_id="select_func" ORDER BY orderlines[0].productId {Thread #07} [PASS] SELECT 1, orderlines[0] as totords FROM orders WHERE test_id="select_func" ORDER BY 1, totords {Thread #07} [PASS] SELECT orderlines[0].productId AS productId, orderlines[0] AS totords FROM orders WHERE test_id="select_func" ORDER BY productId, totords.qty {Thread #07} [FAIL] SELECT orderlines[0] FROM orders WHERE test_id="select_func" ORDER BY custId LIMIT 1 {Thread #07} Expected: {Thread #07} [ { "$1": { "productId": "tea111", "qty": 1 } } ] {Thread #07} Actual: {Thread #07} [ { "*": { "productId": "tea111", "qty": 1 } } ] {Thread #07} [PASS] SELECT {"name": id} AS custom_obj FROM orders WHERE test_id="select_func" ORDER BY custom_obj {Thread #07} [PASS] SELECT id FROM orders WHERE `shipped-on` IS VALUED AND test_id="select_func" ORDER BY id {Thread #07} [PASS] SELECT `shipped-on`, custId, id FROM orders WHERE `shipped-on` IS NULL AND test_id="select_func" ORDER BY id {Thread #07} [PASS] SELECT custId FROM orders WHERE id = "1236" AND test_id="select_func" {Thread #07} [PASS] SELECT `shipped-on` FROM orders WHERE test_id="select_func" ORDER BY `shipped-on` {Thread #07} [PASS] SELECT orderlines[0].qty FROM orders WHERE test_id="select_func" ORDER BY custId {Thread #08} [PASS] SELECT DISTINCT LOWER(state) AS lostate FROM customer where test_id="str_func" ORDER BY lostate limit 5 {Thread #08} [PASS] SELECT LOWER(ccInfo.cardType) as cardname, LOWER(firstName) as fnamelo FROM customer where test_id="str_func" ORDER BY fnamelo limit 5 {Thread #08} [PASS] SELECT lower(orderlines[0].productId) AS ordlines FROM orders where test_id="str_func" ORDER BY ordlines limit 3 {Thread #08} [FAIL] select LOWER(ccInfo) as cclo FROM customer where test_id="str_func" ORDER by firstName limit 5 {Thread #08} Expected: {Thread #08} [ { "cclo": null }, { "cclo": null }, { "cclo": null }, { "cclo": null }, { "cclo": null } ] {Thread #08} Actual: {Thread #08} [ {}, {}, {}, {}, {} ] {Thread #07} [PASS] SELECT upper(orderlines[0].productId) AS ordlines FROM orders where test_id="str_func" ORDER BY ordlines limit 3 {Thread #07} [PASS] SELECT UPPER(ccInfo.cardType) as cardname, UPPER(firstName) as fnamehi FROM customer where test_id="str_func" ORDER BY fnamehi limit 5 {Thread #07} [PASS] SELECT lower(orderlines[0].productId) AS ordlines FROM orders where test_id="str_func" ORDER BY ordlines limit 3 {Thread #07} [PASS] SELECT emailAddress, LENGTH(emailAddress) AS addlen FROM customer WHERE LENGTH(customer.emailAddress) <= 15 AND test_id="str_func" ORDER BY addlen, emailAddress limit 5 {Thread #07} [PASS] SELECT CONTAINS("Couchbaseisdope","chbaseisdo") AS dope FROM scratch {Thread #07} [PASS] SELECT firstName from customer WHERE LENGTH(customer.firstName) < 5 AND test_id= "str_func" ORDER BY firstName LIMIT 5 {Thread #05} [PASS] select LOWER("THIS Is a N1Ql QuErY") as lower FROM scratch {Thread #05} Failed to create query for 'select REGEXP_CONTAINS("Thisisabigsubquery","query") as regex FROM scratch'... {Thread #05} ...LiteCore InvalidQuery, "N1QL syntax error near character 62" {Thread #05} ...uery") as regex FROM scratch... {Thread #05} ^ {Thread #05} [PASS] select REGEXP_LIKE("Thisisabigsubquery","query%") AS liketru FROM scratch {Thread #05} [PASS] select REGEXP_LIKE("query","query") AS liketru FROM scratch {Thread #05} [PASS] select REGEXP_LIKE("query","query.*") AS liketru FROM scratch {Thread #05} [PASS] select REGEXP_POSITION("Thisisabigsubquery","query") AS pos FROM scratch {Thread #05} [PASS] select REGEXP_REPLACE("Thisisaqueryisasubqandisnotisnull","is","IS") AS rep FROM scratch {Thread #05} [PASS] select REGEXP_REPLACE("Thisisaqueryisasubqandisnotisnull","is","IS", 4) AS rep FROM scratch {Thread #05} [PASS] SELECT regexp_replace("esgFSdfa3rjs84tha5gref4", "[a-z]","9" ) AS azreplace FROM scratch {Thread #05} Failed to create query for 'SELECT REPLACE('SQL SQL SQL', 'S', 'N1', -1) as negative_n, REPLACE('SQL SQL SQL', 'S', 'N1', 2) as replace_2, REPLACE('SQL SQL SQL', 'S', 'N1') as replace_all FROM scratch'... {Thread #05} ...LiteCore InvalidQuery, "N1QL syntax error near character 15" {Thread #05} ...SELECT REPLACE('SQL SQL SQL', ... {Thread #05} ^ {Thread #07} [PASS] select TOARRAY(orders.id) as a from orders WHERE test_id="typeconv_func" order by a {Thread #05} [PASS] select IS_ARRAY(orders.orderlines) as a from orders WHERE test_id="typeconv_func" order by a {Thread #05} [PASS] select IS_ARRAY(orders.id) as a from orders WHERE test_id="typeconv_func" order by a {Thread #05} [FAIL] select IS_ARRAY(null) FROM scratch {Thread #05} Expected: {Thread #05} [ { "$1": null } ] {Thread #05} Actual: {Thread #05} [ { "$1": false } ] {Thread #05} [FAIL] select IS_ARRAY(missing) FROM scratch {Thread #05} Expected: {Thread #05} [ {} ] {Thread #05} Actual: {Thread #05} [ { "$1": false } ] {Thread #05} [PASS] select IS_ATOM(orders.orderlines) as a from orders WHERE test_id="typeconv_func" order by a {Thread #05} [PASS] select IS_ATOM(orders.id) as a from orders WHERE test_id="typeconv_func" order by a {Thread #05} [PASS] select IS_BOOLEAN(false) FROM scratch {Thread #05} [PASS] select IS_BOOLEAN(1) FROM scratch {Thread #07} [PASS] select TOATOM(TOARRAY(orders.id)) AS a from orders WHERE test_id="typeconv_func" ORDER BY a {Thread #05} Failed to create query for 'select IS_NUM(0) FROM scratch'... {Thread #05} ...LiteCore InvalidQuery, "N1QL syntax error near character 14" {Thread #05} ...select IS_NUM(0) FROM scratch... {Thread #05} ^ {Thread #05} Failed to create query for 'select IS_NUM([1,2]) FROM scratch'... {Thread #05} ...LiteCore InvalidQuery, "N1QL syntax error near character 14" {Thread #05} ...select IS_NUM([1,2]) FROM scr... {Thread #05} ^ {Thread #05} Failed to create query for 'select IS_OBJ(orders) as a from orders WHERE test_id="typeconv_func"'... {Thread #05} ...LiteCore InvalidQuery, "N1QL syntax error near character 14" {Thread #05} ...select IS_OBJ(orders) as a fro... {Thread #05} ^ {Thread #05} [PASS] select is_string("") FROM scratch {Thread #07} [PASS] select TONUMBER(id) as a from orders WHERE test_id="typeconv_func" ORDER BY a {Thread #07} [PASS] select TOSTRING(TONUMBER(id)) as a from orders WHERE test_id="typeconv_func" ORDER BY a {Thread #07} [PASS] select TOOBJECT(orders.`shipped-on`) as a from orders WHERE test_id="typeconv_func" ORDER BY a {Thread #07} [PASS] select TOOBJECT(orders.orderlines[1]) as a from orders WHERE test_id="typeconv_func" ORDER BY a {Thread #07} [PASS] select TOBOOLEAN(orders.orderlines[1]) as a from orders WHERE test_id="typeconv_func" ORDER BY a {Thread #07} [PASS] select TOBOOLEAN(orders.`shipped-on`) as a from orders WHERE test_id="typeconv_func" ORDER BY a {Thread #09} Failed to create query for 'SELECT unitPrice, name FROM product WHERE unitPrice IS NOT MISSING AND test_id="where_func" ORDER BY unitPrice, productId LIMIT 3'... {Thread #09} ...LiteCore InvalidQuery, "operation must be a string" {Thread #07} [FAIL] SELECT * FROM product WHERE name = "SODIAL(TM) Mickey Mouse Face Shape Cookie Cutter" AND test_id="where_func" ORDER BY 1 {Thread #07} Expected: {Thread #07} [ { "product": { "categories": [ "Kitchen & Dining" ], "color": "fuchsia", "dateAdded": "2013-06-10T15:52:18Z", "dateModified": "2014-05-06T15:52:18Z", "description": "This product is available on Amazon.com.", "imageURL": "http://ecx.images-amazon.com/images/I/31VyPF%2BIbGL._SL300_.jpg", "name": "SODIAL(TM) Mickey Mouse Face Shape Cookie Cutter", "productId": "product43", "reviewList": [ "review173", "review1275", "review3729", "review4266", "review4485", "review6338", "review7045", "review7882", "review8388", "review9141", "review9570" ], "test_id": "where_func", "type": "product", "unitPrice": 0.69 } } ] {Thread #07} Actual: {Thread #07} [ { "*": { "dateAdded": "2013-06-10T08:52:18-07:00", "description": "This product is available on Amazon.com.", "color": "fuchsia", "unitPrice": 0.69, "imageURL": "http://ecx.images-amazon.com/images/I/31VyPF%2BIbGL._SL300_.jpg", "reviewList": [ "review173", "review1275", "review3729", "review4266", "review4485", "review6338", "review7045", "review7882", "review8388", "review9141", "review9570" ], "productId": "product43", "type": "product", "dateModified": "2014-05-06T08:52:18-07:00", "categories": [ "Kitchen & Dining" ], "name": "SODIAL(TM) Mickey Mouse Face Shape Cookie Cutter", "test_id": "where_func" } } ] {Thread #05} [PASS] SELECT * FROM product WHERE name = "nEvErPoSSIble" AND test_id="where_func" ORDER BY 1 {Thread #09} [PASS] SELECT unitPrice, name FROM product WHERE unitPrice IS NOT NULL AND test_id="where_func" ORDER BY unitPrice, productId LIMIT 3 {Thread #08} [PASS] SELECT unitPrice, name FROM product WHERE unitPrice IS NULL AND test_id="where_func" ORDER BY unitPrice, productId LIMIT 3 {Thread #08} [PASS] SELECT categories, color FROM product WHERE product.categories[0]="Luggage" AND test_id="where_func" ORDER BY color limit 3 {Thread #08} [PASS] SELECT productId, color FROM product WHERE unitPrice=183.2 AND productId LIKE "product1%" AND test_id="where_func" ORDER BY productId, color {Thread #08} [PASS] SELECT productId, color, categories FROM product WHERE categories[0] LIKE "Bed%" AND test_id="where_func" ORDER BY productId LIMIT 3 {Thread #08} [PASS] SELECT name, color, productId FROM product WHERE reviewList=["review1908", "review7858"] AND test_id="where_func" ORDER BY name {Thread #08} [PASS] SELECT name, color FROM product WHERE length(name) < 15 AND test_id="where_func" ORDER BY name limit 3 {Thread #08} [PASS] SELECT name from product as prods WHERE prods.name="Ball Cap Buddy" AND test_id="where_func" {Thread #08} [PASS] SELECT name, categories[0] AS category FROM product AS prods WHERE prods.unitPrice=183.2 AND test_id="where_func" {Thread #08} [PASS] SELECT name AS category FROM product AS prods WHERE prods.unitPrice=183.2 AND test_id="where_func" {Thread #05} [PASS] SELECT name FROM product WHERE (ANY review IN product.reviewList SATISFIES review="review1908" END AND ANY category IN product.categories SATISFIES category="Appliances" END) AND unitPrice>70 AND test_id="where_func" ORDER BY name {Thread #08} [PASS] SELECT name, reviewList FROM product WHERE (EVERY review in product.reviewList SATISFIES length(review)>9 END) AND test_id="where_func" ORDER BY name limit 3 {Thread #08} [PASS] SELECT name FROM product WHERE ANY review IN reviewList SATISFIES review="review2042" END AND NOT (unitPrice<10) AND test_id="where_func" ORDER BY name {Thread #08} [PASS] SELECT custId, id FROM orders WHERE `shipped-on` IS VALUED AND test_id="where_func" ORDER BY id {Thread #08} [PASS] SELECT id FROM orders WHERE `shipped-on` IS NOT NULL AND test_id="where_func" ORDER BY id {Thread #08} [PASS] SELECT custId, id FROM orders WHERE `shipped-on` IS NOT VALUED AND test_id="where_func" ORDER BY id {Thread #08} [PASS] SELECT id FROM orders WHERE `shipped-on` IS NULL AND test_id="where_func" ORDER BY id {Thread #08} Failed to create query for 'SELECT id FROM orders WHERE `shipped-on` IS NOT MISSING AND test_id="where_func" ORDER BY id'... {Thread #08} ...LiteCore InvalidQuery, "operation must be a string" {Thread #08} [PASS] SELECT id FROM orders WHERE `shipped-on` IS MISSING AND test_id="where_func" ORDER BY id {Thread #08} [PASS] SELECT id FROM orders WHERE id <> "1234" AND test_id="where_func" ORDER BY id {Thread #08} [PASS] SELECT id FROM orders WHERE id <= "1234" AND test_id="where_func" ORDER BY id {Thread #08} [PASS] SELECT id FROM orders WHERE id > "1234" AND test_id="where_func" ORDER BY id {Thread #08} [PASS] SELECT id FROM orders WHERE (id = "1200" OR id = "1236") AND test_id="where_func" ORDER BY id {Thread #08} [FAIL] SELECT customerId, id, orderlines FROM orders WHERE orderlines[0]={"productId": "coffee01", "qty": 2} AND id="1234" AND test_id="where_func" {Thread #08} Expected: {Thread #08} [ { "id": "1234", "orderlines": [ { "productId": "coffee01", "qty": 2 }, { "productId": "tea111", "qty": 1 } ] } ] {Thread #08} Actual: {Thread #08} [] {Thread #08} [FAIL] SELECT * from orders WHERE (custId LIKE "customer3%" OR `shipped-on` IS VALUED) AND type="order" AND test_id="where_func" AND length(custId)>10 ORDER BY id {Thread #08} Expected: {Thread #08} [ { "orders": { "custId": "customer312", "id": "1234", "orderlines": [ { "productId": "coffee01", "qty": 2 }, { "productId": "tea111", "qty": 1 } ], "test_id": "where_func", "type": "order" } } ] {Thread #08} Actual: {Thread #08} [ { "*": { "type": "order", "orderlines": [ { "qty": 2, "productId": "coffee01" }, { "qty": 1, "productId": "tea111" } ], "custId": "customer312", "id": "1234", "test_id": "where_func" } } ] {Thread #04} [PASS] SELECT name from product where every review in reviewList satisfies length(review)>=10 END AND test_id="where_func" ORDER BY name DESC limit 3 {Thread #04} [PASS] SELECT productId, reviewList FROM product WHERE EVERY review IN reviewList satisfies length(review)>length(productId) END AND test_id="where_func" ORDER BY productId limit 3 PASS: 221 FAIL: 27 ERROR: 9C:\UberJenkins\workspace\mobile-n1ql-test\N1QLQueryHarness\script\server_run.ps1 : 36 queries did not pass! At C:\Users\Administrator\AppData\Local\Temp\jenkins1500254925768997372.ps1:1 char:1 + .\N1QLQueryHarness\script\server_run.ps1 -sha $env:SHA + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,server_run.ps1 Build step 'Windows PowerShell' marked build as failure Set build name. New build name is 'LC d4d710b96e41c67e3b65aa7bcbdaae5b1bae4590' Archiving artifacts [BFA] Scanning build for known causes... [BFA] No failure causes found [BFA] Done. 0s Started calculate disk usage of build Finished Calculation of disk usage of build in 0 seconds Started calculate disk usage of workspace Finished Calculation of disk usage of workspace in 0 seconds Finished: FAILURE