View Issue Details

IDProjectCategoryView StatusLast Update
0006170MMW v4DB/FileMonitorpublic2010-10-13 22:48
ReporterLudek Assigned To 
PriorityurgentSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version4.0 
Target Version4.0Fixed in Version4.0 
Summary0006170: Searching for quoted strings via search bar no longer works after SQLite update (MM 4.0 only)
DescriptionAfter 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.
Tagstodoc-help
Fixed in build1307

Relationships

related to 0005147 closedLudek Search for exact text containing special characters doesn't always work 

Activities

Ludek

2009-11-10 19:39

developer   ~0019657

Last edited: 2009-11-10 19:57

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.

Ludek

2010-06-14 23:18

developer   ~0020265

Fixed in build 1307.

peke

2010-10-08 23:52

developer   ~0020682

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?

Ludek

2010-10-11 17:08

developer   ~0020725

Last edited: 2010-10-11 17:11

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).

peke

2010-10-13 22:48

developer   ~0020752

Verified 1315
thx Ludek for clarification