As a developer, I feel your pain, but... ...this group might not be the best place to reach Google Music staff.
Try this instead: 2013/10/29 nakvic <nak...@googlemail.com>: > 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 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. -- 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.
