Re: [sqlite] Re: insert default values - supporting it?

2006-08-01 Thread Mario Frasca
just to show that it does not crash: sqlite> create table test2 (k integer primary key autoincrement); sqlite> insert into test2 default values; sqlite> insert into test2 () values (); sqlite> select * from test2; 1 2 sqlite>

Re: [sqlite] Re: insert default values - supporting it?

2006-08-01 Thread Mario Frasca
I refined the patch. it constructs a list of values with one NULL, but I don't see how to construct an idList with just the primary key. also added the grammar rule to recognize both: insert into default values; insert into () values (); anybody completing/correcting the work? sqlite>

[sqlite] Re: insert default values - supporting it?

2006-07-31 Thread Mario Frasca
I'm throwing this here, I assume that it would not be too much work to complete this patch. the aim is to support the sql92 syntax insert into default values; any comments? hints? thanks in advance, Mario Frasca. cvs diff: Diffing src Index: src/insert.c