Android Q SQLiteException

[breewf]

设备：Google Pixel XL

系统版本：Android Q

执行AlbumTask.buildAlbumInfo时异常：

android.database.sqlite.SQLiteException: near "GROUP": syntax error (code 1 SQLITE_ERROR): , while compiling: SELECT bucket_id, bucket_display_name FROM images WHERE ((is_pending=0) AND (is_trashed=0)) AND ((0==0) GROUP BY(bucket_id)) ORDER BY date_modified desc
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:184)
at android.database.DatabaseUtils.readExceptionFromParcel(DatabaseUtils.java:140)
at android.content.ContentProviderProxy.query(ContentProviderNative.java:423)
at android.content.ContentResolver.query(ContentResolver.java:862)
at android.content.ContentResolver.query(ContentResolver.java:809)
at android.content.ContentResolver.query(ContentResolver.java:767)
at com.bilibili.boxing.model.task.impl.AlbumTask.buildAlbumInfo(AlbumTask.java:72)
at com.bilibili.boxing.model.task.impl.AlbumTask.start(AlbumTask.java:64)
at com.bilibili.boxing.model.BoxingManager$2.run(BoxingManager.java:74)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
at java.lang.Thread.run(Thread.java:914)

[pinguo-sunjianfei]

我也遇到这个问题了。

[pinguo-sunjianfei]

好久可以更新呢？

[zhoufeng1213]

只能把代码下下来之后改了
bucketCursor = cr.query(Media.EXTERNAL_CONTENT_URI, distinctBucketColumns, "0==0) "+" GROUP BY(" + Media.BUCKET_ID, null,
Media.DATE_MODIFIED + " desc");
把上面的代码替换成下面的：
bucketCursor = cr.query(Media.EXTERNAL_CONTENT_URI, distinctBucketColumns, null, null,
Media.DATE_MODIFIED + " desc");
//android Q之后查询的where条件会出现(())两层的括号，没法使用group by
//由于查出来的数据中有多个buckId和name重复的数据，需要把它过滤掉
HashSet<HashMap<String,String>> hashSet = new HashSet<>();
if (bucketCursor != null && bucketCursor.moveToFirst()) {
do {
String buckId = bucketCursor.getString(bucketCursor.getColumnIndex(Media.BUCKET_ID));
String name = bucketCursor.getString(bucketCursor.getColumnIndex(Media.BUCKET_DISPLAY_NAME));
if (!TextUtils.isEmpty(buckId)) {
HashMap<String,String> map = new HashMap<>(2);
map.put("buckId",buckId);
map.put("name",name);
hashSet.add(map);
}
} while (bucketCursor.moveToNext());
}
for(HashMap<String,String> map:hashSet){
AlbumEntity album = buildAlbumInfo(map.get("name"), map.get("buckId"));
if (!TextUtils.isEmpty(map.get("buckId"))) {
buildAlbumCover(cr, map.get("buckId"), album);
}
}

[li-lance]

@ChenSiLiang 有空适配下吗？

[Mysqi]

有更新么？1.0.4版本还是有这个问题

[parcool]

同。等更新。。。。