search doesn't work with single quotes (apostrophes)

[nik.martin]

I just fetched master and built and now search doesn't work if the track/artist has an apostrophe. Example:

Search for "That's What I Like" - nothing.

Search "That What I like" works.

The workaround is simple, but this is pretty critical bug when you are busy and need to find a track

[Daniel Schürmann (daschuer)]

Workaround:
Search for
title:"That's What I Like"

related:
https://bugs.launchpad.net/mixxx/+bug/1784141

[Daniel Schürmann (daschuer)]

Can you you confirm the workaround?

I am trying to hunt it down, but I cannot reproduce it on my Ubuntu Trusty development machine using
libsqlite3-0 3.8.2-1ubuntu2.1 Qt4.8 and Qt5.2

I can reproduce it on my Ubuntu Xenial machine using libsqlite3-0 3.11.0-1ubuntu1 and Qt5.5.1

Interestingly ' does not work, but '' finds (7'' mix)

Can you confirm that?

[Daniel Schürmann (daschuer)]

On the Xenial system,

SELECT title from Library where title LIKE '%''%'

using http://sqlitebrowser.org/ with the same software stack works as it should.

[Daniel Schürmann (daschuer)]

Got it. It is a regression from https://github.com/mixxxdj/mixxx/pull/1388

[Daniel Schürmann (daschuer)]

A fix is here:
https://github.com/mixxxdj/mixxx/pull/1766

[nik.martin (nik-martin)]

Can confirm the workaround works until the pull is merged into master

[Daniel Schürmann (daschuer)]

It is here now https://github.com/mixxxdj/mixxx/pull/1797

[Uwe Klotz (uklotzde-deactivatedaccount)]

I have made a different observation:

That's What I Like
Find all tracks containing all of the (case-insensitive) strings in any order: "that's", "what" "i", "like"

title:"That's What I Like"
Finds all tracks containing the (case insensitive) sub-string "that's what i like" in the title -> CORRECT

"That's What I Like"
Finds nothing -> WRONG

Handling of quotations seems to be wrong without a preceding field selector. If it is a simple bug we should provide a fix for 2.1 and not only for 2.2.

[Uwe Klotz (uklotzde-deactivatedaccount)]

The quotation bug I just mentioned has not been fixed by https://github.com/mixxxdj/mixxx/pull/1797. Should we create new issue or rename and reuse this issue for tracking?

[Daniel Schürmann (daschuer)]

I think we should set this to fix committed an use https://bugs.launchpad.net/bugs/1784141 for the general issue.

[Swiftb0y (swiftb0y)]

Mixxx now uses GitHub for bug tracking. This bug has been migrated to:
https://github.com/mixxxdj/mixxx/issues/9395