On 14-09-2010 23:50, Oliver Peters wrote: > your version of sqlite? I used several programs SQLiteSpy, SQLcc, Python-programs, so I don't know which versions of sqlite I used, might that be the problem ? > your OS? windows XP > your backend? several, see above > What exactly have you done before the Natural Join stopped working? converted tables from string to unicode, column rename + columns added + changed column constraints ( through copy table / drop table / rename table )
thanks, Stef > Oliver > > > Am Dienstag, den 14.09.2010, 23:41 +0200 schrieb Stef Mientki: >> hello, >> >> after modifying some tables, natural join stopped working ??? >> >> I've 2 tables, each with a field named "vlid", which is the primary key in >> one of the tables >> >> until a few moments ago, this worked perfectly >> >> select Header from vraag >> natural join vraaglist >> where Nr = 0 and vraaglist.Name = 'eortc_br23' >> >> but now it returns an empty string (while the string shouldn't be empty). >> >> I test that by doing an explicit join >> >> select Header from vraag >> join vraaglist on vraag.vlid = vraaglist.vlid >> where Nr = 0 and vraaglist.Name = 'eortc_br23' >> >> which gives me the correct string of the field Header. >> >> exchanging the 2 tables in the above statements, gives exactly the same >> results. >> >> Is my database corrupt ? >> >> thanks, >> Stef Mientki >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users