Derby
  1. Derby
  2. DERBY-591

Several builtin functions are incorrectly exposed through the JDBC escaped function syntax {fn <function_call>}

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.0.2.0, 10.1.1.0, 10.3.1.4, 10.4.1.3
    • Fix Version/s: None
    • Component/s: JDBC, SQL
    • Urgency:
      Normal
    • Bug behavior facts:
      Deviation from standard

      Description

      Due to lack of direction in the way functions are added into the parser, any functions that are added into the parser's miscBuiltinsCore are also automatically JDBC/ODBC escaped functions.

      E.g. the new XML functions (e.g. XMLPARSE), COALESCE, VALUE etc. etc.

      The correct set of escaped scaler functions is defined in appendex C (C1- C5) of JDBC 3.0.

      Discovered this while trying to make the JDBC escape functions table driven, at least for the valid subset of table driven functions added in DERBY-475.

      Probably just need to split the miscBuiltins core into two functions, one for functions that are SQL and allowed in JDBC escape, and one for ones only allowed in SQL.

        Issue Links

          Activity

          Daniel John Debrunner created issue -
          Daniel John Debrunner made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-475 [ DERBY-475 ]
          Daniel John Debrunner made changes -
          Link This issue is related to DERBY-471 [ DERBY-471 ]
          Mike Matrigali made changes -
          Component/s JDBC [ 11407 ]
          Component/s SQL [ 11408 ]
          Satheesh Bandaram made changes -
          Assignee Satheesh Bandaram [ bandaram ]
          Satheesh Bandaram made changes -
          Assignee Satheesh Bandaram [ bandaram ]
          Kristian Waagan made changes -
          Affects Version/s 10.3.1.4 [ 12312590 ]
          Fix Version/s 10.4.0.0 [ 12312540 ]
          Assignee Kristian Waagan [ kristwaa ]
          Kristian Waagan made changes -
          Affects Version/s 10.4.0.0 [ 12312540 ]
          Kristian Waagan made changes -
          Assignee Kristian Waagan [ kristwaa ]
          Dyre Tjeldvoll made changes -
          Fix Version/s 10.4.0.0 [ 12312540 ]
          Mike Matrigali made changes -
          Urgency Normal
          Bug behavior facts [Deviation from standard]
          Kathey Marsden made changes -
          Labels derby_triage10_5_2
          Gavin made changes -
          Workflow jira [ 12330622 ] Default workflow, editable Closed status [ 12798743 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              Daniel John Debrunner
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:

                Development