[sqlite] bus error in sqlite

[Will Leshner]

I believe I have discovered a bug in sqlite that results in a bus 
error. If you have a malformed date in a column and you try to select 
that column with strftime, then the error occurs. More specifically, I 
think this is the series of SQL statements that will reveal the 
problem:

create table test (t);
insert into test values ('2003-12-23 20:15:3');
insert into test values ('2003-12-23 20:15:3');
select * from test where strftime('%Y', datetime(t))='2003';
Notice that the time value is malformed in that the seconds should most 
likely be '03' and not '3'.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]