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>
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>
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
3 matches
Mail list logo