Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.4.0
    • Fix Version/s: 1.4.0
    • Component/s: Table SQL / API
    • Labels:
      None

      Description

      LOG(X), LOG(B,X)

      If called with one parameter, this function returns the natural logarithm of X. If X is less than or equal to 0.0E0, the function returns NULL and (as of MySQL 5.7.4) a warning “Invalid argument for logarithm” is reported.
      The inverse of this function (when called with a single argument) is the EXP() function.

      If called with two parameters, this function returns the logarithm of X to the base B. If X is less than or equal to 0, or if B is less than or equal to 1, then NULL is returned.

      • Example:
        LOG(2) -> 0.69314718055995
        LOG(-2) -> NULL
        LOG(2,65536) -> 16
        LOG(10,100) -> 2
        LOG(1,100) -> NULL

      -NOTE- In this JIRA. NULL case will throw IllegalArgumentException.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sunjincheng121 sunjincheng
                Reporter:
                sunjincheng121 sunjincheng
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: