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
36417	Intersects result not matching 'not disjoint' result for geography field	Jiro Shirota		"The following two queries don't always result in the same output.

{{{

.filter(my_geography_field__intersects=polygon)

.exclude(my_geography_field__disjoint=polygon)

}}}

''Also the intersects example above is significantly slower.''

It may be that ::geometry casting needs to be applied to a geography field all the time (not just for operations supported for geography).  Possibly remove the second condition in the following if statement?

https://github.com/django/django/blob/b373721af0e5c3de0986977ac07e3ad55061ecbe/django/contrib/gis/db/backends/postgis/operations.py#L94


"	Bug	closed	GIS	5.1	Normal	needsinfo		Claude Paroz	Unreviewed	0	0	0	0	0	0