Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 84D0E8AD9 for ; Fri, 26 Aug 2011 19:05:54 +0000 (UTC) Received: (qmail 42582 invoked by uid 500); 26 Aug 2011 19:05:54 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 42308 invoked by uid 500); 26 Aug 2011 19:05:53 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 42090 invoked by uid 99); 26 Aug 2011 19:05:53 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Aug 2011 19:05:53 +0000 X-ASF-Spam-Status: No, hits=-2000.9 required=5.0 tests=ALL_TRUSTED,RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Aug 2011 19:05:50 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 85653D1E5F for ; Fri, 26 Aug 2011 19:05:29 +0000 (UTC) Date: Fri, 26 Aug 2011 19:05:29 +0000 (UTC) From: "Rick Hillegas (JIRA)" To: derby-dev@db.apache.org Message-ID: <569603602.18761.1314385529542.JavaMail.tomcat@hel.zones.apache.org> In-Reply-To: <1905430244.1433.1312292487208.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Resolved] (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 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-5370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas resolved DERBY-5370. ---------------------------------- Resolution: Fixed > 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 > --------------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-5370 > URL: https://issues.apache.org/jira/browse/DERBY-5370 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.8.1.2 > Reporter: Brett Bergquist > Attachments: derby-5370-01-aa-withTest.diff, derby-5370.diff > > > 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. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira