Cursor vs DebugCursor behavior not the same on execute without arguments

[g.starck@…]

In [1]: from django.conf import settings

In [2]: settings.DEBUG
Out[2]: True

In [3]: from django.db import connection

In [4]: c = connection.cursor()

In [5]: type(c)
Out[5]: django.db.backends.util.CursorDebugWrapper

In [6]: c.execute("SELECT '%%';")

In [7]: c.fetchone()
Out[7]: ('%',)

In [8]:

In [8]: settings.DEBUG = False

In [9]:

In [9]: c = connection.cursor()

In [10]: type(c)
Out[10]: django.db.backends.util.CursorWrapper

In [11]: c.execute("SELECT '%%';")

In [12]: c.fetchone()
Out[12]: ('%%',)

In [13]:

=>

Out[7]: ('%',) vs Out[12]: ('%%',)

(if you explicitly give an empty arguments to execute then it's ok/ there is no diff between Cursor and DebugCursor)

[Grégory Starck]

simple workaround / fix

[Claude Paroz]

Duplicate of #9055