org.apache.derbyTesting.functionTests.tests.lang

Class XMLTypeAndOpsTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.lang.XMLTypeAndOpsTest

All Implemented Interfaces:

junit.framework.Test

public final class XMLTypeAndOpsTest
extends BaseJDBCTestCase

XMLTypeAndOpsTest this test is the JUnit equivalent to what used to be the "lang/xml_general.sql" test, which was canon-based. Since the .sql test had different masters for embedded, JCC, and Derby Client, and since it performed some "sed'ing" to ensure consistent results across JVMs, it was not sufficient to just wrap the test in a JUnit ScriptTestCase (because ScriptTestCase doesn't deal with multiple masters nor with sed'ing). Hence the creation of this pure JUnit version of the test.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
private static class	XMLTypeAndOpsTest.XMLTestSetup Wrapper for the tests in XMLTypeAndOpsTest.

Field Summary

Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
XMLTypeAndOpsTest(java.lang.String name) Public constructor required for running test as standalone JUnit.

Method Summary

Modifier and Type	Method and Description
static junit.framework.Test	suite() Return a suite that runs a set of tests which are meant to be the equivalent to the test cases in the old xml_general.sql.
void	testAttrSerialization() DERBY-1759: Serialization of attribute nodes.
void	testIllegalNullInserts() Check insertion of null values into XML columns.
void	testIllegalOps() Test additional restrictions on use of XML values.
void	testIsNull() Test use of the "is [not] null" clause with XML values.
void	testNestedXMLQuery()
void	testNonXMLColsWithXMLVals() Test insertion of XML values into non-XML columns.
void	testNumericReturnValues() Test how numeric values returned by XPath queries are formatted.
void	testTopLevelSelect() Derby doesn't currently support XML values in a top-level result set.
void	testTriggerSetXML() Test use of XML columns in a trigger's "SET" clause.
void	testTriggerSPSWithXML() DERBY-1718 create trigger fails when SPS contains XML related op.
void	testXMLCasting() Test casting of values to type XML.
void	testXMLColCreation() Test creation of XML columns.
void	testXMLColsWithNonXMLVals() Test insertion of non-XML values into XML columns.
void	testXMLComparisons() Test simple comparisons with XML.
void	testXMLExists() Various tests for the XMLEXISTS operator.
void	testXMLInNonXMLOps() Try to use XML values in non-XML operations.
void	testXMLParse() Various tests for the XMLPARSE operator.
void	testXMLParseSerializeCombos() Various tests with XMLPARSE and XMLSERIALIZE combinations.
void	testXMLQuery() Various tests for the XMLQUERY operator.
void	testXMLQueryInsert()
void	testXMLQueryUpdate()
void	testXMLSerialize() Various tests for the XMLSERIALIZE operator.

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

assertCallError, assertCheckTable, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, emptyStatementCache, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, initializeConnection, openConnection, openDefaultConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runBare, runBareOverridable, runScript, runScript, runSQLCommands, setAutoCommit, tearDown, usingDB2Client, usingDerbyNetClient, usingEmbedded

Methods inherited from class org.apache.derbyTesting.junit.BaseTestCase

alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemProperty, sleep, sleepAtLeastOneTick, traceit

Methods inherited from class junit.framework.TestCase

assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, countTestCases, createResult, fail, fail, failNotEquals, failNotSame, failSame, format, getName, run, run, runTest, setName, setUp, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

XMLTypeAndOpsTest

public XMLTypeAndOpsTest(java.lang.String name)

Public constructor required for running test as standalone JUnit.

Method Detail

suite

public static junit.framework.Test suite()

Return a suite that runs a set of tests which are meant to be the equivalent to the test cases in the old xml_general.sql. But only return such a suite IF the testing classpath has the required XML classes. Otherwise just return an empty suite.

testXMLColCreation

public void testXMLColCreation()
                        throws java.lang.Exception

Test creation of XML columns.

Throws:

java.lang.Exception

testIllegalNullInserts

public void testIllegalNullInserts()
                            throws java.lang.Exception

