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
34969	Documentation is misleading about SQL equivalent	Piotr Kotarba	nobody	"Below misleading has been checked for 3.2, but I assume it might also apply for all remaining version up to 4.2(not checked).

Documentation says:
{{{
#!div style=""font-size: 80%""
Code highlighting:
  {{{#!python
  **Example:**
Blog.objects.get(name__iexact=""beatles blog"")
Blog.objects.get(name__iexact=None)

**SQL equivalents:**
SELECT ... WHERE name ILIKE 'beatles blog';
SELECT ... WHERE name IS NULL;

  }}}
}}}

Based on a code of Django itself I have found out that not every backend uses ILIKE. 
For example postgresql or Oracle uses UPPER:

{{{
#!div style=""font-size: 80%""
Code highlighting:
  {{{#!python
  class DatabaseWrapper(BaseDatabaseWrapper):
    vendor = 'oracle'
    display_name = 'Oracle'
    _standard_operators = {
        'exact': '= %s',
        'iexact': '= UPPER(%s)',
      ... }

  }}}
}}}


You can check that under:
django.db.backends.oracle.base.DatabaseWrapper




"	Cleanup/optimization	closed	Documentation	3.2	Normal	duplicate			Unreviewed	0	0	0	0	0	0