db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Closed: (DERBY-3773) ImportExportLobTest failed on Zos Clobs differ at index 1 expected:<99> but was:<196>
Date Fri, 11 Jul 2008 16:02:31 GMT

     [ https://issues.apache.org/jira/browse/DERBY-3773?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kathey Marsden closed DERBY-3773.
---------------------------------

       Resolution: Fixed
    Fix Version/s: 10.5.0.0
                   10.4.1.4
                   10.3.3.1
         Assignee: Kathey Marsden

> ImportExportLobTest failed on Zos  Clobs differ at index 1 expected:<99> but was:<196>
> --------------------------------------------------------------------------------------
>
>                 Key: DERBY-3773
>                 URL: https://issues.apache.org/jira/browse/DERBY-3773
>             Project: Derby
>          Issue Type: Bug
>          Components: Test, Tools
>    Affects Versions: 10.3.3.1, 10.4.1.4, 10.5.0.0
>         Environment: IBM 1.5
>            Reporter: Kathey Marsden
>            Assignee: Kathey Marsden
>             Fix For: 10.3.3.1, 10.4.1.4, 10.5.0.0
>
>
> testImportDataExportQueryLobsInExtFile(org.apache.derbyTesting.f
> unctionTests.tests.tools.ImportExportLobTest)junit.framework.Ass
> ertionFailedError: Clobs differ at index 1 expected:<99> but 
> was:<196>
> 	at 
> org.apache.derbyTesting.junit.BaseJDBCTestCase.assertEquals(Base
> JDBCTestCase.java:693)
> 	at 
> org.apache.derbyTesting.junit.JDBC.assertSameContents(JDBC.java:
> 1139)
> 	at 
> org.apache.derbyTesting.functionTests.tests.tools.ImportExportLo
> bTest.verifyData(ImportExportLobTest.java:534)
> 	at 
> org.apache.derbyTesting.functionTests.tests.tools.ImportExportLo
> bTest.testImportDataExportQueryLobsInExtFile(ImportExportLobTest
> .java:341)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native 
> Method)
> 	at 
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
> Impl.java:59)
> 	at 
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
> AccessorImpl.java:39)
> 	at 
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.
> java:101)
> 	at 
> junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> 	at junit.extensions.TestSetup.run(TestSetup.java:23)
> 	at 
> junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> 	at junit.extensions.TestSetup.run(TestSetup.java:23)
> I ran on Windows with -Dfile.encoding="UTF-16" and got a different error.
> 1) testImportDataExportQueryLobsInExtFile(org.apache.derbyTesting.functionTests.tests.tools.ImportExportLobTest)java.sql
> .SQLException: The exception 'java.sql.SQLException: Column 'COLUMN4' is either not in
any table in the FROM list or app
> ears within a join specification and is outside the scope of the join specification or
appears in a HAVING clause and is
>  not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'COLUMN4'
is not a column in the target ta
> ble.' was thrown while evaluating an expression.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:95)
>         at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:87)
>         at org.apache.derby.impl.jdbc.Util.seeNextException(Util.java:223)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:398)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
>         at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2183)
>         at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
>         at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1325)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1652)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(EmbedPreparedStatement.java:1307)
>         at org.apache.derbyTesting.functionTests.tests.tools.ImportExportBaseTest.doImportDataLobsFromExtFile(ImportExpo
> rtBaseTest.java:258)
>         at org.apache.derbyTesting.functionTests.tests.tools.ImportExportLobTest.testImportDataExportQueryLobsInExtFile(
> ImportExportLobTest.java:339)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:104)
>         at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>         at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>         at junit.extensions.TestSetup.run(TestSetup.java:23)
>         at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>         at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>         at junit.extensions.TestSetup.run(TestSetup.java:23)
>         at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> Caused by: java.sql.SQLException: The exception 'java.sql.SQLException: Column 'COLUMN4'
is either not in any table in t
> he FROM list or appears within a join specification and is outside the scope of the join
specification or appears in a H
> AVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement
then 'COLUMN4' is not a colu
> mn in the target table.' was thrown while evaluating an expression.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:11
> 9)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
>         ... 36 more
> Caused by: java.sql.SQLException: Column 'COLUMN4' is either not in any table in the
FROM list or appears within a join
> specification and is outside the scope of the join specification or appears in a HAVING
clause and is not in the GROUP B
> Y list. If this is a CREATE or ALTER TABLE  statement then 'COLUMN4' is not a column
in the target table.
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:11
> 9)
>         at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:70)
>         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:201)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
>         at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2183)
>         at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:146)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(EmbedPreparedStatement40.java:40)
>         at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Driver40.java:105)
>         at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1533)
>         at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1361)
>         at org.apache.derby.impl.load.Import.performImport(Import.java:274)
>         at org.apache.derby.impl.load.Import.importData(Import.java:166)
>         at org.apache.derby.catalog.SystemProcedures.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE(SystemProcedures.java:1538)
>         at org.apache.derby.exe.acaa7ac093x011bx0970x9cd2x00003dcd3cb42.g0(Unknown Source)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(ReflectMethod.java:46)
>         at org.apache.derby.impl.sql.execute.CallStatementResultSet.open(CallStatementResultSet.java:76)
>         at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:384)
>         at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235)
>         ... 29 more
> Caused by: ERROR 42X04: Column 'COLUMN4' is either not in any table in the FROM list
or appears within a join specificat
> ion and is outside the scope of the join specification or appears in a HAVING clause
and is not in the GROUP BY list. If
>  this is a CREATE or ALTER TABLE  statement then 'COLUMN4' is not a column in the target
table.
>         at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:286)
>         at org.apache.derby.impl.sql.compile.ColumnReference.bindExpression(ColumnReference.java:354)
>         at org.apache.derby.impl.sql.compile.ResultColumn.bindExpression(ResultColumn.java:588)
>         at org.apache.derby.impl.sql.compile.ResultColumnList.bindExpressions(ResultColumnList.java:693)
>         at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(SelectNode.java:443)
>         at org.apache.derby.impl.sql.compile.SelectNode.bindExpressionsWithTables(SelectNode.java:578)
>         at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressionsWithTables(DMLStatementNode.java:251)
>         at org.apache.derby.impl.sql.compile.DMLStatementNode.bindResultSetsWithTables(DMLStatementNode.java:175)
>         at org.apache.derby.impl.sql.compile.InsertNode.bindStatement(InsertNode.java:242)
>         at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:314)
>         at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
>         at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConne
> ctionContext.java:794)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
>         ... 47 more
> 2) testImportDataExportQueryLobsInExtFile(org.apache.derbyTesting.functionTests.tests.tools.ImportExportLobTest)java.sql
> .SQLException: The exception 'java.sql.SQLException: Column 'COLUMN4' is either not in
any table in the FROM list or app
> ears within a join specification and is outside the scope of the join specification or
appears in a HAVING clause and is
>  not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'COLUMN4'
is not a column in the target ta
> ble.' was thrown while evaluating an expression.
>         at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:96)
>         at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:362)
>         at org.apache.derby.client.am.PreparedStatement.execute(PreparedStatement.java:1588)
>         at org.apache.derbyTesting.functionTests.tests.tools.ImportExportBaseTest.doImportDataLobsFromExtFile(ImportExpo
> rtBaseTest.java:258)
>         at org.apache.derbyTesting.functionTests.tests.tools.ImportExportLobTest.testImportDataExportQueryLobsInExtFile(
> ImportExportLobTest.java:339)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:104)
>         at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>         at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>         at junit.extensions.TestSetup.run(TestSetup.java:23)
>         at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
>         at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>         at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>         at junit.extensions.TestSetup.run(TestSetup.java:23)
>         at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>         at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>         at junit.extensions.TestSetup.run(TestSetup.java:23)
>         at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
>         at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
>         at junit.extensions.TestSetup.run(TestSetup.java:23)
>         at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> Caused by: org.apache.derby.client.am.SqlException: The exception 'java.sql.SQLException:
Column 'COLUMN4' is either not
>  in any table in the FROM list or appears within a join specification and is outside
the scope of the join specification
>  or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or
ALTER TABLE  statement then 'COLU
> MN4' is not a column in the target table.' was thrown while evaluating an expression.
>         at org.apache.derby.client.am.Statement.completeExecute(Statement.java:1601)
>         at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(NetStatementReply.java:322)
>         at org.apache.derby.client.net.NetStatementReply.readExecuteCall(NetStatementReply.java:106)
>         at org.apache.derby.client.net.StatementReply.readExecuteCall(StatementReply.java:75)
>         at org.apache.derby.client.net.NetStatement.readExecuteCall_(NetStatement.java:179)
>         at org.apache.derby.client.am.Statement.readExecuteCall(Statement.java:1567)
>         at org.apache.derby.client.am.PreparedStatement.flowExecute(PreparedStatement.java:2151)
>         at org.apache.derby.client.am.PreparedStatement.executeX(PreparedStatement.java:1594)
>         at org.apache.derby.client.am.PreparedStatement.execute(PreparedStatement.java:1579)
>         ... 38 more
> Caused by: org.apache.derby.client.am.SqlException: Column 'COLUMN4' is either not in
any table in the FROM list or appe
> ars within a join specification and is outside the scope of the join specification or
appears in a HAVING clause and is
> not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'COLUMN4'
is not a column in the target tab
> le.
>         ... 47 more

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


Mime
View raw message