State is one of:
- harness - runs as a harness test
- adapter - runs as a canon based test in JUnit infrastructure
- junit - converted to an assert based JUnit test
Client/Embedded is one of
- embedded - runs only in embedded with derbyall
- client - runs only in client with derbyall
- both - runs embedded and client with derbyall
Any .sql script not listed here may already be running under the JUnit infrastructure using the LangScripts class.
Test (lang) |
State |
Old Suite(s) |
Client/Embedded |
Notes |
AIjdbc.java |
JUnit |
derbylang |
embedded |
|
JUnit |
derbylang |
?? |
||
CharUTF8.java |
JUnit |
derbylang |
embedded |
|
|
harness |
derbylang |
?? |
|
LOBDB2compatibility.sql |
harness |
derbylang |
?? |
|
aggregateOptimization.sql |
harness |
derbylang |
?? |
|
altertable.sql |
harness |
derbylang |
both |
|
authorize.sql |
harness |
derbylang |
?? |
As part of DERBY-2735 |
autoincrement.sql |
harness |
derbylang |
?? |
|
bug4356.java |
adapter |
derbylang |
embedded |
|
bug5052rts.java |
adapter |
derbylang |
embedded |
|
bug5054.java |
adapter |
derbylang |
embedded |
|
casting.java |
harness |
derbylang |
?? |
|
checkConstraint.sql |
harness |
derbylang |
both |
|
closed.java |
harness |
derbylang |
both |
|
coalesceTests.java |
harness |
derbylang |
both |
|
columnDefaults.sql |
harness |
derbylang |
both |
|
compressTable.sql |
harness |
derbylang |
?? |
|
concateTests.java |
adapter |
derbylang |
embedded |
|
connect.sql |
harness |
derbylang |
?? |
|
consistencyChecker.sql |
harness |
derbylang |
?? |
|
currentSchema.sql |
harness |
derbylang |
?? |
|
currentof.java |
junit |
derbylang |
embedded |
currently blocked from running with server. See DERBY-2283 |
cursor.java |
junit |
derbylang |
?? |
|
cursorerrors.sql |
harness |
derbylang |
?? |
|
DateTimeTest.java |
harness |
derbylang |
both |
|
db2Compatibility.sql |
harness |
derbylang |
?? |
|
dbManagerLimits.java |
adapter |
derbylang |
embedded |
|
ddlTableLockMode.sql |
harness |
derbylang |
?? |
|
DeadlockModeTest.java |
junit |
derbylang |
embedded |
|
declareGlobalTempTableJava.java |
harness |
derbylang |
?? |
|
declareGlobalTempTableJavaJDBC30.java |
harness |
derbylang |
?? |
|
desc_index.sql |
harness |
derbylang |
?? |
|
distinct.sql |
junit |
derbylang |
embedded |
|
distinctElimination.sql |
junit |
derbylang |
embedded |
|
distinctFiltering.sql |
junit |
derbylang |
embedded |
|
dropTable.sql |
harness |
derbylang |
?? |
|
dynamicLikeOptimization.sql |
harness |
derbylang |
embedded |
|
emptyStatistics.sql |
harness |
derbylang |
?? |
|
errorCode.sql |
junit |
derbylang |
embedded |
|
errorStream.java |
harness |
derbylang |
?? |
|
fk_nonSPS.sql |
harness |
derbylang |
?? |
|
forbitdata.java |
harness |
derbylang |
both |
|
forupdate.sql |
harness |
derbylang |
both |
|
grantRevokeDDL.sql |
junit |
derbylang |
embedded |
|
grantRevokeDDL2.sql |
junit |
derbylang |
embedded |
|
grantRevoke.java |
junit |
derbylang |
both |
|
holdCursorIJ.sql |
harness |
derbylang |
?? |
|
holdCursorJavaReflection.java |
harness |
derbylang |
?? |
|
inbetween.sql |
harness |
derbylang |
both |
|
infostreams.sql |
harness |
derbylang |
?? |
|
isolationLevels.sql |
harness |
derbylang |
?? |
|
JitTest.java |
adapter |
derbylang |
embedded |
|
joinDeadlock.sql |
harness |
derbylang |
?? |
|
langUnitTests.sql |
harness |
derbylang |
?? |
|
lockTable.sql |
harness |
derbylang |
?? |
DERBY-2999 Issue appears stalled, no action for almost 1 year |
logStream.java |
harness |
derbylang |
?? |
|
lojreorder.sql |
harness |
derbylang |
?? |
|
longStringColumn.java |
adapter |
derbylang |
embedded |
|
maxMemPerTab.java |
harness |
derbylang |
?? |
|
nestedCommit.sql |
harness |
derbylang |
?? |
|
openScans.sql |
harness |
derbylang |
?? |
|
optimizerOverrides.sql |
harness |
derbylang |
?? |
|
orderbyElimination.sql |
harness |
derbylang |
?? |
|
outerjoin.sql |
harness |
derbylang |
?? |
|
outparams.java |
harness |
derbylang |
?? |
|
paramij.sql |
harness |
derbylang |
?? |
|
partdml.sql |
harness |
derbylang |
?? |
|
predicatePushdown.sql |
harness |
derbylang |
?? |
|
predicatesIntoViews.sql |
harness |
derbylang |
?? |
|
primarykey.sql |
harness |
derbylang |
?? |
|
procedure.java |
junit |
derbylang |
both |
|
procedureInTrigger.sql |
harness |
derbylang |
?? |
|
refActions.sql |
harness |
derbylang |
?? |
|
refActions2.sql |
harness |
derbylang |
?? |
|
refActions3.sql |
harness |
derbylang |
?? |
|
releaseCompileLocks.sql |
harness |
derbylang |
both |
|
renameIndex.sql |
harness |
derbylang |
?? |
|
renameTable.sql |
junit |
derbylang |
?? |
|
reopenScan.sql |
harness |
derbylang |
?? |
|
repeat.java |
junit |
derbylang |
embedded |
|
scrollCursors2.java |
junit |
derbylang |
both |
|
scrollCursors1.sql |
junit |
jdbc20 |
both |
|
scrollCursors3.sql |
junit |
jdbc20 |
both |
|
setOpPlan.sql |
harness |
derbylang |
?? |
|
simpleThreadWrapper.java |
adapter |
derbylang |
embedded |
|
specjPlans.sql |
harness |
derbylang |
?? |
|
SpillHash.java |
junit |
derbylang |
?? |
|
staleplans.sql |
junit |
derbylang |
embedded |
|
stmtCache0.sql |
junit |
derbylang |
?? |
|
stmtCache1.sql |
junit |
derbylang |
?? |
|
stmtCache3.java |
junit |
derbylang |
?? |
|
streams.java |
junit |
derbylang |
?? |
|
subquery.sql |
harness |
derbylang |
?? |
|
subquery2.sql |
harness |
derbylang |
?? |
|
subqueryFlattening.sql |
harness |
derbylang |
?? |
|
supersimple.sql |
junit |
derbylang |
both |
|
syscat.sql |
junit |
derbylang |
both |
|
timestampArith.java |
junit |
derbylang |
?? |
|
triggerBeforeTrig.sql |
harness |
derbylang |
?? |
|
triggerGeneral.sql |
harness |
derbylang |
?? |
|
triggerRecursion.sql |
harness |
derbylang |
?? |
|
triggerRefClause.sql |
harness |
derbylang |
?? |
|
triggerStream.java |
harness |
derbylang |
?? |
|
unaryArithmeticDynamicParameter.java |
junit |
derbylang |
both |
|
ungroupedAggregatesNegative.sql |
harness |
derbylang |
?? |
|
updateCursor.java |
junit |
derbylang |
both |
|
wisconsin.java |
harness |
derbylang |
?? |
|
|
harness/junit |
derbylang |
?? |
DERBY-2464 embedded runs junit, DERBY-2477 prevents networkserver junit run |
|
|
|
|
|