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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.8.1.2
    • Fix Version/s: 10.8.3.0, 10.9.1.0
    • Component/s: SQL
    • Labels:
      None
    • Urgency:
      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
          Rick Hillegas

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: