View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0007962||MediaMonkey (current)||Framework: Scripts/Extensions||public||2011-06-15 23:22||2011-06-17 13:36|
|Target Version||4.0||Fixed in Version||4.0|
|Summary||0007962: A bug in SQLite 3.6.18 -> update to the latest version|
|Description||There is a problem with some SQL queries used in OpenSQL and AddTracksFromQuery, manifesting only in MM4 (tested 1333, 1343, 1389). It is manifesting in MagicNodes as some user reported (http://www.mediamonkey.com/forum/viewtopic.php?p=301210#p301210), but I tested the same queries with Bex's SQLView and got the same results.|
Let say that you have one track with Title = '4 Steps'. The next query displays that track in MM3 just fine, but it is not displayed in MM4:
SELECT * FROM Songs WHERE cast(SongTitle COLLATE NOCASE as integer) < 20 AND SongTitle COLLATE NOCASE = '4 Steps'
At first I though that something happened within the new SQLite engine used in MM4, but that query works fine in SQLiteSpy 1.9.0 which has SQLite 3.7.6 (MM 1389 has the older 3.6.18 engine as you already know).
It is really strange because the next two queries display the mentioned track even in MM4:
SELECT * FROM Songs WHERE cast(SongTitle COLLATE NOCASE as integer) < 20
SELECT * FROM Songs WHERE SongTitle COLLATE NOCASE = '4 Steps'
So, in MM4 the record is displayed if criterion 1 = True, it is also displayed if criterion 2 = True, but it is not displayed if criterion 1 = True AND criterion 2 = True, which doesn't follows the Boolean logic.
By the way, I wrote COLLATE NOCASE in these queries only because of testing in SQLiteSpy, to avoid its error about unknown collating with IUnicode.
|Tags||No tags attached.|
|Fixed in build||1392|
||I can confirm that this is a bug in SQLite. It seems to be worth updating to the latest version, even though MM 4.0 is close to being released.|
||Fixed in build 1392.|
||This could be related to bug I have found in OpenSQL regarding bug 0007653 where in case that OpenSQL parameter is sent with trailing space OpenSQL do not return anything an lock Last.fm Client.|
||I don't know if this is related to Peke's bug, but my bug is fixed in 1392. Thanks.|