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

The toSQL method of the org.apache.derby.vti.Restriction class does not output correct constants for VARCHAR, Timestamp, Date, Time, or CHAR FOR BIT DATA types

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.8.1.2
    • 10.8.3.0, 10.9.1.0
    • SQL
    • None
    • Urgent

    Description

      The toSQL method of the org.apache.derby.vti.Restriction class does not output correct constants for VARCHAR, Timestamp, Date, Time, or CHAR FOR BIT DATA types. This method is useful for building the WHERE clause when implementing a Restricted Table Function. The result of calling the toSQL method with restrictions on columns of these types does not produce valid SQL constants. For example with a VARCHAR column being restricted the single quote characters are not placed round the string constant.

      Attachments

        1. derby-5370.diff
          1 kB
          Brett Bergquist
        2. derby-5370-01-aa-withTest.diff
          25 kB
          Richard N. Hillegas

        Activity

          People

            bbergquist Brett Bergquist
            bbergquist Brett Bergquist
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: