MM2-0 / Kvaesitso

A search-focused Android launcher
https://kvaesitso.mm20.de/
GNU General Public License v3.0
2.51k stars 86 forks source link

Crash Report: SQLiteException - "too many SQL variables" Error during Query Execution #1115

Open ccamacho-d opened 1 month ago

ccamacho-d commented 1 month ago

Description: I encountered a crash while running the application due to an SQLite error.

SELECT * FROM CustomAttributes WHERE type = ? AND key IN (?, ?, ..., ?).

The crash seems related to exceeding the maximum number of SQL variables allowed in a query.

Steps to Reproduce: I'm not sure if it is the specific scenario that causes this, but:

  1. Set the app as the default home app
  2. Use it for like an 1~2 hrs

Stack Trace:

android.database.sqlite.SQLiteException: too many SQL variables (code 1 SQLITE_ERROR)

Screenshot_20241022-133551 Screenshot_20241022-133546