[sqlite] Difference in pragma table_info between tables and views

Hi All, I noticed a difference in the output that pragma table_info gives for tables and views. It seems, that not null conditions aren't properly returned for views: create table atab ( id int not null primary key, withnulls text, withoutnulls text NOT NULL ); create view aview as select * from

Re: [sqlite] Bug report: query parser should trigger an error if a subquery selects unknown columns from table

I ran into a similar issue: DELETE FROM ATable WHERE EXISTS(SELECT 1 FROM TMPTable AS t WHERE id = t.id) ; Syntactically I was expecting id to be the ATable.id as I had aliased the TMPTable with t. But the result was a non-correlated subquery, id = t.id was always true. The fix is clear, yet a