rollforwardrecovery.out

derby database source code.good for you.

1000000                                                                                                                        &|2000000                                                                                                                        &|3000000                                                                                                                        &|4000000                                                                                                                        &|5000000                                                                                                                        &
10000000                                                                                                                       &|20000000                                                                                                                       &|30000000                                                                                                                       &|40000000                                                                                                                       &|50000000                                                                                                                       &
100000000                                                                                                                      &|200000000                                                                                                                      &|300000000                                                                                                                      &|400000000                                                                                                                      &|500000000                                                                                                                      &
ij> select a from testing;
A                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
1                                                                                                                              &
10                                                                                                                             &
100                                                                                                                            &
1000                                                                                                                           &
10000                                                                                                                          &
100000                                                                                                                         &
1000000                                                                                                                        &
10000000                                                                                                                       &
100000000                                                                                                                      &
ij> select b from testing;
B                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
2                                                                                                                              &
20                                                                                                                             &
200                                                                                                                            &
2000                                                                                                                           &
20000                                                                                                                          &
200000                                                                                                                         &
2000000                                                                                                                        &
20000000                                                                                                                       &
200000000                                                                                                                      &
ij> select c from testing;
C                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
3                                                                                                                              &
30                                                                                                                             &
300                                                                                                                            &
3000                                                                                                                           &
30000                                                                                                                          &
300000                                                                                                                         &
3000000                                                                                                                        &
30000000                                                                                                                       &
300000000                                                                                                                      &
ij> select d from testing;
D                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
4                                                                                                                              &
40                                                                                                                             &
400                                                                                                                            &
4000                                                                                                                           &
40000                                                                                                                          &
400000                                                                                                                         &
4000000                                                                                                                        &
40000000                                                                                                                       &
400000000                                                                                                                      &
ij> select e from testing;
E                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
5                                                                                                                              &
50                                                                                                                             &
500                                                                                                                            &
5000                                                                                                                           &
50000                                                                                                                          &
500000                                                                                                                         &
5000000                                                                                                                        &
50000000                                                                                                                       &
500000000                                                                                                                      &
ij> -- insert some partial rows. 
insert into testing (a) values (PADSTRING('a',2024));
1 row inserted/updated/deleted
ij> insert into testing (a, b) values (PADSTRING('a',2024), PADSTRING('b',1024));
1 row inserted/updated/deleted
ij> insert into testing (a, b, c) values (PADSTRING('a',2024), PADSTRING('b',1024), PADSTRING('c',1024));
1 row inserted/updated/deleted
ij> insert into testing (a, b, c, d) values (PADSTRING('a',2024), PADSTRING('b',1024), PADSTRING('c',1024), PADSTRING('d',2048));
1 row inserted/updated/deleted
ij> insert into testing (a, b, c, d, e) values (PADSTRING('a',2024), PADSTRING('b',1024), PADSTRING('c',1024), PADSTRING('d',2048), PADSTRING('e',300));
1 row inserted/updated/deleted
ij> connect 'jdbc:derby:wombat;shutdown=true';
ERROR 08006: Database 'wombat' shutdown.
ij> disconnect;
ij> connect 'jdbc:derby:wombat;rollForwardRecoveryFrom=extinout/mybackup/wombat';
ij> -- select some partial rows.
-- should select 14 rows
select * from testing;
A                                                                                                                               |B                                                                                                                               |C                                                                                                                               |D                                                                                                                               |E                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1                                                                                                                              &|2                                                                                                                              &|3                                                                                                                              &|4                                                                                                                              &|5                                                                                                                              &
10                                                                                                                             &|20                                                                                                                             &|30                                                                                                                             &|40                                                                                                                             &|50                                                                                                                             &
100                                                                                                                            &|200                                                                                                                            &|300                                                                                                                            &|400                                                                                                                            &|500                                                                                                                            &
1000                                                                                                                           &|2000                                                                                                                           &|3000                                                                                                                           &|4000                                                                                                                           &|5000                                                                                                                           &
10000                                                                                                                          &|20000                                                                                                                          &|30000                                                                                                                          &|40000                                                                                                                          &|50000                                                                                                                          &
100000                                                                                                                         &|200000                                                                                                                         &|300000                                                                                                                         &|400000                                                                                                                         &|500000                                                                                                                         &
1000000                                                                                                                        &|2000000                                                                                                                        &|3000000                                                                                                                        &|4000000                                                                                                                        &|5000000                                                                                                                        &
10000000                                                                                                                       &|20000000                                                                                                                       &|30000000                                                                                                                       &|40000000                                                                                                                       &|50000000                                                                                                                       &
100000000                                                                                                                      &|200000000                                                                                                                      &|300000000                                                                                                                      &|400000000                                                                                                                      &|500000000                                                                                                                      &
a                                                                                                                              &|NULL                                                                                                                            |NULL                                                                                                                            |NULL                                                                                                                            |NULL                                                                                                                            
a                                                                                                                              &|b                                                                                                                              &|NULL                                                                                                                            |NULL                                                                                                                            |NULL                                                                                                                            
a                                                                                                                              &|b                                                                                                                              &|c                                                                                                                              &|NULL                                                                                                                            |NULL                                                                                                                            
a                                                                                                                              &|b                                                                                                                              &|c                                                                                                                              &|d                                                                                                                              &|NULL                                                                                                                            
a                                                                                                                              &|b                                                                                                                              &|c                                                                                                                              &|d                                                                                                                              &|e                                                                                                                              &
ij> -- should select 5 rows
select * from testing where a = PADSTRING('a',2024);
A                                                                                                                               |B                                                                                                                               |C                                                                                                                               |D                                                                                                                               |E                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
a                                                                                                                              &|NULL                                                                                                                            |NULL                                                                                                                            |NULL                                                                                                                            |NULL                                                                                                                            
a                                                                                                                              &|b                                                                                                                              &|NULL                                                                                                                            |NULL                                                                                                                            |NULL                                                                                                                            
a                                                                                                                              &|b                                                                                                                              &|c                                                                                                                              &|NULL                                                                                                                            |NULL                                                                                                                            
a                                                                                                                              &|b                                                                                                                              &|c                                                                                                                              &|d                                                                                                                              &|NULL                                                                                                                            
a                                                                                                                              &|b                                                                                                                              &|c                                                                                                                              &|d                                                                                                                              &|e                                                                                                                              &
ij> -- should select 4 rows
select a,c,d from testing where b = PADSTRING('b',1024);
A                                                                                                                               |C                                                                                                                               |D                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
a                                                                                                                              &|NULL                                                                                                                            |NULL                                                                                                                            
a                                                                                                                              &|c                                                                                                                              &|NULL                                                                                                                            
a                                                                                                                              &|c                                                                                                                              &|d                                                                                                                              &
a                                                                                                                              &|c                                                                                                                              &|d                                                                                                                              &
ij> -- should select 1 row
select b, e from testing where e = PADSTRING('e',300);
B                                                                                                                               |E                                                                                                                               
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
b                                                                                                                              &|e                                                                                                                              &
ij> -- should select 14 rows
select a,c,e from testing order by a;
A                                                                                                                               |C                                                                                                                               |E                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1                                                                                                                              &|3                                                                                                                              &|5                                                                                                                              &
10                                                                                                                             &|30                                                                                                                             &|50                                                                                                                             &
100                                                                                                                            &|300                                                                                                                            &|500                                                                                                                            &
1000                                                                                                                           &|3000                                                                                                                           &|5000                                                                                                                           &
10000                                                                                                                          &|30000                                                                                                                          &|50000                                                                                                                          &
100000                                                                                                                         &|300000                                                                                                                         &|500000                                                                                                                         &
1000000                                                                                                                        &|3000000                                                                                                                        &|5000000                                                                                                                        &
10000000                                                                                                                       &|30000000                                                                                                                       &|50000000                                                                                                                       &
100000000                                                                                                                      &|300000000                                                                                                                      &|500000000                                                                                                                      &
a                                                                                                                              &|c                                                                                                                              &|e                                                                                                                              &
a                                                                                                                              &|c                                                                                                                              &|NULL                                                                                                                            
a                                                                                                                              &|c                                                                                                                              &|NULL                                                                                                                            
a                                                                                                                              &|NULL                                                                                                                            |NULL                                                                                                                            
a                                                                                                                              &|NULL                                                                                                                            |NULL                                                                                                                            
ij> -- update 5 rows on the main data page
update testing set a = PADSTRING('aa',2024) where a = PADSTRING('a',2024);
5 rows inserted/updated/deleted
ij> -- following select should return 0 rows
select * from testing where a = PADSTRING('a',2024);
A                                                                                                                               |B                                                                                                                               |C                                                                                                                               |D                                                                                                                               |E                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ij> -- following select should return 5 rows
select * from testing where a = PADSTRING('aa',2024);
A                                                                                                                               |B                                                                                                                               |C                                                                                                                               |D                                                                                                                               |E                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
aa                                                                                                                             &|NULL                                                                                                                            |NULL                                                                                                                            |NULL                                                                                                                            |NULL                                                                                                                            
aa                                                                                                                             &|b                                                                                                                              &|NULL                                                                                                                            |NULL                                                                                                                            |NULL                                                                                                                            
aa                                                                                                                             &|b                                                                                                                              &|c                                                                                                                              &|NULL                                                                                                                            |NULL                                                                                                                            
aa