SQLite Forum

SQLite3 shell doing math operation on parameter substitution
Login
I believe the quickest "fix" to this issue is to correct "help" in sqlite3 shell as well online documentation as @jake suggested: require to wrap arbitrary literal strings with parentheses with single quotes in the same way as it going with **`VALUES`** for example to match syntax:

--------------------------------

```
.parameter set @str1 ('string')
.parameter set @str2 ('+1+2+3')

.parameter set @num (2+3+4)
```

--------------------------------

in these cases, **@str1** & **@str2** will be strings and parameter **@num** will be 9.

IMHO it will be more intuitively understandable and may be some one would find calculation on assignment as a feature.

And as always, - thank you for the sqlite !