Adding WorkManager to a project that uses the new androidx.sqlite crashes looking for androidx.sqlite.db.SupportSQLiteCompat$Api19Impl [402796648]

Fixed

Bug

Status Update

No update yet.

Description

ey...@gmail.com

created issue #1

Mar 13, 2025 04:57AM

Component used: work-runtime-ktx Version used: 2.10.0

I added a simple worker to my project that is using the new androidx.sqlite bundled library (2.5.0-rc02), and I get the following crash:

java.lang.NoClassDefFoundError: Failed resolution of: Landroidx/sqlite/db/SupportSQLiteCompat$Api19Impl;
  at androidx.room.RoomDatabase$JournalMode.isLowRamDevice(RoomDatabase.kt:679)
  at androidx.room.RoomDatabase$JournalMode.resolve$room_runtime_release(RoomDatabase.kt:670)
  at androidx.room.RoomDatabase$Builder.build(RoomDatabase.kt:1337)
  at androidx.work.impl.WorkDatabase$Companion.create(WorkDatabase.kt:165)
  at androidx.work.impl.WorkManagerImplExtKt.createWorkManager$default(WorkManagerImplExt.kt:38)
  at androidx.work.impl.WorkManagerImplExtKt.createWorkManager(Unknown Source:20)
  at androidx.work.impl.WorkManagerImpl.initialize(WorkManagerImpl.java:214)
  at androidx.work.impl.WorkManagerImpl.getInstance(WorkManagerImpl.java:174)
  at androidx.work.WorkManager$Companion.getInstance(WorkManager.kt:173)

Comments

il...@google.com <il...@google.com> Mar 13, 2025 03:12PM

Assigned to da...@google.com.

da...@google.com <da...@google.com> #2Mar 13, 2025 04:11PM

We'd also need to trim the ")".

da...@google.com <da...@google.com> #3Mar 13, 2025 04:23PM

that would not work because we don't know if the IN statement is a positive one or a negative one.
e.g. the result would be different if it is
NOT IN
vs
IN.

but putting () should just do the right thing. afaik, SQLite accepts empty set.

ap...@google.com <ap...@google.com> #4Mar 14, 2025 02:49PM

When I tested empty sets I was getting no results, but let me double check that I didn't goof something.

da...@google.com <da...@google.com> #5Mar 14, 2025 02:51PM

Marked as fixed.

i think that is WAI.

Imagine you have a query like:

@Query("select * from users where uid IN (:uids)")
List<User> getUsersByIds(List<String> uids)

If you call that query w/ an empty list of uids, the expected result should be an empty list of users.

Issue 402796648