Sorry got confused with Sqlite sites, created this ticket at
system.data.sqlite.org yesterday.
Regards,
Winter
Ticket UUID: 4ca56c780c92f6e308abf1ad5bb76be2a3e29a68
Title: AsyncTableQuery "Where" clause can't handle "OR" (||).
Status: Open Type: Code_Defect
Severity: Important Priority:
Subsystem: Resolution:
Last Modified: 2016-08-16 09:04:24
Version Found In: v3.1.1
User Comments:
anonymous added on 2016-08-16 09:04:24:
Table has data with ID 1.
var filteredIDs = new List<int>{1};
_connection.Table<T>().Where(x=>filteredIDs.Contains(x.ID)).ToListAsync()
Result has 1 row returned.
_connection.Table<T>().Where(x=>filteredIDs.Count==0||filteredIDs.Contains(x.ID)).ToListAsync()
Result has 0 row returned.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
