"Richard Hipp" wrote...
On Wed, May 1, 2013 at 11:24 AM, Richard Hipp <d...@sqlite.org> wrote:
On Wed, May 1, 2013 at 8:30 AM, Martin Altmayer <
martin.altma...@googlemail.com> wrote:
Hi,
I have a query that runs more than 400x slower in 3.7.16.2 than in
3.7.11.
This seems to be caused by the use of transitive constraints in version
3.7.16. Your work-around (until an official fix is available in SQLite)
is
to put a "+" sign in front of the "elements.id" identifier in the ON
clause:
SELECT count(*) FROM elements JOIN tags ON +elements.id =
tags.element_id
WHERE elements.id IN (<list>);
Thank you for the trouble report.
I think the problem is fixed with
http://www.sqlite.org/src/info/faedaeace9
Dr. Hipp,
will this fix break the work-around you provided,
"
to put a "+" sign in front of the "elements.id" identifier in the ON clause:
SELECT count(*) FROM elements JOIN tags ON +elements.id = tags.element_id
WHERE elements.id IN (<list>);
"
or will it also work?
Thanks.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
