Files

56 lines
1.3 KiB
Python

#!/usr/bin/env python
"""
Copyright (c) 2006-2026 sqlmap developers (https://sqlmap.org)
See the file 'LICENSE' for copying permission
"""
import re
from lib.core.enums import PRIORITY
__priority__ = PRIORITY.HIGHEST
def dependencies():
pass
def tamper(payload, **kwargs):
"""
Replaces greater than operator ('>') with 'GREATEST' counterpart
Requirement:
* MySQL
* MariaDB
* PostgreSQL
* Microsoft SQL Server >= 2022
* Oracle
Tested against:
* MySQL 8.4.9
* MariaDB 11.8.8
* PostgreSQL 16.11
* Microsoft SQL Server 2022
* Oracle 23ai
Notes:
* Useful to bypass weak and bespoke web application firewalls that
filter the greater than character
* NOT usable against SQLite, which has no GREATEST() (it overloads
MAX() for the multi-argument case instead). Microsoft SQL Server
only gained GREATEST() in 2022
>>> tamper('1 AND A > B')
'1 AND GREATEST(A,B+1)=A'
"""
retVal = payload
if payload:
match = re.search(r"(?i)(\b(AND|OR)\b\s+)([^>]+?)\s*>\s*(\w+|'[^']+')", payload)
if match:
_ = "%sGREATEST(%s,%s+1)=%s" % (match.group(1), match.group(3), match.group(4), match.group(3))
retVal = retVal.replace(match.group(0), _)
return retVal