On 08/08/2015 04:11 AM, Robert Weiss wrote: > I observed the sqlite command shell version 3.8.11.1 to crash (exit to the > OSwithout an error message) while running in a Cygwin shell under Windows 7 > when I tried to create anindex. The source was compiled by gcc 4.9.2. The > same type of crashhappened when I tried the operation from a Lua script > linked to the same objectlibrary. > > > > Here are the DDL statements entered previous to the crash: > > > > CREATE TABLEd200_on_passport(fn,path,size,serial,pid); > > CREATE INDEX d200_on_passport_serial ond200_on_passport(serial); > > CREATE VIEW d200 as select * fromd200_on_passport; > > > > And here is the statement thatcaused the crash: > > create index d200_on_passport_fn ond200_on_passport(fn); > > > > The crash didn?t happen when Itried the CREATE INDEX statement on a test > database with the same ddlstatements but containing no data. > > > The compressed version of the database that illustrates the problem is a > little smaller than 2 MB. It contains some semi-personal information (it's > part of an attempt to organize my photo library; pathnames hint at where I've > been on vacation and so on, but the database contains no images) and I'd > prefer not to post it to a list, but I can send it for use by those tracking > down the bug.
Can you send the database to me? Or to drh if that seems more prudent to you. Thanks, Dan. > > Robert Weiss > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users