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 android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com 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 android-developers+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
