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 Bug
    • Status: Closed
    • Priority: Major 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.

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

        Activity

        No work has yet been logged on this issue.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development