Cannot execute multiple statements with one call
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 42/100
- Issue type
- Bug
- Clarity
- Mostly clear
- Activity status
- Stale
- Tech stack
- cpp, react-native, sqlite
- Domain
- databases, mobile-dev
Research direction
Start in cpp/sqliteBridge.cpp around the sqliteExecute prepare call at line 260, and inspect how the unused pzTail value is handled. Reproduce the two-statement script, then determine whether the interface should execute all statements or report trailing SQL; done means the behavior is explicit and no statement is silently ignored.
Written by the indexing model from the issue text.
Description
Consider the following sql script:
CREATE TABLE foo (id INTEGER);
CREATE TABLE bar (id INTEGER);
With the current interface, only the first statement will be executed and no error is given. I would've expected to have the whole sql script executed, or at least to get an error.
I digged through the code, and found out that the pzTail parameter is unused in the sqliteExecute's prepare call:
Apparently that pointer gets populated with the remaining text that is yet to be processed: https://sqlite.org/forum/info/2a9775b88a90d2e6.
- Dominant language
- C
- Stars
- 565
- Forks
- 53
- Avg merge
- 3d 13h
- Merged PRs (30d)
- 28
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from margelo/react-native-nitro-sqlite
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
margelo/react-native-nitro-sqlite#218 · 1 comment ·
-
Difficulty 4/5 3-5 days Newbie friendliness 45/100
All issues in margelo/react-native-nitro-sqlite
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
-
level/task module/gcp type/bug
Difficulty 2/5 1-3 hours Newbie friendliness 85/100
-
Difficulty 1/5 Under an hour Newbie friendliness 86/100
hapostgres/pg_auto_failover#1190 ·
-
docs
Difficulty 1/5 Under an hour Newbie friendliness 85/100
-
P3 sonic-vpp
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
sonic-net/sonic-buildimage#29662 ·