Check insertion of null values into XML columns. This test just checks the negative cases--i.e. cases where we expect the insertions to fail. The positive cases are tested implicitly as part of XMLTestSetup.setUp() when we load the test data.

Throws:

java.lang.Exception

testXMLColsWithNonXMLVals

public void testXMLColsWithNonXMLVals()
                               throws java.lang.Exception

Test insertion of non-XML values into XML columns. These should all fail because such an operation is not allowed.

Throws:

java.lang.Exception

testNonXMLColsWithXMLVals

public void testNonXMLColsWithXMLVals()
                               throws java.lang.Exception

Test insertion of XML values into non-XML columns. These should all fail because such an operation is not allowed.

Throws:

java.lang.Exception

testXMLCasting

public void testXMLCasting()
                    throws java.lang.Exception

Test casting of values to type XML. These should all fail because such casting is not allowed.

Throws:

java.lang.Exception

testXMLInNonXMLOps

public void testXMLInNonXMLOps()
                        throws java.lang.Exception

Try to use XML values in non-XML operations. These should all fail (the only operations allowed with XML are the specified XML operations (xmlparse, xmlserialize, xmlexists, xmlquery)).

Throws:

java.lang.Exception

testXMLComparisons

public void testXMLComparisons()
                        throws java.lang.Exception

Test simple comparisons with XML. These should all fail because no such comparisons are allowed.

Throws:

java.lang.Exception

testIllegalOps

public void testIllegalOps()
                    throws java.lang.Exception

Test additional restrictions on use of XML values. These should all fail.

Throws:

java.lang.Exception

testTriggerSetXML

public void testTriggerSetXML()
                       throws java.lang.Exception

Test use of XML columns in a trigger's "SET" clause. Should work so long as the target value has type XML.

Throws:

java.lang.Exception

testXMLParse

public void testXMLParse()
                  throws java.lang.Exception

Various tests for the XMLPARSE operator. Note that this test primarily checks the negative cases--i.e. cases where we expect the XMLPARSE op to fail. The positive cases were tested implicitly as part of XMLTestSetup.setUp() when we loaded the test data.

Throws:

java.lang.Exception

testIsNull

public void testIsNull()
                throws java.lang.Exception

Test use of the "is [not] null" clause with XML values. These should work.

Throws:

java.lang.Exception

testTopLevelSelect

public void testTopLevelSelect()
                        throws java.lang.Exception

Derby doesn't currently support XML values in a top-level result set. So make sure that doesn't work. These should all fail.

Throws:

java.lang.Exception

testXMLSerialize

public void testXMLSerialize()
                      throws java.lang.Exception

Various tests for the XMLSERIALIZE operator.

Throws:

java.lang.Exception

testXMLParseSerializeCombos

public void testXMLParseSerializeCombos()
                                 throws java.lang.Exception

Various tests with XMLPARSE and XMLSERIALIZE combinations.

Throws:

java.lang.Exception

testXMLExists

public void testXMLExists()
                   throws java.lang.Exception

Various tests for the XMLEXISTS operator.

Throws:

java.lang.Exception

testXMLQuery

public void testXMLQuery()
                  throws java.lang.Exception

Various tests for the XMLQUERY operator.

Throws:

java.lang.Exception

testXMLQueryInsert

public void testXMLQueryInsert()
                        throws java.lang.Exception

Throws:

java.lang.Exception

testXMLQueryUpdate

public void testXMLQueryUpdate()
                        throws java.lang.Exception

Throws:

java.lang.Exception

testNestedXMLQuery

public void testNestedXMLQuery()
                        throws java.lang.Exception

Throws:

java.lang.Exception

testAttrSerialization

public void testAttrSerialization()
                           throws java.lang.Exception

DERBY-1759: Serialization of attribute nodes.

Throws:

java.lang.Exception

testTriggerSPSWithXML

public void testTriggerSPSWithXML()
                           throws java.lang.Exception

DERBY-1718 create trigger fails when SPS contains XML related op.

Throws:

java.lang.Exception

testNumericReturnValues

public void testNumericReturnValues()
                             throws java.sql.SQLException

Test how numeric values returned by XPath queries are formatted.

Throws:

java.sql.SQLException