Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Date: Mon, 15 Apr 2013 21:12:16 +0000 (UTC)
From: "Mamta A. Satoor (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Message-ID: <JIRA.12642582.1366050451665.169917.1366060336768@arcas>
In-Reply-To: <JIRA.12642582.1366050451665@arcas>
References: <JIRA.12642582.1366050451665@arcas>
Subject: [jira] [Commented] (DERBY-6183) rlliso2multi and rlliso3multi
 failing with [WARNING 01004: Data truncation]
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-6183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13632196#comment-13632196 ] 

Mamta A. Satoor commented on DERBY-6183:
----------------------------------------

I briefly looked at Derby code and see that only place where we do anything with data truncation error is in org.apache.derby.client.am.SqlException:SqlException method as shown below

    /**
     * Create one of the exceptions in an exception chain generated by the
     * engine. This constructor calls itself recursively to create the rest of
     * the exception chain if <code>chain</code> is <code>true</code>.
     *
     * @param sqlca the SQLCA sent from the server
     * @param number the message number for this exception (counting from 0)
     * @param chain if <code>true</code>, generate the rest of the exception
     * chain recursively and link it to this exception
     */
    private SqlException(Sqlca sqlca, int number, boolean chain) {
        this.sqlca_ = sqlca;
        messageNumber_ = number;
        sqlstate_ = sqlca.getSqlState(number);

        // If the SQLState indicates that this is a java.sql.DataTruncation
        // type of exception, generate one right away.
        if (SQLState.DATA_TRUNCATION_READ.equals(sqlstate_)) {
            wrappedException_ = sqlca.getDataTruncation();
        }

        int nextMsg = number + 1;
        if (chain && (sqlca.numberOfMessages() > nextMsg)) {
            setThrowable(new SqlException(sqlca, nextMsg, true));
        }
    }

But the two tests in this jira are failing in embedded mode and there is nothing in the derby.log or error trace output about where the exception is being generated. This is not much info but wanted to share what I have seen so far.
                
> rlliso2multi and rlliso3multi failing with [WARNING 01004: Data truncation]
> ---------------------------------------------------------------------------
>
>                 Key: DERBY-6183
>                 URL: https://issues.apache.org/jira/browse/DERBY-6183
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.10.1.2
>         Environment: Windows XP with IBM jdk 1.7
>            Reporter: Mamta A. Satoor
>         Attachments: derbyFor_rlliso2multi.log, derbyFor_rlliso3multi.log, error-stacktraceFor_rlliso2multi.out, error-stacktraceFor_rlliso3multi.out
>
>
> 1) rlliso2multi(org.apache.derbyTesting.functionTests.tests.store.StoreScriptsTest)junit.framework.ComparisonFailure: Output at line 1188 expected:<[TABLE   |1  |IX  |TEST_11     |Tablelock |GRANT]> but was:<[WARNING 01004: Data truncation]>
> 	at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:109)
> 	at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:204)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:117)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:442)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:459)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> 2) rlliso3multi(org.apache.derbyTesting.functionTests.tests.store.StoreScriptsTest)junit.framework.ComparisonFailure: Output at line 602 expected:<[TABLE   |1  |IX  |TEST_6      |Tablelock |GRANT]> but was:<[WARNING 01004: Data truncation]>
> 	at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:109)
> 	at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:204)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:117)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:442)
> 	at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:459)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira