Changes between Version 37 and Version 38 of Ticket #28643


Ignore:
Timestamp:
Mar 22, 2018, 7:23:43 PM (7 years ago)
Author:
Nick Pope
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #28643 – Description

    v37 v38  
    55This is just a sample checklist, with corresponding attributes to which backend has them available.
    66
    7 ||||||||||||||= **Comparison** =||
    8 ||**Name**||**Description**||**PostgreSQL**||**Oracle**||**MySQL**||**SQLite**||**PR**||
    9 ||{{{NULLIF}}}||Returns {{{NULL}}} if the first argument equals the second.||‎✔||‎✔||‎✔||‎✔||[https://github.com/django/django/pull/9543 9543]||
    10 ||||||||||||||= **Math** =||
    11 ||**Name**||**Description**||**PostgreSQL**||**Oracle**||**MySQL**||**SQLite**||**PR**||
    12 ||{{{ABS}}}||Returns the absolute value.||‎✔||‎✔||‎✔||‎✔||[https://github.com/django/django/pull/9577 9577], [https://github.com/django/django/pull/9622 9622]||
    13 ||{{{ACOS}}}||Returns the arccosine.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
    14 ||{{{ASIN}}}||Returns the arcsine.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
    15 ||{{{ATAN}}}||Returns the arctangent.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
    16 ||{{{ATAN2}}}||Returns the arctangent of the two variables passed to it.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
    17 ||{{{CEILING}}}||Returns the smallest integer value that is not less than a numeric expression||‎✔||{{{CEIL}}}||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
    18 ||{{{COS}}}||Returns the cosine expressed in radians.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
    19 ||{{{COT}}}||Returns the cotangent.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
    20 ||{{{DEGREES}}}||Returns a numeric expression converted from radians to degrees.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
    21 ||{{{EXP}}}||Returns the base of the natural logarithm (e) raised to the power of a numeric expression.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
    22 ||{{{FLOOR}}}||Returns the largest integer value that is not greater than a numeric expression.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
    23 ||{{{LOG}}}||Returns the natural logarithm of a numeric expression.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
    24 ||{{{MOD}}}||Returns the remainder of one expression by diving by another expression.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
    25 ||{{{PI}}}||Returns the value of π||‎✔||-||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
    26 ||{{{POWER}}}||Returns the value of one expression raised to the power of another expression||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
    27 ||{{{RADIANS}}}||Returns the value of an expression converted from degrees to radians.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
    28 ||{{{ROUND}}}||Returns a numeric expression rounded to an integer.\\Can be used to round an expression to a number of decimal points||‎✔||‎✔||‎✔||‎✔||[https://github.com/django/django/pull/9622 9622]||
    29 ||{{{SIN}}}||Returns the sine given in radians.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
    30 ||{{{SQRT}}}||Returns the square root.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
    31 ||{{{TAN}}}||Returns the tangent expressed in radians.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
    32 ||||||||||||||= **Text** =||
    33 ||**Name**||**Description**||**PostgreSQL**||**Oracle**||**MySQL**||**SQLite**||**PR**||
    34 ||{{{ASCII}}}||Returns numeric value of left-most character. (Equivalent to {{{ord()}}} in Python.)||‎✔||‎✔||‎✔||{{{UNICODE}}}||[https://github.com/django/django/pull/9583 9583]||
    35 ||{{{CHR}}}||Character with the given code||‎✔||‎✔||{{{CHAR}}}||{{{CHAR}}}||[https://github.com/django/django/pull/9583 9583]||
    36 ||{{{LEFT}}}||Returns the leftmost number of characters as specified||‎✔||✔**^2^**||‎✔||✔**^2^**||[https://github.com/django/django/pull/9583 9583]||
    37 ||{{{LPAD}}}||Returns the string argument, left-padded with the specified string||‎✔||‎✔||‎✔||-||[https://github.com/django/django/pull/9798 9798]||
    38 ||{{{LTRIM}}}||Removes leading spaces||‎✔||‎✔||‎✔||‎✔||[https://github.com/django/django/pull/9220 9220]||
    39 ||{{{MD5}}}||Calculates the MD5 hash of string, returning the result in hexadecimal||‎✔||-||-||✔**^1^**||-||
    40 ||{{{REPEAT}}}||Repeats a string the specified number of times||‎✔||-||‎✔||✔**^1^**||[https://github.com/django/django/pull/9808 9808]||
    41 ||{{{REPLACE}}}||Replaces occurrences of a specified string||‎✔||‎✔||‎✔||‎✔||[https://github.com/django/django/pull/9539 9539] [[span(style=font-size:75%, (Merged))]]||
    42 ||{{{REVERSE}}}||Reverse the characters in a string||‎✔||-||‎✔||✔**^1^**||-||
    43 ||{{{RIGHT}}}||Returns the specified rightmost number of characters||‎✔||✔**^2^**||‎✔||✔**^2^**||[https://github.com/django/django/pull/9583 9583]||
    44 ||{{{RPAD}}}||Appends string the specified number of times||‎✔||‎✔||‎✔||-||[https://github.com/django/django/pull/9798 9798]||
    45 ||{{{RTRIM}}}||Removes trailing spaces||‎✔||‎✔||‎✔||‎✔||[https://github.com/django/django/pull/9220 9220]||
    46 ||{{{TRIM}}}||Removes leading and trailing spaces||‎✔||‎✔||‎✔||‎✔||[https://github.com/django/django/pull/9220 9220]||
     7||||||||||||||||= **Comparison** =||
     8||**Django**||**SQL**||**Description**||**PostgreSQL**||**Oracle**||**MySQL**||**SQLite**||**PR**||
     9||{{{NullIf}}}||{{{NULLIF}}}||Returns {{{NULL}}} if the first argument equals the second.||‎✔||‎✔||‎✔||‎✔||[https://github.com/django/django/pull/9543 9543]||
     10||||||||||||||||= **Math** =||
     11||**Django**||**SQL**||**Description**||**PostgreSQL**||**Oracle**||**MySQL**||**SQLite**||**PR**||
     12||{{{Abs}}}||{{{ABS}}}||Returns the absolute value.||‎✔||‎✔||‎✔||‎✔||[https://github.com/django/django/pull/9622 9622]||
     13||{{{ACos}}}||{{{ACOS}}}||Returns the arccosine.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     14||{{{ASin}}}||{{{ASIN}}}||Returns the arcsine.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     15||{{{ATan}}}||{{{ATAN}}}||Returns the arctangent.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     16||{{{ATan2}}}||{{{ATAN2}}}||Returns the arctangent of the two variables passed to it.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     17||{{{Ceil}}}||{{{CEILING}}}||Returns the smallest integer value that is not less than a numeric expression||‎✔||{{{CEIL}}}||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     18||{{{Cos}}}||{{{COS}}}||Returns the cosine expressed in radians.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     19||{{{Cot}}}||{{{COT}}}||Returns the cotangent.||‎✔||‎✔**^5^**||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     20||{{{Degrees}}}||{{{DEGREES}}}||Returns a numeric expression converted from radians to degrees.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     21||{{{Exp}}}||{{{EXP}}}||Returns the base of the natural logarithm (e) raised to the power of a numeric expression.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     22||{{{Floor}}}||{{{FLOOR}}}||Returns the largest integer value that is not greater than a numeric expression.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     23||{{{Ln}}}||{{{LN}}}||Returns the natural logarithm of a numeric expression.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     24||{{{Log}}}||{{{LOG(B, X)}}}||Returns the logarithm of a numeric expression.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     25||{{{Mod}}}||{{{MOD}}}||Returns the remainder of one expression by diving by another expression.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     26||{{{Pi}}}||{{{PI}}}||Returns the value of π||‎✔||✔**^4^**||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     27||{{{Power}}}||{{{POWER}}}||Returns the value of one expression raised to the power of another expression||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     28||{{{Radians}}}||{{{RADIANS}}}||Returns the value of an expression converted from degrees to radians.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     29||{{{Round}}}||{{{ROUND}}}||Returns a numeric expression rounded to an integer.\\Can be used to round an expression to a number of decimal points||‎✔||‎✔||‎✔||‎✔||[https://github.com/django/django/pull/9622 9622]||
     30||{{{Sin}}}||{{{SIN}}}||Returns the sine given in radians.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     31||{{{Sqrt}}}||{{{SQRT}}}||Returns the square root.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     32||{{{Tan}}}||{{{TAN}}}||Returns the tangent expressed in radians.||‎✔||‎✔||‎✔||✔**^1^**||[https://github.com/django/django/pull/9622 9622]||
     33||||||||||||||||= **Text** =||
     34||**Django**||**SQL**||**Description**||**PostgreSQL**||**Oracle**||**MySQL**||**SQLite**||**PR**||
     35||{{{Ord}}}||{{{ASCII}}}||Returns numeric value of left-most character. (Equivalent to {{{ord()}}} in Python.)||‎✔||‎✔||‎✔||{{{UNICODE}}}||~~9583~~||
     36||{{{Chr}}}||{{{CHR}}}||Character with the given code||‎✔||‎✔||{{{CHAR}}}||{{{CHAR}}}||~~9583~~||
     37||{{{Left}}}||{{{LEFT}}}||Returns the leftmost number of characters as specified||‎✔||✔**^2^**||‎✔||✔**^2^**||~~9583~~||
     38||{{{LPad}}}||{{{LPAD}}}||Returns the string argument, left-padded with the specified string||‎✔||‎✔||‎✔||✔**^1^**||~~9798~~||
     39||{{{LTrim}}}||{{{LTRIM}}}||Removes leading spaces||‎✔||‎✔||‎✔||‎✔||~~9220~~||
     40||{{{MD5}}}||{{{MD5}}}||Calculates the MD5 hash of string, returning the result in hexadecimal||‎✔||-||-||✔**^1^**||-||
     41||{{{Repeat}}}||{{{REPEAT}}}||Repeats a string the specified number of times||‎✔||✔**^3^**||‎✔||✔**^1^**||[https://github.com/django/django/pull/9808 9808]||
     42||{{{Replace}}}||{{{REPLACE}}}||Replaces occurrences of a specified string||‎✔||‎✔||‎✔||‎✔||~~9539~~||
     43||{{{Reverse}}}||{{{REVERSE}}}||Reverse the characters in a string||‎✔||-||‎✔||✔**^1^**||-||
     44||{{{Right}}}||{{{RIGHT}}}||Returns the specified rightmost number of characters||‎✔||✔**^2^**||‎✔||✔**^2^**||~~9583~~||
     45||{{{RPad}}}||{{{RPAD}}}||Appends string the specified number of times||‎✔||‎✔||‎✔||✔**^1^**||~~9798~~||
     46||{{{RTrim}}}||{{{RTRIM}}}||Removes trailing spaces||‎✔||‎✔||‎✔||‎✔||~~9220~~||
     47||{{{Trim}}}||{{{TRIM}}}||Removes leading and trailing spaces||‎✔||‎✔||‎✔||‎✔||~~9220~~||
    4748
    4849- **^1^** Function can be easily supported on SQLite with a [https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection.create_function user defined function].
    4950- **^2^** Behaviour can be emulated by using {{{SUBSTR}}}.
     51- **^3^** Behaviour can be emulated by using {{{LENGTH}}} and {{{RPAD}}}.
     52- **^4^** Behaviour can be emulated by directly substituting constant {{{math.pi}}}.
     53- **^5^** Behaviour can be emulated by using {{{1 / TAN(X)}}}.
Back to Top