Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <29711394.1184354044764.JavaMail.jira@brutus>
Date: Fri, 13 Jul 2007 12:14:04 -0700 (PDT)
From: "Daniel John Debrunner (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Created: (DERBY-2937) ERROR 22011: The second or third
 argument of the SUBSTR function is out of range   with data concatenation
 in group by query.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

ERROR 22011: The second or third argument of the SUBSTR function is out of range   with data concatenation in group by query.
-----------------------------------------------------------------------------------------------------------------------------

                 Key: DERBY-2937
                 URL: https://issues.apache.org/jira/browse/DERBY-2937
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.4.0.0
            Reporter: Daniel John Debrunner
            Assignee: Daniel John Debrunner


CREATE TABLE A (C CHAR(10) NOT NULL, D DATE NOT NULL, DC DECIMAL(6,2));
INSERT INTO A  VALUES ('aaa', DATE('2007-07-10'), 500.00);     
SELECT A.C, SUBSTR (MAX(CAST(A.D AS CHAR(10)) || CAST(A.DC AS CHAR(8))), 11, 8) AS BUG
 FROM A GROUP BY A.C;

results in a 22011 error on the select.

ij> C         |BUG
-------------------
ERROR 22011: The second or third argument of the SUBSTR function is out of range

Note that the ResultSetMetaData seems to indicate to ij that the column width of "BUG' is four instead of 18.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.