... 2013/10/29 Kostya Vasilyev <[email protected]>: > As a developer, I feel your pain, but... > > ...this group might not be the best place to reach Google Music staff. > > Try this instead:
Sorry, the link: https://support.google.com/googleplay/topic/2999684?hl=en&ref_topic=2952998# Clicking "contact us" eventually leads here: -- K > > > 2013/10/29 nakvic <[email protected]>: >> Need to comment on my post: >> >> THIS IS A BUG, introduced in latest Google Play Music App. >> >> The one of the previous versions works fine, that is why I had it working on >> android 2.x. >> >> Google, please, fix the above mentioned exception in Play Music content >> provider!!! >> >> Regards, >> Victor >> >> >> On Monday, October 28, 2013 10:08:54 PM UTC+1, nakvic wrote: >>> >>> Hi there, >>> >>> I'm trying to query Google Play Music database. So far I have succeeded >>> with querying for tracks, but not for albums and artists. >>> >>> >>> If I try to query Play Music app for artists or albums, it throws an >>> annoying exception on android 3+: >>> >>> android.database.sqlite.SQLiteException: cannot use index: >>> MUSIC_DOMAIN_ALBUMID_SOURCE_TEXT_INDEX, while compiling: SELECT AlbumArtist >>> AS album_artist, Album AS album_name, MUSIC.AlbumId AS _id FROM MUSIC >>> INDEXED BY MUSIC_DOMAIN_ALBUMID_SOURCE_TEXT_INDEX LEFT JOIN KEEPON ON >>> (MUSIC.AlbumId = KEEPON.AlbumId) WHERE (MUSIC.AlbumIdSourceText IN (SELECT >>> AlbumIdSourceText FROM MUSIC GROUP BY MUSIC.AlbumIdSourceText ORDER BY >>> MUSIC.AlbumIdSourceText) ) GROUP BY MUSIC.AlbumIdSourceText ORDER BY >>> MUSIC.AlbumIdSourceText >>> >>> What is very confusing is that the same code does work just great on >>> android 2.x (?!). >>> >>> Does anyone tried to query Google Play Music database for artists and/or >>> albums? >>> What is MUSIC_DOMAIN_ALBUMID_SOURCE_TEXT_INDEX and why it fails on Android >>> 3+? >>> >>> Regards, >>> Victor >> >> -- >> You received this message because you are subscribed to the Google >> Groups "Android Developers" group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> For more options, visit this group at >> http://groups.google.com/group/android-developers?hl=en >> --- >> You received this message because you are subscribed to the Google Groups >> "Android Developers" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en --- You received this message because you are subscribed to the Google Groups "Android Developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.

