Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 52142 invoked from network); 26 Jul 2006 01:26:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 26 Jul 2006 01:26:48 -0000 Received: (qmail 14654 invoked by uid 500); 26 Jul 2006 01:26:37 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 14615 invoked by uid 500); 26 Jul 2006 01:26:37 -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 14601 invoked by uid 99); 26 Jul 2006 01:26:37 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 25 Jul 2006 18:26:37 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [209.237.227.198] (HELO brutus.apache.org) (209.237.227.198) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 25 Jul 2006 18:26:35 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 39E9C71428E for ; Wed, 26 Jul 2006 01:24:15 +0000 (GMT) Message-ID: <18802411.1153877055234.JavaMail.jira@brutus> Date: Tue, 25 Jul 2006 18:24:15 -0700 (PDT) From: "Yip Ng (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Commented: (DERBY-1587) INTEGER function cannot be abbreviated In-Reply-To: <16732323.1153838414363.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N [ http://issues.apache.org/jira/browse/DERBY-1587?page=comments#action_12423502 ] Yip Ng commented on DERBY-1587: ------------------------------- I think it could possibly be a doc error before which then makes the master files correct in 10.1.3.1 and onward. > INTEGER function cannot be abbreviated > -------------------------------------- > > Key: DERBY-1587 > URL: http://issues.apache.org/jira/browse/DERBY-1587 > Project: Derby > Issue Type: Bug > Components: SQL > Affects Versions: 10.1.3.1 > Reporter: Christian d'Heureuse > Assigned To: Yip Ng > Priority: Minor > Attachments: derby1587trunkdiff1.txt, derby1587trunkstat1.txt > > > The reference manual (http://db.apache.org/derby/docs/10.1/ref/rrefbuiltinteger.html) states that the INTEGER function can be abbreviated by INT, but Derby 10.1.3.1 does not accept that. > Example: > VALUES INTEGER(1.5); > -> OK > VALUES INT(1.5); > -> ERROR 42X80: VALUES clause must contain at least one element. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira