Re: [sqlite] Segfault when querying deeply nested view

I reproduced this as well on Suse 10 and 3.3.7 Using the following data: insert into records values ( date('NOW'), 'D/D', 'NPOWER','20','test acc','123456') ; insert into records values(date('2006-01-12'), 'D/D', 'NPOWER','20','test acc','123456') ; insert into records

[sqlite] Segfault when querying deeply nested view

Hi List, I've found a situation which causes sqlite to segfault. System Info - OS: Debian Etch Sqlite Version: 3.3.8 Run the attached sql script to see segfault. I'd be interested to hear of a workaround if anybody knows of one. Of course, I'll post to the list if I find one.