holdcursorexternalsortjdbc30.out

derby database source code.good for you.

--------------------------------------------------------------------------------------------------------------------------------------------
6          |6                                                                                                                              &
ij> next test1;
A          |DATA                                                                                                                            
--------------------------------------------------------------------------------------------------------------------------------------------
7          |7                                                                                                                              &
ij> next test1;
A          |DATA                                                                                                                            
--------------------------------------------------------------------------------------------------------------------------------------------
8          |8                                                                                                                              &
ij> next test1;
A          |DATA                                                                                                                            
--------------------------------------------------------------------------------------------------------------------------------------------
9          |9                                                                                                                              &
ij> next test1;
A          |DATA                                                                                                                            
--------------------------------------------------------------------------------------------------------------------------------------------
10         |10                                                                                                                             &
ij> next test1;
No current row
ij> close test1;
ij> commit;
ij> ------------------------------------------------------------------------------
--    TEST  1: test hold cursor with multi-level 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.
------------------------------------------------------------------------------
insert into foo select a + 100, data from foo;
10 rows inserted/updated/deleted
ij> insert into foo select a + 10,  data from foo;
20 rows inserted/updated/deleted
ij> insert into foo select a + 200, data from foo;
40 rows inserted/updated/deleted
ij> insert into foo select a + 200, data from foo;
80 rows inserted/updated/deleted
ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.language.bulkFetchDefault', '1');
0 rows inserted/updated/deleted
ij> 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/deleted
ij> 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;
A          |DATA                                                                                                                            
--------------------------------------------------------------------------------------------------------------------------------------------
11         |1                                                                                                                              &
ij> commit;
ij> next test1;
A          |DATA                                                                                                                            
--------------------------------------------------------------------------------------------------------------------------------------------
12         |2                                                                                                                              &
ij> next test1;
A          |DATA                                                                                                                            
--------------------------------------------------------------------------------------------------------------------------------------------
13         |3                                                                                                                              &
ij> next test1;
A          |DATA                                                                                                                            
--------------------------------------------------------------------------------------------------------------------------------------------
14         |4                                                                                                                              &
ij> next test1;
A          |DATA                                                                                                                            
--------------------------------------------------------------------------------------------------------------------------------------------
15         |5                                                                                                                              &
ij> commit;
ij> next test1;
A          |DATA                                                                                                                            
--------------------------------------------------------------------------------------------------------------------------------------------
16         |6                                                                                                                              &
ij> next test1;
A          |DATA                                                                                                                            
--------------------------------------------------------------------------------------------------------------------------------------------
17         |7                                                                                                                              &