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