📄 removestubs.out

📁 derby database source code.good for you.
💻 OUT
字号:
ij> ---test which goes through the code path that --removes the stub files are no longer necessarycreate table t1(a int ) ;0 rows inserted/updated/deletedij> autocommit off ;ij> drop table t1 ;0 rows inserted/updated/deletedij> commit ;ij> connect 'jdbc:derby:wombat;shutdown=true';ERROR 08006: Database 'wombat' shutdown.ij> disconnect all;ij> connect 'jdbc:derby:wombat';ij> autocommit on;ij> create table t1(a int ) ;0 rows inserted/updated/deletedij> drop table t1 ;0 rows inserted/updated/deletedij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();0 rows inserted/updated/deletedij> create table t1(a int ) ;0 rows inserted/updated/deletedij> drop table t1 ;0 rows inserted/updated/deletedij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();0 rows inserted/updated/deletedij> create table t1(a int ) ;0 rows inserted/updated/deletedij> drop table t1 ;0 rows inserted/updated/deletedij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();0 rows inserted/updated/deletedij> connect 'jdbc:derby:wombat;shutdown=true';ERROR 08006: Database 'wombat' shutdown.ij> disconnect all;ij> connect 'jdbc:derby:wombat';ij> create table t2( a int ) ;0 rows inserted/updated/deletedij> connect 'jdbc:derby:wombat;shutdown=true';ERROR 08006: Database 'wombat' shutdown.ij> disconnect all;ij> connect 'jdbc:derby:wombat';ij> drop table t2 ;0 rows inserted/updated/deletedij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();0 rows inserted/updated/deletedij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();0 rows inserted/updated/deletedij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();0 rows inserted/updated/deletedij> --following create will make sure that the container--cache does not have the delete stub file entrycreate table t3(a int ) ;0 rows inserted/updated/deletedij> --do some inserts/delete and thene remove the stubscreate table t2(b int);0 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> autocommit off;ij> delete from t2;28 rows inserted/updated/deletedij> commit;ij> drop table t2;0 rows inserted/updated/deletedij> commit;ij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();0 rows inserted/updated/deletedij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();0 rows inserted/updated/deletedij> -- do some delete and drpop of the container in the same transactioncreate table t2(b int);0 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> commit;ij> delete from t2;28 rows inserted/updated/deletedij> drop table t2;0 rows inserted/updated/deletedij> commit;ij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();0 rows inserted/updated/deletedij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();0 rows inserted/updated/deletedij> --just do a rollback for the heck of it-- do some delete and drpop of the container in the same transactioncreate table t2(b int);0 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> insert into t2 values (1) , (2) , (3) , (4);4 rows inserted/updated/deletedij> commit;ij> delete from t2;28 rows inserted/updated/deletedij> drop table t2;0 rows inserted/updated/deletedij> rollback;ij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();0 rows inserted/updated/deletedij> CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE();0 rows inserted/updated/deletedij>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -