Differences between revisions 49 and 50
Revision 49 as of 2009-08-04 19:53:05
Size: 10610
Comment:
Revision 50 as of 2009-09-20 22:11:35
Size: 10716
Editor: localhost
Comment: converted to 1.6 markup
Deletions are marked like this. Additions are marked like this.
Line 14: Line 14:
|| AIjdbc.java || JUnit || derbylang || embedded || LangHarnessJavaTest [http://issues.apache.org/jira/browse/DERBY-2726 DERBY-2726]||
|| AggregateClassLoading.java || JUnit || derbylang || ?? || [https://issues.apache.org/jira/browse/DERBY-2727 DERBY-2727]||
|| CharUTF8.java|| JUnit || derbylang || embedded || [https://issues.apache.org/jira/browse/DERBY-2727 DERBY-2867] ||
|| AIjdbc.java || JUnit || derbylang || embedded || LangHarnessJavaTest [[http://issues.apache.org/jira/browse/DERBY-2726|DERBY-2726]]||
|| AggregateClassLoading.java || JUnit || derbylang || ?? || [[https://issues.apache.org/jira/browse/DERBY-2727|DERBY-2727]]||
|| CharUTF8.java|| JUnit || derbylang || embedded || [[https://issues.apache.org/jira/browse/DERBY-2727|DERBY-2867]] ||
Line 20: Line 20:
|| altertable.sql|| harness || derbylang || both || [http://issues.apache.org/jira/browse/DERBY-4187 DERBY-4187]||
|| authorize.sql|| harness || derbylang || ?? || As part of [http://issues.apache.org/jira/browse/DERBY-2735 DERBY-2735] ||
|| altertable.sql|| harness || derbylang || both || [[http://issues.apache.org/jira/browse/DERBY-4187|DERBY-4187]]||
|| authorize.sql|| harness || derbylang || ?? || As part of [[http://issues.apache.org/jira/browse/DERBY-2735|DERBY-2735]] ||
Line 26: Line 26:
|| casting.java|| harness || derbylang || ?? || [http://issues.apache.org/jira/browse/DERBY-2382 DERBY-2382]||
|| checkConstraint.sql|| harness || derbylang || both || [http://issues.apache.org/jira/browse/DERBY-4248 DERBY-4248]||
|| closed.java|| harness || derbylang || both || [http://issues.apache.org/jira/browse/DERBY-2514 DERBY-2514] ||
|| coalesceTests.java|| harness || derbylang || both || [http://issues.apache.org/jira/browse/DERBY-2497 DERBY-2497] ||
|| columnDefaults.sql|| harness || derbylang || both || [http://issues.apache.org/jira/browse/DERBY-4317 DERBY-4317] ||
|| casting.java|| harness || derbylang || ?? || [[http://issues.apache.org/jira/browse/DERBY-2382|DERBY-2382]]||
|| checkConstraint.sql|| harness || derbylang || both || [[http://issues.apache.org/jira/browse/DERBY-4248|DERBY-4248]]||
|| closed.java|| harness || derbylang || both || [[http://issues.apache.org/jira/browse/DERBY-2514|DERBY-2514]] ||
|| coalesceTests.java|| harness || derbylang || both || [[http://issues.apache.org/jira/browse/DERBY-2497|DERBY-2497]] ||
|| columnDefaults.sql|| harness || derbylang || both || [[http://issues.apache.org/jira/browse/DERBY-4317|DERBY-4317]] ||
Line 36: Line 36:
|| currentof.java|| junit || derbylang || embedded || currently blocked from running with server. See [http://issues.apache.org/jira/browse/DERBY-2283 DERBY-2283] ||
|| cursor.java|| junit || derbylang || ?? || [http://issues.apache.org/jira/browse/DERBY-2299 DERBY-2299] ||
|| currentof.java|| junit || derbylang || embedded || currently blocked from running with server. See [[http://issues.apache.org/jira/browse/DERBY-2283|DERBY-2283]] ||
|| cursor.java|| junit || derbylang || ?? || [[http://issues.apache.org/jira/browse/DERBY-2299|DERBY-2299]] ||
Line 39: Line 39:
|| DateTimeTest.java|| harness || derbylang || both || [http://issues.apache.org/jira/browse/DERBY-3653 DERBY-3653] || || DateTimeTest.java|| harness || derbylang || both || [[http://issues.apache.org/jira/browse/DERBY-3653|DERBY-3653]] ||
Line 43: Line 43:
|| DeadlockModeTest.java|| junit || derbylang || embedded || LangHarnessJavaTest [http://issues.apache.org/jira/browse/DERBY-3623 DERBY-3623] || || DeadlockModeTest.java|| junit || derbylang || embedded || LangHarnessJavaTest [[http://issues.apache.org/jira/browse/DERBY-3623|DERBY-3623]] ||
Line 47: Line 47:
|| distinct.sql|| junit || derbylang || embedded || [http://issues.apache.org/jira/browse/DERBY-2491 DERBY-2491] ||
|| distinctElimination.sql|| junit || derbylang || embedded || [http://issues.apache.org/jira/browse/DERBY-2491 DERBY-2491] ||
|| distinctFiltering.sql|| junit || derbylang || embedded || [http://issues.apache.org/jira/browse/DERBY-2491 DERBY-2491] ||
|| distinct.sql|| junit || derbylang || embedded || [[http://issues.apache.org/jira/browse/DERBY-2491|DERBY-2491]] ||
|| distinctElimination.sql|| junit || derbylang || embedded || [[http://issues.apache.org/jira/browse/DERBY-2491|DERBY-2491]] ||
|| distinctFiltering.sql|| junit || derbylang || embedded || [[http://issues.apache.org/jira/browse/DERBY-2491|DERBY-2491]] ||
Line 51: Line 51:
|| dynamicLikeOptimization.sql|| harness || derbylang || embedded || [http://issues.apache.org/jira/browse/DERBY-2642 DERBY-2642] || || dynamicLikeOptimization.sql|| harness || derbylang || embedded || [[http://issues.apache.org/jira/browse/DERBY-2642|DERBY-2642]] ||
Line 53: Line 53:
|| errorCode.sql|| junit|| derbylang || embedded || [http://issues.apache.org/jira/browse/DERBY-2567 DERBY-2567]||
|| errorStream.java|| harness || derbylang || ?? || [http://issues.apache.org/jira/browse/DERBY-3156 DERBY-3156] ||
|| errorCode.sql|| junit|| derbylang || embedded || [[http://issues.apache.org/jira/browse/DERBY-2567|DERBY-2567]]||
|| errorStream.java|| harness || derbylang || ?? || [[http://issues.apache.org/jira/browse/DERBY-3156|DERBY-3156]] ||
Line 56: Line 56:
|| forbitdata.java|| harness || derbylang || both || [http://issues.apache.org/jira/browse/DERBY-2476 DERBY-2476] ||
|| forupdate.sql|| harness || derbylang || both || [http://issues.apache.org/jira/browse/DERBY-2517 DERBY-2517] ||
|| grantRevokeDDL.sql|| junit || derbylang || embedded || [http://issues.apache.org/jira/browse/DERBY-2525 DERBY-2525]||
|| grantRevokeDDL2.sql|| junit || derbylang || embedded ||[http://issues.apache.org/jira/browse/DERBY-2525 DERBY-2525] ||
|| grantRevoke.java|| junit || derbylang || both || [http://issues.apache.org/jira/browse/DERBY-2410 DERBY-2410] ||
|| holdCursorIJ.sql|| harness || derbylang || ?? || [http://issues.apache.org/jira/browse/DERBY-3801 DERBY-3801]||
|| forbitdata.java|| harness || derbylang || both || [[http://issues.apache.org/jira/browse/DERBY-2476|DERBY-2476]] ||
|| forupdate.sql|| harness || derbylang || both || [[http://issues.apache.org/jira/browse/DERBY-2517|DERBY-2517]] ||
|| grantRevokeDDL.sql|| junit || derbylang || embedded || [[http://issues.apache.org/jira/browse/DERBY-2525|DERBY-2525]]||
|| grantRevokeDDL2.sql|| junit || derbylang || embedded ||[[http://issues.apache.org/jira/browse/DERBY-2525|DERBY-2525]] ||
|| grantRevoke.java|| junit || derbylang || both || [[http://issues.apache.org/jira/browse/DERBY-2410|DERBY-2410]] ||
|| holdCursorIJ.sql|| harness || derbylang || ?? || [[http://issues.apache.org/jira/browse/DERBY-3801|DERBY-3801]]||
Line 63: Line 63:
|| inbetween.sql|| harness || derbylang || both || [http://issues.apache.org/jira/browse/DERBY-4318 DERBY-4318] || || inbetween.sql|| harness || derbylang || both || [[http://issues.apache.org/jira/browse/DERBY-4318|DERBY-4318]] ||
Line 69: Line 69:
|| lockTable.sql|| harness || derbylang || ?? || [http://issues.apache.org/jira/browse/DERBY-2999 DERBY-2999] Issue appears stalled, no action for almost 1 year ||
|| logStream.java|| harness || derbylang || ?? || [http://issues.apache.org/jira/browse/DERBY-3156 DERBY-3156] ||
|| lockTable.sql|| harness || derbylang || ?? || [[http://issues.apache.org/jira/browse/DERBY-2999|DERBY-2999]] Issue appears stalled, no action for almost 1 year ||
|| logStream.java|| harness || derbylang || ?? || [[http://issues.apache.org/jira/browse/DERBY-3156|DERBY-3156]] ||
Line 82: Line 82:
|| predicatePushdown.sql|| harness || derbylang || ?? ||[http://issues.apache.org/jira/browse/DERBY-3686 DERBY-3686] || || predicatePushdown.sql|| harness || derbylang || ?? ||[[http://issues.apache.org/jira/browse/DERBY-3686|DERBY-3686]] ||
Line 85: Line 85:
|| procedure.java|| junit || derbylang || both|| [https://issues.apache.org/jira/browse/DERBY-2461 DERBY-2461]||
|| procedureInTrigger.sql|| harness || derbylang || ?? || [https://issues.apache.org/jira/browse/DERBY-2536 DERBY-2536]||
|| procedure.java|| junit || derbylang || both|| [[https://issues.apache.org/jira/browse/DERBY-2461|DERBY-2461]]||
|| procedureInTrigger.sql|| harness || derbylang || ?? || [[https://issues.apache.org/jira/browse/DERBY-2536|DERBY-2536]]||
Line 90: Line 90:
|| releaseCompileLocks.sql|| harness || derbylang || both || [http://issues.apache.org/jira/browse/DERBY-2518 DERBY-2518] ||
|| renameIndex.sql|| harness || derbylang || ?? ||[http://issues.apache.org/jira/browse/DERBY-2995 DERBY-2995] ||
|| renameTable.sql|| junit || derbylang || ?? || [http://issues.apache.org/jira/browse/DERBY-2968 DERBY-2968]||
|| releaseCompileLocks.sql|| harness || derbylang || both || [[http://issues.apache.org/jira/browse/DERBY-2518|DERBY-2518]] ||
|| renameIndex.sql|| harness || derbylang || ?? ||[[http://issues.apache.org/jira/browse/DERBY-2995|DERBY-2995]] ||
|| renameTable.sql|| junit || derbylang || ?? || [[http://issues.apache.org/jira/browse/DERBY-2968|DERBY-2968]]||
Line 95: Line 95:
|| scrollCursors2.java|| junit || derbylang ||both ||[http://issues.apache.org/jira/browse/DERBY-2411 DERBY-2411]||
|| scrollCursors1.sql|| junit || jdbc20 ||both ||[http://issues.apache.org/jira/browse/DERBY-2542 DERBY-2542]||
|| scrollCursors3.sql|| junit || jdbc20 ||both ||[http://issues.apache.org/jira/browse/DERBY-2542 DERBY-2542]||
|| scrollCursors2.java|| junit || derbylang ||both ||[[http://issues.apache.org/jira/browse/DERBY-2411|DERBY-2411]]||
|| scrollCursors1.sql|| junit || jdbc20 ||both ||[[http://issues.apache.org/jira/browse/DERBY-2542|DERBY-2542]]||
|| scrollCursors3.sql|| junit || jdbc20 ||both ||[[http://issues.apache.org/jira/browse/DERBY-2542|DERBY-2542]]||
Line 101: Line 101:
|| SpillHash.java|| junit || derbylang || ?? || [http://issues.apache.org/jira/browse/DERBY-2562 DERBY-2562]||
|| staleplans.sql|| junit || derbylang || embedded || [http://issues.apache.org/jira/browse/DERBY-2641 DERBY-2641] ||
|| stmtCache0.sql|| junit || derbylang || ?? || StatementPlanCacheTest [http://issues.apache.org/jira/browse/DERBY-2332 DERBY-2332] ||
|| stmtCache1.sql|| junit|| derbylang || ?? || StatementPlanCacheTest [http://issues.apache.org/jira/browse/DERBY-2332 DERBY-2332] ||
|| stmtCache3.java|| junit || derbylang || ?? || StatementPlanCacheTest [http://issues.apache.org/jira/browse/DERBY-2332 DERBY-2332] ||
|| streams.java|| junit || derbylang || ?? || [http://issues.apache.org/jira/browse/DERBY-2300 DERBY-2300] ||
|| subquery.sql|| harness || derbylang || ?? || [http://issues.apache.org/jira/browse/DERBY-3808 DERBY-3808]||
|| SpillHash.java|| junit || derbylang || ?? || [[http://issues.apache.org/jira/browse/DERBY-2562|DERBY-2562]]||
|| staleplans.sql|| junit || derbylang || embedded || [[http://issues.apache.org/jira/browse/DERBY-2641|DERBY-2641]] ||
|| stmtCache0.sql|| junit || derbylang || ?? || StatementPlanCacheTest [[http://issues.apache.org/jira/browse/DERBY-2332|DERBY-2332]] ||
|| stmtCache1.sql|| junit|| derbylang || ?? || StatementPlanCacheTest [[http://issues.apache.org/jira/browse/DERBY-2332|DERBY-2332]] ||
|| stmtCache3.java|| junit || derbylang || ?? || StatementPlanCacheTest [[http://issues.apache.org/jira/browse/DERBY-2332|DERBY-2332]] ||
|| streams.java|| junit || derbylang || ?? || [[http://issues.apache.org/jira/browse/DERBY-2300|DERBY-2300]] ||
|| subquery.sql|| harness || derbylang || ?? || [[http://issues.apache.org/jira/browse/DERBY-3808|DERBY-3808]]||
Line 110: Line 110:
|| supersimple.sql|| junit || derbylang || both ||[http://issues.apache.org/jira/browse/DERBY-2554 DERBY-2554] ||
|| syscat.sql|| junit || derbylang || both || [http://issues.apache.org/jira/browse/DERBY-2484 DERBY-2484] ||
|| timestampArith.java|| junit || derbylang || ?? || [http://issues.apache.org/jira/browse/DERBY-2539 DERBY-2539] ||
|| supersimple.sql|| junit || derbylang || both ||[[http://issues.apache.org/jira/browse/DERBY-2554|DERBY-2554]] ||
|| syscat.sql|| junit || derbylang || both || [[http://issues.apache.org/jira/browse/DERBY-2484|DERBY-2484]] ||
|| timestampArith.java|| junit || derbylang || ?? || [[http://issues.apache.org/jira/browse/DERBY-2539|DERBY-2539]] ||
Line 114: Line 114:
|| triggerGeneral.sql|| harness || derbylang || ?? || [http://issues.apache.org/jira/browse/DERBY-1102 DERBY-1102] || || triggerGeneral.sql|| harness || derbylang || ?? || [[http://issues.apache.org/jira/browse/DERBY-1102|DERBY-1102]] ||
Line 117: Line 117:
|| triggerStream.java|| harness || derbylang || ?? || [http://issues.apache.org/jira/browse/DERBY-1102 DERBY-1102]||
|| unaryArithmeticDynamicParameter.java|| junit || derbylang || both || [http://issues.apache.org/jira/browse/DERBY-2458 DERBY-2458] ||
|| triggerStream.java|| harness || derbylang || ?? || [[http://issues.apache.org/jira/browse/DERBY-1102|DERBY-1102]]||
|| unaryArithmeticDynamicParameter.java|| junit || derbylang || both || [[http://issues.apache.org/jira/browse/DERBY-2458|DERBY-2458]] ||
Line 120: Line 120:
|| updateCursor.java|| junit || derbylang || both || [https://issues.apache.org/jira/browse/DERBY-2467 DERBY-2467] || || updateCursor.java|| junit || derbylang || both || [[https://issues.apache.org/jira/browse/DERBY-2467|DERBY-2467]] ||
Line 122: Line 122:
|| `ShutdownDatabase.java`|| harness/junit || derbylang || ?? || [https://issues.apache.org/jira/browse/DERBY-2464 DERBY-2464] embedded runs junit, DERBY-2477 prevents networkserver junit run || || `ShutdownDatabase.java`|| harness/junit || derbylang || ?? || [[https://issues.apache.org/jira/browse/DERBY-2464|DERBY-2464]] embedded runs junit, DERBY-2477 prevents networkserver junit run ||

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

LangHarnessJavaTest DERBY-2726

AggregateClassLoading.java

JUnit

derbylang

??

DERBY-2727

CharUTF8.java

JUnit

derbylang

embedded

DERBY-2867

DB2IsolationLevels.sql

harness

derbylang

??

LOBDB2compatibility.sql

harness

derbylang

??

aggregateOptimization.sql

harness

derbylang

??

altertable.sql

harness

derbylang

both

DERBY-4187

authorize.sql

harness

derbylang

??

As part of DERBY-2735

autoincrement.sql

harness

derbylang

??

bug4356.java

adapter

derbylang

embedded

LangHarnessJavaTest

bug5052rts.java

adapter

derbylang

embedded

LangHarnessJavaTest

bug5054.java

adapter

derbylang

embedded

LangHarnessJavaTest

casting.java

harness

derbylang

??

DERBY-2382

checkConstraint.sql

harness

derbylang

both

DERBY-4248

closed.java

harness

derbylang

both

DERBY-2514

coalesceTests.java

harness

derbylang

both

DERBY-2497

columnDefaults.sql

harness

derbylang

both

DERBY-4317

compressTable.sql

harness

derbylang

??

concateTests.java

adapter

derbylang

embedded

LangHarnessJavaTest

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

??

DERBY-2299

cursorerrors.sql

harness

derbylang

??

DateTimeTest.java

harness

derbylang

both

DERBY-3653

db2Compatibility.sql

harness

derbylang

??

dbManagerLimits.java

adapter

derbylang

embedded

LangHarnessJavaTest

ddlTableLockMode.sql

harness

derbylang

??

DeadlockModeTest.java

junit

derbylang

embedded

LangHarnessJavaTest DERBY-3623

declareGlobalTempTableJava.java

harness

derbylang

??

declareGlobalTempTableJavaJDBC30.java

harness

derbylang

??

desc_index.sql

harness

derbylang

??

distinct.sql

junit

derbylang

embedded

DERBY-2491

distinctElimination.sql

junit

derbylang

embedded

DERBY-2491

distinctFiltering.sql

junit

derbylang

embedded

DERBY-2491

dropTable.sql

harness

derbylang

??

dynamicLikeOptimization.sql

harness

derbylang

embedded

DERBY-2642

emptyStatistics.sql

harness

derbylang

??

errorCode.sql

junit

derbylang

embedded

DERBY-2567

errorStream.java

harness

derbylang

??

DERBY-3156

fk_nonSPS.sql

harness

derbylang

??

forbitdata.java

harness

derbylang

both

DERBY-2476

forupdate.sql

harness

derbylang

both

DERBY-2517

grantRevokeDDL.sql

junit

derbylang

embedded

DERBY-2525

grantRevokeDDL2.sql

junit

derbylang

embedded

DERBY-2525

grantRevoke.java

junit

derbylang

both

DERBY-2410

holdCursorIJ.sql

harness

derbylang

??

DERBY-3801

holdCursorJavaReflection.java

harness

derbylang

??

inbetween.sql

harness

derbylang

both

DERBY-4318

infostreams.sql

harness

derbylang

??

isolationLevels.sql

harness

derbylang

??

JitTest.java

adapter

derbylang

embedded

LangHarnessJavaTest

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

??

DERBY-3156

lojreorder.sql

harness

derbylang

??

longStringColumn.java

adapter

derbylang

embedded

LangHarnessJavaTest

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

??

DERBY-3686

predicatesIntoViews.sql

harness

derbylang

??

primarykey.sql

harness

derbylang

??

procedure.java

junit

derbylang

both

DERBY-2461

procedureInTrigger.sql

harness

derbylang

??

DERBY-2536

refActions.sql

harness

derbylang

??

refActions2.sql

harness

derbylang

??

refActions3.sql

harness

derbylang

??

releaseCompileLocks.sql

harness

derbylang

both

DERBY-2518

renameIndex.sql

harness

derbylang

??

DERBY-2995

renameTable.sql

junit

derbylang

??

DERBY-2968

reopenScan.sql

harness

derbylang

??

repeat.java

junit

derbylang

embedded

StatementPlanCacheTest

scrollCursors2.java

junit

derbylang

both

DERBY-2411

scrollCursors1.sql

junit

jdbc20

both

DERBY-2542

scrollCursors3.sql

junit

jdbc20

both

DERBY-2542

setOpPlan.sql

harness

derbylang

??

simpleThreadWrapper.java

adapter

derbylang

embedded

LangHarnessJavaTest

specjPlans.sql

harness

derbylang

??

SpillHash.java

junit

derbylang

??

DERBY-2562

staleplans.sql

junit

derbylang

embedded

DERBY-2641

stmtCache0.sql

junit

derbylang

??

StatementPlanCacheTest DERBY-2332

stmtCache1.sql

junit

derbylang

??

StatementPlanCacheTest DERBY-2332

stmtCache3.java

junit

derbylang

??

StatementPlanCacheTest DERBY-2332

streams.java

junit

derbylang

??

DERBY-2300

subquery.sql

harness

derbylang

??

DERBY-3808

subquery2.sql

harness

derbylang

??

subqueryFlattening.sql

harness

derbylang

??

supersimple.sql

junit

derbylang

both

DERBY-2554

syscat.sql

junit

derbylang

both

DERBY-2484

timestampArith.java

junit

derbylang

??

DERBY-2539

triggerBeforeTrig.sql

harness

derbylang

??

triggerGeneral.sql

harness

derbylang

??

DERBY-1102

triggerRecursion.sql

harness

derbylang

??

triggerRefClause.sql

harness

derbylang

??

triggerStream.java

harness

derbylang

??

DERBY-1102

unaryArithmeticDynamicParameter.java

junit

derbylang

both

DERBY-2458

ungroupedAggregatesNegative.sql

harness

derbylang

??

updateCursor.java

junit

derbylang

both

DERBY-2467

wisconsin.java

harness

derbylang

??

ShutdownDatabase.java

harness/junit

derbylang

??

DERBY-2464 embedded runs junit, DERBY-2477 prevents networkserver junit run

LangJunitTestConversion (last edited 2009-09-20 22:11:35 by localhost)