id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
13430	Clarify limitations of MySQL in GeoDjango docs	Ryan Nowakowski	jbronn	"Following the GeoDjango tutorial, I get different results querying each border individually than I do when using filter.
{{{
>>> from django.contrib.gis.geos import Point
>>> from world.models import WorldBorders
>>> 
>>> pnt = Point(-97.7695999145507812, 30.3036994934082031)
>>> countries_from_iteration = []
>>> for country in WorldBorders.objects.all():
...         if country.geom.contains(pnt):
...             countries_from_iteration.append(country)
... 
>>> countries_from_iteration
[<WorldBorders: United States>]
>>> countries_from_filter = WorldBorders.objects.filter(geom__contains=pnt)
>>> countries_from_filter
[<WorldBorders: United States>, <WorldBorders: Mexico>]
}}}

Notice that the filter query results contain Mexico while the results from interating do not.  I'm using mysql and Django SVN r13027"		closed	Documentation	dev		fixed	gis mysql docs		Accepted	0	0	0	0	0	0