0005667: The following search: "genre: -country" produces an error

ID	Project	Category	View Status	Date Submitted	Last Update

0005667	MMW v4	Playlist / Search	public	2009-05-24 22:02	2009-05-28 02:36

Reporter	~~stephen_platt~~	Assigned To
Priority	immediate	Severity	minor	Reproducibility	always
Status	closed	Resolution	fixed
Product Version	3.1
Target Version	3.1	Fixed in Version	3.1

Summary	0005667: The following search: "genre: -country" produces an error
Description	1. Type genre: -country into the search bar 2. Wait a few seconds. No results appear and an error is seen: There was a problem querying the database: Could not retrieve data "SELECT Songs.* FROM Songs WHERE Songs.ID IN (SELECT rowid FROM SongsText WHERE SongsText MATCH' genre: -country*') ":SQL logic error or missing database (1, 21)
Additional Information	http://www.mediamonkey.com/support/staff/index.php?_m=tickets&_a=viewticket&ticketid=4771&departmentid=2&ticketstatusid=1
Tags	No tags attached.

Fixed in build	1249

Ludek 2009-05-25 10:21 developer ~0018006 Last edited: 2009-05-25 10:25	Yes, according to SQLite's FTS3 the query must contain at least one non-excluded term therefore there is the SQL logic error. Thank you. Fixed in build 1249. (The SQL error no more occurs and there are no results in such a case)

~~stephen_platt~~ 2009-05-28 02:36 developer ~0018051	verified 1249