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
29865	Add logical XOR support to Q() and QuerySet().	Griffith Rees	Ryan Heard	"XOR seems to be available in [https://www.postgresql.org/docs/8.4/static/functions-math.html Postgresql], [https://dev.mysql.com/doc/refman/8.0/en/logical-operators.html MySQL], [https://docs.microsoft.com/en-us/sql/mdx/xor-mdx?view=sql-server-2017 SequelServer] and [https://docs.oracle.com/cd/E17952_01/mysql-5.1-en/logical-operators.html Oracle] but NOT [https://stackoverflow.com/questions/2294137/sqlite-exclusive-or-how-do-i-clear-a-flag sqlite]. Two stackoverflow questions cover this sort of thing: [https://stackoverflow.com/questions/50408142/django-models-xor-at-the-model-level] and [https://stackoverflow.com/questions/14711203/perform-a-logical-exclusive-or-on-a-django-q-object].

I propose adding XOR to work with Q queries like the [https://stackoverflow.com/a/21220712/678486 answer]  to the second question above. This will be my first time making a major contribution so we'll see how this goes (apologies in advance if this is annoying!)."	New feature	closed	Database layer (models, ORM)	dev	Normal	fixed	xor	Mariusz Felisiak	Ready for checkin	1	0	0	0	0	0