[sqlite] ICC Compiler Warning

Hello, compiling the latest stable version 3300100 using VS2019 on Windows and ICC 2019 Update 5 gives this warning: 1>-- Rebuild All started: Project: SQLite DLL, Configuration: Release x64 -- 1>sqlite3.c 1>C:\Dropbox\Boo\Shares\Code\SQLite\SQLite DLL\sqlite3.c(154619): message #111:

[sqlite] Error 19 with Caret ^ INSERT

Hello, in my C# program which uses DllImport for sqlite.dll (3.29) I get Error 19 (SQLITE_CONSTRAINT) with this statement: INSERT INTO CompanyDetails (RIC) VALUES('AMBEUR.IP^G19') The ^ symbol is part of the text I want to save, its not a filter or so, its just plain text. The odd thing is

[sqlite] ORDER BY is ignored during INSERT INTO

Hello, I try to copy one table into a second identical one. Once the second table is created I want to move the content over sorted by ASC. The issue is that the ORDER BY statement gets ignored during a INSERT INTO: INSERT INTO CompanyDetails2 SELECT * FROM CompanyDetails WHERE

[sqlite] Unreachable Breaks with ICC on Windows

Hello, ICC reports two unreachable "break;" statements as warnings: SQLite 3.29 Windows 2019 Visual Studio 16.2.0 Preview 3.0 Intel Parallel Studio XE 2019 Update 4 1>-- Rebuild All started: Project: SQLite, Configuration: Release x64 -- 1>sqlite3.c 1>D:\Dropbox\Chaos\SQLite