Integer wraparound in PostgreSQL fuzzystrmatch allows a user to direct writes to a huge range of addresses, executing arbitrary code as the operating system user running the database, via extreme inputs to SQL function levenshtein() or levenshtein_less_equal(). Versions before PostgreSQL 18.6, 17.11, 16.15, 15.19, and 14.24 are affected.
Weakness
The product performs a calculation that can produce an integer overflow or wraparound when the logic assumes that the resulting value will always be larger than the original value. This occurs when an integer value is incremented to a value that is too large to store in the associated representation. When this occurs, the value may become a very small or negative number.
Affected Software
| Name | Vendor | Start Version | End Version |
|---|---|---|---|
| Postgresql | Postgresql | 14.0 (including) | 14.24 (excluding) |
| Postgresql | Postgresql | 15.0 (including) | 15.19 (excluding) |
| Postgresql | Postgresql | 16.0 (including) | 16.15 (excluding) |
| Postgresql | Postgresql | 17.0 (including) | 17.11 (excluding) |
| Postgresql | Postgresql | 18.0 (including) | 18.5 (excluding) |
| Red Hat Enterprise Linux 10 | RedHat | postgresql18-0:18.6-1.el10_2 | * |
| Red Hat Enterprise Linux 10 | RedHat | postgresql16-0:16.15-1.el10_2 | * |
| Red Hat Enterprise Linux 8 | RedHat | postgresql:16-8100020260910192321.489197e6 | * |
| Red Hat Enterprise Linux 8 | RedHat | postgresql:15-8100020260906175012.489197e6 | * |
| Red Hat Enterprise Linux 8 | RedHat | postgresql:12-8100020260917081510.489197e6 | * |
| Red Hat Enterprise Linux 8.8 Telecommunications Update Service | RedHat | postgresql:15-8080020260921162003.63b34585 | * |
| Red Hat Enterprise Linux 8.8 Update Services for SAP Solutions | RedHat | postgresql:15-8080020260921162003.63b34585 | * |
| Red Hat Enterprise Linux 9 | RedHat | postgresql:16-9080020260907191505.rhel9 | * |
| Red Hat Enterprise Linux 9 | RedHat | postgresql:18-9080020260914093252.rhel9 | * |
| Red Hat Enterprise Linux 9 | RedHat | postgresql-0:13.23-6.el9_8 | * |
| Red Hat Enterprise Linux 9 | RedHat | postgresql:15-9080020260903073937.rhel9 | * |
| Red Hat Enterprise Linux 9.2 Update Services for SAP Solutions | RedHat | postgresql:15-9020020260917092006.rhel9 | * |
| Red Hat Enterprise Linux 9.4 Update Services for SAP Solutions | RedHat | postgresql:15-9040020260917091622.rhel9 | * |
| Red Hat Enterprise Linux 9.4 Update Services for SAP Solutions | RedHat | postgresql:16-9040020260922062609.rhel9 | * |
| Red Hat Enterprise Linux 9.6 Extended Update Support | RedHat | postgresql:15-9060020260917102335.rhel9 | * |
| Red Hat Enterprise Linux 9.6 Extended Update Support | RedHat | postgresql:16-9060020260921091101.rhel9 | * |
| Red Hat Update Infrastructure 5 | RedHat | rhui5/rhua-rhel9:1790242004 | * |
| Postgresql-10 | Ubuntu | upstream | * |
| Postgresql-12 | Ubuntu | upstream | * |
| Postgresql-14 | Ubuntu | jammy | * |
| Postgresql-16 | Ubuntu | noble | * |
| Postgresql-18 | Ubuntu | devel | * |
| Postgresql-18 | Ubuntu | resolute | * |
| Postgresql-9.3 | Ubuntu | upstream | * |
| Postgresql-9.5 | Ubuntu | upstream | * |
Potential Mitigations
- Use a language that does not allow this weakness to occur or provides constructs that make this weakness easier to avoid.
- If possible, choose a language or compiler that performs automatic bounds checking.
- Use a vetted library or framework that does not allow this weakness to occur or provides constructs that make this weakness easier to avoid [REF-1482].
- Use libraries or frameworks that make it easier to handle numbers without unexpected consequences.
- Examples include safe integer handling packages such as SafeInt (C++) or IntegerLib (C or C++). [REF-106]
- Perform input validation on any numeric input by ensuring that it is within the expected range. Enforce that the input meets both the minimum and maximum requirements for the expected range.
- Use unsigned integers where possible. This makes it easier to perform validation for integer overflows. When signed integers are required, ensure that the range check includes minimum values as well as maximum values.
- Understand the programming language’s underlying representation and how it interacts with numeric calculation (CWE-681). Pay close attention to byte size discrepancies, precision, signed/unsigned distinctions, truncation, conversion and casting between types, “not-a-number” calculations, and how the language handles numbers that are too large or too small for its underlying representation. [REF-7]
- Also be careful to account for 32-bit, 64-bit, and other potential differences that may affect the numeric representation.