Getting an error on Memory access out of bounds when trying to run db.exec with a large query string
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 30/100
- Issue type
- Bug
- Clarity
- Needs clarification
- Activity status
- Stale
- Tech stack
- javascript, sqlite, wasm
- Domain
- databases
Research direction
Reproduce the failure in Google Chrome with SQL.js 1.8.0 using a db.exec query around 1.5 MB, then compare it with a smaller query that succeeds. Determine whether the behavior is a documented query-size limit or a defect, and document the limit or provide a verified fix.
Written by the indexing model from the issue text.
Description
When creating the database initially, we use a large file that is successfully processed to create the database.
Afterwards, when we attampt to run a script to add another table, it is throw the error Memory access out of bounds.
This always happens when the query string is about 1.5MB.
When the query is below that size, the query is successfully processed and the database is updated with the new table.
Is there a limit to much much the query string should be big?
This is was done Google Chrome browser version 120.0.6099.224 64bits
On SQL.js library version ^1.8.0
- Dominant language
- JavaScript
- Stars
- 13.7k
- Forks
- 1.1k
- PR merge metrics
- No merged PRs in 30d
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 sql-js/sql.js
-
Difficulty 4/5 3-5 days Newbie friendliness 48/100
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 45/100
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
Similar issues
-
ai-observability bug team/ai-observability
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
AllTheMods/ATM-10-L#19 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
SignalK/n2k-signalk#345 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
-
Difficulty 1/5 1-3 hours Newbie friendliness 88/100
JuliaPluto/PlutoPlotly.jl#72 ·