Re: [sqlite] Why is the VDBE testing for NULL?

On Oct 9, 2008, at 11:46 AM, Ken wrote: > DRH, > I noticed that the VDBE is doing a check for null Can this be removed? > > test script to show output: > create table t (id integer not null, id2 integer); > create index t_idx on t (id); > explain select id from t where id = 5; > > > 0|Trace|0|0|

[sqlite] Why is the VDBE testing for NULL?

DRH, I noticed that the VDBE is doing a check for null Can this be removed? test script to show output: create table t (id integer not null, id2 integer); create index  t_idx on t (id); explain select id from t where id = 5; 0|Trace|0|0|0|explain select id from t where id = 5;|00| 1|Integer|5|1