collections() return Error: Invalid column DISTINCT bucket_id only on Android 10

[pecos19]

Initially I tested my cordova app with the photos plugin with an Android 9 and everything worked perfectly.
I encountered this problem exclusively with android 10

[jguyet]

Hello pecos19
For this moment deploy your app for android 9 or anterior version.
Is necessary for you to use a android 10 features ?

[siegklenes]

Hi @jguyet

In November, 2, 2020, play store will not accept api level 28 (android 9) releases.
Do you have any plans to update this project to be compatible with cordova-android@9 and api level29/android10 ?

[siegklenes]

Hi @domax, see previous comment in this issue.

[jguyet]

I have create a fork project with differently fixes for ios 14.4 and android 10, and have increase speed of loading.
(collections() return Error: Invalid column DISTINCT bucket_id only on Android 10) Fixed.

I don't forget domax, but I have started Pull Request for over a year without a response.

https://github.com/jguyet/cordova-plugin-albums-and-photos