capacitor-community / capacitor-community/sqlite

bug: SQLite RETURNING fails

Open
#605 0 comments 0 reactions 0 assignees View on GitHub
bug/fix needs: triage
Dominant language
Swift
Stars
661
Forks
158
PR merge metrics
No merged PRs in 30d

Description

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"}

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.