View Issue Details

IDProjectCategoryView StatusLast Update
0009195MMW v4Playlist / Searchpublic2012-05-01 14:48
Reporterlowlander Assigned To 
PriorityurgentSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version4.0.3 
Target Version4.0.5Fixed in Version4.0.5 
Summary0009195: Search including OR throws SQL error in Quick Search
DescriptionIf you type a search of Artist1 OR Artist2 in the Quick Search an SQL error is thrown as instant results are loaded (Artist1 OR is an incorrect SQL query).
Steps To ReproduceTesting note: this may also occur with other SQL operators
Additional Informationhttp://www.mediamonkey.com/forum/viewtopic.php?f=7&t=64833
Related: http://www.mediamonkey.com/forum/viewtopic.php?f=7&t=64889
TagsNo tags attached.
Fixed in build1484

Relationships

related to 0005326 closedLudek Boolean "OR" doesn't work correctly in some cases 

Activities

Ludek

2012-03-04 18:49

developer   ~0030609

Fixed in build 1600 and merged into 4.0.4.1480

stephen_platt

2012-04-23 18:20

developer   ~0030881

I can reproduce this in 1483 with quicksearch:

artist:beatles OR artist:

Ludek

2012-04-23 22:21

developer   ~0030884

Fixed in build 1484.

rusty

2012-04-27 13:30

administrator   ~0030956

Verified 1484.

lowlander

2012-04-27 16:33

developer   ~0030959

I wonder if it would be more elegant that instead of not searching when user enters Artist1 OR (even on hitting Enter) that instead it should search, but ignore OR (and other database Operators) until they constitute a valid SQL statement (artist1 OR artist2). This means Artist1 OR would actually search for Artist1.

Ludek

2012-05-01 14:48

developer   ~0030982

Last edited: 2012-05-01 14:48

Yes, it is probably reasonable, but it is a very minor issue and thus I am rather avoiding fixing this in order to prevent from introducing a regression.