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

There is no way to escape the special _ and % characters in DatabaseMetaData search strings

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 10.10.1.1
    • None
    • JDBC
    • Normal
    • Release Note Needed
    • Seen in production

    Description

      And DatabaseMetaData.getSearchStringEscape() returns an empty string. We should add a way to configure a search string escape character. See the discussion on this email thread: http://old.nabble.com/derby-getProcedureColumns-td34176144.html#a34176144

      Attachments

        Issue Links

        is related to

        Bug - A problem which impairs or prevents the functions of the product. DERBY-5875 Derby returns wrong results when you set the ESCAPE character to NULL in a LIKE clause.

        • Major - Major loss of function.
        • Open

        Bug - A problem which impairs or prevents the functions of the product. DERBY-5869 getProcedureColumns doesn't handle escaping in patterns correctly

        • Major - Major loss of function.
        • Closed

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            rhillegas Richard N. Hillegas
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Slack

                Issue deployment