org.apache.derbyTesting.functionTests.tests.lang

Class StreamsTest

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.StreamsTest

All Implemented Interfaces:

junit.framework.Test

public class StreamsTest
extends BaseJDBCTestCase

This tests streams, and when we should not materialize it. Beetle entry 4896, 4955. Some of the code comes from conn/largeStreams.java. But this program figures out whether a stream is materialized or not in a different way. Part of the reason is that this test should be run nightly to catch regressions and shouldn't require too much disk space. It figures out whether a stream is materialized or not by comparing the stack levels of different cases. The stack level is when reading the last byte of the stream. According to the current code, the stack is about 10 levels deeper when reading the stream from store per page (not materialized before hand), comparing to the case when materializing from sql language layer. We don't expect this to change dramatically for some time. And this can always be adjusted when needed. For bug 5592 - match db's limits for long varchar which is 32700. In order to enforce that limit we now materialize the stream to make sure we are not trying to overstuff data in long varchar. Because of this, I had to make some changes into the stack level checking for long varchars. Converted to Junit based StreamsTest from the old streams.java test.

Field Summary

Fields

Modifier and Type	Field and Description
private int	pkCount Unique values for primary keys.

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
StreamsTest(java.lang.String name)

Method Summary

Modifier and Type	Method and Description
private int	insertLongBinary(java.sql.PreparedStatement ps, int kbytes)
private int	insertLongString(java.sql.PreparedStatement ps, int kchars, boolean isInsert)
static junit.framework.Test	suite() Only runs embedded as it is checking stack depths of when certain operations happen to streams.
void	testStreams()

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

Field Detail

pkCount

private int pkCount

Unique values for primary keys.

Constructor Detail

StreamsTest

public StreamsTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

Only runs embedded as it is checking stack depths of when certain operations happen to streams. Stack depths from the network server would be different and test is not designed work with a network client.

testStreams

public void testStreams()
                 throws java.lang.Exception

Throws:

java.lang.Exception

insertLongString

private int insertLongString(java.sql.PreparedStatement ps,
                             int kchars,
                             boolean isInsert)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

insertLongBinary

private int insertLongBinary(java.sql.PreparedStatement ps,
                             int kbytes)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException