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
