Generating report for RunSuite derbyall j9_foundation j9 null null true ------------------ Java Information ------------------ Java Version: J2ME Foundation Specification v1.0 Java Vendor: IBM Corporation Java home: C:\IBM\DeviceDeveloper\wsdd5.0\ive-2.2 Java classpath: C:/deepa/Derby/derby_src/j2me_work/trunk/classes;C:/deepa/Derby/derby_src/j2me_work/trunk/tools/java/jakarta-oro-2.0.8.jar OS name: Windows XP OS architecture: x86 OS version: 5.1 build 2600 Service Pack 1 Java user name: deepa Java user home: C:\Documents and Settings\Administrator Java user dir: C:\deepa\Derby\derby_testing\j2me_tests\pass4\impExp\suite_derbyall java.specification.name: J2ME Foundation Specification java.specification.version: 1.0 --------- Derby Information -------- JRE - JDBC: J2ME - JDBC for CDC/FP 1.0 [C:\deepa\Derby\derby_src\j2me_work\trunk\classes] 10.2.0.0 alpha - (1) ------------------------------------------------------ ----------------- Locale Information ----------------- Current Locale : [English/United States [en_US]] Found support for locale: [de_DE] version: 10.2.0.0 alpha - (1) Found support for locale: [es] version: 10.2.0.0 alpha - (1) Found support for locale: [fr] version: 10.2.0.0 alpha - (1) Found support for locale: [it] version: 10.2.0.0 alpha - (1) Found support for locale: [ja_JP] version: 10.2.0.0 alpha - (1) Found support for locale: [ko_KR] version: 10.2.0.0 alpha - (1) Found support for locale: [pt_BR] version: 10.2.0.0 alpha - (1) Found support for locale: [zh_CN] version: 10.2.0.0 alpha - (1) Found support for locale: [zh_TW] version: 10.2.0.0 alpha - (1) ------------------------------------------------------ Test environment information: COMMAND LINE STYLE: jdk13 TEST CANONS: master ------------------------------------------------------ ------------------------------------------------------ Summary results: Test Run Started: 2005-07-13 16:10:15.0 Test Run Duration: 01:49:42 319 Tests Run 100% Pass (318 tests passed) 0% Fail (1 tests failed) 23 Suites skipped ------------------------------------------------------ Failed tests in: derbyall_fail.txt ------------------------------------------------------ Passed tests in: derbyall_pass.txt ------------------------------------------------------ Skipped suites in: derbyall_skip.txt ------------------------------------------------------ System properties in: derbyall_prop.txt ------------------------------------------------------ ------------------------------------------------------ Failure Details: ********* Diff file derbyall/demo/demo/RunClassPathTester.diff *** Start: RunClassPathTester jdkJ2ME Foundation Specification v1.0 demo:demo 2005-07-13 17:49:13 *** Test skipped: test cannot run with jvm: j9_foundation. RunClassPathTester.java *** End: RunClassPathTester jdkJ2ME Foundation Specification v1.0 demo:demo 2005-07-13 17:49:13 *** ********* Diff file derbyall/demo/simpledemo/SimpleApp.diff *** Start: SimpleApp jdkJ2ME Foundation Specification v1.0 demo:simpledemo 2005-07-13 17:49:13 *** Test skipped: test cannot run with jvm: j9_foundation. SimpleApp.java *** End: SimpleApp jdkJ2ME Foundation Specification v1.0 demo:simpledemo 2005-07-13 17:49:13 *** ********* Diff file derbyall/derbylang/aggregateOptimization.diff *** Start: aggregateOptimization jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:14:03 *** Test skipped: test cannot run with jvm: j9_foundation. aggregateOptimization.sql *** End: aggregateOptimization jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:14:03 *** ********* Diff file derbyall/derbylang/authorize.diff *** Start: authorize jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:15:14 *** Test skipped: test cannot run with jvm: j9_foundation. authorize.sql *** End: authorize jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:15:14 *** ********* Diff file derbyall/derbylang/autoincrement.diff *** Start: autoincrement jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:15:15 *** Test skipped: test cannot run with jvm: j9_foundation. autoincrement.sql *** End: autoincrement jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:15:15 *** ********* Diff file derbyall/derbylang/cast.diff *** Start: cast jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:16:57 *** Test skipped: test cannot run with jvm: j9_foundation. cast.sql *** End: cast jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:16:57 *** ********* Diff file derbyall/derbylang/closed.diff *** Start: closed jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:17:51 *** Test skipped: test cannot run with jvm: j9_foundation. closed.java *** End: closed jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:17:51 *** ********* Diff file derbyall/derbylang/connect.diff *** Start: connect jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:21:03 *** Test skipped: test cannot run with jvm: j9_foundation. connect.sql *** End: connect jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:21:03 *** ********* Diff file derbyall/derbylang/currentSchema.diff *** Start: currentSchema jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:21:39 *** Test skipped: test cannot run with jvm: j9_foundation. currentSchema.sql *** End: currentSchema jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:21:39 *** ********* Diff file derbyall/derbylang/db2Compatibility.diff *** Start: db2Compatibility jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:22:45 *** Test skipped: test cannot run with jvm: j9_foundation. db2Compatibility.sql *** End: db2Compatibility jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:22:45 *** ********* Diff file derbyall/derbylang/declareGlobalTempTableJavaJDBC30.diff *** Start: declareGlobalTempTableJavaJDBC30 jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:26:16 *** Test skipped: test cannot run with jvm: j9_foundation. declareGlobalTempTableJavaJDBC30.java *** End: declareGlobalTempTableJavaJDBC30 jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:26:16 *** ********* Diff file derbyall/derbylang/errorCode.diff *** Start: errorCode jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:31:11 *** Test skipped: test cannot run with jvm: j9_foundation. errorCode.sql *** End: errorCode jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:31:11 *** ********* Diff file derbyall/derbylang/errorStream.diff *** Start: errorStream jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:31:12 *** Test skipped: test cannot run with jvm: j9_foundation. errorStream.java *** End: errorStream jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:31:12 *** ********* Diff file derbyall/derbylang/functions.diff *** Start: functions jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:34:07 *** Test skipped: test cannot run with jvm: j9_foundation. functions.sql *** End: functions jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:34:07 *** ********* Diff file derbyall/derbylang/holdCursorIJ.diff *** Start: holdCursorIJ jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:34:24 *** Test skipped: test cannot run with jvm: j9_foundation. holdCursorIJ.sql *** End: holdCursorIJ jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:34:24 *** ********* Diff file derbyall/derbylang/implicitConversions.diff *** Start: implicitConversions jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:35:04 *** Test skipped: test cannot run with jvm: j9_foundation. implicitConversions.sql *** End: implicitConversions jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:35:04 *** ********* Diff file derbyall/derbylang/joinDeadlock.diff *** Start: joinDeadlock jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:37:03 *** Test skipped: test cannot run with jvm: j9_foundation. joinDeadlock.sql *** End: joinDeadlock jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:37:03 *** ********* Diff file derbyall/derbylang/LOBDB2compatibility.diff *** Start: LOBDB2compatibility jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:12:57 *** Test skipped: test cannot run with jvm: j9_foundation. LOBDB2compatibility.sql *** End: LOBDB2compatibility jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:12:57 *** ********* Diff file derbyall/derbylang/lockTable.diff *** Start: lockTable jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:37:36 *** Test skipped: test cannot run with jvm: j9_foundation. lockTable.sql *** End: lockTable jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:37:36 *** ********* Diff file derbyall/derbylang/logStream.diff *** Start: logStream jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:37:36 *** Test skipped: test cannot run with jvm: j9_foundation. logStream.java *** End: logStream jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:37:36 *** ********* Diff file derbyall/derbylang/maxMemPerTab.diff *** Start: maxMemPerTab jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:40:22 *** Test skipped: test cannot run with jvm: j9_foundation. maxMemPerTab.sql *** End: maxMemPerTab jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:40:22 *** ********* Diff file derbyall/derbylang/metadata.diff *** Start: metadata jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:10:17 *** Test skipped: test cannot run with jvm: j9_foundation. metadata.java *** End: metadata jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:10:17 *** ********* Diff file derbyall/derbylang/metadataMultiConn.diff *** Start: metadataMultiConn jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:10:18 *** Test skipped: test cannot run with jvm: j9_foundation. metadataMultiConn.java *** End: metadataMultiConn jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:10:18 *** ********* Diff file derbyall/derbylang/nestedCommit.diff *** Start: nestedCommit jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:40:53 *** Test skipped: test cannot run with jvm: j9_foundation. nestedCommit.sql *** End: nestedCommit jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:40:53 *** ********* Diff file derbyall/derbylang/odbc_metadata.diff *** Start: odbc_metadata jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:10:18 *** Test skipped: test cannot run with jvm: j9_foundation. odbc_metadata.java *** End: odbc_metadata jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:10:18 *** ********* Diff file derbyall/derbylang/outparams.diff *** Start: outparams jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:43:17 *** Test skipped: test cannot run with jvm: j9_foundation. outparams.java *** End: outparams jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:43:17 *** ********* Diff file derbyall/derbylang/procedure.diff *** Start: procedure jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:45:53 *** Test skipped: test cannot run with jvm: j9_foundation. procedure.java *** End: procedure jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:45:53 *** ********* Diff file derbyall/derbylang/releaseCompileLocks.diff *** Start: releaseCompileLocks jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:59:04 *** Test skipped: test cannot run with jvm: j9_foundation. releaseCompileLocks.sql *** End: releaseCompileLocks jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 16:59:04 *** ********* Diff file derbyall/derbylang/supersimple.diff *** Start: supersimple jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 17:05:20 *** Test skipped: test cannot run with jvm: j9_foundation. supersimple.sql *** End: supersimple jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 17:05:20 *** ********* Diff file derbyall/derbylang/triggerGeneral.diff *** Start: triggerGeneral jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 17:06:18 *** Test skipped: test cannot run with jvm: j9_foundation. triggerGeneral.sql *** End: triggerGeneral jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 17:06:18 *** ********* Diff file derbyall/derbylang/triggerRefClause.diff *** Start: triggerRefClause jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 17:06:39 *** Test skipped: test cannot run with jvm: j9_foundation. triggerRefClause.sql *** End: triggerRefClause jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 17:06:39 *** ********* Diff file derbyall/derbylang/triggerStream.diff *** Start: triggerStream jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 17:06:39 *** Test skipped: test cannot run with jvm: j9_foundation. triggerStream.sql *** End: triggerStream jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 17:06:39 *** ********* Diff file derbyall/derbylang/updatableResultSet.diff *** Start: updatableResultSet jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 17:07:30 *** Test skipped: test cannot run with jvm: j9_foundation. updatableResultSet.java *** End: updatableResultSet jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 17:07:30 *** ********* Diff file derbyall/derbylang/wisconsin.diff *** Start: wisconsin jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 17:09:00 *** Test skipped: test cannot run with jvm: j9_foundation. wisconsin.sql *** End: wisconsin jdkJ2ME Foundation Specification v1.0 derbyall:derbylang 2005-07-13 17:09:00 *** ********* Diff file derbyall/derbytools/dblook_test.diff *** Start: dblook_test jdkJ2ME Foundation Specification v1.0 derbyall:derbytools 2005-07-13 17:28:21 *** Test skipped: test cannot run with jvm: j9_foundation. dblook_test.java *** End: dblook_test jdkJ2ME Foundation Specification v1.0 derbyall:derbytools 2005-07-13 17:28:21 *** ********* Diff file derbyall/derbytools/iepnegativetests.diff *** Start: iepnegativetests jdkJ2ME Foundation Specification v1.0 derbyall:derbytools 2005-07-13 17:29:51 *** Test skipped: test cannot run with jvm: j9_foundation. iepnegativetests.sql *** End: iepnegativetests jdkJ2ME Foundation Specification v1.0 derbyall:derbytools 2005-07-13 17:29:51 *** ********* Diff file derbyall/derbytools/ij.diff *** Start: ij jdkJ2ME Foundation Specification v1.0 derbyall:derbytools 2005-07-13 17:29:52 *** Test skipped: test cannot run with jvm: j9_foundation. ij.sql *** End: ij jdkJ2ME Foundation Specification v1.0 derbyall:derbytools 2005-07-13 17:29:52 *** ********* Diff file derbyall/derbytools/ij2.diff *** Start: ij2 jdkJ2ME Foundation Specification v1.0 derbyall:derbytools 2005-07-13 17:29:52 *** Test skipped: test cannot run with jvm: j9_foundation. ij2.sql *** End: ij2 jdkJ2ME Foundation Specification v1.0 derbyall:derbytools 2005-07-13 17:29:52 *** ********* Diff file derbyall/derbytools/ij4.diff *** Start: ij4 jdkJ2ME Foundation Specification v1.0 derbyall:derbytools 2005-07-13 17:30:03 *** Test skipped: test cannot run with jvm: j9_foundation. ij4.sql *** End: ij4 jdkJ2ME Foundation Specification v1.0 derbyall:derbytools 2005-07-13 17:30:03 *** ********* Diff file derbyall/derbytools/ij5.diff *** Start: ij5 jdkJ2ME Foundation Specification v1.0 derbyall:derbytools 2005-07-13 17:30:03 *** Test skipped: test cannot run with jvm: j9_foundation. ij5.sql *** End: ij5 jdkJ2ME Foundation Specification v1.0 derbyall:derbytools 2005-07-13 17:30:03 *** ********* Diff file derbyall/derbytools/ij6.diff *** Start: ij6 jdkJ2ME Foundation Specification v1.0 derbyall:derbytools 2005-07-13 17:30:03 *** Test skipped: test cannot run with jvm: j9_foundation. ij6.sql *** End: ij6 jdkJ2ME Foundation Specification v1.0 derbyall:derbytools 2005-07-13 17:30:03 *** ********* Diff file derbyall/derbytools/ijConnName.diff *** Start: ijConnName jdkJ2ME Foundation Specification v1.0 derbyall:derbytools 2005-07-13 17:30:03 *** Test skipped: test cannot run with jvm: j9_foundation. ijConnName.sql *** End: ijConnName jdkJ2ME Foundation Specification v1.0 derbyall:derbytools 2005-07-13 17:30:03 *** ********* Diff file derbyall/derbytools/URLCheck.diff *** Start: URLCheck jdkJ2ME Foundation Specification v1.0 derbyall:derbytools 2005-07-13 17:30:04 *** Test skipped: test cannot run with jvm: j9_foundation. URLCheck.sql *** End: URLCheck jdkJ2ME Foundation Specification v1.0 derbyall:derbytools 2005-07-13 17:30:04 *** ********* Diff file derbyall/i18nTest/caseI_tr_TR.diff *** Start: caseI_tr_TR jdkJ2ME Foundation Specification v1.0 derbyall:i18nTest 2005-07-13 17:59:56 *** Test skipped: test cannot run with jvm: j9_foundation. caseI_tr_TR.sql *** End: caseI_tr_TR jdkJ2ME Foundation Specification v1.0 derbyall:i18nTest 2005-07-13 17:59:56 *** ********* Diff file derbyall/i18nTest/I18NImportExport.diff *** Start: I18NImportExport jdkJ2ME Foundation Specification v1.0 derbyall:i18nTest 2005-07-13 17:59:55 *** Test skipped: test cannot run with jvm: j9_foundation. I18NImportExport.sql *** End: I18NImportExport jdkJ2ME Foundation Specification v1.0 derbyall:i18nTest 2005-07-13 17:59:55 *** ********* Diff file derbyall/i18nTest/iepnegativetests_ES.diff *** Start: iepnegativetests_ES jdkJ2ME Foundation Specification v1.0 derbyall:i18nTest 2005-07-13 17:59:57 *** Test skipped: test cannot run with jvm: j9_foundation. iepnegativetests_ES.sql *** End: iepnegativetests_ES jdkJ2ME Foundation Specification v1.0 derbyall:i18nTest 2005-07-13 17:59:57 *** ********* Diff file derbyall/i18nTest/messageLocale.diff *** Start: messageLocale jdkJ2ME Foundation Specification v1.0 derbyall:i18nTest 2005-07-13 17:59:56 *** Test skipped: test cannot run with jvm: j9_foundation. messageLocale.sql *** End: messageLocale jdkJ2ME Foundation Specification v1.0 derbyall:i18nTest 2005-07-13 17:59:56 *** ********* Diff file derbyall/i18nTest/urlLocale.diff *** Start: urlLocale jdkJ2ME Foundation Specification v1.0 derbyall:i18nTest 2005-07-13 17:59:56 *** Test skipped: test cannot run with jvm: j9_foundation. urlLocale.sql *** End: urlLocale jdkJ2ME Foundation Specification v1.0 derbyall:i18nTest 2005-07-13 17:59:56 *** ********* Diff file derbyall/jdbc20/batchUpdate.diff *** Start: batchUpdate jdkJ2ME Foundation Specification v1.0 derbyall:jdbc20 2005-07-13 17:30:29 *** Test skipped: test cannot run with jvm: j9_foundation. batchUpdate.java *** End: batchUpdate jdkJ2ME Foundation Specification v1.0 derbyall:jdbc20 2005-07-13 17:30:29 *** ********* Diff file derbyall/jdbc20/getCurConnJdbc20.diff *** Start: getCurConnJdbc20 jdkJ2ME Foundation Specification v1.0 derbyall:jdbc20 2005-07-13 17:30:41 *** Test skipped: test cannot run with jvm: j9_foundation. getCurConnJdbc20.sql *** End: getCurConnJdbc20 jdkJ2ME Foundation Specification v1.0 derbyall:jdbc20 2005-07-13 17:30:41 *** ********* Diff file derbyall/jdbc20/scrollCursors3.diff *** Start: scrollCursors3 jdkJ2ME Foundation Specification v1.0 derbyall:jdbc20 2005-07-13 17:30:29 *** Test skipped: test cannot run with jvm: j9_foundation. scrollCursors3.sql *** End: scrollCursors3 jdkJ2ME Foundation Specification v1.0 derbyall:jdbc20 2005-07-13 17:30:29 *** ********* Diff file derbyall/jdbc20/StmtCloseFunTest.diff *** Start: StmtCloseFunTest jdkJ2ME Foundation Specification v1.0 derbyall:jdbc20 2005-07-13 17:31:05 *** Test skipped: test cannot run with jvm: j9_foundation. StmtCloseFunTest.java *** End: StmtCloseFunTest jdkJ2ME Foundation Specification v1.0 derbyall:jdbc20 2005-07-13 17:31:05 *** ********* Diff file derbyall/jdbcapi/bestrowidentifier.diff *** Start: bestrowidentifier jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2005-07-13 17:31:16 *** Test skipped: test cannot run with jvm: j9_foundation. bestrowidentifier.sql *** End: bestrowidentifier jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2005-07-13 17:31:16 *** ********* Diff file derbyall/jdbcapi/LOBTest.diff *** Start: LOBTest jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2005-07-13 17:35:22 *** Test skipped: test cannot run with jvm: j9_foundation. LOBTest.java *** End: LOBTest jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2005-07-13 17:35:22 *** ********* Diff file derbyall/jdbcapi/parameterMapping.diff *** Start: parameterMapping jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2005-07-13 17:36:19 *** Test skipped: test cannot run with jvm: j9_foundation. parameterMapping.java *** End: parameterMapping jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2005-07-13 17:36:19 *** ********* Diff file derbyall/jdbcapi/resultset.diff *** Start: resultset jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2005-07-13 17:31:51 *** Test skipped: test cannot run with jvm: j9_foundation. resultset.java *** End: resultset jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2005-07-13 17:31:51 *** ********* Diff file derbyall/jdbcapi/secureUsers.diff *** Start: secureUsers jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2005-07-13 17:32:03 *** Test skipped: test cannot run with jvm: j9_foundation. secureUsers.sql *** End: secureUsers jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2005-07-13 17:32:03 *** ********* Diff file derbyall/jdbcapi/secureUsers1.diff *** Start: secureUsers1 jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2005-07-13 17:32:03 *** Test skipped: test cannot run with jvm: j9_foundation. secureUsers1.sql *** End: secureUsers1 jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2005-07-13 17:32:03 *** ********* Diff file derbyall/jdbcapi/users.diff *** Start: users jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2005-07-13 17:32:02 *** Test skipped: test cannot run with jvm: j9_foundation. users.sql *** End: users jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2005-07-13 17:32:02 *** ********* Diff file derbyall/jdbcapi/users2.diff *** Start: users2 jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2005-07-13 17:32:03 *** Test skipped: test cannot run with jvm: j9_foundation. users2.sql *** End: users2 jdkJ2ME Foundation Specification v1.0 derbyall:jdbcapi 2005-07-13 17:32:03 *** ********* Diff file derbyall/storeall/storemats/storemats/access.diff *** Start: access jdkJ2ME Foundation Specification v1.0 storemats:storemats 2005-07-13 17:19:00 *** 2732 del < 499 rows inserted/updated/deleted 2733 del < ij> delete from foo where foo.c = 0 and foo.a < 1000; 2734 del < 499 rows inserted/updated/deleted 2735 del < ij> commit; 2736 del < ij> -- wait for post commit on heap deleted rows to finish, so that there is 2737 del < -- no interference between post commit heap processing, and btree reclamation 2738 del < -- during split. 2739 del < CALL WAIT_FOR_POST_COMMIT(); 2740 del < 0 rows inserted/updated/deleted 2741 del < ij> insert into foo (select * from foo2); 2742 del < 499 rows inserted/updated/deleted 2743 del < ij> commit; 2744 del < ij> -- check space usage on the index 2745 del < insert into spaceused 2746 del < select numallocatedpages 2747 del < from new org.apache.derby.diag.SpaceTable('FOO') t 2748 del < where conglomeratename = 'A'; 2749 del < 1 row inserted/updated/deleted 2750 del < ij> -- should only be 1 distinct row in this table since space used by the 2751 del < -- index should be the same before and after 2752 del < select count(distinct a) 2753 del < from spaceused; 2754 del < 1 2755 del < ----------- 2756 del < 1 2757 del < ij> -- cleanup 2758 del < drop table foo; 2759 del < 0 rows inserted/updated/deleted 2760 del < ij> drop table foo2; 2761 del < 0 rows inserted/updated/deleted 2762 del < ij> drop table spaceused; 2763 del < 0 rows inserted/updated/deleted 2764 del < ij> -- test case for track 3149, improving max on btree optimization 2765 del < autocommit off; 2766 del < ij> create table foo (a int, b varchar(500), c int); 2767 del < 0 rows inserted/updated/deleted 2768 del < ij> insert into foo values (1, PADSTRING('1',500), 1); 2769 del < 1 row inserted/updated/deleted 2770 del < ij> insert into foo values (11, PADSTRING('11',500), 1); 2771 del < 1 row inserted/updated/deleted 2772 del < ij> insert into foo values (12, PADSTRING('12',500), 1); 2773 del < 1 row inserted/updated/deleted 2774 del < ij> insert into foo values (13, PADSTRING('13',500), 1); 2775 del < 1 row inserted/updated/deleted 2776 del < ij> insert into foo values (14, PADSTRING('14',500), 1); 2777 del < 1 row inserted/updated/deleted 2778 del < ij> insert into foo values (15, PADSTRING('15',500), 1); 2779 del < 1 row inserted/updated/deleted 2780 del < ij> insert into foo values (16, PADSTRING('16',500), 1); 2781 del < 1 row inserted/updated/deleted 2782 del < ij> insert into foo values (17, PADSTRING('17',500), 1); 2783 del < 1 row inserted/updated/deleted 2784 del < ij> insert into foo values (18, PADSTRING('18',500), 1); 2785 del < 1 row inserted/updated/deleted 2786 del < ij> insert into foo values (2, PADSTRING('2',500), 1); 2787 del < 1 row inserted/updated/deleted 2788 del < ij> insert into foo values (3, PADSTRING('3',500), 1); 2789 del < 1 row inserted/updated/deleted 2790 del < ij> insert into foo values (4, PADSTRING('4',500), 1); 2791 del < 1 row inserted/updated/deleted 2792 del < ij> insert into foo values (5, PADSTRING('5',500), 1); 2793 del < 1 row inserted/updated/deleted 2794 del < ij> insert into foo values (6, PADSTRING('6',500), 1); 2795 del < 1 row inserted/updated/deleted 2796 del < ij> insert into foo values (7, PADSTRING('7',500), 1); 2797 del < 1 row inserted/updated/deleted 2798 del < ij> insert into foo values (8, PADSTRING('8',500), 1); 2799 del < 1 row inserted/updated/deleted 2800 del < ij> insert into foo values (9, PADSTRING('9',500), 1); 2801 del < 1 row inserted/updated/deleted 2802 del < ij> create index foox on foo (b); 2803 del < 0 rows inserted/updated/deleted 2804 del < ij> commit; 2805 del < ij> -- normal max optimization, last row in index is not deleted. 2806 del < select max(b) from foo; 2807 del < 1 2808 del < -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2809 del < 9 2810 del < ij> -- new max optimization, last row in index is deleted but others on page aren't. 2811 del < delete from foo where a = 9; 2812 del < 1 row inserted/updated/deleted 2813 del < ij> select max(b) from foo; 2814 del < 1 2815 del < -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2816 del < 8 2817 del < ij> -- new max optimization, last row in index is deleted but others on page aren't. 2818 del < delete from foo where a = 8; 2819 del < 1 row inserted/updated/deleted 2820 del < ij> select max(b) from foo; 2821 del < 1 2822 del < -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2823 del < 7 2824 del < ij> -- max optimization does not work - fail over to scan, all rows on last page are 2825 del < -- deleted. 2826 del < delete from foo where a > 2; 2827 del < 13 rows inserted/updated/deleted 2828 del < ij> select max(b) from foo; 2829 del < 1 2830 del < -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2831 del < 2 2832 del < ij> commit; 2833 del < ij> drop table foo; 2834 del < 0 rows inserted/updated/deleted 2835 del < ij> ------------------------------------------------------------------------ 2836 del < -- regression test for bugs 3368, 3370 2837 del < -- the bugs arose for the edge case where pageReservedSpace = 100 2838 del < -- before bug 3368 was fixed, a short row insert caused 2 pages to be 2839 del < -- allocated per short row insert. 2840 del < drop table a; 2841 del < 0 rows inserted/updated/deleted 2842 del < ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageReservedSpace', '100'); 2843 del < 0 rows inserted/updated/deleted 2844 del < ij> create table a (a int); 2845 del < 0 rows inserted/updated/deleted 2846 del < ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageReservedSpace', NULL); 2847 del < 0 rows inserted/updated/deleted 2848 del < ij> insert into a values (1); 2849 del < 1 row inserted/updated/deleted 2850 del < ij> select numallocatedpages from new org.apache.derby.diag.SpaceTable('A') as a; 2851 del < NUMALLOCATEDPAGES 2852 del < -------------------- 2853 del < 2 2854 del < ij> insert into a values (2); 2855 del < 1 row inserted/updated/deleted 2856 del < ij> select numallocatedpages from new org.apache.derby.diag.SpaceTable('A') as a; 2857 del < NUMALLOCATEDPAGES 2858 del < -------------------- 2859 del < 3 2860 del < ij> insert into a values (1); 2861 del < 1 row inserted/updated/deleted 2862 del < ij> select numallocatedpages from new org.apache.derby.diag.SpaceTable('A') as a; 2863 del < NUMALLOCATEDPAGES 2864 del < -------------------- 2865 del < 4 2866 del < ij> insert into a values (2); 2867 del < 1 row inserted/updated/deleted 2868 del < ij> select numallocatedpages from new org.apache.derby.diag.SpaceTable('A') as a; 2869 del < NUMALLOCATEDPAGES 2870 del < -------------------- 2871 del < 5 2872 del < ij> ------------------------------------------------------------------------ 2873 del < -- regression test for bug 4595, make sure index used in unique key update 2874 del < -- even if table has zero rows. 2875 del < -- 2876 del < call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1); 2877 del < 0 rows inserted/updated/deleted 2878 del < ij> maximumdisplaywidth 9000; 2879 del < ij> -- try delete/update statement compiled against table with 0 rows 2880 del < drop table foo; 2881 del < ERROR 42Y55: 'DROP TABLE' cannot be performed on 'FOO' because it does not exist. 2882 del < ij> create table foo (a int, b int); 2883 del < 0 rows inserted/updated/deleted 2884 del < ij> create unique index foox on foo (a); 2885 del < 0 rows inserted/updated/deleted 2886 del < ij> -- delete against table with 0 rows. 2887 del < delete from foo where a = 1; 2888 del < 0 rows inserted/updated/deleted 2889 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 2890 del < 1 2891 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2892 del < Statement Name: 2893 del < null 2894 del < Statement Text: 2895 del < -- delete against table with 0 rows. 2896 del < delete from foo where a = 1 2897 del < Parse Time: 0 2898 del < Bind Time: 0 2899 del < Optimize Time: 0 2900 del < Generate Time: 0 2901 del < Compile Time: 0 2902 del < Execute Time: 0 2903 del < Begin Compilation Timestamp : null 2904 del < End Compilation Timestamp : null 2905 del < Begin Execution Timestamp : null 2906 del < End Execution Timestamp : null 2907 del < Statement Execution Plan Text: 2908 del < Delete ResultSet using row locking: 2909 del < deferred: false 2910 del < Rows deleted = 0 2911 del < Indexes updated = 1 2912 del < Execute Time = 0 2913 del < Project-Restrict ResultSet (2): 2914 del < Number of opens = 1 2915 del < Rows seen = 0 2916 del < Rows filtered = 0 2917 del < restriction = false 2918 del < projection = true 2919 del < constructor time (milliseconds) = 0 2920 del < open time (milliseconds) = 0 2921 del < next time (milliseconds) = 0 2922 del < close time (milliseconds) = 0 2923 del < restriction time (milliseconds) = 0 2924 del < projection time (milliseconds) = 0 2925 del < Source result set: 2926 del < Project-Restrict ResultSet (1): 2927 del < Number of opens = 1 2928 del < Rows seen = 0 2929 del < Rows filtered = 0 2930 del < restriction = false 2931 del < projection = true 2932 del < constructor time (milliseconds) = 0 2933 del < open time (milliseconds) = 0 2934 del < next time (milliseconds) = 0 2935 del < close time (milliseconds) = 0 2936 del < restriction time (milliseconds) = 0 2937 del < projection time (milliseconds) = 0 2938 del < Source result set: 2939 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using exclusive row locking chosen by the optimizer 2940 del < Number of opens = 1 2941 del < Rows seen = 0 2942 del < Rows filtered = 0 2943 del < Fetch Size = 1 2944 del < constructor time (milliseconds) = 0 2945 del < open time (milliseconds) = 0 2946 del < next time (milliseconds) = 0 2947 del < close time (milliseconds) = 0 2948 del < scan information: 2949 del < Bit set of columns fetched={0, 1} 2950 del < Number of columns fetched=2 2951 del < Number of deleted rows visited=0 2952 del < Number of pages visited=1 2953 del < Number of rows qualified=0 2954 del < Number of rows visited=0 2955 del < Scan type=btree 2956 del < Tree height=1 2957 del < start position: 2958 del < >= on first 1 column(s). 2959 del < Ordered null semantics on the following columns: 2960 del < stop position: 2961 del < > on first 1 column(s). 2962 del < Ordered null semantics on the following columns: 2963 del < qualifiers: 2964 del < None 2965 del < ij> -- update against table with 0 rows. 2966 del < update foo set b = 1 where a = 2; 2967 del < 0 rows inserted/updated/deleted 2968 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 2969 del < 1 2970 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2971 del < Statement Name: 2972 del < null 2973 del < Statement Text: 2974 del < -- update against table with 0 rows. 2975 del < update foo set b = 1 where a = 2 2976 del < Parse Time: 0 2977 del < Bind Time: 0 2978 del < Optimize Time: 0 2979 del < Generate Time: 0 2980 del < Compile Time: 0 2981 del < Execute Time: 0 2982 del < Begin Compilation Timestamp : null 2983 del < End Compilation Timestamp : null 2984 del < Begin Execution Timestamp : null 2985 del < End Execution Timestamp : null 2986 del < Statement Execution Plan Text: 2987 del < Update ResultSet using row locking: 2988 del < deferred: false 2989 del < Rows updated = 0 2990 del < Indexes updated = 0 2991 del < Execute Time = 0 2992 del < Project-Restrict ResultSet (2): 2993 del < Number of opens = 1 2994 del < Rows seen = 0 2995 del < Rows filtered = 0 2996 del < restriction = false 2997 del < projection = true 2998 del < constructor time (milliseconds) = 0 2999 del < open time (milliseconds) = 0 3000 del < next time (milliseconds) = 0 3001 del < close time (milliseconds) = 0 3002 del < restriction time (milliseconds) = 0 3003 del < projection time (milliseconds) = 0 3004 del < Source result set: 3005 del < Index Row to Base Row ResultSet for FOO: 3006 del < Number of opens = 1 3007 del < Rows seen = 0 3008 del < Columns accessed from heap = {1} 3009 del < constructor time (milliseconds) = 0 3010 del < open time (milliseconds) = 0 3011 del < next time (milliseconds) = 0 3012 del < close time (milliseconds) = 0 3013 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using exclusive row locking chosen by the optimizer 3014 del < Number of opens = 1 3015 del < Rows seen = 0 3016 del < Rows filtered = 0 3017 del < Fetch Size = 1 3018 del < constructor time (milliseconds) = 0 3019 del < open time (milliseconds) = 0 3020 del < next time (milliseconds) = 0 3021 del < close time (milliseconds) = 0 3022 del < scan information: 3023 del < Bit set of columns fetched=All 3024 del < Number of columns fetched=2 3025 del < Number of deleted rows visited=0 3026 del < Number of pages visited=1 3027 del < Number of rows qualified=0 3028 del < Number of rows visited=0 3029 del < Scan type=btree 3030 del < Tree height=1 3031 del < start position: 3032 del < >= on first 1 column(s). 3033 del < Ordered null semantics on the following columns: 3034 del < stop position: 3035 del < > on first 1 column(s). 3036 del < Ordered null semantics on the following columns: 3037 del < qualifiers: 3038 del < None 3039 del < ij> -- select against table with 0 rows. 3040 del < select * from foo where a = 2; 3041 del < A |B 3042 del < ----------------------- 3043 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 3044 del < 1 3045 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3046 del < Statement Name: 3047 del < null 3048 del < Statement Text: 3049 del < -- select against table with 0 rows. 3050 del < select * from foo where a = 2 3051 del < Parse Time: 0 3052 del < Bind Time: 0 3053 del < Optimize Time: 0 3054 del < Generate Time: 0 3055 del < Compile Time: 0 3056 del < Execute Time: 0 3057 del < Begin Compilation Timestamp : null 3058 del < End Compilation Timestamp : null 3059 del < Begin Execution Timestamp : null 3060 del < End Execution Timestamp : null 3061 del < Statement Execution Plan Text: 3062 del < Index Row to Base Row ResultSet for FOO: 3063 del < Number of opens = 1 3064 del < Rows seen = 0 3065 del < Columns accessed from heap = {1} 3066 del < constructor time (milliseconds) = 0 3067 del < open time (milliseconds) = 0 3068 del < next time (milliseconds) = 0 3069 del < close time (milliseconds) = 0 3070 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using share row locking chosen by the optimizer 3071 del < Number of opens = 1 3072 del < Rows seen = 0 3073 del < Rows filtered = 0 3074 del < Fetch Size = 1 3075 del < constructor time (milliseconds) = 0 3076 del < open time (milliseconds) = 0 3077 del < next time (milliseconds) = 0 3078 del < close time (milliseconds) = 0 3079 del < scan information: 3080 del < Bit set of columns fetched=All 3081 del < Number of columns fetched=2 3082 del < Number of deleted rows visited=0 3083 del < Number of pages visited=1 3084 del < Number of rows qualified=0 3085 del < Number of rows visited=0 3086 del < Scan type=btree 3087 del < Tree height=1 3088 del < start position: 3089 del < >= on first 1 column(s). 3090 del < Ordered null semantics on the following columns: 3091 del < stop position: 3092 del < > on first 1 column(s). 3093 del < Ordered null semantics on the following columns: 3094 del < qualifiers: 3095 del < None 3096 del < ij> -- select against table with 0 rows. 3097 del < select a from foo where a = 2; 3098 del < A 3099 del < ----------- 3100 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 3101 del < 1 3102 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3103 del < Statement Name: 3104 del < null 3105 del < Statement Text: 3106 del < -- select against table with 0 rows. 3107 del < select a from foo where a = 2 3108 del < Parse Time: 0 3109 del < Bind Time: 0 3110 del < Optimize Time: 0 3111 del < Generate Time: 0 3112 del < Compile Time: 0 3113 del < Execute Time: 0 3114 del < Begin Compilation Timestamp : null 3115 del < End Compilation Timestamp : null 3116 del < Begin Execution Timestamp : null 3117 del < End Execution Timestamp : null 3118 del < Statement Execution Plan Text: 3119 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using share row locking chosen by the optimizer 3120 del < Number of opens = 1 3121 del < Rows seen = 0 3122 del < Rows filtered = 0 3123 del < Fetch Size = 1 3124 del < constructor time (milliseconds) = 0 3125 del < open time (milliseconds) = 0 3126 del < next time (milliseconds) = 0 3127 del < close time (milliseconds) = 0 3128 del < scan information: 3129 del < Bit set of columns fetched={0} 3130 del < Number of columns fetched=1 3131 del < Number of deleted rows visited=0 3132 del < Number of pages visited=1 3133 del < Number of rows qualified=0 3134 del < Number of rows visited=0 3135 del < Scan type=btree 3136 del < Tree height=1 3137 del < start position: 3138 del < >= on first 1 column(s). 3139 del < Ordered null semantics on the following columns: 3140 del < stop position: 3141 del < > on first 1 column(s). 3142 del < Ordered null semantics on the following columns: 3143 del < qualifiers: 3144 del < None 3145 del < ij> -- select against table with 0 rows. 3146 del < select a from foo where a = 2; 3147 del < A 3148 del < ----------- 3149 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 3150 del < 1 3151 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3152 del < Statement Name: 3153 del < null 3154 del < Statement Text: 3155 del < -- select against table with 0 rows. 3156 del < select a from foo where a = 2 3157 del < Parse Time: 0 3158 del < Bind Time: 0 3159 del < Optimize Time: 0 3160 del < Generate Time: 0 3161 del < Compile Time: 0 3162 del < Execute Time: 0 3163 del < Begin Compilation Timestamp : null 3164 del < End Compilation Timestamp : null 3165 del < Begin Execution Timestamp : null 3166 del < End Execution Timestamp : null 3167 del < Statement Execution Plan Text: 3168 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using share row locking chosen by the optimizer 3169 del < Number of opens = 1 3170 del < Rows seen = 0 3171 del < Rows filtered = 0 3172 del < Fetch Size = 1 3173 del < constructor time (milliseconds) = 0 3174 del < open time (milliseconds) = 0 3175 del < next time (milliseconds) = 0 3176 del < close time (milliseconds) = 0 3177 del < scan information: 3178 del < Bit set of columns fetched={0} 3179 del < Number of columns fetched=1 3180 del < Number of deleted rows visited=0 3181 del < Number of pages visited=1 3182 del < Number of rows qualified=0 3183 del < Number of rows visited=0 3184 del < Scan type=btree 3185 del < Tree height=1 3186 del < start position: 3187 del < >= on first 1 column(s). 3188 del < Ordered null semantics on the following columns: 3189 del < stop position: 3190 del < > on first 1 column(s). 3191 del < Ordered null semantics on the following columns: 3192 del < qualifiers: 3193 del < None 3194 del < ij> -- now insert one row and make sure still same plan. Previous to 4595 3195 del < -- 0 row plan was a table scan and it would not change when 1 row was inserted. 3196 del < insert into foo values (1, 1); 3197 del < 1 row inserted/updated/deleted 3198 del < ij> -- update against table with 1 row. 3199 del < update foo set b = 2 where a = 1; 3200 del < 1 row inserted/updated/deleted 3201 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 3202 del < 1 3203 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3204 del < Statement Name: 3205 del < null 3206 del < Statement Text: 3207 del < -- update against table with 1 row. 3208 del < update foo set b = 2 where a = 1 3209 del < Parse Time: 0 3210 del < Bind Time: 0 3211 del < Optimize Time: 0 3212 del < Generate Time: 0 3213 del < Compile Time: 0 3214 del < Execute Time: 0 3215 del < Begin Compilation Timestamp : null 3216 del < End Compilation Timestamp : null 3217 del < Begin Execution Timestamp : null 3218 del < End Execution Timestamp : null 3219 del < Statement Execution Plan Text: 3220 del < Update ResultSet using row locking: 3221 del < deferred: false 3222 del < Rows updated = 1 3223 del < Indexes updated = 0 3224 del < Execute Time = 0 3225 del < Project-Restrict ResultSet (2): 3226 del < Number of opens = 1 3227 del < Rows seen = 1 3228 del < Rows filtered = 0 3229 del < restriction = false 3230 del < projection = true 3231 del < constructor time (milliseconds) = 0 3232 del < open time (milliseconds) = 0 3233 del < next time (milliseconds) = 0 3234 del < close time (milliseconds) = 0 3235 del < restriction time (milliseconds) = 0 3236 del < projection time (milliseconds) = 0 3237 del < Source result set: 3238 del < Index Row to Base Row ResultSet for FOO: 3239 del < Number of opens = 1 3240 del < Rows seen = 1 3241 del < Columns accessed from heap = {1} 3242 del < constructor time (milliseconds) = 0 3243 del < open time (milliseconds) = 0 3244 del < next time (milliseconds) = 0 3245 del < close time (milliseconds) = 0 3246 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using exclusive row locking chosen by the optimizer 3247 del < Number of opens = 1 3248 del < Rows seen = 1 3249 del < Rows filtered = 0 3250 del < Fetch Size = 1 3251 del < constructor time (milliseconds) = 0 3252 del < open time (milliseconds) = 0 3253 del < next time (milliseconds) = 0 3254 del < close time (milliseconds) = 0 3255 del < next time in milliseconds/row = 0 3256 del < scan information: 3257 del < Bit set of columns fetched=All 3258 del < Number of columns fetched=2 3259 del < Number of deleted rows visited=0 3260 del < Number of pages visited=1 3261 del < Number of rows qualified=1 3262 del < Number of rows visited=1 3263 del < Scan type=btree 3264 del < Tree height=1 3265 del < start position: 3266 del < >= on first 1 column(s). 3267 del < Ordered null semantics on the following columns: 3268 del < stop position: 3269 del < > on first 1 column(s). 3270 del < Ordered null semantics on the following columns: 3271 del < qualifiers: 3272 del < None 3273 del < ij> -- delete against table with 1 row. 3274 del < delete from foo where a = 1; 3275 del < 1 row inserted/updated/deleted 3276 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 3277 del < 1 3278 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3279 del < Statement Name: 3280 del < null 3281 del < Statement Text: 3282 del < -- delete against table with 1 row. 3283 del < delete from foo where a = 1 3284 del < Parse Time: 0 3285 del < Bind Time: 0 3286 del < Optimize Time: 0 3287 del < Generate Time: 0 3288 del < Compile Time: 0 3289 del < Execute Time: 0 3290 del < Begin Compilation Timestamp : null 3291 del < End Compilation Timestamp : null 3292 del < Begin Execution Timestamp : null 3293 del < End Execution Timestamp : null 3294 del < Statement Execution Plan Text: 3295 del < Delete ResultSet using row locking: 3296 del < deferred: false 3297 del < Rows deleted = 1 3298 del < Indexes updated = 1 3299 del < Execute Time = 0 3300 del < Project-Restrict ResultSet (2): 3301 del < Number of opens = 1 3302 del < Rows seen = 1 3303 del < Rows filtered = 0 3304 del < restriction = false 3305 del < projection = true 3306 del < constructor time (milliseconds) = 0 3307 del < open time (milliseconds) = 0 3308 del < next time (milliseconds) = 0 3309 del < close time (milliseconds) = 0 3310 del < restriction time (milliseconds) = 0 3311 del < projection time (milliseconds) = 0 3312 del < Source result set: 3313 del < Project-Restrict ResultSet (1): 3314 del < Number of opens = 1 3315 del < Rows seen = 1 3316 del < Rows filtered = 0 3317 del < restriction = false 3318 del < projection = true 3319 del < constructor time (milliseconds) = 0 3320 del < open time (milliseconds) = 0 3321 del < next time (milliseconds) = 0 3322 del < close time (milliseconds) = 0 3323 del < restriction time (milliseconds) = 0 3324 del < projection time (milliseconds) = 0 3325 del < Source result set: 3326 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using exclusive row locking chosen by the optimizer 3327 del < Number of opens = 1 3328 del < Rows seen = 1 3329 del < Rows filtered = 0 3330 del < Fetch Size = 1 3331 del < constructor time (milliseconds) = 0 3332 del < open time (milliseconds) = 0 3333 del < next time (milliseconds) = 0 3334 del < close time (milliseconds) = 0 3335 del < next time in milliseconds/row = 0 3336 del < scan information: 3337 del < Bit set of columns fetched={0, 1} 3338 del < Number of columns fetched=2 3339 del < Number of deleted rows visited=0 3340 del < Number of pages visited=1 3341 del < Number of rows qualified=1 3342 del < Number of rows visited=1 3343 del < Scan type=btree 3344 del < Tree height=1 3345 del < start position: 3346 del < >= on first 1 column(s). 3347 del < Ordered null semantics on the following columns: 3348 del < stop position: 3349 del < > on first 1 column(s). 3350 del < Ordered null semantics on the following columns: 3351 del < qualifiers: 3352 del < None 3353 del < ij> -- try delete/update statement compiled against table with 1 row. 3354 del < drop table foo; 3355 del < 0 rows inserted/updated/deleted 3356 del < ij> create table foo (a int, b int); 3357 del < 0 rows inserted/updated/deleted 3358 del < ij> insert into foo values (1, 1); 3359 del < 1 row inserted/updated/deleted 3360 del < ij> create unique index foox on foo (a); 3361 del < 0 rows inserted/updated/deleted 3362 del < ij> -- update against table with 1 row. 3363 del < update foo set b = 2 where a = 1; 3364 del < 1 row inserted/updated/deleted 3365 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 3366 del < 1 3367 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3368 del < Statement Name: 3369 del < null 3370 del < Statement Text: 3371 del < -- update against table with 1 row. 3372 del < update foo set b = 2 where a = 1 3373 del < Parse Time: 0 3374 del < Bind Time: 0 3375 del < Optimize Time: 0 3376 del < Generate Time: 0 3377 del < Compile Time: 0 3378 del < Execute Time: 0 3379 del < Begin Compilation Timestamp : null 3380 del < End Compilation Timestamp : null 3381 del < Begin Execution Timestamp : null 3382 del < End Execution Timestamp : null 3383 del < Statement Execution Plan Text: 3384 del < Update ResultSet using row locking: 3385 del < deferred: false 3386 del < Rows updated = 1 3387 del < Indexes updated = 0 3388 del < Execute Time = 0 3389 del < Project-Restrict ResultSet (2): 3390 del < Number of opens = 1 3391 del < Rows seen = 1 3392 del < Rows filtered = 0 3393 del < restriction = false 3394 del < projection = true 3395 del < constructor time (milliseconds) = 0 3396 del < open time (milliseconds) = 0 3397 del < next time (milliseconds) = 0 3398 del < close time (milliseconds) = 0 3399 del < restriction time (milliseconds) = 0 3400 del < projection time (milliseconds) = 0 3401 del < Source result set: 3402 del < Index Row to Base Row ResultSet for FOO: 3403 del < Number of opens = 1 3404 del < Rows seen = 1 3405 del < Columns accessed from heap = {1} 3406 del < constructor time (milliseconds) = 0 3407 del < open time (milliseconds) = 0 3408 del < next time (milliseconds) = 0 3409 del < close time (milliseconds) = 0 3410 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using exclusive row locking chosen by the optimizer 3411 del < Number of opens = 1 3412 del < Rows seen = 1 3413 del < Rows filtered = 0 3414 del < Fetch Size = 1 3415 del < constructor time (milliseconds) = 0 3416 del < open time (milliseconds) = 0 3417 del < next time (milliseconds) = 0 3418 del < close time (milliseconds) = 0 3419 del < next time in milliseconds/row = 0 3420 del < scan information: 3421 del < Bit set of columns fetched=All 3422 del < Number of columns fetched=2 3423 del < Number of deleted rows visited=0 3424 del < Number of pages visited=1 3425 del < Number of rows qualified=1 3426 del < Number of rows visited=1 3427 del < Scan type=btree 3428 del < Tree height=1 3429 del < start position: 3430 del < >= on first 1 column(s). 3431 del < Ordered null semantics on the following columns: 3432 del < stop position: 3433 del < > on first 1 column(s). 3434 del < Ordered null semantics on the following columns: 3435 del < qualifiers: 3436 del < None 3437 del < ij> -- delete against table with 1 row. 3438 del < delete from foo where a = 1; 3439 del < 1 row inserted/updated/deleted 3440 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 3441 del < 1 3442 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3443 del < Statement Name: 3444 del < null 3445 del < Statement Text: 3446 del < -- delete against table with 1 row. 3447 del < delete from foo where a = 1 3448 del < Parse Time: 0 3449 del < Bind Time: 0 3450 del < Optimize Time: 0 3451 del < Generate Time: 0 3452 del < Compile Time: 0 3453 del < Execute Time: 0 3454 del < Begin Compilation Timestamp : null 3455 del < End Compilation Timestamp : null 3456 del < Begin Execution Timestamp : null 3457 del < End Execution Timestamp : null 3458 del < Statement Execution Plan Text: 3459 del < Delete ResultSet using row locking: 3460 del < deferred: false 3461 del < Rows deleted = 1 3462 del < Indexes updated = 1 3463 del < Execute Time = 0 3464 del < Project-Restrict ResultSet (2): 3465 del < Number of opens = 1 3466 del < Rows seen = 1 3467 del < Rows filtered = 0 3468 del < restriction = false 3469 del < projection = true 3470 del < constructor time (milliseconds) = 0 3471 del < open time (milliseconds) = 0 3472 del < next time (milliseconds) = 0 3473 del < close time (milliseconds) = 0 3474 del < restriction time (milliseconds) = 0 3475 del < projection time (milliseconds) = 0 3476 del < Source result set: 3477 del < Project-Restrict ResultSet (1): 3478 del < Number of opens = 1 3479 del < Rows seen = 1 3480 del < Rows filtered = 0 3481 del < restriction = false 3482 del < projection = true 3483 del < constructor time (milliseconds) = 0 3484 del < open time (milliseconds) = 0 3485 del < next time (milliseconds) = 0 3486 del < close time (milliseconds) = 0 3487 del < restriction time (milliseconds) = 0 3488 del < projection time (milliseconds) = 0 3489 del < Source result set: 3490 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using exclusive row locking chosen by the optimizer 3491 del < Number of opens = 1 3492 del < Rows seen = 1 3493 del < Rows filtered = 0 3494 del < Fetch Size = 1 3495 del < constructor time (milliseconds) = 0 3496 del < open time (milliseconds) = 0 3497 del < next time (milliseconds) = 0 3498 del < close time (milliseconds) = 0 3499 del < next time in milliseconds/row = 0 3500 del < scan information: 3501 del < Bit set of columns fetched={0, 1} 3502 del < Number of columns fetched=2 3503 del < Number of deleted rows visited=0 3504 del < Number of pages visited=1 3505 del < Number of rows qualified=1 3506 del < Number of rows visited=1 3507 del < Scan type=btree 3508 del < Tree height=1 3509 del < start position: 3510 del < >= on first 1 column(s). 3511 del < Ordered null semantics on the following columns: 3512 del < stop position: 3513 del < > on first 1 column(s). 3514 del < Ordered null semantics on the following columns: 3515 del < qualifiers: 3516 del < None 3517 del < ij> -- repeat set of 4595 tests against table with primary key, vs. unique index - 3518 del < -- there should be no difference in plan shape. 3519 del < -- try delete/update statement compiled against table with 0 rows 3520 del < drop table foo; 3521 del < 0 rows inserted/updated/deleted 3522 del < ij> create table foo (a int not null primary key, b int); 3523 del < 0 rows inserted/updated/deleted 3524 del < ij> -- delete against table with 0 rows. 3525 del < delete from foo where a = 1; 3526 del < 0 rows inserted/updated/deleted 3527 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 3528 del < 1 3529 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3530 del < Statement Name: 3531 del < null 3532 del < Statement Text: 3533 del < -- delete against table with 0 rows. 3534 del < delete from foo where a = 1 3535 del < Parse Time: 0 3536 del < Bind Time: 0 3537 del < Optimize Time: 0 3538 del < Generate Time: 0 3539 del < Compile Time: 0 3540 del < Execute Time: 0 3541 del < Begin Compilation Timestamp : null 3542 del < End Compilation Timestamp : null 3543 del < Begin Execution Timestamp : null 3544 del < End Execution Timestamp : null 3545 del < Statement Execution Plan Text: 3546 del < Delete ResultSet using row locking: 3547 del < deferred: false 3548 del < Rows deleted = 0 3549 del < Indexes updated = 1 3550 del < Execute Time = 0 3551 del < Project-Restrict ResultSet (2): 3552 del < Number of opens = 1 3553 del < Rows seen = 0 3554 del < Rows filtered = 0 3555 del < restriction = false 3556 del < projection = true 3557 del < constructor time (milliseconds) = 0 3558 del < open time (milliseconds) = 0 3559 del < next time (milliseconds) = 0 3560 del < close time (milliseconds) = 0 3561 del < restriction time (milliseconds) = 0 3562 del < projection time (milliseconds) = 0 3563 del < Source result set: 3564 del < Project-Restrict ResultSet (1): 3565 del < Number of opens = 1 3566 del < Rows seen = 0 3567 del < Rows filtered = 0 3568 del < restriction = false 3569 del < projection = true 3570 del < constructor time (milliseconds) = 0 3571 del < open time (milliseconds) = 0 3572 del < next time (milliseconds) = 0 3573 del < close time (milliseconds) = 0 3574 del < restriction time (milliseconds) = 0 3575 del < projection time (milliseconds) = 0 3576 del < Source result set: 3577 del < Index Scan ResultSet for FOO using constraint xxxxGENERATED-IDxxxx at serializable isolation level using exclusive row locking chosen by the optimizer 3578 del < Number of opens = 1 3579 del < Rows seen = 0 3580 del < Rows filtered = 0 3581 del < Fetch Size = 1 3582 del < constructor time (milliseconds) = 0 3583 del < open time (milliseconds) = 0 3584 del < next time (milliseconds) = 0 3585 del < close time (milliseconds) = 0 3586 del < scan information: 3587 del < Bit set of columns fetched={0, 1} 3588 del < Number of columns fetched=2 3589 del < Number of deleted rows visited=0 3590 del < Number of pages visited=1 3591 del < Number of rows qualified=0 3592 del < Number of rows visited=0 3593 del < Scan type=btree 3594 del < Tree height=1 3595 del < start position: 3596 del < >= on first 1 column(s). 3597 del < Ordered null semantics on the following columns: 3598 del < 0 3599 del < stop position: 3600 del < > on first 1 column(s). 3601 del < Ordered null semantics on the following columns: 3602 del < 0 3603 del < qualifiers: 3604 del < None 3605 del < ij> -- update against table with 0 rows. 3606 del < update foo set b = 1 where a = 2; 3607 del < 0 rows inserted/updated/deleted 3608 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 3609 del < 1 3610 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3611 del < Statement Name: 3612 del < null 3613 del < Statement Text: 3614 del < -- update against table with 0 rows. 3615 del < update foo set b = 1 where a = 2 3616 del < Parse Time: 0 3617 del < Bind Time: 0 3618 del < Optimize Time: 0 3619 del < Generate Time: 0 3620 del < Compile Time: 0 3621 del < Execute Time: 0 3622 del < Begin Compilation Timestamp : null 3623 del < End Compilation Timestamp : null 3624 del < Begin Execution Timestamp : null 3625 del < End Execution Timestamp : null 3626 del < Statement Execution Plan Text: 3627 del < Update ResultSet using row locking: 3628 del < deferred: false 3629 del < Rows updated = 0 3630 del < Indexes updated = 0 3631 del < Execute Time = 0 3632 del < Project-Restrict ResultSet (2): 3633 del < Number of opens = 1 3634 del < Rows seen = 0 3635 del < Rows filtered = 0 3636 del < restriction = false 3637 del < projection = true 3638 del < constructor time (milliseconds) = 0 3639 del < open time (milliseconds) = 0 3640 del < next time (milliseconds) = 0 3641 del < close time (milliseconds) = 0 3642 del < restriction time (milliseconds) = 0 3643 del < projection time (milliseconds) = 0 3644 del < Source result set: 3645 del < Index Row to Base Row ResultSet for FOO: 3646 del < Number of opens = 1 3647 del < Rows seen = 0 3648 del < Columns accessed from heap = {1} 3649 del < constructor time (milliseconds) = 0 3650 del < open time (milliseconds) = 0 3651 del < next time (milliseconds) = 0 3652 del < close time (milliseconds) = 0 3653 del < Index Scan ResultSet for FOO using constraint xxxxGENERATED-IDxxxx at serializable isolation level using exclusive row locking chosen by the optimizer 3654 del < Number of opens = 1 3655 del < Rows seen = 0 3656 del < Rows filtered = 0 3657 del < Fetch Size = 1 3658 del < constructor time (milliseconds) = 0 3659 del < open time (milliseconds) = 0 3660 del < next time (milliseconds) = 0 3661 del < close time (milliseconds) = 0 3662 del < scan information: 3663 del < Bit set of columns fetched=All 3664 del < Number of columns fetched=2 3665 del < Number of deleted rows visited=0 3666 del < Number of pages visited=1 3667 del < Number of rows qualified=0 3668 del < Number of rows visited=0 3669 del < Scan type=btree 3670 del < Tree height=1 3671 del < start position: 3672 del < >= on first 1 column(s). 3673 del < Ordered null semantics on the following columns: 3674 del < 0 3675 del < stop position: 3676 del < > on first 1 column(s). 3677 del < Ordered null semantics on the following columns: 3678 del < 0 3679 del < qualifiers: 3680 del < None 3681 del < ij> -- select against table with 0 rows. 3682 del < select * from foo where a = 2; 3683 del < A |B 3684 del < ----------------------- 3685 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 3686 del < 1 3687 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3688 del < Statement Name: 3689 del < null 3690 del < Statement Text: 3691 del < -- select against table with 0 rows. 3692 del < select * from foo where a = 2 3693 del < Parse Time: 0 3694 del < Bind Time: 0 3695 del < Optimize Time: 0 3696 del < Generate Time: 0 3697 del < Compile Time: 0 3698 del < Execute Time: 0 3699 del < Begin Compilation Timestamp : null 3700 del < End Compilation Timestamp : null 3701 del < Begin Execution Timestamp : null 3702 del < End Execution Timestamp : null 3703 del < Statement Execution Plan Text: 3704 del < Index Row to Base Row ResultSet for FOO: 3705 del < Number of opens = 1 3706 del < Rows seen = 0 3707 del < Columns accessed from heap = {1} 3708 del < constructor time (milliseconds) = 0 3709 del < open time (milliseconds) = 0 3710 del < next time (milliseconds) = 0 3711 del < close time (milliseconds) = 0 3712 del < Index Scan ResultSet for FOO using constraint xxxxGENERATED-IDxxxx at serializable isolation level using share row locking chosen by the optimizer 3713 del < Number of opens = 1 3714 del < Rows seen = 0 3715 del < Rows filtered = 0 3716 del < Fetch Size = 1 3717 del < constructor time (milliseconds) = 0 3718 del < open time (milliseconds) = 0 3719 del < next time (milliseconds) = 0 3720 del < close time (milliseconds) = 0 3721 del < scan information: 3722 del < Bit set of columns fetched=All 3723 del < Number of columns fetched=2 3724 del < Number of deleted rows visited=0 3725 del < Number of pages visited=1 3726 del < Number of rows qualified=0 3727 del < Number of rows visited=0 3728 del < Scan type=btree 3729 del < Tree height=1 3730 del < start position: 3731 del < >= on first 1 column(s). 3732 del < Ordered null semantics on the following columns: 3733 del < 0 3734 del < stop position: 3735 del < > on first 1 column(s). 3736 del < Ordered null semantics on the following columns: 3737 del < 0 3738 del < qualifiers: 3739 del < None 3740 del < ij> -- select against table with 0 rows. 3741 del < select a from foo where a = 2; 3742 del < A 3743 del < ----------- 3744 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 3745 del < 1 3746 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3747 del < Statement Name: 3748 del < null 3749 del < Statement Text: 3750 del < -- select against table with 0 rows. 3751 del < select a from foo where a = 2 3752 del < Parse Time: 0 3753 del < Bind Time: 0 3754 del < Optimize Time: 0 3755 del < Generate Time: 0 3756 del < Compile Time: 0 3757 del < Execute Time: 0 3758 del < Begin Compilation Timestamp : null 3759 del < End Compilation Timestamp : null 3760 del < Begin Execution Timestamp : null 3761 del < End Execution Timestamp : null 3762 del < Statement Execution Plan Text: 3763 del < Index Scan ResultSet for FOO using constraint xxxxGENERATED-IDxxxx at serializable isolation level using share row locking chosen by the optimizer 3764 del < Number of opens = 1 3765 del < Rows seen = 0 3766 del < Rows filtered = 0 3767 del < Fetch Size = 1 3768 del < constructor time (milliseconds) = 0 3769 del < open time (milliseconds) = 0 3770 del < next time (milliseconds) = 0 3771 del < close time (milliseconds) = 0 3772 del < scan information: 3773 del < Bit set of columns fetched={0} 3774 del < Number of columns fetched=1 3775 del < Number of deleted rows visited=0 3776 del < Number of pages visited=1 3777 del < Number of rows qualified=0 3778 del < Number of rows visited=0 3779 del < Scan type=btree 3780 del < Tree height=1 3781 del < start position: 3782 del < >= on first 1 column(s). 3783 del < Ordered null semantics on the following columns: 3784 del < 0 3785 del < stop position: 3786 del < > on first 1 column(s). 3787 del < Ordered null semantics on the following columns: 3788 del < 0 3789 del < qualifiers: 3790 del < None 3791 del < ij> -- select against table with 0 rows. 3792 del < select a from foo where a = 2; 3793 del < A 3794 del < ----------- 3795 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 3796 del < 1 3797 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3798 del < Statement Name: 3799 del < null 3800 del < Statement Text: 3801 del < -- select against table with 0 rows. 3802 del < select a from foo where a = 2 3803 del < Parse Time: 0 3804 del < Bind Time: 0 3805 del < Optimize Time: 0 3806 del < Generate Time: 0 3807 del < Compile Time: 0 3808 del < Execute Time: 0 3809 del < Begin Compilation Timestamp : null 3810 del < End Compilation Timestamp : null 3811 del < Begin Execution Timestamp : null 3812 del < End Execution Timestamp : null 3813 del < Statement Execution Plan Text: 3814 del < Index Scan ResultSet for FOO using constraint xxxxGENERATED-IDxxxx at serializable isolation level using share row locking chosen by the optimizer 3815 del < Number of opens = 1 3816 del < Rows seen = 0 3817 del < Rows filtered = 0 3818 del < Fetch Size = 1 3819 del < constructor time (milliseconds) = 0 3820 del < open time (milliseconds) = 0 3821 del < next time (milliseconds) = 0 3822 del < close time (milliseconds) = 0 3823 del < scan information: 3824 del < Bit set of columns fetched={0} 3825 del < Number of columns fetched=1 3826 del < Number of deleted rows visited=0 3827 del < Number of pages visited=1 3828 del < Number of rows qualified=0 3829 del < Number of rows visited=0 3830 del < Scan type=btree 3831 del < Tree height=1 3832 del < start position: 3833 del < >= on first 1 column(s). 3834 del < Ordered null semantics on the following columns: 3835 del < 0 3836 del < stop position: 3837 del < > on first 1 column(s). 3838 del < Ordered null semantics on the following columns: 3839 del < 0 3840 del < qualifiers: 3841 del < None 3842 del < ij> -- now insert one row and make sure still same plan. Previous to 4595 3843 del < -- 0 row plan was a table scan and it would not change when 1 row was inserted. 3844 del < insert into foo values (1, 1); 3845 del < 1 row inserted/updated/deleted 3846 del < ij> -- update against table with 1 row. 3847 del < update foo set b = 2 where a = 1; 3848 del < 1 row inserted/updated/deleted 3849 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 3850 del < 1 3851 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3852 del < Statement Name: 3853 del < null 3854 del < Statement Text: 3855 del < -- update against table with 1 row. 3856 del < update foo set b = 2 where a = 1 3857 del < Parse Time: 0 3858 del < Bind Time: 0 3859 del < Optimize Time: 0 3860 del < Generate Time: 0 3861 del < Compile Time: 0 3862 del < Execute Time: 0 3863 del < Begin Compilation Timestamp : null 3864 del < End Compilation Timestamp : null 3865 del < Begin Execution Timestamp : null 3866 del < End Execution Timestamp : null 3867 del < Statement Execution Plan Text: 3868 del < Update ResultSet using row locking: 3869 del < deferred: false 3870 del < Rows updated = 1 3871 del < Indexes updated = 0 3872 del < Execute Time = 0 3873 del < Project-Restrict ResultSet (2): 3874 del < Number of opens = 1 3875 del < Rows seen = 1 3876 del < Rows filtered = 0 3877 del < restriction = false 3878 del < projection = true 3879 del < constructor time (milliseconds) = 0 3880 del < open time (milliseconds) = 0 3881 del < next time (milliseconds) = 0 3882 del < close time (milliseconds) = 0 3883 del < restriction time (milliseconds) = 0 3884 del < projection time (milliseconds) = 0 3885 del < Source result set: 3886 del < Index Row to Base Row ResultSet for FOO: 3887 del < Number of opens = 1 3888 del < Rows seen = 1 3889 del < Columns accessed from heap = {1} 3890 del < constructor time (milliseconds) = 0 3891 del < open time (milliseconds) = 0 3892 del < next time (milliseconds) = 0 3893 del < close time (milliseconds) = 0 3894 del < Index Scan ResultSet for FOO using constraint xxxxGENERATED-IDxxxx at serializable isolation level using exclusive row locking chosen by the optimizer 3895 del < Number of opens = 1 3896 del < Rows seen = 1 3897 del < Rows filtered = 0 3898 del < Fetch Size = 1 3899 del < constructor time (milliseconds) = 0 3900 del < open time (milliseconds) = 0 3901 del < next time (milliseconds) = 0 3902 del < close time (milliseconds) = 0 3903 del < next time in milliseconds/row = 0 3904 del < scan information: 3905 del < Bit set of columns fetched=All 3906 del < Number of columns fetched=2 3907 del < Number of deleted rows visited=0 3908 del < Number of pages visited=1 3909 del < Number of rows qualified=1 3910 del < Number of rows visited=1 3911 del < Scan type=btree 3912 del < Tree height=1 3913 del < start position: 3914 del < >= on first 1 column(s). 3915 del < Ordered null semantics on the following columns: 3916 del < 0 3917 del < stop position: 3918 del < > on first 1 column(s). 3919 del < Ordered null semantics on the following columns: 3920 del < 0 3921 del < qualifiers: 3922 del < None 3923 del < ij> -- delete against table with 1 row. 3924 del < delete from foo where a = 1; 3925 del < 1 row inserted/updated/deleted 3926 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 3927 del < 1 3928 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 3929 del < Statement Name: 3930 del < null 3931 del < Statement Text: 3932 del < -- delete against table with 1 row. 3933 del < delete from foo where a = 1 3934 del < Parse Time: 0 3935 del < Bind Time: 0 3936 del < Optimize Time: 0 3937 del < Generate Time: 0 3938 del < Compile Time: 0 3939 del < Execute Time: 0 3940 del < Begin Compilation Timestamp : null 3941 del < End Compilation Timestamp : null 3942 del < Begin Execution Timestamp : null 3943 del < End Execution Timestamp : null 3944 del < Statement Execution Plan Text: 3945 del < Delete ResultSet using row locking: 3946 del < deferred: false 3947 del < Rows deleted = 1 3948 del < Indexes updated = 1 3949 del < Execute Time = 0 3950 del < Project-Restrict ResultSet (2): 3951 del < Number of opens = 1 3952 del < Rows seen = 1 3953 del < Rows filtered = 0 3954 del < restriction = false 3955 del < projection = true 3956 del < constructor time (milliseconds) = 0 3957 del < open time (milliseconds) = 0 3958 del < next time (milliseconds) = 0 3959 del < close time (milliseconds) = 0 3960 del < restriction time (milliseconds) = 0 3961 del < projection time (milliseconds) = 0 3962 del < Source result set: 3963 del < Project-Restrict ResultSet (1): 3964 del < Number of opens = 1 3965 del < Rows seen = 1 3966 del < Rows filtered = 0 3967 del < restriction = false 3968 del < projection = true 3969 del < constructor time (milliseconds) = 0 3970 del < open time (milliseconds) = 0 3971 del < next time (milliseconds) = 0 3972 del < close time (milliseconds) = 0 3973 del < restriction time (milliseconds) = 0 3974 del < projection time (milliseconds) = 0 3975 del < Source result set: 3976 del < Index Scan ResultSet for FOO using constraint xxxxGENERATED-IDxxxx at serializable isolation level using exclusive row locking chosen by the optimizer 3977 del < Number of opens = 1 3978 del < Rows seen = 1 3979 del < Rows filtered = 0 3980 del < Fetch Size = 1 3981 del < constructor time (milliseconds) = 0 3982 del < open time (milliseconds) = 0 3983 del < next time (milliseconds) = 0 3984 del < close time (milliseconds) = 0 3985 del < next time in milliseconds/row = 0 3986 del < scan information: 3987 del < Bit set of columns fetched={0, 1} 3988 del < Number of columns fetched=2 3989 del < Number of deleted rows visited=0 3990 del < Number of pages visited=1 3991 del < Number of rows qualified=1 3992 del < Number of rows visited=1 3993 del < Scan type=btree 3994 del < Tree height=1 3995 del < start position: 3996 del < >= on first 1 column(s). 3997 del < Ordered null semantics on the following columns: 3998 del < 0 3999 del < stop position: 4000 del < > on first 1 column(s). 4001 del < Ordered null semantics on the following columns: 4002 del < 0 4003 del < qualifiers: 4004 del < None 4005 del < ij> -- try delete/update statement compiled against table with 1 row. 4006 del < drop table foo; 4007 del < 0 rows inserted/updated/deleted 4008 del < ij> create table foo (a int not null primary key, b int); 4009 del < 0 rows inserted/updated/deleted 4010 del < ij> insert into foo values (1, 1); 4011 del < 1 row inserted/updated/deleted 4012 del < ij> -- update against table with 1 row. 4013 del < update foo set b = 2 where a = 1; 4014 del < 1 row inserted/updated/deleted 4015 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 4016 del < 1 4017 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 4018 del < Statement Name: 4019 del < null 4020 del < Statement Text: 4021 del < -- update against table with 1 row. 4022 del < update foo set b = 2 where a = 1 4023 del < Parse Time: 0 4024 del < Bind Time: 0 4025 del < Optimize Time: 0 4026 del < Generate Time: 0 4027 del < Compile Time: 0 4028 del < Execute Time: 0 4029 del < Begin Compilation Timestamp : null 4030 del < End Compilation Timestamp : null 4031 del < Begin Execution Timestamp : null 4032 del < End Execution Timestamp : null 4033 del < Statement Execution Plan Text: 4034 del < Update ResultSet using row locking: 4035 del < deferred: false 4036 del < Rows updated = 1 4037 del < Indexes updated = 0 4038 del < Execute Time = 0 4039 del < Project-Restrict ResultSet (2): 4040 del < Number of opens = 1 4041 del < Rows seen = 1 4042 del < Rows filtered = 0 4043 del < restriction = false 4044 del < projection = true 4045 del < constructor time (milliseconds) = 0 4046 del < open time (milliseconds) = 0 4047 del < next time (milliseconds) = 0 4048 del < close time (milliseconds) = 0 4049 del < restriction time (milliseconds) = 0 4050 del < projection time (milliseconds) = 0 4051 del < Source result set: 4052 del < Index Row to Base Row ResultSet for FOO: 4053 del < Number of opens = 1 4054 del < Rows seen = 1 4055 del < Columns accessed from heap = {1} 4056 del < constructor time (milliseconds) = 0 4057 del < open time (milliseconds) = 0 4058 del < next time (milliseconds) = 0 4059 del < close time (milliseconds) = 0 4060 del < Index Scan ResultSet for FOO using constraint xxxxGENERATED-IDxxxx at serializable isolation level using exclusive row locking chosen by the optimizer 4061 del < Number of opens = 1 4062 del < Rows seen = 1 4063 del < Rows filtered = 0 4064 del < Fetch Size = 1 4065 del < constructor time (milliseconds) = 0 4066 del < open time (milliseconds) = 0 4067 del < next time (milliseconds) = 0 4068 del < close time (milliseconds) = 0 4069 del < next time in milliseconds/row = 0 4070 del < scan information: 4071 del < Bit set of columns fetched=All 4072 del < Number of columns fetched=2 4073 del < Number of deleted rows visited=0 4074 del < Number of pages visited=1 4075 del < Number of rows qualified=1 4076 del < Number of rows visited=1 4077 del < Scan type=btree 4078 del < Tree height=1 4079 del < start position: 4080 del < >= on first 1 column(s). 4081 del < Ordered null semantics on the following columns: 4082 del < 0 4083 del < stop position: 4084 del < > on first 1 column(s). 4085 del < Ordered null semantics on the following columns: 4086 del < 0 4087 del < qualifiers: 4088 del < None 4089 del < ij> -- delete against table with 1 row. 4090 del < delete from foo where a = 1; 4091 del < 1 row inserted/updated/deleted 4092 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 4093 del < 1 4094 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 4095 del < Statement Name: 4096 del < null 4097 del < Statement Text: 4098 del < -- delete against table with 1 row. 4099 del < delete from foo where a = 1 4100 del < Parse Time: 0 4101 del < Bind Time: 0 4102 del < Optimize Time: 0 4103 del < Generate Time: 0 4104 del < Compile Time: 0 4105 del < Execute Time: 0 4106 del < Begin Compilation Timestamp : null 4107 del < End Compilation Timestamp : null 4108 del < Begin Execution Timestamp : null 4109 del < End Execution Timestamp : null 4110 del < Statement Execution Plan Text: 4111 del < Delete ResultSet using row locking: 4112 del < deferred: false 4113 del < Rows deleted = 1 4114 del < Indexes updated = 1 4115 del < Execute Time = 0 4116 del < Project-Restrict ResultSet (2): 4117 del < Number of opens = 1 4118 del < Rows seen = 1 4119 del < Rows filtered = 0 4120 del < restriction = false 4121 del < projection = true 4122 del < constructor time (milliseconds) = 0 4123 del < open time (milliseconds) = 0 4124 del < next time (milliseconds) = 0 4125 del < close time (milliseconds) = 0 4126 del < restriction time (milliseconds) = 0 4127 del < projection time (milliseconds) = 0 4128 del < Source result set: 4129 del < Project-Restrict ResultSet (1): 4130 del < Number of opens = 1 4131 del < Rows seen = 1 4132 del < Rows filtered = 0 4133 del < restriction = false 4134 del < projection = true 4135 del < constructor time (milliseconds) = 0 4136 del < open time (milliseconds) = 0 4137 del < next time (milliseconds) = 0 4138 del < close time (milliseconds) = 0 4139 del < restriction time (milliseconds) = 0 4140 del < projection time (milliseconds) = 0 4141 del < Source result set: 4142 del < Index Scan ResultSet for FOO using constraint xxxxGENERATED-IDxxxx at serializable isolation level using exclusive row locking chosen by the optimizer 4143 del < Number of opens = 1 4144 del < Rows seen = 1 4145 del < Rows filtered = 0 4146 del < Fetch Size = 1 4147 del < constructor time (milliseconds) = 0 4148 del < open time (milliseconds) = 0 4149 del < next time (milliseconds) = 0 4150 del < close time (milliseconds) = 0 4151 del < next time in milliseconds/row = 0 4152 del < scan information: 4153 del < Bit set of columns fetched={0, 1} 4154 del < Number of columns fetched=2 4155 del < Number of deleted rows visited=0 4156 del < Number of pages visited=1 4157 del < Number of rows qualified=1 4158 del < Number of rows visited=1 4159 del < Scan type=btree 4160 del < Tree height=1 4161 del < start position: 4162 del < >= on first 1 column(s). 4163 del < Ordered null semantics on the following columns: 4164 del < 0 4165 del < stop position: 4166 del < > on first 1 column(s). 4167 del < Ordered null semantics on the following columns: 4168 del < 0 4169 del < qualifiers: 4170 del < None 4171 del < ij> -- select against table with 1 row. 4172 del < select * from foo where a = 2; 4173 del < A |B 4174 del < ----------------------- 4175 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 4176 del < 1 4177 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 4178 del < Statement Name: 4179 del < null 4180 del < Statement Text: 4181 del < -- select against table with 1 row. 4182 del < select * from foo where a = 2 4183 del < Parse Time: 0 4184 del < Bind Time: 0 4185 del < Optimize Time: 0 4186 del < Generate Time: 0 4187 del < Compile Time: 0 4188 del < Execute Time: 0 4189 del < Begin Compilation Timestamp : null 4190 del < End Compilation Timestamp : null 4191 del < Begin Execution Timestamp : null 4192 del < End Execution Timestamp : null 4193 del < Statement Execution Plan Text: 4194 del < Index Row to Base Row ResultSet for FOO: 4195 del < Number of opens = 1 4196 del < Rows seen = 0 4197 del < Columns accessed from heap = {1} 4198 del < constructor time (milliseconds) = 0 4199 del < open time (milliseconds) = 0 4200 del < next time (milliseconds) = 0 4201 del < close time (milliseconds) = 0 4202 del < Index Scan ResultSet for FOO using constraint xxxxGENERATED-IDxxxx at serializable isolation level using share row locking chosen by the optimizer 4203 del < Number of opens = 1 4204 del < Rows seen = 0 4205 del < Rows filtered = 0 4206 del < Fetch Size = 1 4207 del < constructor time (milliseconds) = 0 4208 del < open time (milliseconds) = 0 4209 del < next time (milliseconds) = 0 4210 del < close time (milliseconds) = 0 4211 del < scan information: 4212 del < Bit set of columns fetched=All 4213 del < Number of columns fetched=2 4214 del < Number of deleted rows visited=0 4215 del < Number of pages visited=1 4216 del < Number of rows qualified=0 4217 del < Number of rows visited=0 4218 del < Scan type=btree 4219 del < Tree height=1 4220 del < start position: 4221 del < >= on first 1 column(s). 4222 del < Ordered null semantics on the following columns: 4223 del < 0 4224 del < stop position: 4225 del < > on first 1 column(s). 4226 del < Ordered null semantics on the following columns: 4227 del < 0 4228 del < qualifiers: 4229 del < None 4230 del < ij> -- select against table with 1 row. 4231 del < select a from foo where a = 2; 4232 del < A 4233 del < ----------- 4234 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 4235 del < 1 4236 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 4237 del < Statement Name: 4238 del < null 4239 del < Statement Text: 4240 del < -- select against table with 1 row. 4241 del < select a from foo where a = 2 4242 del < Parse Time: 0 4243 del < Bind Time: 0 4244 del < Optimize Time: 0 4245 del < Generate Time: 0 4246 del < Compile Time: 0 4247 del < Execute Time: 0 4248 del < Begin Compilation Timestamp : null 4249 del < End Compilation Timestamp : null 4250 del < Begin Execution Timestamp : null 4251 del < End Execution Timestamp : null 4252 del < Statement Execution Plan Text: 4253 del < Index Scan ResultSet for FOO using constraint xxxxGENERATED-IDxxxx at serializable isolation level using share row locking chosen by the optimizer 4254 del < Number of opens = 1 4255 del < Rows seen = 0 4256 del < Rows filtered = 0 4257 del < Fetch Size = 1 4258 del < constructor time (milliseconds) = 0 4259 del < open time (milliseconds) = 0 4260 del < next time (milliseconds) = 0 4261 del < close time (milliseconds) = 0 4262 del < scan information: 4263 del < Bit set of columns fetched={0} 4264 del < Number of columns fetched=1 4265 del < Number of deleted rows visited=0 4266 del < Number of pages visited=1 4267 del < Number of rows qualified=0 4268 del < Number of rows visited=0 4269 del < Scan type=btree 4270 del < Tree height=1 4271 del < start position: 4272 del < >= on first 1 column(s). 4273 del < Ordered null semantics on the following columns: 4274 del < 0 4275 del < stop position: 4276 del < > on first 1 column(s). 4277 del < Ordered null semantics on the following columns: 4278 del < 0 4279 del < qualifiers: 4280 del < None 4281 del < ij> -- select against table with 1 row. 4282 del < select a from foo where a = 2; 4283 del < A 4284 del < ----------- 4285 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 4286 del < 1 4287 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 4288 del < Statement Name: 4289 del < null 4290 del < Statement Text: 4291 del < -- select against table with 1 row. 4292 del < select a from foo where a = 2 4293 del < Parse Time: 0 4294 del < Bind Time: 0 4295 del < Optimize Time: 0 4296 del < Generate Time: 0 4297 del < Compile Time: 0 4298 del < Execute Time: 0 4299 del < Begin Compilation Timestamp : null 4300 del < End Compilation Timestamp : null 4301 del < Begin Execution Timestamp : null 4302 del < End Execution Timestamp : null 4303 del < Statement Execution Plan Text: 4304 del < Index Scan ResultSet for FOO using constraint xxxxGENERATED-IDxxxx at serializable isolation level using share row locking chosen by the optimizer 4305 del < Number of opens = 1 4306 del < Rows seen = 0 4307 del < Rows filtered = 0 4308 del < Fetch Size = 1 4309 del < constructor time (milliseconds) = 0 4310 del < open time (milliseconds) = 0 4311 del < next time (milliseconds) = 0 4312 del < close time (milliseconds) = 0 4313 del < scan information: 4314 del < Bit set of columns fetched={0} 4315 del < Number of columns fetched=1 4316 del < Number of deleted rows visited=0 4317 del < Number of pages visited=1 4318 del < Number of rows qualified=0 4319 del < Number of rows visited=0 4320 del < Scan type=btree 4321 del < Tree height=1 4322 del < start position: 4323 del < >= on first 1 column(s). 4324 del < Ordered null semantics on the following columns: 4325 del < 0 4326 del < stop position: 4327 del < > on first 1 column(s). 4328 del < Ordered null semantics on the following columns: 4329 del < 0 4330 del < qualifiers: 4331 del < None 4332 del < ij> -- repeat set of 4595 tests against table with non-unique index with no 4333 del < -- statistics. 4334 del < -- there should be no difference in plan shape. 4335 del < -- try delete/update statement compiled against table with 0 rows 4336 del < drop table foo; 4337 del < 0 rows inserted/updated/deleted 4338 del < ij> create table foo (a int, b int); 4339 del < 0 rows inserted/updated/deleted 4340 del < ij> create index foox on foo (a); 4341 del < 0 rows inserted/updated/deleted 4342 del < ij> -- delete against table with 0 rows. 4343 del < delete from foo where a = 1; 4344 del < 0 rows inserted/updated/deleted 4345 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 4346 del < 1 4347 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 4348 del < Statement Name: 4349 del < null 4350 del < Statement Text: 4351 del < -- delete against table with 0 rows. 4352 del < delete from foo where a = 1 4353 del < Parse Time: 0 4354 del < Bind Time: 0 4355 del < Optimize Time: 0 4356 del < Generate Time: 0 4357 del < Compile Time: 0 4358 del < Execute Time: 0 4359 del < Begin Compilation Timestamp : null 4360 del < End Compilation Timestamp : null 4361 del < Begin Execution Timestamp : null 4362 del < End Execution Timestamp : null 4363 del < Statement Execution Plan Text: 4364 del < Delete ResultSet using row locking: 4365 del < deferred: false 4366 del < Rows deleted = 0 4367 del < Indexes updated = 1 4368 del < Execute Time = 0 4369 del < Project-Restrict ResultSet (2): 4370 del < Number of opens = 1 4371 del < Rows seen = 0 4372 del < Rows filtered = 0 4373 del < restriction = false 4374 del < projection = true 4375 del < constructor time (milliseconds) = 0 4376 del < open time (milliseconds) = 0 4377 del < next time (milliseconds) = 0 4378 del < close time (milliseconds) = 0 4379 del < restriction time (milliseconds) = 0 4380 del < projection time (milliseconds) = 0 4381 del < Source result set: 4382 del < Project-Restrict ResultSet (1): 4383 del < Number of opens = 1 4384 del < Rows seen = 0 4385 del < Rows filtered = 0 4386 del < restriction = false 4387 del < projection = true 4388 del < constructor time (milliseconds) = 0 4389 del < open time (milliseconds) = 0 4390 del < next time (milliseconds) = 0 4391 del < close time (milliseconds) = 0 4392 del < restriction time (milliseconds) = 0 4393 del < projection time (milliseconds) = 0 4394 del < Source result set: 4395 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using exclusive row locking chosen by the optimizer 4396 del < Number of opens = 1 4397 del < Rows seen = 0 4398 del < Rows filtered = 0 4399 del < Fetch Size = 1 4400 del < constructor time (milliseconds) = 0 4401 del < open time (milliseconds) = 0 4402 del < next time (milliseconds) = 0 4403 del < close time (milliseconds) = 0 4404 del < scan information: 4405 del < Bit set of columns fetched={0, 1} 4406 del < Number of columns fetched=2 4407 del < Number of deleted rows visited=0 4408 del < Number of pages visited=1 4409 del < Number of rows qualified=0 4410 del < Number of rows visited=0 4411 del < Scan type=btree 4412 del < Tree height=1 4413 del < start position: 4414 del < >= on first 1 column(s). 4415 del < Ordered null semantics on the following columns: 4416 del < stop position: 4417 del < > on first 1 column(s). 4418 del < Ordered null semantics on the following columns: 4419 del < qualifiers: 4420 del < None 4421 del < ij> -- update against table with 0 rows. 4422 del < update foo set b = 1 where a = 2; 4423 del < 0 rows inserted/updated/deleted 4424 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 4425 del < 1 4426 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 4427 del < Statement Name: 4428 del < null 4429 del < Statement Text: 4430 del < -- update against table with 0 rows. 4431 del < update foo set b = 1 where a = 2 4432 del < Parse Time: 0 4433 del < Bind Time: 0 4434 del < Optimize Time: 0 4435 del < Generate Time: 0 4436 del < Compile Time: 0 4437 del < Execute Time: 0 4438 del < Begin Compilation Timestamp : null 4439 del < End Compilation Timestamp : null 4440 del < Begin Execution Timestamp : null 4441 del < End Execution Timestamp : null 4442 del < Statement Execution Plan Text: 4443 del < Update ResultSet using row locking: 4444 del < deferred: false 4445 del < Rows updated = 0 4446 del < Indexes updated = 0 4447 del < Execute Time = 0 4448 del < Project-Restrict ResultSet (2): 4449 del < Number of opens = 1 4450 del < Rows seen = 0 4451 del < Rows filtered = 0 4452 del < restriction = false 4453 del < projection = true 4454 del < constructor time (milliseconds) = 0 4455 del < open time (milliseconds) = 0 4456 del < next time (milliseconds) = 0 4457 del < close time (milliseconds) = 0 4458 del < restriction time (milliseconds) = 0 4459 del < projection time (milliseconds) = 0 4460 del < Source result set: 4461 del < Index Row to Base Row ResultSet for FOO: 4462 del < Number of opens = 1 4463 del < Rows seen = 0 4464 del < Columns accessed from heap = {1} 4465 del < constructor time (milliseconds) = 0 4466 del < open time (milliseconds) = 0 4467 del < next time (milliseconds) = 0 4468 del < close time (milliseconds) = 0 4469 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using exclusive row locking chosen by the optimizer 4470 del < Number of opens = 1 4471 del < Rows seen = 0 4472 del < Rows filtered = 0 4473 del < Fetch Size = 1 4474 del < constructor time (milliseconds) = 0 4475 del < open time (milliseconds) = 0 4476 del < next time (milliseconds) = 0 4477 del < close time (milliseconds) = 0 4478 del < scan information: 4479 del < Bit set of columns fetched=All 4480 del < Number of columns fetched=2 4481 del < Number of deleted rows visited=0 4482 del < Number of pages visited=1 4483 del < Number of rows qualified=0 4484 del < Number of rows visited=0 4485 del < Scan type=btree 4486 del < Tree height=1 4487 del < start position: 4488 del < >= on first 1 column(s). 4489 del < Ordered null semantics on the following columns: 4490 del < stop position: 4491 del < > on first 1 column(s). 4492 del < Ordered null semantics on the following columns: 4493 del < qualifiers: 4494 del < None 4495 del < ij> -- select against table with 0 rows. 4496 del < select * from foo where a = 2; 4497 del < A |B 4498 del < ----------------------- 4499 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 4500 del < 1 4501 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 4502 del < Statement Name: 4503 del < null 4504 del < Statement Text: 4505 del < -- select against table with 0 rows. 4506 del < select * from foo where a = 2 4507 del < Parse Time: 0 4508 del < Bind Time: 0 4509 del < Optimize Time: 0 4510 del < Generate Time: 0 4511 del < Compile Time: 0 4512 del < Execute Time: 0 4513 del < Begin Compilation Timestamp : null 4514 del < End Compilation Timestamp : null 4515 del < Begin Execution Timestamp : null 4516 del < End Execution Timestamp : null 4517 del < Statement Execution Plan Text: 4518 del < Index Row to Base Row ResultSet for FOO: 4519 del < Number of opens = 1 4520 del < Rows seen = 0 4521 del < Columns accessed from heap = {0, 1} 4522 del < constructor time (milliseconds) = 0 4523 del < open time (milliseconds) = 0 4524 del < next time (milliseconds) = 0 4525 del < close time (milliseconds) = 0 4526 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using share row locking chosen by the optimizer 4527 del < Number of opens = 1 4528 del < Rows seen = 0 4529 del < Rows filtered = 0 4530 del < Fetch Size = 16 4531 del < constructor time (milliseconds) = 0 4532 del < open time (milliseconds) = 0 4533 del < next time (milliseconds) = 0 4534 del < close time (milliseconds) = 0 4535 del < scan information: 4536 del < Bit set of columns fetched=All 4537 del < Number of columns fetched=2 4538 del < Number of deleted rows visited=0 4539 del < Number of pages visited=1 4540 del < Number of rows qualified=0 4541 del < Number of rows visited=0 4542 del < Scan type=btree 4543 del < Tree height=1 4544 del < start position: 4545 del < >= on first 1 column(s). 4546 del < Ordered null semantics on the following columns: 4547 del < stop position: 4548 del < > on first 1 column(s). 4549 del < Ordered null semantics on the following columns: 4550 del < qualifiers: 4551 del < None 4552 del < ij> -- select against table with 0 rows. 4553 del < select a from foo where a = 2; 4554 del < A 4555 del < ----------- 4556 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 4557 del < 1 4558 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 4559 del < Statement Name: 4560 del < null 4561 del < Statement Text: 4562 del < -- select against table with 0 rows. 4563 del < select a from foo where a = 2 4564 del < Parse Time: 0 4565 del < Bind Time: 0 4566 del < Optimize Time: 0 4567 del < Generate Time: 0 4568 del < Compile Time: 0 4569 del < Execute Time: 0 4570 del < Begin Compilation Timestamp : null 4571 del < End Compilation Timestamp : null 4572 del < Begin Execution Timestamp : null 4573 del < End Execution Timestamp : null 4574 del < Statement Execution Plan Text: 4575 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using share row locking chosen by the optimizer 4576 del < Number of opens = 1 4577 del < Rows seen = 0 4578 del < Rows filtered = 0 4579 del < Fetch Size = 16 4580 del < constructor time (milliseconds) = 0 4581 del < open time (milliseconds) = 0 4582 del < next time (milliseconds) = 0 4583 del < close time (milliseconds) = 0 4584 del < scan information: 4585 del < Bit set of columns fetched={0} 4586 del < Number of columns fetched=1 4587 del < Number of deleted rows visited=0 4588 del < Number of pages visited=1 4589 del < Number of rows qualified=0 4590 del < Number of rows visited=0 4591 del < Scan type=btree 4592 del < Tree height=1 4593 del < start position: 4594 del < >= on first 1 column(s). 4595 del < Ordered null semantics on the following columns: 4596 del < stop position: 4597 del < > on first 1 column(s). 4598 del < Ordered null semantics on the following columns: 4599 del < qualifiers: 4600 del < None 4601 del < ij> -- select against table with 0 rows. 4602 del < select a from foo where a = 2; 4603 del < A 4604 del < ----------- 4605 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 4606 del < 1 4607 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 4608 del < Statement Name: 4609 del < null 4610 del < Statement Text: 4611 del < -- select against table with 0 rows. 4612 del < select a from foo where a = 2 4613 del < Parse Time: 0 4614 del < Bind Time: 0 4615 del < Optimize Time: 0 4616 del < Generate Time: 0 4617 del < Compile Time: 0 4618 del < Execute Time: 0 4619 del < Begin Compilation Timestamp : null 4620 del < End Compilation Timestamp : null 4621 del < Begin Execution Timestamp : null 4622 del < End Execution Timestamp : null 4623 del < Statement Execution Plan Text: 4624 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using share row locking chosen by the optimizer 4625 del < Number of opens = 1 4626 del < Rows seen = 0 4627 del < Rows filtered = 0 4628 del < Fetch Size = 16 4629 del < constructor time (milliseconds) = 0 4630 del < open time (milliseconds) = 0 4631 del < next time (milliseconds) = 0 4632 del < close time (milliseconds) = 0 4633 del < scan information: 4634 del < Bit set of columns fetched={0} 4635 del < Number of columns fetched=1 4636 del < Number of deleted rows visited=0 4637 del < Number of pages visited=1 4638 del < Number of rows qualified=0 4639 del < Number of rows visited=0 4640 del < Scan type=btree 4641 del < Tree height=1 4642 del < start position: 4643 del < >= on first 1 column(s). 4644 del < Ordered null semantics on the following columns: 4645 del < stop position: 4646 del < > on first 1 column(s). 4647 del < Ordered null semantics on the following columns: 4648 del < qualifiers: 4649 del < None 4650 del < ij> -- now insert one row and make sure still same plan. Previous to 4595 4651 del < -- 0 row plan was a table scan and it would not change when 1 row was inserted. 4652 del < insert into foo values (1, 1); 4653 del < 1 row inserted/updated/deleted 4654 del < ij> -- update against table with 1 row. 4655 del < update foo set b = 2 where a = 1; 4656 del < 1 row inserted/updated/deleted 4657 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 4658 del < 1 4659 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 4660 del < Statement Name: 4661 del < null 4662 del < Statement Text: 4663 del < -- update against table with 1 row. 4664 del < update foo set b = 2 where a = 1 4665 del < Parse Time: 0 4666 del < Bind Time: 0 4667 del < Optimize Time: 0 4668 del < Generate Time: 0 4669 del < Compile Time: 0 4670 del < Execute Time: 0 4671 del < Begin Compilation Timestamp : null 4672 del < End Compilation Timestamp : null 4673 del < Begin Execution Timestamp : null 4674 del < End Execution Timestamp : null 4675 del < Statement Execution Plan Text: 4676 del < Update ResultSet using row locking: 4677 del < deferred: false 4678 del < Rows updated = 1 4679 del < Indexes updated = 0 4680 del < Execute Time = 0 4681 del < Project-Restrict ResultSet (2): 4682 del < Number of opens = 1 4683 del < Rows seen = 1 4684 del < Rows filtered = 0 4685 del < restriction = false 4686 del < projection = true 4687 del < constructor time (milliseconds) = 0 4688 del < open time (milliseconds) = 0 4689 del < next time (milliseconds) = 0 4690 del < close time (milliseconds) = 0 4691 del < restriction time (milliseconds) = 0 4692 del < projection time (milliseconds) = 0 4693 del < Source result set: 4694 del < Index Row to Base Row ResultSet for FOO: 4695 del < Number of opens = 1 4696 del < Rows seen = 1 4697 del < Columns accessed from heap = {1} 4698 del < constructor time (milliseconds) = 0 4699 del < open time (milliseconds) = 0 4700 del < next time (milliseconds) = 0 4701 del < close time (milliseconds) = 0 4702 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using exclusive row locking chosen by the optimizer 4703 del < Number of opens = 1 4704 del < Rows seen = 1 4705 del < Rows filtered = 0 4706 del < Fetch Size = 1 4707 del < constructor time (milliseconds) = 0 4708 del < open time (milliseconds) = 0 4709 del < next time (milliseconds) = 0 4710 del < close time (milliseconds) = 0 4711 del < next time in milliseconds/row = 0 4712 del < scan information: 4713 del < Bit set of columns fetched=All 4714 del < Number of columns fetched=2 4715 del < Number of deleted rows visited=0 4716 del < Number of pages visited=1 4717 del < Number of rows qualified=1 4718 del < Number of rows visited=1 4719 del < Scan type=btree 4720 del < Tree height=1 4721 del < start position: 4722 del < >= on first 1 column(s). 4723 del < Ordered null semantics on the following columns: 4724 del < stop position: 4725 del < > on first 1 column(s). 4726 del < Ordered null semantics on the following columns: 4727 del < qualifiers: 4728 del < None 4729 del < ij> -- delete against table with 1 row. 4730 del < delete from foo where a = 1; 4731 del < 1 row inserted/updated/deleted 4732 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 4733 del < 1 4734 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 4735 del < Statement Name: 4736 del < null 4737 del < Statement Text: 4738 del < -- delete against table with 1 row. 4739 del < delete from foo where a = 1 4740 del < Parse Time: 0 4741 del < Bind Time: 0 4742 del < Optimize Time: 0 4743 del < Generate Time: 0 4744 del < Compile Time: 0 4745 del < Execute Time: 0 4746 del < Begin Compilation Timestamp : null 4747 del < End Compilation Timestamp : null 4748 del < Begin Execution Timestamp : null 4749 del < End Execution Timestamp : null 4750 del < Statement Execution Plan Text: 4751 del < Delete ResultSet using row locking: 4752 del < deferred: false 4753 del < Rows deleted = 1 4754 del < Indexes updated = 1 4755 del < Execute Time = 0 4756 del < Project-Restrict ResultSet (2): 4757 del < Number of opens = 1 4758 del < Rows seen = 1 4759 del < Rows filtered = 0 4760 del < restriction = false 4761 del < projection = true 4762 del < constructor time (milliseconds) = 0 4763 del < open time (milliseconds) = 0 4764 del < next time (milliseconds) = 0 4765 del < close time (milliseconds) = 0 4766 del < restriction time (milliseconds) = 0 4767 del < projection time (milliseconds) = 0 4768 del < Source result set: 4769 del < Project-Restrict ResultSet (1): 4770 del < Number of opens = 1 4771 del < Rows seen = 1 4772 del < Rows filtered = 0 4773 del < restriction = false 4774 del < projection = true 4775 del < constructor time (milliseconds) = 0 4776 del < open time (milliseconds) = 0 4777 del < next time (milliseconds) = 0 4778 del < close time (milliseconds) = 0 4779 del < restriction time (milliseconds) = 0 4780 del < projection time (milliseconds) = 0 4781 del < Source result set: 4782 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using exclusive row locking chosen by the optimizer 4783 del < Number of opens = 1 4784 del < Rows seen = 1 4785 del < Rows filtered = 0 4786 del < Fetch Size = 1 4787 del < constructor time (milliseconds) = 0 4788 del < open time (milliseconds) = 0 4789 del < next time (milliseconds) = 0 4790 del < close time (milliseconds) = 0 4791 del < next time in milliseconds/row = 0 4792 del < scan information: 4793 del < Bit set of columns fetched={0, 1} 4794 del < Number of columns fetched=2 4795 del < Number of deleted rows visited=0 4796 del < Number of pages visited=1 4797 del < Number of rows qualified=1 4798 del < Number of rows visited=1 4799 del < Scan type=btree 4800 del < Tree height=1 4801 del < start position: 4802 del < >= on first 1 column(s). 4803 del < Ordered null semantics on the following columns: 4804 del < stop position: 4805 del < > on first 1 column(s). 4806 del < Ordered null semantics on the following columns: 4807 del < qualifiers: 4808 del < None 4809 del < ij> -- try delete/update statement compiled against table with 1 row. 4810 del < drop table foo; 4811 del < 0 rows inserted/updated/deleted 4812 del < ij> create table foo (a int, b int); 4813 del < 0 rows inserted/updated/deleted 4814 del < ij> create index foox on foo (a); 4815 del < 0 rows inserted/updated/deleted 4816 del < ij> insert into foo values (1, 1); 4817 del < 1 row inserted/updated/deleted 4818 del < ij> -- update against table with 1 row. 4819 del < update foo set b = 2 where a = 1; 4820 del < 1 row inserted/updated/deleted 4821 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 4822 del < 1 4823 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 4824 del < Statement Name: 4825 del < null 4826 del < Statement Text: 4827 del < -- update against table with 1 row. 4828 del < update foo set b = 2 where a = 1 4829 del < Parse Time: 0 4830 del < Bind Time: 0 4831 del < Optimize Time: 0 4832 del < Generate Time: 0 4833 del < Compile Time: 0 4834 del < Execute Time: 0 4835 del < Begin Compilation Timestamp : null 4836 del < End Compilation Timestamp : null 4837 del < Begin Execution Timestamp : null 4838 del < End Execution Timestamp : null 4839 del < Statement Execution Plan Text: 4840 del < Update ResultSet using row locking: 4841 del < deferred: false 4842 del < Rows updated = 1 4843 del < Indexes updated = 0 4844 del < Execute Time = 0 4845 del < Project-Restrict ResultSet (2): 4846 del < Number of opens = 1 4847 del < Rows seen = 1 4848 del < Rows filtered = 0 4849 del < restriction = false 4850 del < projection = true 4851 del < constructor time (milliseconds) = 0 4852 del < open time (milliseconds) = 0 4853 del < next time (milliseconds) = 0 4854 del < close time (milliseconds) = 0 4855 del < restriction time (milliseconds) = 0 4856 del < projection time (milliseconds) = 0 4857 del < Source result set: 4858 del < Index Row to Base Row ResultSet for FOO: 4859 del < Number of opens = 1 4860 del < Rows seen = 1 4861 del < Columns accessed from heap = {1} 4862 del < constructor time (milliseconds) = 0 4863 del < open time (milliseconds) = 0 4864 del < next time (milliseconds) = 0 4865 del < close time (milliseconds) = 0 4866 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using exclusive row locking chosen by the optimizer 4867 del < Number of opens = 1 4868 del < Rows seen = 1 4869 del < Rows filtered = 0 4870 del < Fetch Size = 1 4871 del < constructor time (milliseconds) = 0 4872 del < open time (milliseconds) = 0 4873 del < next time (milliseconds) = 0 4874 del < close time (milliseconds) = 0 4875 del < next time in milliseconds/row = 0 4876 del < scan information: 4877 del < Bit set of columns fetched=All 4878 del < Number of columns fetched=2 4879 del < Number of deleted rows visited=0 4880 del < Number of pages visited=1 4881 del < Number of rows qualified=1 4882 del < Number of rows visited=1 4883 del < Scan type=btree 4884 del < Tree height=1 4885 del < start position: 4886 del < >= on first 1 column(s). 4887 del < Ordered null semantics on the following columns: 4888 del < stop position: 4889 del < > on first 1 column(s). 4890 del < Ordered null semantics on the following columns: 4891 del < qualifiers: 4892 del < None 4893 del < ij> -- delete against table with 1 row. 4894 del < delete from foo where a = 1; 4895 del < 1 row inserted/updated/deleted 4896 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 4897 del < 1 4898 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 4899 del < Statement Name: 4900 del < null 4901 del < Statement Text: 4902 del < -- delete against table with 1 row. 4903 del < delete from foo where a = 1 4904 del < Parse Time: 0 4905 del < Bind Time: 0 4906 del < Optimize Time: 0 4907 del < Generate Time: 0 4908 del < Compile Time: 0 4909 del < Execute Time: 0 4910 del < Begin Compilation Timestamp : null 4911 del < End Compilation Timestamp : null 4912 del < Begin Execution Timestamp : null 4913 del < End Execution Timestamp : null 4914 del < Statement Execution Plan Text: 4915 del < Delete ResultSet using row locking: 4916 del < deferred: false 4917 del < Rows deleted = 1 4918 del < Indexes updated = 1 4919 del < Execute Time = 0 4920 del < Project-Restrict ResultSet (2): 4921 del < Number of opens = 1 4922 del < Rows seen = 1 4923 del < Rows filtered = 0 4924 del < restriction = false 4925 del < projection = true 4926 del < constructor time (milliseconds) = 0 4927 del < open time (milliseconds) = 0 4928 del < next time (milliseconds) = 0 4929 del < close time (milliseconds) = 0 4930 del < restriction time (milliseconds) = 0 4931 del < projection time (milliseconds) = 0 4932 del < Source result set: 4933 del < Project-Restrict ResultSet (1): 4934 del < Number of opens = 1 4935 del < Rows seen = 1 4936 del < Rows filtered = 0 4937 del < restriction = false 4938 del < projection = true 4939 del < constructor time (milliseconds) = 0 4940 del < open time (milliseconds) = 0 4941 del < next time (milliseconds) = 0 4942 del < close time (milliseconds) = 0 4943 del < restriction time (milliseconds) = 0 4944 del < projection time (milliseconds) = 0 4945 del < Source result set: 4946 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using exclusive row locking chosen by the optimizer 4947 del < Number of opens = 1 4948 del < Rows seen = 1 4949 del < Rows filtered = 0 4950 del < Fetch Size = 1 4951 del < constructor time (milliseconds) = 0 4952 del < open time (milliseconds) = 0 4953 del < next time (milliseconds) = 0 4954 del < close time (milliseconds) = 0 4955 del < next time in milliseconds/row = 0 4956 del < scan information: 4957 del < Bit set of columns fetched={0, 1} 4958 del < Number of columns fetched=2 4959 del < Number of deleted rows visited=0 4960 del < Number of pages visited=1 4961 del < Number of rows qualified=1 4962 del < Number of rows visited=1 4963 del < Scan type=btree 4964 del < Tree height=1 4965 del < start position: 4966 del < >= on first 1 column(s). 4967 del < Ordered null semantics on the following columns: 4968 del < stop position: 4969 del < > on first 1 column(s). 4970 del < Ordered null semantics on the following columns: 4971 del < qualifiers: 4972 del < None 4973 del < ij> -- select against table with 1 row. 4974 del < select * from foo where a = 2; 4975 del < A |B 4976 del < ----------------------- 4977 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 4978 del < 1 4979 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 4980 del < Statement Name: 4981 del < null 4982 del < Statement Text: 4983 del < -- select against table with 1 row. 4984 del < select * from foo where a = 2 4985 del < Parse Time: 0 4986 del < Bind Time: 0 4987 del < Optimize Time: 0 4988 del < Generate Time: 0 4989 del < Compile Time: 0 4990 del < Execute Time: 0 4991 del < Begin Compilation Timestamp : null 4992 del < End Compilation Timestamp : null 4993 del < Begin Execution Timestamp : null 4994 del < End Execution Timestamp : null 4995 del < Statement Execution Plan Text: 4996 del < Index Row to Base Row ResultSet for FOO: 4997 del < Number of opens = 1 4998 del < Rows seen = 0 4999 del < Columns accessed from heap = {0, 1} 5000 del < constructor time (milliseconds) = 0 5001 del < open time (milliseconds) = 0 5002 del < next time (milliseconds) = 0 5003 del < close time (milliseconds) = 0 5004 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using share row locking chosen by the optimizer 5005 del < Number of opens = 1 5006 del < Rows seen = 0 5007 del < Rows filtered = 0 5008 del < Fetch Size = 16 5009 del < constructor time (milliseconds) = 0 5010 del < open time (milliseconds) = 0 5011 del < next time (milliseconds) = 0 5012 del < close time (milliseconds) = 0 5013 del < scan information: 5014 del < Bit set of columns fetched=All 5015 del < Number of columns fetched=2 5016 del < Number of deleted rows visited=0 5017 del < Number of pages visited=1 5018 del < Number of rows qualified=0 5019 del < Number of rows visited=0 5020 del < Scan type=btree 5021 del < Tree height=1 5022 del < start position: 5023 del < >= on first 1 column(s). 5024 del < Ordered null semantics on the following columns: 5025 del < stop position: 5026 del < > on first 1 column(s). 5027 del < Ordered null semantics on the following columns: 5028 del < qualifiers: 5029 del < None 5030 del < ij> -- select against table with 1 row. 5031 del < select a from foo where a = 2; 5032 del < A 5033 del < ----------- 5034 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 5035 del < 1 5036 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 5037 del < Statement Name: 5038 del < null 5039 del < Statement Text: 5040 del < -- select against table with 1 row. 5041 del < select a from foo where a = 2 5042 del < Parse Time: 0 5043 del < Bind Time: 0 5044 del < Optimize Time: 0 5045 del < Generate Time: 0 5046 del < Compile Time: 0 5047 del < Execute Time: 0 5048 del < Begin Compilation Timestamp : null 5049 del < End Compilation Timestamp : null 5050 del < Begin Execution Timestamp : null 5051 del < End Execution Timestamp : null 5052 del < Statement Execution Plan Text: 5053 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using share row locking chosen by the optimizer 5054 del < Number of opens = 1 5055 del < Rows seen = 0 5056 del < Rows filtered = 0 5057 del < Fetch Size = 16 5058 del < constructor time (milliseconds) = 0 5059 del < open time (milliseconds) = 0 5060 del < next time (milliseconds) = 0 5061 del < close time (milliseconds) = 0 5062 del < scan information: 5063 del < Bit set of columns fetched={0} 5064 del < Number of columns fetched=1 5065 del < Number of deleted rows visited=0 5066 del < Number of pages visited=1 5067 del < Number of rows qualified=0 5068 del < Number of rows visited=0 5069 del < Scan type=btree 5070 del < Tree height=1 5071 del < start position: 5072 del < >= on first 1 column(s). 5073 del < Ordered null semantics on the following columns: 5074 del < stop position: 5075 del < > on first 1 column(s). 5076 del < Ordered null semantics on the following columns: 5077 del < qualifiers: 5078 del < None 5079 del < ij> -- select against table with 1 row. 5080 del < select a from foo where a = 2; 5081 del < A 5082 del < ----------- 5083 del < ij> values SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS(); 5084 del < 1 5085 del < ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 5086 del < Statement Name: 5087 del < null 5088 del < Statement Text: 5089 del < -- select against table with 1 row. 5090 del < select a from foo where a = 2 5091 del < Parse Time: 0 5092 del < Bind Time: 0 5093 del < Optimize Time: 0 5094 del < Generate Time: 0 5095 del < Compile Time: 0 5096 del < Execute Time: 0 5097 del < Begin Compilation Timestamp : null 5098 del < End Compilation Timestamp : null 5099 del < Begin Execution Timestamp : null 5100 del < End Execution Timestamp : null 5101 del < Statement Execution Plan Text: 5102 del < Index Scan ResultSet for FOO using index FOOX at serializable isolation level using share row locking chosen by the optimizer 5103 del < Number of opens = 1 5104 del < Rows seen = 0 5105 del < Rows filtered = 0 5106 del < Fetch Size = 16 5107 del < constructor time (milliseconds) = 0 5108 del < open time (milliseconds) = 0 5109 del < next time (milliseconds) = 0 5110 del < close time (milliseconds) = 0 5111 del < scan information: 5112 del < Bit set of columns fetched={0} 5113 del < Number of columns fetched=1 5114 del < Number of deleted rows visited=0 5115 del < Number of pages visited=1 5116 del < Number of rows qualified=0 5117 del < Number of rows visited=0 5118 del < Scan type=btree 5119 del < Tree height=1 5120 del < start position: 5121 del < >= on first 1 column(s). 5122 del < Ordered null semantics on the following columns: 5123 del < stop position: 5124 del < > on first 1 column(s). 5125 del < Ordered null semantics on the following columns: 5126 del < qualifiers: 5127 del < None 5128 del < ij> ------------------------------------------------------------------------ 5129 del < -- simple regression test for qualifier work. 5130 del < ------------------------------------------------------------------------ 5131 del < drop table foo; 5132 del < 0 rows inserted/updated/deleted 5133 del < ij> commit; 5134 del < ij> create table foo (a int, b int, c int); 5135 del < 0 rows inserted/updated/deleted 5136 del < ij> insert into foo values (1, 10, 100); 5137 del < 1 row inserted/updated/deleted 5138 del < ij> insert into foo values (2, 20, 200); 5139 del < 1 row inserted/updated/deleted 5140 del < ij> insert into foo values (3, 30, 300); 5141 del < 1 row inserted/updated/deleted 5142 del < ij> -- should return no rows 5143 del < select a, b, c from foo where a = 1 and b = 20; 5144 del < A |B |C 5145 del < ----------------------------------- 5146 del < ij> -- should return one row 5147 del < select a, b, c from foo where a = 3 and b = 30; 5148 del < A |B |C 5149 del < ----------------------------------- 5150 del < 3 |30 |300 5151 del < ij> select a, b, c from foo where a = 3 or c = 40; 5152 del < A |B |C 5153 del < ----------------------------------- 5154 del < 3 |30 |300 5155 del < ij> -- should return 2 rows 5156 del < select a, b, c from foo where a = 1 or b = 20; 5157 del < A |B |C 5158 del < ----------------------------------- 5159 del < 1 |10 |100 5160 del < 2 |20 |200 5161 del < ij> select a, b, c from foo where a = 1 or a = 3; 5162 del < A |B |C 5163 del < ----------------------------------- 5164 del < 1 |10 |100 5165 del < 3 |30 |300 5166 del < ij> DROP FUNCTION PADSTRING; 5167 del < 0 rows inserted/updated/deleted 5168 del < ij> DROP PROCEDURE WAIT_FOR_POST_COMMIT; 5169 del < 0 rows inserted/updated/deleted 5170 del < ij> exit; 5170 add > Unhandled exception > Type=GPF vmState=0x00000040 > Target=2_20_20040706_1457_lHdSMR (Windows XP 5.1 build 2600 Service Pack 1) > CPU=x86 (1 logical CPUs) (0x3feec000 RAM) > ExceptionCode=c0000005 ExceptionAddress=1130A074 ContextFlags=0001003f Handler1=1130A07C > Handler2=1130A080 > EDI=0170e650 ESI=00000151 EAX=0000001e EBX=024ce1a8 > ECX=01c8e978 EDX=0170f0d8 EBP=013efa88 > EIP=12c12176 ESP=013efa54 > Module=C:\IBM\DeviceDeveloper\wsdd5.0\ive-2.2\bin\j9jit22.dll > Module_base_address=12c00000 Offset_in_DLL=00012176 > JavaVMInitArgs.nOptions=15: > -Dcom.ibm.oti.vm.exe=C:\IBM\DeviceDeveloper\wsdd5.0\ive-2.2\bin\j9.exe > _port_library (extra info: 0012F894) > -Dij.dataSource=org.apache.derby.jdbc.EmbeddedSimpleDataSource > -Xjcl:jclfoun10_22 > -Xbootclasspath/a:C:/IBM/DeviceDeveloper/wsdd5.0/ive-2.2/lib/jdbc.jar > -Dderby.system.home=C:\deepa\Derby\derby_testing\j2me_tests\pass4\impExp\suite_derbyall\derbyall\storeall\storemats\storemats\access > -Dderby.infolog.append=true > -Duser.dir=C:\deepa\Derby\derby_testing\j2me_tests\pass4\impExp\suite_derbyall > -Dij.defaultResourcePackage=/org/apache/derbyTesting/functionTests/tests/store/ > -Dframework=embedded > -Dconsole.encoding=Cp1252 > -Djava.home=C:\IBM\DeviceDeveloper\wsdd5.0\ive-2.2 > -Dcom.ibm.oti.vm.bootstrap.library.path=C:\IBM\DeviceDeveloper\wsdd5.0\ive-2.2\bin\ > -Djava.library.path=C:\IBM\DeviceDeveloper\wsdd5.0\ive-2.2\bin\;.;C:\MKS\bin;C:\MKS\bin\X11;C:\MKS\mksnt;C:\Cloudscape_10.0\frameworks\embedded\bin;C:\Perl\bin\;C:\j2sdk1.4.2_06\bin;C:\apache-ant-1.6.2\bin;C:\PROGRAM FILES\THINKPAD\UTILITIES;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\IBM\Infoprint Select;C:\Utilities;C:\Notes;C:\Program Files\XLView\;C:\lotus\compnent\;C:\Program Files\IBM\Personal Communications\;C:\Program Files\IBM\Trace Facility\;C:\WINDOWS\Downloaded Program Files;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\SAMPLES\REPL;C:\Subversion\bin;C:\Perforce;C:\CMVC\exe;C:\CMVC\exe\bin;;C:\Program Files\IBM\CMVCDC50;C:\Infoprint; > Generated system dump: C:\Documents and Settings\Administrator\j9.dmp > (no Thread object associated with thread) > Thread: derby.antiGC (priority 1) (daemon) > Thread: Thread-0 (priority 5) (daemon) > Thread: derby.rawStoreDaemon (priority 5) (daemon) > Thread: Finalizer thread (priority 5) (daemon) > Thread: main (priority 5) Test Failed. *** End: access jdkJ2ME Foundation Specification v1.0 storemats:storemats 2005-07-13 17:20:03 *** ********* Diff file derbyall/storeall/storemore/backupRestore.diff *** Start: backupRestore jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:14:09 *** Test skipped: test cannot run with jvm: j9_foundation. backupRestore.sql *** End: backupRestore jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:14:09 *** ********* Diff file derbyall/storeall/storemore/backupRestore1.diff *** Start: backupRestore1 jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:14:10 *** Test skipped: test cannot run with jvm: j9_foundation. backupRestore1.java *** End: backupRestore1 jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:14:10 *** ********* Diff file derbyall/storeall/storemore/Beetle6038.diff *** Start: Beetle6038 jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:14:40 *** Test skipped: test cannot run with jvm: j9_foundation. Beetle6038.java *** End: Beetle6038 jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:14:40 *** ********* Diff file derbyall/storeall/storemore/bootLock.diff *** Start: bootLock jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:14:10 *** Test skipped: test cannot run with jvm: j9_foundation. bootLock.java *** End: bootLock jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:14:10 *** ********* Diff file derbyall/storeall/storemore/cisco.diff *** Start: cisco jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:09:00 *** Test skipped: test cannot run with jvm: j9_foundation. cisco.sql *** End: cisco jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:09:00 *** ********* Diff file derbyall/storeall/storemore/connectDisconnect.diff *** Start: connectDisconnect jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:09:01 *** Test skipped: test cannot run with jvm: j9_foundation. connectDisconnect.sql *** End: connectDisconnect jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:09:01 *** ********* Diff file derbyall/storeall/storemore/databaseProperties.diff *** Start: databaseProperties jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:09:01 *** Test skipped: test cannot run with jvm: j9_foundation. databaseProperties.sql *** End: databaseProperties jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:09:01 *** ********* Diff file derbyall/storeall/storemore/heapscan.diff *** Start: heapscan jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:11:27 *** Test skipped: test cannot run with jvm: j9_foundation. heapscan.sql *** End: heapscan jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:11:27 *** ********* Diff file derbyall/storeall/storemore/lockTableVti.diff *** Start: lockTableVti jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:11:28 *** Test skipped: test cannot run with jvm: j9_foundation. lockTableVti.sql *** End: lockTableVti jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:11:28 *** ********* Diff file derbyall/storeall/storemore/logDevice.diff *** Start: logDevice jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:09:20 *** Test skipped: test cannot run with jvm: j9_foundation. logDevice.sql *** End: logDevice jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:09:20 *** ********* Diff file derbyall/storeall/storemore/removeStubs.diff *** Start: removeStubs jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:11:27 *** Test skipped: test cannot run with jvm: j9_foundation. removeStubs.sql *** End: removeStubs jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:11:28 *** ********* Diff file derbyall/storeall/storemore/rlliso1multi.diff *** Start: rlliso1multi jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:10:30 *** Test skipped: test cannot run with jvm: j9_foundation. rlliso1multi.sql *** End: rlliso1multi jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:10:30 *** ********* Diff file derbyall/storeall/storemore/rlliso2multi.diff *** Start: rlliso2multi jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:10:30 *** Test skipped: test cannot run with jvm: j9_foundation. rlliso2multi.sql *** End: rlliso2multi jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:10:30 *** ********* Diff file derbyall/storeall/storemore/rlliso3multi.diff *** Start: rlliso3multi jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:10:31 *** Test skipped: test cannot run with jvm: j9_foundation. rlliso3multi.sql *** End: rlliso3multi jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:10:31 *** ********* Diff file derbyall/storeall/storemore/rollForwardBackup.diff *** Start: rollForwardBackup jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:11:28 *** Test skipped: test cannot run with jvm: j9_foundation. rollForwardBackup.sql *** End: rollForwardBackup jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:11:28 *** ********* Diff file derbyall/storeall/storemore/rollForwardRecovery.diff *** Start: rollForwardRecovery jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:11:29 *** Test skipped: test cannot run with jvm: j9_foundation. rollForwardRecovery.sql *** End: rollForwardRecovery jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:11:29 *** ********* Diff file derbyall/storeall/storemore/TestDurabilityProperty.diff *** Start: TestDurabilityProperty jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:15:19 *** Test skipped: test cannot run with jvm: j9_foundation. TestDurabilityProperty.java *** End: TestDurabilityProperty jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:15:19 *** ********* Diff file derbyall/storeall/storemore/TransactionTable.diff *** Start: TransactionTable jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:10:31 *** Test skipped: test cannot run with jvm: j9_foundation. TransactionTable.sql *** End: TransactionTable jdkJ2ME Foundation Specification v1.0 storeall:storemore 2005-07-13 17:10:31 *** ********* Diff file derbyall/storeall/storerecovery/LogChecksumRecovery.diff *** Start: LogChecksumRecovery jdkJ2ME Foundation Specification v1.0 storeall:storerecovery 2005-07-13 17:27:13 *** Test skipped: test cannot run with jvm: j9_foundation. LogChecksumRecovery.java *** End: LogChecksumRecovery jdkJ2ME Foundation Specification v1.0 storeall:storerecovery 2005-07-13 17:27:13 *** ********* Diff file derbyall/storeall/storerecovery/LogChecksumRecovery1.diff *** Start: LogChecksumRecovery1 jdkJ2ME Foundation Specification v1.0 storeall:storerecovery 2005-07-13 17:27:13 *** Test skipped: test cannot run with jvm: j9_foundation. LogChecksumRecovery1.java *** End: LogChecksumRecovery1 jdkJ2ME Foundation Specification v1.0 storeall:storerecovery 2005-07-13 17:27:13 *** ********* Diff file derbyall/storeall/storerecovery/LogChecksumSetup.diff *** Start: LogChecksumSetup jdkJ2ME Foundation Specification v1.0 storeall:storerecovery 2005-07-13 17:27:12 *** Test skipped: test cannot run with jvm: j9_foundation. LogChecksumSetup.java *** End: LogChecksumSetup jdkJ2ME Foundation Specification v1.0 storeall:storerecovery 2005-07-13 17:27:12 *** ********* Diff file derbyall/storeall/storerecovery/MaxLogNumber.diff *** Start: MaxLogNumber jdkJ2ME Foundation Specification v1.0 storeall:storerecovery 2005-07-13 17:27:13 *** Test skipped: test cannot run with jvm: j9_foundation. MaxLogNumber.java *** End: MaxLogNumber jdkJ2ME Foundation Specification v1.0 storeall:storerecovery 2005-07-13 17:27:13 *** ********* Diff file derbyall/storeall/storerecovery/MaxLogNumberRecovery.diff *** Start: MaxLogNumberRecovery jdkJ2ME Foundation Specification v1.0 storeall:storerecovery 2005-07-13 17:27:13 *** Test skipped: test cannot run with jvm: j9_foundation. MaxLogNumberRecovery.java *** End: MaxLogNumberRecovery jdkJ2ME Foundation Specification v1.0 storeall:storerecovery 2005-07-13 17:27:13 *** ********* Diff file derbyall/storeall/storetests/derby94.diff *** Start: derby94 jdkJ2ME Foundation Specification v1.0 storeall:storetests 2005-07-13 17:21:57 *** Test skipped: test cannot run with jvm: j9_foundation. derby94.sql *** End: derby94 jdkJ2ME Foundation Specification v1.0 storeall:storetests 2005-07-13 17:21:57 *** ********* Diff file derbyall/storeall/storetests/st_1.diff *** Start: st_1 jdkJ2ME Foundation Specification v1.0 storeall:storetests 2005-07-13 17:21:56 *** Test skipped: test cannot run with jvm: j9_foundation. st_1.sql *** End: st_1 jdkJ2ME Foundation Specification v1.0 storeall:storetests 2005-07-13 17:21:56 *** ********* Diff file derbyall/storeall/storetests/st_b5772.diff *** Start: st_b5772 jdkJ2ME Foundation Specification v1.0 storeall:storetests 2005-07-13 17:21:57 *** Test skipped: test cannot run with jvm: j9_foundation. st_b5772.sql *** End: st_b5772 jdkJ2ME Foundation Specification v1.0 storeall:storetests 2005-07-13 17:21:57 *** ********* Diff file derbyall/storeall/storetests/st_schema.diff *** Start: st_schema jdkJ2ME Foundation Specification v1.0 storeall:storetests 2005-07-13 17:21:56 *** Test skipped: test cannot run with jvm: j9_foundation. st_schema.sql *** End: st_schema jdkJ2ME Foundation Specification v1.0 storeall:storetests 2005-07-13 17:21:56 *** ********* Diff file derbyall/unit/cacheService.diff *** Start: cacheService jdkJ2ME Foundation Specification v1.0 derbyall:unit 2005-07-13 17:59:16 *** Test skipped: test cannot run with jvm: j9_foundation. cacheService.unit *** End: cacheService jdkJ2ME Foundation Specification v1.0 derbyall:unit 2005-07-13 17:59:16 *** ------------------------------------------------------