updatecursor.out

derby database source code.good for you.

Test updateable cursor using index starting
PASS: expected and got 0 rows
PASS: expected and got 0 rows
PASS: expected and got 0 rows
PASS: expected and got 0 rows
PASS: expected and got 0 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: expected and got 5 rows
PASS: setup complete
************************************TESTING VIRTUAL MEM HEAP*********
Notice the order in the rows we get: from 2 to 102 asc order on second column (c3)
then from 202 down to 103 on that column; then from 203 up to 250.  The reason is
we are using asc index on c3, all the rows updated are in the future direction of the
index scan, so they all get filled into a hash table.  The MAX_MEMORY_PER_TABLE
property determines max cap of hash table 100.  So from row 103 it goes into virtual
memory heap, whose in memory part is also 100 entries.  So row 103 to 202 goes into
the in-memory part and gets dumped out in reverse order.  Finally Row 203 to 250
goes into file system.  Here we mean row ids.
PASS: expected and got true
Row: 4,2
PASS: expected and got true
Row: 3,3
PASS: expected and got true
Row: 2,4
PASS: expected and got true
Row: 1,5
PASS: expected and got true
Row: 10,6
PASS: expected and got true
Row: 9,7
PASS: expected and got true
Row: 8,8
PASS: expected and got true
Row: 7,9
PASS: expected and got true
Row: 6,10
PASS: expected and got true
Row: 15,11
PASS: expected and got true
Row: 14,12
PASS: expected and got true
Row: 13,13
PASS: expected and got true
Row: 12,14
PASS: expected and got true
Row: 11,15
PASS: expected and got true
Row: 20,16
PASS: expected and got true
Row: 19,17
PASS: expected and got true
Row: 18,18
PASS: expected and got true
Row: 17,19
PASS: expected and got true
Row: 16,20
PASS: expected and got true
Row: 25,21
PASS: expected and got true
Row: 24,22
PASS: expected and got true
Row: 23,23
PASS: expected and got true
Row: 22,24
PASS: expected and got true
Row: 21,25
PASS: expected and got true
Row: 30,26
PASS: expected and got true
Row: 29,27
PASS: expected and got true
Row: 28,28
PASS: expected and got true
Row: 27,29
PASS: expected and got true
Row: 26,30
PASS: expected and got true
Row: 35,31
PASS: expected and got true
Row: 34,32
PASS: expected and got true
Row: 33,33
PASS: expected and got true
Row: 32,34
PASS: expected and got true
Row: 31,35
PASS: expected and got true
Row: 40,36
PASS: expected and got true
Row: 39,37
PASS: expected and got true
Row: 38,38
PASS: expected and got true
Row: 37,39
PASS: expected and got true
Row: 36,40
PASS: expected and got true
Row: 45,41
PASS: expected and got true
Row: 44,42
PASS: expected and got true
Row: 43,43
PASS: expected and got true
Row: 42,44
PASS: expected and got true
Row: 41,45
PASS: expected and got true
Row: 50,46
PASS: expected and got true
Row: 49,47
PASS: expected and got true
Row: 48,48
PASS: expected and got true
Row: 47,49
PASS: expected and got true
Row: 46,50
PASS: expected and got true
Row: 55,51
PASS: expected and got true
Row: 54,52
PASS: expected and got true
Row: 53,53
PASS: expected and got true
Row: 52,54
PASS: expected and got true
Row: 51,55
PASS: expected and got true
Row: 60,56
PASS: expected and got true
Row: 59,57
PASS: expected and got true
Row: 58,58
PASS: expected and got true
Row: 57,59
PASS: expected and got true
Row: 56,60
PASS: expected and got true
Row: 65,61
PASS: expected and got true
Row: 64,62
PASS: expected and got true
Row: 63,63
PASS: expected and got true
Row: 62,64
PASS: expected and got true
Row: 61,65
PASS: expected and got true
Row: 70,66
PASS: expected and got true
Row: 69,67
PASS: expected and got true
Row: 68,68
PASS: expected and got true
Row: 67,69
PASS: expected and got true
Row: 66,70
PASS: expected and got true
Row: 75,71
PASS: expected and got true
Row: 74,72
PASS: expected and got true
Row: 73,73
PASS: expected and got true
Row: 72,74
PASS: expected and got true
Row: 71,75
PASS: expected and got true
Row: 80,76
PASS: expected and got true
Row: 79,77
PASS: expected and got true
Row: 78,78
PASS: expected and got true
Row: 77,79
PASS: expected and got true
Row: 76,80
PASS: expected and got true
Row: 85,81
PASS: expected and got true
Row: 84,82
PASS: expected and got true
Row: 83,83
PASS: expected and got true
Row: 82,84
PASS: expected and got true
Row: 81,85
PASS: expected and got true
Row: 90,86
PASS: expected and got true
Row: 89,87
PASS: expected and got true
Row: 88,88
PASS: expected and got true
Row: 87,89
PASS: expected and got true
Row: 86,90
PASS: expected and got true
Row: 95,91
PASS: expected and got true
Row: 94,92
PASS: expected and got true
Row: 93,93
PASS: expected and got true
Row: 92,94
PASS: expected and got true
Row: 91,95
PASS: expected and got true
Row: 100,96
PASS: expected and got true
Row: 99,97
PASS: expected and got true
Row: 98,98
PASS: expected and got true
Row: 97,99
PASS: expected and got true
Row: 96,100
PASS: expected and got true
Row: 105,101
PASS: expected and got true
Row: 104,102
PASS: expected and got true
Row: 204,202
PASS: expected and got true
Row: 205,201
PASS: expected and got true
Row: 196,200
PASS: expected and got true
Row: 197,199
PASS: expected and got true
Row: 198,198
PASS: expected and got true
Row: 199,197
PASS: expected and got true
Row: 200,196
PASS: expected and got true
Row: 191,195
PASS: expected and got true
Row: 192,194
PASS: expected and got true
Row: 193,193
PASS: expected and got true
Row: 194,192
PASS: expected and got true
Row: 195,191
PASS: expected and got true
Row: 186,190
PASS: expected and got true
Row: 187,189
PASS: expected and got true
Row: 188,188
PASS: expected and got true
Row: 189,187
PASS: expected and got true
Row: 190,186
PASS: expected and got true
Row: 181,185
PASS: expected and got true
Row: 182,184
PASS: expected and got true
Row: 183,183
PASS: expected and got true
Row: 184,182
PASS: expected and got true
Row: 185,181
PASS: expected and got true
Row: 176,180
PASS: expected and got true
Row: 177,179
PASS: expected and got true
Row: 178,178
PASS: expected and got true
Row: 179,177
PASS: expected and got true
Row: 180,176
PASS: expected and got true
Row: 171,175
PASS: expected and got true
Row: 172,174
PASS: expected and got true
Row: 173,173
PASS: expected and got true
Row: 174,172
PASS: expected and got true
Row: 175,171
PASS: expected and got true
Row: 166,170
PASS: expected and got true
Row: 167,169
PASS: expected and got true
Row: 168,168
PASS: expected and got true
Row: 169,167
PASS: expected and got true
Row: 170,166
PASS: expected and got true
Row: 161,165
PASS: expected and got true
Row: 162,164
PASS: expected and got true
Row: 163,163
PASS: expected and got true
Row: 164,162
PASS: expected and got true
Row: 165,161
PASS: expected and got true
Row: 156,160
PASS: expected and got true
Row: 157,159
PASS: expected and got true
Row: 158,158
PASS: expected and got true
Row: 159,157
PASS: expected and got true
Row: 160,156
PASS: expected and got true
Row: 151,155
PASS: expected and got true
Row: 152,154
PASS: expected and got true
Row: 153,153
PASS: expected and got true
Row: 154,152
PASS: expected and got true
Row: 155,151
PASS: expected and got true
Row: 146,150
PASS: expected and got true
Row: 147,149
PASS: expected and got true
Row: 148,148
PASS: expected and got true
Row: 149,147
PASS: expected and got true
Row: 150,146
PASS: expected and got true
Row: 141,145
PASS: expected and got true
Row: 142,144
PASS: expected and got true
Row: 143,143
PASS: expected and got true
Row: 144,142
PASS: expected and got true
Row: 145,141
PASS: expected and got true
Row: 136,140
PASS: expected and got true
Row: 137,139
PASS: expected and got true
Row: 138,138
PASS: expected and got true
Row: 139,137
PASS: expected and got true
Row: 140,136
PASS: expected and got true
Row: 131,135
PASS: expected and got true
Row: 132,134
PASS: expected and got true
Row: 133,133
PASS: expected and got true
Row: 134,132
PASS: expected and got true
Row: 135,131
PASS: expected and got true
Row: 126,130
PASS: expected and got true
Row: 127,129
PASS: expected and got true
Row: 128,128
PASS: expected and got true
Row: 129,127
PASS: expected and got true
Row: 130,126
PASS: expected and got true
Row: 121,125
PASS: expected and got true
Row: 122,124
PASS: expected and got true
Row: 123,123
PASS: expected and got true
Row: 124,122
PASS: expected and got true
Row: 125,121
PASS: expected and got true
Row: 116,120
PASS: expected and got true
Row: 117,119
PASS: expected and got true
Row: 118,118
PASS: expected and got true
Row: 119,117
PASS: expected and got true
Row: 120,116
PASS: expected and got true
Row: 111,115
PASS: expected and got true
Row: 112,114
PASS: expected and got true
Row: 113,113
PASS: expected and got true
Row: 114,112
PASS: expected and got true
Row: 115,111
PASS: expected and got true
Row: 106,110
PASS: expected and got true
Row: 107,109
PASS: expected and got true
Row: 108,108
PASS: expected and got true
Row: 109,107
PASS: expected and got true
Row: 110,106
PASS: expected and got true
Row: 101,105
PASS: expected and got true
Row: 102,104
PASS: expected and got true
Row: 103,103
PASS: expected and got true
Row: 203,203
PASS: expected and got true
Row: 202,204
PASS: expected and got true
Row: 201,205
PASS: expected and got true
Row: 210,206
PASS: expected and got true
Row: 209,207
PASS: expected and got true
Row: 208,208
PASS: expected and got true
Row: 207,209
PASS: expected and got true
Row: 206,210
PASS: expected and got true
Row: 215,211
PASS: expected and got true
Row: 214,212
PASS: expected and got true
Row: 213,213