Double quoted string doc wrt shell wrong
(1) By Roger Binns (rogerbinns) on 2023-08-14 18:21:37 [source]
In quirks at the end of double quoted strings it says:
As of SQLite 3.41.0 (2023-02-21) SQLITE_DBCONFIG_DQS_DDL and SQLTIE_DBCONFIG_DQS_DML are disabled by default in the CLI. Use the ".dbconfig" dot-command to reenable the legacy behavior if desired.
I'm interpreting that to mean that double quoted strings are not allowed. But even with the pre-release:
$ ./sqlite3
SQLite version 3.43.0 2023-08-11 19:31:51
sqlite> select "hello";
hello
sqlite> .dbconfig
dqs_ddl on
dqs_dml on
Using .dbconfig dqs_dml off
does then cause the expected error. I suggest making the doc and the shell consistent.
(2) By Richard Hipp (drh) on 2023-08-14 19:13:10 in reply to 1 [link] [source]
It seems to have been working correctly in all builds except for the amalgamation-autoconf tarball build on unix. Should be fixed there now, too. Tnx for the report.