Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-3894

Reference Manual: supported functions should be listed in JDBC escape syntax topic

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.4.2.0
    • Fix Version/s: 10.5.1.1
    • Component/s: Documentation
    • Labels:
      None

      Description

      The topic "JDBC escape syntax for fn keyword" (http://db.apache.org/derby/docs/dev/ref/rrefjdbc88908.html) does not include all the functions listed in Appendix C of the JDBC specification that Derby supports.

      The following numeric functions, listed in Section C.1, are implemented in Derby but not listed in this topic:

      COT(float)
      RAND(integer)
      SIGN(number)

      Three numeric functions listed in Section C.1 are not yet implemented in Derby; they should be added to this topic when they are. (See DERBY-3893.)

      A number of the string functions listed in Section C.2 are not implemented in Derby. Of the ones that are, the following are not listed in the JDBC escape syntax topic:

      LCASE(string)
      LENGTH(string)
      LTRIM(string)
      RTRIM(string)
      UCASE(string)

      Some of the time and date functions listed in Section C.3 are not implemented in Derby. Of the ones that are, only two (TIMESTAMPADD and TIMESTAMPDIFF) are listed in the JDBC escape syntax topic. The following should be added:

      CURDATE()
      CURTIME()
      HOUR(time)
      MINUTE(time)
      MONTH(date)
      SECOND(time)
      YEAR(date)

      Two of the three system functions listed in Section C.4 are not implemented in Derby. The one that is, USER(), is not listed in the JDBC escape syntax topic.

      The functions should be listed in groups by type of function, and the fonts should conform with Derby documentation style.

        Attachments

        1. DERBY-3894.diff
          34 kB
          Camilla Haase
        2. rrefjdbc88908.html
          25 kB
          Camilla Haase
        3. DERBY-3894-2.diff
          34 kB
          Camilla Haase
        4. rrefjdbc88908.html
          25 kB
          Camilla Haase

          Activity

            People

            • Assignee:
              chaase3 Camilla Haase
              Reporter:
              chaase3 Camilla Haase
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: