exportToJson fails when CREATE TABLE statement contains nested parentheses

[Random90]

Plugin version:
capacitor-community/sqlite@8.1.0

Platform(s):
Android

Current behavior:

exportToJson('full', false); fails when CREATE TABLE statement contains nested parentheses

e.g if this statements are used, export fails

CHECK (isDisabled IN (0, 1))

CHECK (endDate IS NULL OR date(endDate) >= date(startDate))

CHECK ( (isRecurring = 1 AND recurrenceIntervalType IS NOT NULL AND recurrenceIntervalValue IS NOT NULL) OR
                   (isRecurring = 0 AND recurrenceIntervalType IS NULL AND recurrenceIntervalValue IS NULL) ),

Changing those to those below works as workaround, export finishes:

CHECK (isDisabled = 0 OR isDisabled = 1)

CHECK (endDate IS NULL OR endDate >= startDate)

CHECK (isRecurring = 1 AND recurrenceIntervalType IS NOT NULL AND recurrenceIntervalValue IS NOT NULL
                  OR isRecurring = 0 AND recurrenceIntervalType IS NULL AND recurrenceIntervalValue IS NULL),

Exact error messages from android:

Error: exportToJson CreateExportObject: GetTablesFull: begin 919, end 831, length 1121
2026-04-28 23:41:51.380 8687-8752 com.getcap...RetHandler com.myapp.app V *** ERROR ExportToJson: ExportToJson CreateExportObject: GetTablesFull: begin 919, end 831, length 1121
2026-04-28 23:41:51.380 8687-8752 Capacitor com.myapp.app D Sending plugin error: {"save":false,"callbackId":"14032160","pluginId":"CapacitorSQLite","methodName":"exportToJson","success":false,"error":{"message":"ExportToJson: ExportToJson CreateExportObject: GetTablesFull: begin 919, end 831, length 1121"}}
2026-04-28 23:41:51.380 8687-8687 Capacitor/Console com.myapp.app E File: - Line 330 - Msg: [object Object]
2026-04-28 23:41:51.382 8687-8687 Capacitor/Console com.myapp.app E File: https://localhost/settings - Line 961 - Msg: Uncaught (in promise) Error: ExportToJson: ExportToJson CreateExportObject: GetTablesFull: begin 919, end 831, length 1121

Expected behavior:

Export completed without problems.

Steps to reproduce:

Run statement containing nested parentheses and run exportToJson('full')

`CREATE TABLE budgets
         (
           id                        INTEGER PRIMARY KEY AUTOINCREMENT,
           name                      TEXT    NOT NULL,
           amount                    REAL    NOT NULL,
           startDate                 TEXT    NOT NULL,
           endDate                   TEXT    NULL,
           isRecurring               BOOLEAN NOT NULL DEFAULT 0,
           recurrenceIntervalType    TEXT    NULL,
           recurrenceIntervalValue   INTEGER NULL,
           warnNotifThresholdPercent INTEGER NOT NULL DEFAULT 80,
           CHECK (isRecurring IN (0, 1)),
           CHECK ( (isRecurring = 1 AND recurrenceIntervalType IS NOT NULL AND recurrenceIntervalValue IS NOT NULL) OR
                   (isRecurring = 0 AND recurrenceIntervalType IS NULL AND recurrenceIntervalValue IS NULL) ),
           CHECK (recurrenceIntervalType IN ('days', 'weeks', 'months', 'years') OR recurrenceIntervalType IS NULL),
           CHECK (endDate IS NULL OR date(endDate) >= date(startDate))
         );`

Other information:
Claude sonnet analysis of the problem:

The Android plugin's modEmbeddedParentheses() helper in ExportToJson.java iterates through the ( and ) positions it collected from the CREATE TABLE body. When it detects a nested pair (oPars[i+1] < cPars[i]), it advances i inside the loop and the loop advances it again, putting it out of sync. It then tries to fill the "gap" between the two inner groups with substring(cPars[i], oPars[i+1]-1).
For CHECK ( (expr_A) OR (expr_B) ) the inner i points to the close of expr_B (later in string) while i+1 points to the open of expr_B (earlier in string) → begin > end → StringIndexOutOfBoundsException: begin 919, end 831, length 1121.

Or from other prompt

The crash comes from ExportToJson.java (line ~290) inside the modEmbeddedParentheses() helper, which is called for every CREATE TABLE schema during exportToJson('full').
The helper collects all ( positions into oPars and all ) positions into cPars and then tries to pair them up in a single loop. The pairing logic has a flaw: when a table has sibling nested parentheses — i.e., two (or more) inner groups at the same depth — it advances i inside the loop body and outside it, so the "gap between groups" substring is computed as substring(cPars[i], oPars[i+1] - 1) where cPars[i] ends up greater than oPars[i+1] - 1. That triggers Java's StringIndexOutOfBoundsException: begin N, end M, length L.

Capacitor doctor:

💊   Capacitor Doctor  💊 

Latest Dependencies:

  @capacitor/cli: 8.3.1
  @capacitor/core: 8.3.1
  @capacitor/android: 8.3.1
  @capacitor/ios: 8.3.1

Installed Dependencies:

  @capacitor/ios: not installed
  @capacitor/cli: 8.3.1
  @capacitor/core: 8.3.1
  @capacitor/android: 8.3.1

[success] Android looking great! 👌