📄 holdcursorexternalsortjdbc30.out
字号:
ij> -------------------------------------------------------------------------------- TEST CASES SPECIFIC TO STORE IMPLEMENTATION OF HOLD CURSOR (external sort):-- overview:-- TEST 0: test hold cursor with external sort (order by).-- TEST 1: basic heap scan tests (multiple rows)-- TEST 2: basic btree scan tests (zero rows/update nonkey field)-- TEST 3: basic btree scan tests (multiple rows/update nonkey field)-- TEST 4: basic btree scan tests (zero rows/read only/no group fetch)-- TEST 5: basic btree scan tests (multiple rows/read only/no group fetch)-- TEST 6: basic tests for cursors with order by-- TEST 7: test of hold cursor code in DistinctScalarAggregateResultSet.java-- TEST 8: test of hold cursor code in GroupedAggregateResultSet.java-- TEST 9: test scan positioned on a row which has been purged.-- TEST 10: test scan positioned on a page which has been purged---------------------------------------------------------------------------------------------------------------------------------------------------------------- TEST 0: test hold cursor with external sort (order by).-- Cutover to external sort has been set to 4 rows by the test property -- file so with 10 rows we get a 1 level external sort. This tests that-- temp files will be held open across the commit if the cursor is held-- open.------------------------------------------------------------------------------run resource 'createTestProcedures.subsql';ij> CREATE FUNCTION PADSTRING (DATA VARCHAR(32000), LENGTH INTEGER) RETURNS VARCHAR(32000) EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.Formatters.padString' LANGUAGE JAVA PARAMETER STYLE JAVA;0 rows inserted/updated/deletedij> CREATE PROCEDURE WAIT_FOR_POST_COMMIT() DYNAMIC RESULT SETS 0 LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.T_Access.waitForPostCommitToFinish' PARAMETER STYLE JAVA;0 rows inserted/updated/deletedij> autocommit off;ij> create table foo (a int, data varchar(2000));0 rows inserted/updated/deletedij> insert into foo values (10,PADSTRING('10',2000)), (9,PADSTRING('9',2000)), (8,PADSTRING('8',2000)), (7,PADSTRING('7',2000)), (6,PADSTRING('6',2000)), (5,PADSTRING('5',2000)), (4,PADSTRING('4',2000)), (3,PADSTRING('3',2000)), (2,PADSTRING('2',2000)), (1,PADSTRING('1',2000));10 rows inserted/updated/deletedij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '1');0 rows inserted/updated/deletedij> get with hold cursor test1 as 'select * from foo order by a';ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');0 rows inserted/updated/deletedij> next test1;A |DATA --------------------------------------------------------------------------------------------------------------------------------------------1 |1 &ij> commit;ij> next test1;A |DATA --------------------------------------------------------------------------------------------------------------------------------------------2 |2 &ij> next test1;A |DATA --------------------------------------------------------------------------------------------------------------------------------------------3 |3 &ij> next test1;A |DATA --------------------------------------------------------------------------------------------------------------------------------------------4 |4 &ij> next test1;A |DATA --------------------------------------------------------------------------------------------------------------------------------------------5 |5 &ij> commit;ij> next test1;A |DATA --------------------------------------------------------------------------------------------------------------------------------------------6 |6 &ij> next test1;A |DATA --------------------------------------------------------------------------------------------------------------------------------------------7 |7 &ij> next test1;A |DATA --------------------------------------------------------------------------------------------------------------------------------------------8 |8 &ij> next test1;A |DATA --------------------------------------------------------------------------------------------------------------------------------------------9 |9 &ij> commit;ij> next test1;A |DATA --------------------------------------------------------------------------------------------------------------------------------------------10 |10 &ij> next test1;No current rowij> commit;ij> close test1;ij> -- exercise the non-held cursor path also.call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '1');0 rows inserted/updated/deletedij> get cursor test1 as 'select * from foo order by a';ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');0 rows inserted/updated/deletedij> next test1;A |DATA --------------------------------------------------------------------------------------------------------------------------------------------1 |1 &ij> next test1;A |DATA --------------------------------------------------------------------------------------------------------------------------------------------2 |2 &ij> next test1;A |DATA --------------------------------------------------------------------------------------------------------------------------------------------3 |3 &ij> next test1;A |DATA --------------------------------------------------------------------------------------------------------------------------------------------4 |4 &ij> next test1;A |DATA --------------------------------------------------------------------------------------------------------------------------------------------5 |5 &ij> next test1;A |DATA ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -