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 >
