On 08/11/2015 12:23 AM, Robert Weiss wrote: > Dan Kennedy-- > What address, precisely, should I use to send the database to you? When I > "reply" to your message I get the whole SQLite discussion group, which is > what I want to avoid (no offense intended, guys and gals). > BTW, the problem does not seem to occur in version 3.8.10.2. > Robert Weiss
Thanks for the database. We couldn't reproduce the problem here though. The crash is repeatable, correct? Are you able to capture a stack trace from the command line shell with gdb? Thanks, Dan. > > > On Friday, August 7, 2015 11:31 PM, Dan Kennedy <danielk1977 at > gmail.com> wrote: > > > 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 > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
