[DERBY-2612] running soft upgrade of a 10.0 database vs. 10.3 software gives test error in testGetTablesModify concerning XML type

• 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

m2_ibm15:402>sysinfo
------------------ Java Information ------------------
Java Version: 1.5.0
Java Vendor: IBM Corporation
Java home: c:\p4\m2\ibm15\jre
Java classpath: .;.;c:/p4/m2/classes;c:/p4/m2/tools/java/jdbctests.zip;c:/p4/m2
/tools/java/jakarta-oro-2.0.8.jar;c:/p4/m2/tools/java/jgl3.1.0.jar;c:/p4/m2/tool
s/java/jndi/providerutil.jar;c:/p4/m2/tools/java/jndi/ldap.jar;c:/p4/m2/tools/ja
va/jndi/jndi.jar;c:/p4/m2/tools/java/jnl1.0F.zip;c:/p4/m2/tools/java/junit.jar;c
:/p4/m2/tools/java/servlet-2_2b.jar;c:/p4/m2/tools/java/xslt4j-2_5_0/xercesImpl.
jar;c:/p4/m2/tools/java/xslt4j-2_5_0/xml-apis.jar;c:/p4/m2/tools/java/xslt4j-2_5
_0/xalan.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\m2\opensource\java\testing\org\apache\derbyTesting\functi
onTests\tests\upgradeTests
java.specification.name: Java Platform API Specification
java.specification.version: 1.5
--------- Derby Information --------
JRE - JDBC: J2SE 5.0 - JDBC 3.0
[C:\p4\m2\classes] 10.3.0.0 alpha - (1)

• Bug behavior facts: Regression Test Failure
• Assignee: Myrna van Lunteren
• Reporter: Mike Matrigali
• Created: 05/May/07 01:19
• Updated: 29/Jun/09 22:42
• Resolved: 25/May/07 20:41

Description

When running full set of upgrade tests from 10.0 to current trunk I get the following error. This looks like a test problem to me, as the error seems to
be correctly saying that XML cannot be used in a 10.0 db.

1) testGetTablesModify(org.apache.derbyTesting.functionTests.tests.jdbcapi.Datab
aseMetaDataTest)java.sql.SQLException: Use of 'XML' requires database to be upgr
aded from version 10.0 to version 10.1 or later.
at org.apache.derby.iapi.error.StandardException.newException(StandardExcept
ion.java:356)
at org.apache.derby.impl.sql.catalog.DD_Version.checkVersion(DD_Version.java
:788)
at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.checkVersion(DataDic
tionaryImpl.java:8487)
at org.apache.derby.impl.sql.compile.SQLParser.checkVersion(SQLParser.java:3
00)
at org.apache.derby.impl.sql.compile.SQLParser.XMLType(SQLParser.java:4181)
at org.apache.derby.impl.sql.compile.SQLParser.dataTypeCommon(SQLParser.java
:3607)
at org.apache.derby.impl.sql.compile.SQLParser.dataTypeDDL(SQLParser.java:35
37)
at org.apache.derby.impl.sql.compile.SQLParser.columnDefinition(SQLParser.ja
va:3400)
at org.apache.derby.impl.sql.compile.SQLParser.tableElement(SQLParser.java:3
368)
at org.apache.derby.impl.sql.compile.SQLParser.tableElementList(SQLParser.ja
va:3209)
at org.apache.derby.impl.sql.compile.SQLParser.tableDefinition(SQLParser.jav
a:10992)
at org.apache.derby.impl.sql.compile.SQLParser.createStatements(SQLParser.ja
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:1636
)
at org.apache.derby.impl.sql.compile.ParserImpl.parseStatement(ParserImpl.ja
va:151)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.ja
va:280)
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.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.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)