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
28621	Crash in QuerySet.annotate() with OuterRef	Дилян Палаузов	Mariusz Felisiak	"
{{{
class A(models.Model):
  tag = models.CharField()

class B(models.Model):
  pattern = models.CharField()
}}}


A single query that retrieves all A.tag, not matching B.pattern:

{{{
SELECT a.tag FROM app_a as a WHERE NOT EXISTS (SELECT 1 FROM app_b as b WHERE a.tag ~ b.pattern);
}}}

Is it possibe to write a queryset for this, without .extra and .raw?"	Bug	closed	Database layer (models, ORM)	dev	Normal	fixed	QuerySet.extra	Leo Antunes Dmitry Mugtasimov	Ready for checkin	1	0	0	0	0	0