Details
Description
Actual Result:
Error
Expected Result:
No Error and get query result.
What is the last build this test passed:
This was not added in unit test. so not sure.
Steps to Reproduce(updated unit test):
func testWhereMatch() throws { |
Database.log.console.level = .debug
|
try loadJSONResource(name: "sentences") |
|
let index = IndexBuilder
|
.fullTextIndex(items: FullTextIndexItem.property("sentence")) |
.language(nil)
|
.ignoreAccents(false) |
try db.createIndex(index, withName: "sentence") |
|
let alias = "db" |
let s_sentence = SelectResult.expression(Expression.property("sentence") |
.from(alias))
|
let q = QueryBuilder.select([SelectResult.expression(Meta.id.from(alias)), s_sentence])
|
.from(DataSource.database(db).as(alias))
|
.where(FullTextExpression.index("sentence").match("'Dummie woman'")) |
.orderBy(Ordering.expression(FullTextFunction.rank("sentence")).descending()) |
let numRows = try verifyQuery(q) { (n, r) in |
|
}
|
XCTAssertEqual(numRows, 2) |
}
|
Logs:
2019-09-06 23:12:23.989531-0700 xctest[85798:4258167] CouchbaseLite Query Info: {Query#2} Compiling JSON query: {"WHAT":[[".db._id"],[".db.sentence"]],"WHERE":["MATCH","sentence","'Dummie woman'"],"FROM":[{"AS":"db"}],"ORDER_BY":[["DESC",["RANK()","sentence"]]]} |
2019-09-06 23:12:23.990462-0700 xctest[85798:4258167] CouchbaseLite Query Info: {Query#2} Compiled as SELECT "db".db.rowid, offsets(fts1."kv_default::sentence"), fl_result("db".key), fl_result(fl_value("db".body, 'sentence')) FROM kv_default AS "db" JOIN "kv_default::sentence" AS fts1 ON fts1.docid = "db".rowid WHERE (fts1."kv_default::sentence" MATCH '''Dummie woman''') AND ("db".flags & 1 = 0) ORDER BY rank(matchinfo(fts1."kv_default::sentence")) DESC |
2019-09-06 23:12:23.990750-0700 xctest[85798:4258167] CouchbaseLite Database ERROR: SQLite error (code 1): no such column: db.db.rowid in "SELECT "db".db.rowid, offsets(fts1."kv_default::sentence"), fl_result("db".key), fl_result(fl_value("db".body, 'sentence')) FROM kv_default AS "db" JOIN "kv_default::sentence" AS fts1 ON fts1.docid = "db".rowid WHERE (fts1."kv_default::sentence" MATCH '''Dummie woman''') AND ("db".flags & 1 = 0) ORDER BY rank(matchinfo(fts1."kv_default::sentence")) DESC" |
2019-09-06 23:12:23.990992-0700 xctest[85798:4258167] CouchbaseLite Database ERROR: no such column: db.db.rowid (1/1) |
2019-09-06 23:12:23.991285-0700 xctest[85798:4258167] CouchbaseLite Database WARNING: {DB#1} SQLite error compiling statement "SELECT "db".db.rowid, offsets(fts1."kv_default::sentence"), fl_result("db".key), fl_result(fl_value("db".body, 'sentence')) FROM kv_default AS "db" JOIN "kv_default::sentence" AS fts1 ON fts1.docid = "db".rowid WHERE (fts1."kv_default::sentence" MATCH '''Dummie woman''') AND ("db".flags & 1 = 0) ORDER BY rank(matchinfo(fts1."kv_default::sentence")) DESC": no such column: db.db.rowid |
<unknown>:0: error: -[CouchbaseLiteSwiftTests.QueryTest testWhereMatch] : failed: caught error: no such column: db.db.rowid |
Attachments
Issue Links
- links to