[2022-11-07T10:04:30.059Z] Test Case '-[QueryTest_Main testQueryParameters]' started. [2022-11-07T10:04:30.059Z] 2022-11-07 02:04:30.010922-0800 xctest[43650:11052142] CouchbaseLite Query Info: {Query#59}==> litecore::SQLiteQuery {"WHAT":[["."]],"WHERE":["AND",["AND",["AND",["AND",["AND",["AND",["AND",["=",[".city"],["$city"]],[">",[".code"],["$code"]]],[">",[".year"],["$year"]]],[">",[".id"],["$id"]]],[">",[".score"],["$score"]]],[">=",[".gpa"],["$gpa"]]],["=",[".isFullTime"],["$isFullTime"]]],[">",[".startDate"],["$startDate"]]],"FROM":[{"AS":"testdb"}]} @0x611000143250 [2022-11-07T10:04:30.059Z] 2022-11-07 02:04:30.011248-0800 xctest[43650:11052142] CouchbaseLite Query Info: {Query#59} Compiling JSON query: {"WHAT":[["."]],"WHERE":["AND",["AND",["AND",["AND",["AND",["AND",["AND",["=",[".city"],["$city"]],[">",[".code"],["$code"]]],[">",[".year"],["$year"]]],[">",[".id"],["$id"]]],[">",[".score"],["$score"]]],[">=",[".gpa"],["$gpa"]]],["=",[".isFullTime"],["$isFullTime"]]],[">",[".startDate"],["$startDate"]]],"FROM":[{"AS":"testdb"}]} [2022-11-07T10:04:30.059Z] 2022-11-07 02:04:30.012699-0800 xctest[43650:11052142] CouchbaseLite Query Info: {Query#59} Compiled as SELECT fl_result(fl_root(testdb.body)) FROM kv_default AS testdb WHERE (((((((fl_value(testdb.body, 'city') = $_city AND fl_value(testdb.body, 'code') > $_code) AND fl_value(testdb.body, 'year') > $_year) AND fl_value(testdb.body, 'id') > $_id) AND fl_value(testdb.body, 'score') > $_score) AND fl_value(testdb.body, 'gpa') >= $_gpa) AND fl_value(testdb.body, 'isFullTime') = $_isFullTime) AND fl_value(testdb.body, 'startDate') > $_startDate) AND (testdb.flags & 1 = 0) [2022-11-07T10:04:30.059Z] 2022-11-07 02:04:30.013827-0800 xctest[43650:11052142] Query explain: params: { [2022-11-07T10:04:30.059Z] city = "santa clara"; [2022-11-07T10:04:30.059Z] code = 100; [2022-11-07T10:04:30.059Z] gpa = 4; [2022-11-07T10:04:30.059Z] id = 123456791; [2022-11-07T10:04:30.059Z] isFullTime = 1; [2022-11-07T10:04:30.059Z] score = 60; [2022-11-07T10:04:30.059Z] startDate = "2022-10-24T10:04:30.011Z"; [2022-11-07T10:04:30.059Z] year = 2016; [2022-11-07T10:04:30.059Z] } SELECT fl_result(fl_root(testdb.body)) FROM kv_default AS testdb WHERE (((((((fl_value(testdb.body, 'city') = $_city AND fl_value(testdb.body, 'code') > $_code) AND fl_value(testdb.body, 'year') > $_year) AND fl_value(testdb.body, 'id') > $_id) AND fl_value(testdb.body, 'score') > $_score) AND fl_value(testdb.body, 'gpa') >= $_gpa) AND fl_value(testdb.body, 'isFullTime') = $_isFullTime) AND fl_value(testdb.body, 'startDate') > $_startDate) AND (testdb.flags & 1 = 0) [2022-11-07T10:04:30.059Z] [2022-11-07T10:04:30.059Z] 2|0|0| SCAN TABLE kv_default AS testdb [2022-11-07T10:04:30.059Z] [2022-11-07T10:04:30.059Z] {"WHAT":[["."]],"WHERE":["AND",["AND",["AND",["AND",["AND",["AND",["AND",["=",[".city"],["$city"]],[">",[".code"],["$code"]]],[">",[".year"],["$year"]]],[">",[".id"],["$id"]]],[">",[".score"],["$score"]]],[">=",[".gpa"],["$gpa"]]],["=",[".isFullTime"],["$isFullTime"]]],[">",[".startDate"],["$startDate"]]],"FROM":[{"AS":"testdb"}]} [2022-11-07T10:04:30.059Z] 2022-11-07 02:04:30.015585-0800 xctest[43650:11052142] CouchbaseLite Query Info: {QueryEnum#60}==> litecore::SQLiteQueryEnumerator 0x60e0002fd638 @0x60e0002fd638 [2022-11-07T10:04:30.059Z] 2022-11-07 02:04:30.015900-0800 xctest[43650:11052142] CouchbaseLite Query Info: {QueryEnum#60} Created on {Query#59} with 2 rows (216 bytes) in 0.563ms [2022-11-07T10:04:30.059Z] 2022-11-07 02:04:30.016224-0800 xctest[43650:11052142] CouchbaseLite Query Info: Beginning query enumeration (0x60b000383920) [2022-11-07T10:04:30.059Z] 2022-11-07 02:04:30.016490-0800 xctest[43650:11052142] CouchbaseLite Query Verbose: {QueryEnum#60} --> [{"score":65.92,"city":"santa clara","id":123456794,"code":105,"gpa":4.02,"isFullTime":false,"startDate":"2022-10-26T10:04:30.006Z","year":2017,"name":"Tom"}] [2022-11-07T10:04:30.059Z] 2022-11-07 02:04:30.016788-0800 xctest[43650:11052142] CouchbaseLite Query Verbose: {QueryEnum#60} --> [{"score":65.92,"city":"santa clara","id":123456796,"code":106,"gpa":4.02,"isFullTime":true,"startDate":"2022-10-25T10:04:30.006Z","year":2017,"name":"Casper"}] [2022-11-07T10:04:30.059Z] 2022-11-07 02:04:30.017014-0800 xctest[43650:11052142] CouchbaseLite Query Verbose: {QueryEnum#60} END [2022-11-07T10:04:30.059Z] 2022-11-07 02:04:30.017241-0800 xctest[43650:11052142] CouchbaseLite Query Info: End of query enumeration (0x60b000383920) [2022-11-07T10:04:31.467Z] /Users/couchbase/jenkins/workspace/eline_couchbase-lite-ios_PR-3040/couchbase-lite-ios/Objective-C/Tests/QueryTest+Main.m:767: error: -[QueryTest_Main testQueryParameters] : ((allObjects.count) equal to (1u)) failed: ("2") is not equal to ("1") [2022-11-07T10:04:31.467Z] /Users/couchbase/jenkins/workspace/eline_couchbase-lite-ios_PR-3040/couchbase-lite-ios/Objective-C/Tests/QueryTest+Main.m:768: error: -[QueryTest_Main testQueryParameters] : (([[allObjects.firstObject valueAtIndex: 0] stringForKey: @"name"]) equal to (@"Casper")) failed: ("Tom") is not equal to ("Casper") [2022-11-07T10:04:31.467Z] 2022-11-07 02:04:31.028496-0800 xctest[43650:11052142] CouchbaseLite Query Info: {QueryEnum#60} Deleted [2022-11-07T10:04:31.467Z] 2022-11-07 02:04:31.029241-0800 xctest[43650:11052142] CouchbaseLite Database Info: Closing CBLDatabase[testdb] at path /Users/couchbase/Library/Developer/CoreSimulator/Devices/1CB22794-72D4-4F0E-9B48-670AFF6F92AE/data/tmp/CouchbaseLite_EE/testdb.cblite2/ [2022-11-07T10:04:31.467Z] 2022-11-07 02:04:31.029841-0800 xctest[43650:11052142] CouchbaseLite Database Info: {DB#61}==> litecore::SQLiteDataFile /Users/couchbase/Library/Developer/CoreSimulator/Devices/1CB22794-72D4-4F0E-9B48-670AFF6F92AE/data/tmp/CouchbaseLite_EE/testdb.cblite2/db.sqlite3 @0x6120003ba940 [2022-11-07T10:04:31.467Z] 2022-11-07 02:04:31.030276-0800 xctest[43650:11052142] CouchbaseLite Database Verbose: {DB#61} Housekeeping: 0 of 7 pages free (0%) [2022-11-07T10:04:31.467Z] 2022-11-07 02:04:31.039251-0800 xctest[43650:11052142] CouchbaseLite Database Verbose: {DB#61} Closed SQLite database [2022-11-07T10:04:31.467Z] 2022-11-07 02:04:31.039640-0800 xctest[43650:11053258] [GCKSession] Not in connected state, so giving up for participant [489C5727] on channel [0]. [2022-11-07T10:04:31.467Z] 2022-11-07 02:04:31.039643-0800 xctest[43650:11052142] CouchbaseLite Database Info: {Shared#62}==> litecore::DataFile::Shared 0x61300004d598 @0x61300004d598 [2022-11-07T10:04:31.467Z] 2022-11-07 02:04:31.039874-0800 xctest[43650:11052142] CouchbaseLite Database Debug: {Shared#62} Remove DataFile 0x6120003ba940 [2022-11-07T10:04:31.467Z] 2022-11-07 02:04:31.040092-0800 xctest[43650:11052142] CouchbaseLite Database Info: {DB#61} Closing database [2022-11-07T10:04:31.467Z] 2022-11-07 02:04:31.040294-0800 xctest[43650:11052142] CouchbaseLite Database Debug: {Shared#62} Remove DataFile 0x6120003ba940 [2022-11-07T10:04:31.467Z] 2022-11-07 02:04:31.040488-0800 xctest[43650:11052142] CouchbaseLite Database Info: {CollectionImpl#63}==> litecore::CollectionImpl testdb/_default @0x60b000355fd0 [2022-11-07T10:04:31.467Z] 2022-11-07 02:04:31.040693-0800 xctest[43650:11052142] CouchbaseLite Database Info: {CollectionImpl#63} Closed [2022-11-07T10:04:31.468Z] 2022-11-07 02:04:31.040936-0800 xctest[43650:11052142] CouchbaseLite Database Debug: {Shared#62} Remove DataFile 0x6120003ba940 [2022-11-07T10:04:31.468Z] 2022-11-07 02:04:31.041642-0800 xctest[43650:11053258] [GCKSession] Not in connected state, so giving up for participant [489C5727] on channel [1]. [2022-11-07T10:04:31.468Z] 2022-11-07 02:04:31.042333-0800 xctest[43650:11052142] CouchbaseLite Database Debug: {DB#61} destructing (~DataFile) [2022-11-07T10:04:31.468Z] 2022-11-07 02:04:31.043314-0800 xctest[43650:11052142] CouchbaseLite Database Debug: {Shared#62} Remove DataFile 0x6120003ba940 [2022-11-07T10:04:31.468Z] 2022-11-07 02:04:31.044341-0800 xctest[43650:11052142] CouchbaseLite Database Debug: {Shared#62} destructing [2022-11-07T10:04:31.468Z] 2022-11-07 02:04:31.044469-0800 xctest[43650:11053258] [GCKSession] Not in connected state, so giving up for participant [489C5727] on channel [2]. [2022-11-07T10:04:31.468Z] Test Case '-[QueryTest_Main testQueryParameters]' failed (1.048 seconds).