The result is: 2015-05-04 19:13:25 850c11866686a7b39d7b163fb60898c11283688e
2016-10-24 14:28 GMT+02:00 Richard Hipp <d...@sqlite.org>: > Please post the result of the following query: > > SELECT sqlite_source_id(); > > On 10/24/16, Werner Kleiner <sqlitetes...@gmail.com> wrote: >> I have dropped the double index >> DROP INDEX 'InternalName'; >> Then executed the SQL Select statement which caused the sqlite warning. >> But same warning, nothing changed. >> >> Then I added a new index CREATE INDEX idx_installid ON ... >> >> >> Now the sqlite warning is gone away. :-) >> >> The SQL statement has a JOIN like; >> .. >> LEFT JOIN >> is_mytable H ON H.InstallD = I.InstallD >> >> perhaps this was the problem? >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users