View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006170 | MMW v4 | DB/FileMonitor | public | 2009-11-10 19:33 | 2010-10-13 22:48 |
| Reporter | Ludek | Assigned To | |||
| Priority | urgent | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 4.0 | ||||
| Target Version | 4.0 | Fixed in Version | 4.0 | ||
| Summary | 0006170: Searching for quoted strings via search bar no longer works after SQLite update (MM 4.0 only) | ||||
| Description | After update to SQLite 3.6.18 entering artist:"a-ha" into search bar resluts in SQL logic error. Watching the change log http://www.sqlite.org/changes.html it might be something that had been changed 2009 Jan 12 (3.6.8) related to the SQLITE_ENABLE_FTS3_PARENTHESIS makro. | ||||
| Tags | todoc-help | ||||
| Fixed in build | 1307 | ||||
|
|
Important note about this: ** By default, this module parses the legacy syntax that has been ** traditionally used by fts3. Or, if SQLITE_ENABLE_FTS3_PARENTHESIS ** is defined, then it uses the new syntax. The differences between ** the new and the old syntaxes are: ** ** a) The new syntax supports parenthesis. The old does not. ** ** b) The new syntax supports the AND and NOT operators. The old does not. ** ** c) The old syntax supports the "-" token qualifier. This is not ** supported by the new syntax (it is replaced by the NOT operator). ** ** d) When using the old syntax, the OR operator has a greater precedence ** than an implicit AND. When using the new, both implicity and explicit ** AND operators have a higher precedence than OR. ** ** If compiled with SQLITE_TEST defined, then this module exports the ** symbol "int sqlite3_fts3_enable_parentheses". Setting this variable ** to zero causes the module to use the old syntax. If it is set to ** non-zero the new syntax is activated. This is so both syntaxes can ** be tested using a single build of testfixture. */ Maybe we should use the advantages of the new syntax in MM 4.0, but this way we will need to make also several changes in our code. So I am leaving this open for now. |
|
|
Fixed in build 1307. |
|
|
Can you please clarify how to test this as testing "a-ha" in search bar of 1314 gave me correct results of artist A-Ha? |
|
|
Yes, that's correct, both searching for artist:"a-ha" and "a-ha" should give results of artist A-Ha. And (non-quoted) searching for a-ha could find also A Hard Day's Night, because the special characters aren't indexed by FTS3 (see 0005147 for details). |
|
|
Verified 1315 thx Ludek for clarification |
