removestubs.out

来自「derby database source code.good for you.」· OUT 代码 · 共 138 行

OUT
138 行
字号 
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>

removestubs.out - 源码说明

本页面展示了「derby database source code.good for you.」中的 removestubs.out 源码文件，采用 OUT 编程语言编写，共 138 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与database相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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