Skip to content

bug: SQLite RETURNING fails #605

Open
@MonicaExplan

Description

@MonicaExplan

Hi,

I need hook value change in one filed in my table. On Changed value then I'll notify user using local notification

I inserted "RETURNING" at the end of the UPSERT statement and I get an error.

Here https://www.sqlite.org/lang_returning.html:
"..
The RETURNING syntax has been supported by SQLite since version 3.35.0 (2021-03-12).
.."

So, RETURNING IN supported in this sqlite plugin?
Many thanks
Monica

Plugin version:
"@capacitor-community/sqlite": "6.0.1"

Platform(s):
vue 3
Ionic 7
capacitor 6

Current behavior:
If I put the RETURNING, with * or status 1, it goes into error
[error] - {"errorMessage":"Run: Failed in runSQL : Error: prepareSQL prepare failed rc: 1 message: near ";": syntax error","message":"Run: Failed in runSQL : Error: prepareSQL prepare failed rc: 1 message: near ";": syntax error"}

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions