diff options
Diffstat (limited to 'django/core/cache')
| -rw-r--r-- | django/core/cache/backends/db.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/django/core/cache/backends/db.py b/django/core/cache/backends/db.py index af343ffc5d..88d7ae2973 100644 --- a/django/core/cache/backends/db.py +++ b/django/core/cache/backends/db.py @@ -139,7 +139,7 @@ class DatabaseCache(BaseDatabaseCache): if connections[db].vendor == 'oracle': # Special case for Oracle because it doesn't support LIMIT + OFFSET cursor.execute("SELECT cache_key FROM (SELECT ROW_NUMBER() OVER (ORDER BY cache_key) AS counter, cache_key FROM %s) WHERE counter > %%s AND COUNTER <= %%s" % table, [cull_num, cull_num + 1]) - else: + else: # This isn't standard SQL, it's likely to break with some non officially supported databases cursor.execute("SELECT cache_key FROM %s ORDER BY cache_key LIMIT 1 OFFSET %%s" % table, [cull_num]) cursor.execute("DELETE FROM %s WHERE cache_key < %%s" % table, [cursor.fetchone()[0]]) |