SQLite Forum

Error: near line 3: parser stack overflow
Not sure of the facts, I have a query run in the CLI returning the titled error and I just cannot seem to up the limit at runtime, though the .help command indicates to me it should be possible. Also the documentation states that making it 0 would allow the stack usage to just grow, though I still get the parser stack overflow error:

SQLite version 3.32.3 2020-06-18 14:00:33
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .limit expr_depth
          expr_depth 1000
sqlite> .limit expr_depth 2000
          expr_depth 1000
sqlite> .limit expr_depth 900
          expr_depth 900
sqlite> .limit expr_depth 0
          expr_depth 0

Can't make it higher than 1000 and 0 still cause the error for me...

Is it possible to change it via CLI tool?