Assigned
Status Update
No update yet.
Comments
ja...@gmail.com
I confirm the problem and attach an example.
Expected (Correct):
Android 13 (Api 33, emulator): TestEntity(id=6, index=3, text=F), TestEntity(id=4, index=2, text=D), TestEntity(id=2, index=1, text=B)
Actual (Incorrect):
Android 14 (Api 34, pixel 5): TestEntity(id=5, index=3, text=E), TestEntity(id=3, index=2, text=C), TestEntity(id=1, index=1, text=A)
Table data:
_id_index_text
(1, 1, "A")
(2, 1, "B")
(3, 2, "C")
(4, 2, "D")
(5, 3, "E")
(6, 3, "F")
Query:
SELECT * FROM (SELECT * FROM test ORDER BY text DESC) GROUP BY `index` ORDER BY id DESC
Description
Version used:
Devices/Android versions reproduced on: 14
create table test('a' integer, 'b' text)
insert into test(a, b) values(1, 'a');
insert into test(a, b) values(2, 'a');
select * from (select * from test order by a desc) ta group by b order by a desc
before android 14
2|a
android 14
1|a
why??
If this is a bug in the library, we would appreciate if you could attach:
- Sample project to trigger the issue.
- A screenrecord or screenshots showing the issue (if UI related).