Since attachments are not supported, https://github.com/jhihn/files/blob/master/no_such_column.sqlite3
I apologize for the added complexity. > Sent: Wednesday, July 15, 2015 at 1:41 PM > From: "Jason H" <jhihn at gmx.com> > To: sqlite-users at mailinglists.sqlite.org > Cc: "General Discussion of SQLite Database" <sqlite-users at > mailinglists.sqlite.org> > Subject: Re: [sqlite] Error: no such column: When column exists! > > Ok, I've dropped irrelevant tables, dropped the data, vacuumed, and am > attaching the result. (Does this ML support attachments?) > > I was using v3.7.17, I tried the 3.8.5 and 3.8.10 releases, and all are the > same error. > > > > > Sent: Wednesday, July 15, 2015 at 10:28 AM > > From: "Donald Griggs" <dfgriggs at gmail.com> > > To: "General Discussion of SQLite Database" <sqlite-users at > > mailinglists.sqlite.org> > > Subject: Re: [sqlite] Error: no such column: When column exists! > > > > Jason, > > > > I think your problem description is too abbreviated to allow anyone to > > easily reproduce it. > > > > Maybe you can repost with a minimal example of the failure, but include a > > full script that will show the problem, and let us know what version of the > > sqlite3 commandline utility was used and what OS you're using. > > > > I tried the following on Windows 7 with sqlite3 3.8.10.2 and got no error. > > (I did not populate the tables.) > > > > > > D:\>sqlite3 > > SQLite version 3.8.10.2 2015-05-20 18:17:19 > > Enter ".help" for usage hints. > > Connected to a transient in-memory database. > > Use ".open FILENAME" to reopen on a persistent database. > > > > sqlite> CREATE TABLE PatientTreatmentNote( > > ...> TreatmentNoteID, dog, cat, rat ); > > > > sqlite> CREATE TABLE PatientTreatmentNoteStep( > > ...> TreatmentNoteID, dog2, cat2, rat2 ); > > > > > > sqlite> select * from PatientTreatmentNote ptn join > > PatientTreatmentNoteStep pts > > ON pts.TreatmentNoteID = ptn.TreatmentNoteID ; > > sqlite> > > sqlite> > > =================================== > > Script was: > > > > CREATE TABLE PatientTreatmentNote( > > TreatmentNoteID, dog, cat, rat ); > > > > CREATE TABLE PatientTreatmentNoteStep( > > TreatmentNoteID, dog2, cat2, rat2 ); > > > > select * from PatientTreatmentNote ptn join PatientTreatmentNoteStep pts ON > > pts.TreatmentNoteID = ptn.TreatmentNoteID ; > > _______________________________________________ > > 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 >
