[DERBY-2611] upgrade test incorrectly tries to test in place compress in 10.0 release.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.3.1.4
• Fix Version/s: 10.3.1.4
• Component/s: Test

Environment

windows XP, single processor laptop, ibm15 JVM
m1_ibm15:30>sysinfo
------------------ Java Information ------------------
Java Version: 1.5.0
Java Vendor: IBM Corporation
Java home: c:\p4\m1\ibm15\jre
Java classpath: c:/p4/m1/classes;c:/p4/m1/tools/java/jdbctests.zip;c:/p4/m1/too
ls/java/jakarta-oro-2.0.8.jar;c:/p4/m1/tools/java/jgl3.1.0.jar;c:/p4/m1/tools/ja
va/jndi/providerutil.jar;c:/p4/m1/tools/java/jndi/ldap.jar;c:/p4/m1/tools/java/j
ndi/jndi.jar;c:/p4/m1/tools/java/jnl1.0F.zip;c:/p4/m1/tools/java/junit.jar;c:/p4
/m1/tools/java/servlet-2_2b.jar;c:/p4/m1/tools/java/xslt4j-2_5_0/xercesImpl.jar;
c:/p4/m1/tools/java/xslt4j-2_5_0/xml-apis.jar;c:/p4/m1/tools/java/xslt4j-2_5_0/x
alan.jar
OS name: Windows XP
OS architecture: x86
OS version: 5.1 build 2600 Service Pack 2
Java user name: mikem
Java user home: C:\Documents and Settings\Administrator
Java user dir: C:\p4\m1\systest\newout\upgrade
java.specification.name: Java Platform API Specification
java.specification.version: 1.5
--------- Derby Information --------
JRE - JDBC: J2SE 5.0 - JDBC 3.0
[C:\p4\m1\classes] 10.3.0.0 alpha - (1)
------------------------------------------------------
----------------- Locale Information -----------------
Current Locale : [English/United States [en_US]]
Found support for locale: [cs]
         version: 10.3.0.0 alpha - (1)
Found support for locale: [de_DE]
         version: 10.3.0.0 alpha - (1)
Found support for locale: [es]
         version: 10.3.0.0 alpha - (1)
Found support for locale: [fr]
         version: 10.3.0.0 alpha - (1)
Found support for locale: [hu]
         version: 10.3.0.0 alpha - (1)
Found support for locale: [it]
         version: 10.3.0.0 alpha - (1)
Found support for locale: [ja_JP]
         version: 10.3.0.0 alpha - (1)
Found support for locale: [ko_KR]
         version: 10.3.0.0 alpha - (1)
Found support for locale: [pl]
         version: 10.3.0.0 alpha - (1)
Found support for locale: [pt_BR]
         version: 10.3.0.0 alpha - (1)
Found support for locale: [ru]
         version: 10.3.0.0 alpha - (1)
Found support for locale: [zh_CN]
         version: 10.3.0.0 alpha - (1)
Found support for locale: [zh_TW]
         version: 10.3.0.0 alpha - (1)
------------------------------------------------------

• Bug behavior facts: Regression Test Failure
• Assignee: Mike Matrigali
• Reporter: Mike Matrigali
• Created: 05/May/07 00:18
• Updated: 29/Jun/09 22:42
• Resolved: 25/May/07 18:19

Description

When trying to run upgrade test in trunk with all releases available for upgrade to test found at:
https://svn.apache.org/repos/asf/db/derby/jars/10.2.2.0/

I got 4 errors (not including those that are part of DERBY-2598).:

