📄 holdcursorjdbc30.out
字号:
ij> commit;ij> next test1;No current rowij> next test1;No current rowij> next test1;No current rowij> commit;ij> close test1;ij> -- should failnext test1;IJ ERROR: Unable to establish cursorij> get with hold cursor test1 as 'select a,data from foo order by data desc';ij> next test1;No current rowij> commit;ij> next test1;No current rowij> commit;ij> next test1;No current rowij> next test1;No current rowij> next test1;No current rowij> next test1;No current rowij> commit;ij> close test1;ij> -- should failnext test1;IJ ERROR: Unable to establish cursorij> get with hold cursor test1 as 'select a,data from foo order by data desc';ij> next test1;No current rowij> commit;ij> next test1;No current rowij> commit;ij> next test1;No current rowij> next test1;No current rowij> next test1;No current rowij> next test1;No current rowij> close test1;ij> commit;ij> -- should failnext test1;IJ ERROR: Unable to establish cursorij> commit;ij> insert into foo values (1, 10);1 row inserted/updated/deletedij> insert into foo values (1, 20);1 row inserted/updated/deletedij> insert into foo values (1, 30);1 row inserted/updated/deletedij> insert into foo values (1, 40);1 row inserted/updated/deletedij> insert into foo values (1, 50);1 row inserted/updated/deletedij> -- insert into foo (select a + 5, data + 50 from foo);-- the following for update of data cursors will all use group fetch = 1, thus each-- next passes straight through to store.get with hold cursor test1 as 'select a,data from foo order by data desc';ij> close test1;ij> commit;ij> -- should failnext test1;IJ ERROR: Unable to establish cursorij> get with hold cursor test1 as 'select a,data from foo order by data desc';ij> commit;ij> close test1;ij> -- should failnext test1;IJ ERROR: Unable to establish cursorij> get with hold cursor test1 as 'select a,data from foo order by data desc';ij> commit;ij> next test1;A |DATA -----------------------1 |50 ij> close test1;ij> -- should failnext test1;IJ ERROR: Unable to establish cursorij> get with hold cursor test1 as 'select a,data from foo order by data desc';ij> next test1;A |DATA -----------------------1 |50 ij> commit;ij> next test1;A |DATA -----------------------1 |40 ij> close test1;ij> -- should failnext test1;IJ ERROR: Unable to establish cursorij> get with hold cursor test1 as 'select a,data from foo order by data desc';ij> next test1;A |DATA -----------------------1 |50 ij> commit;ij> next test1;A |DATA -----------------------1 |40 ij> commit;ij> close test1;ij> -- should failnext test1;IJ ERROR: Unable to establish cursorij> get with hold cursor test1 as 'select a,data from foo order by data desc';ij> next test1;A |DATA -----------------------1 |50 ij> commit;ij> next test1;A |DATA -----------------------1 |40 ij> commit;ij> next test1;A |DATA -----------------------1 |30 ij> next test1;A |DATA -----------------------1 |20 ij> next test1;A |DATA -----------------------1 |10 ij> commit;ij> close test1;ij> -- should failnext test1;IJ ERROR: Unable to establish cursorij> get with hold cursor test1 as 'select a,data from foo order by data desc';ij> next test1;A |DATA -----------------------1 |50 ij> commit;ij> next test1;A |DATA -----------------------1 |40 ij> commit;ij> next test1;A |DATA -----------------------1 |30 ij> next test1;A |DATA -----------------------1 |20 ij> next test1;A |DATA -----------------------1 |10 ij> next test1;No current rowij> commit;ij> close test1;ij> -- should failnext test1;IJ ERROR: Unable to establish cursorij> get with hold cursor test1 as 'select a,data from foo order by data desc';ij> next test1;A |DATA -----------------------1 |50 ij> commit;ij> next test1;A |DATA -----------------------1 |40 ij> commit;ij> next test1;A |DATA -----------------------1 |30 ij> next test1;A |DATA -----------------------1 |20 ij> next test1;A |DATA -----------------------1 |10 ij> next test1;No current rowij> close test1;ij> commit;ij> -- should failnext test1;IJ ERROR: Unable to establish cursorij> commit;ij> -------------------------------------------------------------------------------- TEST 7: test of hold cursor code in DistinctScalarAggregateResultSet.java-- Directed test of hold cursor as applies to sort scans opened by-- DistinctScalarAggregateResultSet.java.-----------------------------------------------------------------------------drop table t1;ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T1' because it does not exist.ij> create table t1 (c1 int, c2 int);0 rows inserted/updated/deletedij> insert into t1 values (null, null), (1,1), (null, null), (2,1), (3,1), (10,10);6 rows inserted/updated/deletedij> select * from t1;C1 |C2 -----------------------NULL |NULL 1 |1 NULL |NULL 2 |1 3 |1 10 |10 ij> select sum(distinct c1) from t1;1 -----------16 WARNING 01003: Null values were eliminated from the argument of a column function.ij> get with hold cursor test1 as 'select sum(distinct c1) from t1';ij> commit;ij> next test1;1 -----------16 WARNING 01003: Null values were eliminated from the argument of a column function.ij> close test1;ij> get with hold cursor test1 as 'select sum(distinct c1) from t1';ij> next test1;1 -----------16 WARNING 01003: Null values were eliminated from the argument of a column function.ij> commit;ij> next test1;No current rowij> commit;ij> close test1;ij> commit;ij> -------------------------------------------------------------------------------- TEST 8: test of hold cursor code in GroupedAggregateResultSet.java-- Directed test of hold cursor as applies to sort scans opened by-- GroupedAggregateResultSet.java.-----------------------------------------------------------------------------drop table t1;0 rows inserted/updated/deletedij> create table t1 (c1 int, c2 int);0 rows inserted/updated/deletedij> insert into t1 values (null, null), (1,1), (null, null), (2,1), (3,1), (10,10);6 rows inserted/updated/deletedij> select * from t1;C1 |C2 -----------------------NULL |NULL 1 |1 NULL |NULL 2 |1 3 |1 10 |10 ij> select sum(distinct c1) from t1 group by c2;1 -----------6 10 NULL WARNING 01003: Null values were eliminated from the argument of a column function.ij> commit;ij> get with hold cursor test1 as 'select sum(distinct c1) from t1 group by c2';ij> commit;ij> next test1;1 -----------6 ij> next test1;1 -----------10 ij> commit;ij> next test1;1 -----------NULL WARNING 01003: Null values were eliminated from the argument of a column function.ij> close test1;ij> get with hold cursor test1 as 'select sum(distinct c1) from t1 group by c2';ij> next test1;1 -----------6 ij> commit;ij> next test1;1 -----------10 ij> commit;ij> next test1;1 -----------NULL WARNING 01003: Null values were eliminated from the argument of a column function.ij> close test1;ij> -------------------------------------------------------------------------------- TEST 9: test scan positioned on a row which has been purged.-----------------------------------------------------------------------------drop table t1;0 rows inserted/updated/deletedij> create table t1 (c1 int, c2 int);0 rows inserted/updated/deletedij> create index tx on t1 (c1);0 rows inserted/updated/deletedij> insert into t1 values (1, 1), (2, 2), (3, 3), (4, 4), (5, 5), (6, 6);6 rows inserted/updated/deletedij> get with hold cursor test1 as 'select c1 from t1';ij> next test1;C1 -----------1 ij> commit;ij> -- at this point the btree scan is positioned by "key" on (1,1). Make sure-- deleting this key doesn't cause any problems.delete from t1 where c1 = 1 or c1 = 2;2 rows inserted/updated/deletedij> next test1;C1 -----------3 ij> -- at this point the btree scan is positioned on (3, 3), let's see what happens-- if we delete (3,3) and look at current scan.delete from t1 where c1 = 3;1 row inserted/updated/deletedij> -- position on (4,4)next test1;C1 -----------4 ij> commit;ij> -- delete all the rows and hopefully get all rows to be purged by the time-- the scan does the next.delete from t1;3 rows inserted/updated/deletedij> commit;ij> next test1;No current rowij> close test1;ij> -------------------------------------------------------------------------------- TEST 10: test scan positioned on a page which has been purged (should really-- not be any different than a row being purged).-----------------------------------------------------------------------------drop table t1;0 rows inserted/updated/deletedij> create table t1 (c1 varchar(1000), c2 int);0 rows inserted/updated/deletedij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', '4096');0 rows inserted/updated/deletedij> create index tx on t1 (c1);0 rows inserted/updated/deletedij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', NULL);0 rows inserted/updated/deletedij> insert into t1 values (PADSTRING('1',1000), 1), (PADSTRING('2',1000), 2), (PADSTRING('3',1000), 3), (PADSTRING('4',1000), 4), (PADSTRING('5',1000), 5), (PADSTRING('6',1000), 6), (PADSTRING('7',1000), 7);7 rows inserted/updated/deletedij> get with hold cursor test1 as 'select c1 from t1';ij> next test1;C1 --------------------------------------------------------------------------------------------------------------------------------1 &ij> commit;ij> -- at this point the btree scan is positioned by "key" on (1,1). Make sure-- deleting this key doesn't cause any problems.delete from t1 where c1 = PADSTRING('1',1000) or c1 = PADSTRING('2',1000);2 rows inserted/updated/deletedij> next test1;C1 --------------------------------------------------------------------------------------------------------------------------------3 &ij> -- at this point the btree scan is positioned on (3, 3), let's see what happens-- if we delete (3,3) and look at current scan.delete from t1 where c1 = PADSTRING('3',1000);1 row inserted/updated/deletedij> -- position on (4,4)next test1;C1 --------------------------------------------------------------------------------------------------------------------------------4 &ij> commit;ij> -- delete all the rows and hopefully get all rows to be purged by the time-- the scan does the next.delete from t1;4 rows inserted/updated/deletedij> commit;ij> next test1;No current rowij> close test1;ij> -------------------------------------------------------------------------------- TEST 11: beetle 4902: test query plans which use reopenScan() on a btree to -- do the inner table processing of a join. Prior to the fix a null-- pointer exception would be thrown after the commit, as the code-- did not handle keeping the resultset used for the inner table-- open across commits in this case.-----------------------------------------------------------------------------drop table t1;0 rows inserted/updated/deletedij> drop table t2;ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T2' because it does not exist.ij> create table t1 (i1 int, i2 int);0 rows inserted/updated/deletedij> create table t2 (i1 int, i2 int);0 rows inserted/updated/deletedij> create index t1_idx on t1 (i1);0 rows inserted/updated/deletedij> create index t2_idx on t2 (i1);0 rows inserted/updated/deletedij> insert into t1 values (1, 10), (2, 20), (3, 30), (4, 40), (5, 50);5 rows inserted/updated/deletedij> insert into t2 values (1, 10), (2, 20), (4, 40), (5, 50);4 rows inserted/updated/deletedij> commit;ij> -- force nestedLoop to make sure reopenScan() is used on inner table.get with hold cursor test11 as'select * from t1, t2 where t1.i1 = t2.i1';ij> commit;ij> next test11;I1 |I2 |I1 |I2 -----------------------------------------------1 |10 |1 |10 ij> commit;ij> next test11;I1 |I2 |I1 |I2 -----------------------------------------------2 |20 |2 |20 ij> commit;ij> next test11;I1 |I2 |I1 |I2 -----------------------------------------------4 |40 |4 |40 ij> next test11;I1 |I2 |I1 |I2 -----------------------------------------------5 |50 |5 |50 ij> commit;ij> commit;ij> next test11;No current rowij> commit;ij> close test11;ij> -------------------------------------------------------------------------------- TEST 12: beetle 4902: test query plans which use reopenScan() on a base table-- to do the inner table processing of a join. Prior to the fix a null-- pointer exception would be thrown after the commit, as the code-- did not handle keeping the resultset used for the inner table-- open across commits in this case.-----------------------------------------------------------------------------drop table t1;0 rows inserted/updated/deletedij> drop table t2;0 rows inserted/updated/deletedij> create table t1 (i1 int, i2 int);0 rows inserted/updated/deletedij> create table t2 (i1 int, i2 int);0 rows inserted/updated/deletedij> insert into t1 values (1, 10), (2, 20), (3, 30), (4, 40), (5, 50);5 rows inserted/updated/deletedij> insert into t2 values (1, 10), (2, 20), (4, 40), (5, 50);4 rows inserted/updated/deletedij> commit;ij> -- force nestedLoop to make sure reopenScan() is used on inner table.get with hold cursor test12 as'select * from t1, t2 where t1.i1 = t2.i1';ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '16');0 rows inserted/updated/deletedij> commit;ij> next test12;I1 |I2 |I1 |I2 -----------------------------------------------1 |10 |1 |10 ij> commit;ij> next test12;I1 |I2 |I1 |I2 -----------------------------------------------2 |20 |2 |20 ij> commit;ij> next test12;I1 |I2 |I1 |I2 -----------------------------------------------4 |40 |4 |40 ij> next test12;I1 |I2 |I1 |I2 -----------------------------------------------5 |50 |5 |50 ij> commit;ij> commit;ij> next test12;No current rowij> commit;ij> close test12;ij> exit;⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -