SQLite Forum

Why was there no error message at CREATE TABLE?
Login
I just came within a whisker of distributing an app with this error:

```
Third-Mini% 
Third-Mini% sqlite3
SQLite version 3.28.0 2019-04-16 19:49:53
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> create table xx (a text, b integer);
sqlite> .schema
CREATE TABLE xx (a text, b integer);
sqlite> .tables
xx
sqlite> create table bad (a text b integer);
sqlite> .schema
CREATE TABLE xx (a text, b integer);
CREATE TABLE bad (a text b integer);
sqlite> .tables
bad  xx 
sqlite> select a from bad;
sqlite> select b from bad;
Error: no such column: b
sqlite> 
```

Should there not have been a syntax error reported at the CREATE TABLE stage?