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
34544	models.TextField with =None filter throws Error for Oracle	Michael Smith	nobody	"Model contains

somefield = models.TextField(
        blank=True, null=True
    )

At 4.1.9:

{{{
print(MyModel.objects.filter(somefield=None).only('id').query)

}}}

{{{
SELECT ""TNAME_MYMODEL"".""ID"" FROM ""TNAME_MYMODEL"" WHERE ""TNAME_MYMODEL"".""SOMEFIELD""  IS NULL

}}}
works

At 4.2.0:

{{{
print(MyModel.objects.filter(somefield=None).only('id').query)

}}}

{{{
SELECT ""TNAME_MYMODEL"".""ID"" FROM ""TNAME_MYMODEL"" WHERE DBMS_LOB.SUBSTR(""TNAME_MYMODEL"".""SOMEFIELD"") IS NULL

DatabaseError: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1
}}}
"	Bug	new	Database layer (models, ORM)	4.2	Normal		Oracle isnull lob		Unreviewed	0	0	0	0	0	0