1) testNegValueSupportedLogRecord(org.apache.derbyTesting.functionTests.tests.up
gradeTests.Changes10_3)java.sql.SQLException: 'SYSCS_UTIL.SYSCS_INPLACE_COMPRESS
_TABLE' is not recognized as a function or procedure.
at org.apache.derby.iapi.error.StandardException.newException(StandardExcept
ion.java:305)
at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Sta
ticMethodCallNode.java:224)
at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(JavaT
oSQLValueNode.java:243)
at org.apache.derby.impl.sql.compile.CallStatementNode.bindStatement(CallSta
tementNode.java:145)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.ja
va:314)
at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:
88)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareIn
ternalStatement(GenericLanguageConnectionContext.java:742)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:567
)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:516
)
at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3.chec
kDataToCase606(Changes10_3.java:177)
at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3.test
NegValueSupportedLogRecord(Changes10_3.java:118)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI
mpl.java:43)
at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
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 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 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 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)
2) testGetTablesModify(org.apache.derbyTesting.functionTests.tests.jdbcapi.Data
aseMetaDataTest)java.sql.SQLException: Use of 'XML' requires database to be upg
aded from version 10.0 to version 10.1 or later.
at org.apache.derby.iapi.error.StandardException.newException(StandardExcep
ion.java:356)
at org.apache.derby.impl.sql.catalog.DD_Version.checkVersion(DD_Version.jav
:788)
at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.checkVersion(DataDi
tionaryImpl.java:8487)
at org.apache.derby.impl.sql.compile.SQLParser.checkVersion(SQLParser.java:
00)
at org.apache.derby.impl.sql.compile.SQLParser.XMLType(SQLParser.java:4181)
at org.apache.derby.impl.sql.compile.SQLParser.dataTypeCommon(SQLParser.jav
:3607)
at org.apache.derby.impl.sql.compile.SQLParser.dataTypeDDL(SQLParser.java:3
37)
at org.apache.derby.impl.sql.compile.SQLParser.columnDefinition(SQLParser.j
va:3400)
at org.apache.derby.impl.sql.compile.SQLParser.tableElement(SQLParser.java:
368)
at org.apache.derby.impl.sql.compile.SQLParser.tableElementList(SQLParser.j
va:3209)
at org.apache.derby.impl.sql.compile.SQLParser.tableDefinition(SQLParser.ja
a:10992)
at org.apache.derby.impl.sql.compile.SQLParser.createStatements(SQLParser.j
va:1811)
at org.apache.derby.impl.sql.compile.SQLParser.StatementPart(SQLParser.java
1718)
at org.apache.derby.impl.sql.compile.SQLParser.Statement(SQLParser.java:163
)
at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(ParserImpl.j
va:151)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.j
va:280)
at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java
88)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareI
ternalStatement(GenericLanguageConnectionContext.java:742)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:56
)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:51
)
at org.apache.derbyTesting.functionTests.tests.jdbcapi.DatabaseMetaDataTest
createTablesForTest(DatabaseMetaDataTest.java:1123)
at org.apache.derbyTesting.functionTests.tests.jdbcapi.DatabaseMetaDataTest
testGetTablesModify(DatabaseMetaDataTest.java:912)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav
:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
mpl.java:43)
at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
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 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 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 junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
3) testNegValueSupportedLogRecord(org.apache.derbyTesting.functionTests.tests.up
gradeTests.Changes10_3)ERROR 42Y03: 'SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE' is
not recognized as a function or procedure.
at org.apache.derby.iapi.error.StandardException.newException(StandardExcept
ion.java)
at org.apache.derby.impl.sql.compile.StaticMethodCallNode.bindExpression(Sta
ticMethodCallNode.java)
at org.apache.derby.impl.sql.compile.JavaToSQLValueNode.bindExpression(JavaT
oSQLValueNode.java)
at org.apache.derby.impl.sql.compile.CallStatementNode.bind(CallStatementNod
e.java)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.ja
va)
at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareIn
ternalStatement(GenericLanguageConnectionContext.java)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java)
at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3.chec
kDataToCase606(Changes10_3.java:177)
at org.apache.derbyTesting.functionTests.tests.upgradeTests.Changes10_3.test
NegValueSupportedLogRecord(Changes10_3.java:122)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
:64)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI
mpl.java:43)
at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:88)
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 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 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 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)
4) Upgrade Phase: UPGRADEjava.sql.SQLException: Failed to start database 'single
Use/oneuse0', see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExcepti
onFactory.java:45)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:88)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Util.java:94)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:173)
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(EmbedConnectio
n.java:2119)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(EmbedConnection.j
ava:1783)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(EmbedConnection.java:24
9)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Driver30.java:74)
at org.apache.derby.jdbc.InternalDriver.connect(InternalDriver.java:209)
at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(EmbeddedDataSource
.java:479)
at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(EmbeddedDataSource
.java:423)
at org.apache.derbyTesting.functionTests.tests.upgradeTests.PhaseChanger.set
Up(PhaseChanger.java:94)
at junit.extensions.TestSetup$1.protect(TestSetup.java:18)
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 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 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)

FAILURES!!!
Tests run: 505, Failures: 0, Errors: 4