[sqlite] Why SQLite allows to create table with unknown types?

*Actually I have found that SQLite creates tables with unknown types when I was investigating an issue about really bad performance during execution DELETE requests. The root cause was a bug in our custom protocol input stream decoder removing space symbols from input data, so the input commands

[sqlite] Why SQLite allows to create table with unknown types?

On 13 Apr 2016, at 4:56pm, Vladimir Soldatov wrote: > Why there is no data type checks to avoid such misprints? Please read this page then post again if you still have questions. Simon.

[sqlite] Why SQLite allows to create table with unknown types?

Hi all, Why create table request like 'CREATE TABLE perf1 (_id ANYANYANY, DATA1 TEXT, DATA2 TEXT);' is working well? The table is created, we can insert and delete rows. Btw, the programmer can do misprint like CREATE TABLE perf1 (_id INTEGERT, DATA1 TEXT, DATA2 TEXT) and everything will work

[sqlite] Why SQLite allows to create table with unknown types?

On 4/13/2016 11:56 AM, Vladimir Soldatov wrote: > Btw, the programmer can do misprint like CREATE TABLE perf1 (_id INTEGERT, > DATA1 TEXT, DATA2 TEXT) and everything will work well except very slow > delete operations. What makes you believe such a typo would affect performance in any way? It