📄 updatecursor.out
字号:
PASS: expected and got trueRow: 208,458PASS: expected and got trueRow: 207,459PASS: expected and got trueRow: 206,460PASS: expected and got trueRow: 215,461PASS: expected and got trueRow: 214,462PASS: expected and got trueRow: 213,463PASS: expected and got trueRow: 212,464PASS: expected and got trueRow: 211,465PASS: expected and got trueRow: 220,466PASS: expected and got trueRow: 219,467PASS: expected and got trueRow: 218,468PASS: expected and got trueRow: 217,469PASS: expected and got trueRow: 216,470PASS: expected and got trueRow: 225,471PASS: expected and got trueRow: 224,472PASS: expected and got trueRow: 223,473PASS: expected and got trueRow: 222,474PASS: expected and got trueRow: 221,475PASS: expected and got trueRow: 230,476PASS: expected and got trueRow: 229,477PASS: expected and got trueRow: 228,478PASS: expected and got trueRow: 227,479PASS: expected and got trueRow: 226,480PASS: expected and got trueRow: 235,481PASS: expected and got trueRow: 234,482PASS: expected and got trueRow: 233,483PASS: expected and got trueRow: 232,484PASS: expected and got trueRow: 231,485PASS: expected and got trueRow: 240,486PASS: expected and got trueRow: 239,487PASS: expected and got trueRow: 238,488PASS: expected and got trueRow: 237,489PASS: expected and got trueRow: 236,490PASS: expected and got trueRow: 245,491PASS: expected and got trueRow: 244,492PASS: expected and got trueRow: 243,493PASS: expected and got trueRow: 242,494PASS: expected and got trueRow: 241,495PASS: expected and got trueRow: 250,496PASS: expected and got trueRow: 249,497PASS: expected and got trueRow: 248,498PASS: expected and got trueRow: 247,499PASS: expected and got trueRow: 246,500AFTER UPDATE WITH VIRTUAL MEM HEAP: got 250 rows************************************TESTING NONCOVERINGINDEX*********PASS: expected and got trueRow: 126,126 PASS: expected and got trueRow: 127,126 PASS: expected and got trueRow: 128,126 PASS: expected and got trueRow: 129,126 PASS: expected and got trueRow: 130,126 PASS: expected and got trueRow: 131,131 PASS: expected and got trueRow: 132,131 PASS: expected and got trueRow: 133,131 PASS: expected and got trueRow: 134,131 PASS: expected and got trueRow: 135,131 PASS: expected and got trueRow: 136,136 PASS: expected and got trueRow: 137,136 PASS: expected and got trueRow: 138,136 PASS: expected and got trueRow: 139,136 PASS: expected and got trueRow: 140,136 PASS: expected and got trueRow: 141,141 PASS: expected and got trueRow: 142,141 PASS: expected and got trueRow: 143,141 PASS: expected and got trueRow: 144,141 PASS: expected and got trueRow: 145,141 PASS: expected and got trueRow: 146,146 PASS: expected and got trueRow: 147,146 PASS: expected and got trueRow: 148,146 PASS: expected and got trueRow: 149,146 PASS: expected and got trueRow: 150,146 PASS: expected and got trueRow: 151,151 PASS: expected and got trueRow: 152,151 PASS: expected and got trueRow: 153,151 PASS: expected and got trueRow: 154,151 PASS: expected and got trueRow: 155,151 PASS: expected and got trueRow: 156,156 PASS: expected and got trueRow: 157,156 PASS: expected and got trueRow: 158,156 PASS: expected and got trueRow: 159,156 PASS: expected and got trueRow: 160,156 PASS: expected and got trueRow: 161,161 PASS: expected and got trueRow: 162,161 PASS: expected and got trueRow: 163,161 PASS: expected and got trueRow: 164,161 PASS: expected and got trueRow: 165,161 PASS: expected and got trueRow: 166,166 PASS: expected and got trueRow: 167,166 PASS: expected and got trueRow: 168,166 PASS: expected and got trueRow: 169,166 PASS: expected and got trueRow: 170,166 PASS: expected and got trueRow: 171,171 PASS: expected and got trueRow: 172,171 PASS: expected and got trueRow: 173,171 PASS: expected and got trueRow: 174,171 PASS: expected and got trueRow: 175,171 PASS: expected and got trueRow: 176,176 PASS: expected and got trueRow: 177,176 PASS: expected and got trueRow: 178,176 PASS: expected and got trueRow: 179,176 PASS: expected and got trueRow: 180,176 PASS: expected and got trueRow: 181,181 PASS: expected and got trueRow: 182,181 PASS: expected and got trueRow: 183,181 PASS: expected and got trueRow: 184,181 PASS: expected and got trueRow: 185,181 PASS: expected and got trueRow: 186,186 PASS: expected and got trueRow: 187,186 PASS: expected and got trueRow: 188,186 PASS: expected and got trueRow: 189,186 PASS: expected and got trueRow: 190,186 PASS: expected and got trueRow: 191,191 PASS: expected and got trueRow: 192,191 PASS: expected and got trueRow: 193,191 PASS: expected and got trueRow: 194,191 PASS: expected and got trueRow: 195,191 PASS: expected and got trueRow: 196,196 PASS: expected and got trueRow: 197,196 PASS: expected and got trueRow: 198,196 PASS: expected and got trueRow: 199,196 PASS: expected and got trueRow: 200,196 PASS: expected and got trueRow: 201,201 PASS: expected and got trueRow: 202,201 PASS: expected and got trueRow: 203,201 PASS: expected and got trueRow: 204,201 PASS: expected and got trueRow: 205,201 PASS: expected and got trueRow: 206,206 PASS: expected and got trueRow: 207,206 PASS: expected and got trueRow: 208,206 PASS: expected and got trueRow: 209,206 PASS: expected and got trueRow: 210,206 PASS: expected and got trueRow: 211,211 PASS: expected and got trueRow: 212,211 PASS: expected and got trueRow: 213,211 PASS: expected and got trueRow: 214,211 PASS: expected and got trueRow: 215,211 PASS: expected and got trueRow: 216,216 PASS: expected and got trueRow: 217,216 PASS: expected and got trueRow: 218,216 PASS: expected and got trueRow: 219,216 PASS: expected and got trueRow: 220,216 PASS: expected and got trueRow: 221,221 PASS: expected and got trueRow: 222,221 PASS: expected and got trueRow: 223,221 PASS: expected and got trueRow: 224,221 PASS: expected and got trueRow: 225,221 PASS: expected and got trueRow: 226,226 PASS: expected and got trueRow: 227,226 PASS: expected and got trueRow: 228,226 PASS: expected and got trueRow: 229,226 PASS: expected and got trueRow: 230,226 PASS: expected and got trueRow: 231,231 PASS: expected and got trueRow: 232,231 PASS: expected and got trueRow: 233,231 PASS: expected and got trueRow: 234,231 PASS: expected and got trueRow: 235,231 PASS: expected and got trueRow: 236,236 PASS: expected and got trueRow: 237,236 PASS: expected and got trueRow: 238,236 PASS: expected and got trueRow: 239,236 PASS: expected and got trueRow: 240,236 PASS: expected and got trueRow: 241,241 PASS: expected and got trueRow: 242,241 PASS: expected and got trueRow: 243,241 PASS: expected and got trueRow: 244,241 PASS: expected and got trueRow: 245,241 PASS: expected and got trueRow: 246,246 PASS: expected and got trueRow: 247,246 PASS: expected and got trueRow: 248,246 PASS: expected and got trueRow: 249,246 PASS: expected and got trueRow: 250,246 UPDATE USING NONCOVERING INDEX: got 125 rows************ See what we have in table:PASS: expected and got trueRow: 5,1PASS: expected and got trueRow: 4,2PASS: expected and got trueRow: 3,3PASS: expected and got trueRow: 2,4PASS: expected and got trueRow: 1,5PASS: expected and got trueRow: 10,6PASS: expected and got trueRow: 9,7PASS: expected and got trueRow: 8,8PASS: expected and got trueRow: 7,9PASS: expected and got trueRow: 6,10PASS: expected and got trueRow: 15,11PASS: expected and got trueRow: 14,12PASS: expected and got trueRow: 13,13PASS: expected and got trueRow: 12,14PASS: expected and got trueRow: 11,15PASS: expected and got trueRow: 20,16PASS: expected and got trueRow: 19,17PASS: expected and got trueRow: 18,18PASS: expected and got trueRow: 17,19PASS: expected and got trueRow: 16,20PASS: expected and got trueRow: 25,21PASS: expected and got trueRow: 24,22PASS: expected and got trueRow: 23,23PASS: expected and got trueRow: 22,24PASS: expected and got trueRow: 21,25PASS: expected and got trueRow: 30,26PASS: expected and got trueRow: 29,27PASS: expected and got trueRow: 28,28PASS: expected and got trueRow: 27,29PASS: expected and got trueRow: 26,30PASS: expected and got trueRow: 35,31PASS: expected and got trueRow: 34,32PASS: expected and got trueRow: 33,33PASS: expected and got trueRow: 32,34PASS: expected and got trueRow: 31,35PASS: expected and got trueRow: 40,36PASS: expected and got trueRow: 39,37PASS: expected and got trueRow: 38,38PASS: expected and got trueRow: 37,39PASS: expected and got trueRow: 36,40PASS: expected and got trueRow: 45,41PASS: expected and got trueRow: 44,42PASS: expected and got trueRow: 43,43PASS: expected and got trueRow: 42,44PASS: expected and got trueRow: 41,45PASS: expected and got trueRow: 50,46PASS: expected and got trueRow: 49,47PASS: expected and got trueRow: 48,48PASS: expected and got trueRow: 47,49PASS: expected and got trueRow: 46,50PASS: expected and got trueRow: 55,51PASS: expected and got trueRow: 54,52PASS: expected and got trueRow: 53,53PASS: expected and got trueRow: 52,54PASS: expected and got trueRow: 51,55PASS: expected and got trueRow: 60,56PASS: expected and got trueRow: 59,57PASS: expected and got trueRow: 58,58PASS: expected and got trueRow: 57,59PASS: expected and got trueRow: 56,60PASS: expected and got trueRow: 65,61PASS: expected and got trueRow: 64,62PASS: expected and got trueRow: 63,63PASS: expected and got trueRow: 62,64PASS: expected and got trueRow: 61,65PASS: expected and got trueRow: 70,66PASS: expected and got trueRow: 69,67PASS: expected and got trueRow: 68,68PASS: expected and got trueRow: 67,69PASS: expected and got trueRow: 66,70PASS: expected and got trueRow: 75,71PASS: expected and got trueRow: 74,72PASS: expected and got trueRow: 73,73PASS: expected and got trueRow: 72,74PASS: expected and got trueRow: 71,75⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -