SQLite Forum

Complex view breaking SQLite on Android < v11
Your view uses a [window function][1] `OVER (PARTITION BY', which may not be supported by the SQLite version on Android < v11, or by aSQLiteManager on those versions.

Use [SELECT sqlite_version()][2] to find out what version your target Android version has installed, and consult the [release history][3] to find out if that version is supposed to support window functions.

[1]: https://www.sqlite.org/windowfunctions.html#introduction_to_window_functions
[2]: https://www.sqlite.org/lang_corefunc.html#sqlite_version
[3]: https://www.sqlite.org/changes.html