test/durability/recovery/exp.testMMAP012.ksh

   1 Durablity = TRUE
   2 Server Started
   3 CREATING TABLE
   4 echo CREATE TABLE T1(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10), PRIMARY KEY(f2, f3, f1));
   5 Statement Executed
   6 echo CREATE TABLE T2(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10), PRIMARY KEY(f2, f3, f1));
   7 Statement Executed
   8 echo CREATE TABLE T3(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10), PRIMARY KEY(f2, f3, f1));
   9 Statement Executed
  10 echo CREATE TABLE T4(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10), PRIMARY KEY(f2, f3, f1));
  11 Statement Executed
  12 echo CREATE TABLE T5(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10), PRIMARY KEY(f2, f3, f1));
  13 Statement Executed
  14 echo CREATE TABLE T6(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10), PRIMARY KEY(f2, f3, f1));
  15 Statement Executed
  16 echo CREATE TABLE T7(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10), PRIMARY KEY(f2, f3, f1));
  17 Statement Executed
  18 echo CREATE TABLE T8(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10), PRIMARY KEY(f2, f3, f1));
  19 Statement Executed
  20 echo CREATE TABLE T9(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10), PRIMARY KEY(f2, f3, f1));
  21 Statement Executed
  22 echo CREATE TABLE T10(f1 INT,f2 BIGINT,f3 SMALLINT, f4 FLOAT, f5 CHAR(10), PRIMARY KEY(f2, f3, f1));
  23 Statement Executed
  24 echo show tables;
  25 =============TableNames===================
  26    T1
  27    T2
  28    T3
  29    T4
  30    T5
  31    T6
  32    T7
  33    T8
  34    T9
  35    T10
  36 ==========================================
  37 Server Killed
  38 Durablity = TRUE
  39 Checking Durability
  40 Server Started
  41 INSERTING INTO TABLE
  42 echo INSERT INTO T1 VALUES(1, 10, 101, 101.101, 'Lakshya');
  43 Statement Executed: Rows Affected = 1
  44 echo INSERT INTO T1 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
  45 Statement Executed: Rows Affected = 1
  46 echo INSERT INTO T1 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
  47 Statement Executed: Rows Affected = 1
  48 echo INSERT INTO T1 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
  49 Statement execute failed with error -21
  50 echo INSERT INTO T1 VALUES(2, 20, 201, 101.101, 'Lakshya');
  51 Statement Executed: Rows Affected = 1
  52 echo INSERT INTO T1 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
  53 Statement Executed: Rows Affected = 1
  54 echo INSERT INTO T1 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
  55 Statement Executed: Rows Affected = 1
  56 echo INSERT INTO T1 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
  57 Statement execute failed with error -21
  58 echo INSERT INTO T2 VALUES(1, 10, 101, 101.101, 'Lakshya');
  59 Statement Executed: Rows Affected = 1
  60 echo INSERT INTO T2 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
  61 Statement Executed: Rows Affected = 1
  62 echo INSERT INTO T2 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
  63 Statement Executed: Rows Affected = 1
  64 echo INSERT INTO T2 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
  65 Statement execute failed with error -21
  66 echo INSERT INTO T2 VALUES(2, 20, 201, 101.101, 'Lakshya');
  67 Statement Executed: Rows Affected = 1
  68 echo INSERT INTO T2 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
  69 Statement Executed: Rows Affected = 1
  70 echo INSERT INTO T2 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
  71 Statement Executed: Rows Affected = 1
  72 echo INSERT INTO T2 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
  73 Statement execute failed with error -21
  74 echo INSERT INTO T3 VALUES(1, 10, 101, 101.101, 'Lakshya');
  75 Statement Executed: Rows Affected = 1
  76 echo INSERT INTO T3 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
  77 Statement Executed: Rows Affected = 1
  78 echo INSERT INTO T3 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
  79 Statement Executed: Rows Affected = 1
  80 echo INSERT INTO T3 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
  81 Statement execute failed with error -21
  82 echo INSERT INTO T3 VALUES(2, 20, 201, 101.101, 'Lakshya');
  83 Statement Executed: Rows Affected = 1
  84 echo INSERT INTO T3 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
  85 Statement Executed: Rows Affected = 1
  86 echo INSERT INTO T3 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
  87 Statement Executed: Rows Affected = 1
  88 echo INSERT INTO T3 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
  89 Statement execute failed with error -21
  90 echo INSERT INTO T4 VALUES(1, 10, 101, 101.101, 'Lakshya');
  91 Statement Executed: Rows Affected = 1
  92 echo INSERT INTO T4 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
  93 Statement Executed: Rows Affected = 1
  94 echo INSERT INTO T4 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
  95 Statement Executed: Rows Affected = 1
  96 echo INSERT INTO T4 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
  97 Statement execute failed with error -21
  98 echo INSERT INTO T4 VALUES(2, 20, 201, 101.101, 'Lakshya');
  99 Statement Executed: Rows Affected = 1
 100 echo INSERT INTO T4 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 101 Statement Executed: Rows Affected = 1
 102 echo INSERT INTO T4 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
 103 Statement Executed: Rows Affected = 1
 104 echo INSERT INTO T4 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 105 Statement execute failed with error -21
 106 echo INSERT INTO T5 VALUES(1, 10, 101, 101.101, 'Lakshya');
 107 Statement Executed: Rows Affected = 1
 108 echo INSERT INTO T5 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 109 Statement Executed: Rows Affected = 1
 110 echo INSERT INTO T5 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
 111 Statement Executed: Rows Affected = 1
 112 echo INSERT INTO T5 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 113 Statement execute failed with error -21
 114 echo INSERT INTO T5 VALUES(2, 20, 201, 101.101, 'Lakshya');
 115 Statement Executed: Rows Affected = 1
 116 echo INSERT INTO T5 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 117 Statement Executed: Rows Affected = 1
 118 echo INSERT INTO T5 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
 119 Statement Executed: Rows Affected = 1
 120 echo INSERT INTO T5 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 121 Statement execute failed with error -21
 122 echo INSERT INTO T6 VALUES(1, 10, 101, 101.101, 'Lakshya');
 123 Statement Executed: Rows Affected = 1
 124 echo INSERT INTO T6 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 125 Statement Executed: Rows Affected = 1
 126 echo INSERT INTO T6 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
 127 Statement Executed: Rows Affected = 1
 128 echo INSERT INTO T6 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 129 Statement execute failed with error -21
 130 echo INSERT INTO T6 VALUES(2, 20, 201, 101.101, 'Lakshya');
 131 Statement Executed: Rows Affected = 1
 132 echo INSERT INTO T6 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 133 Statement Executed: Rows Affected = 1
 134 echo INSERT INTO T6 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
 135 Statement Executed: Rows Affected = 1
 136 echo INSERT INTO T6 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 137 Statement execute failed with error -21
 138 echo INSERT INTO T7 VALUES(1, 10, 101, 101.101, 'Lakshya');
 139 Statement Executed: Rows Affected = 1
 140 echo INSERT INTO T7 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 141 Statement Executed: Rows Affected = 1
 142 echo INSERT INTO T7 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
 143 Statement Executed: Rows Affected = 1
 144 echo INSERT INTO T7 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 145 Statement execute failed with error -21
 146 echo INSERT INTO T7 VALUES(2, 20, 201, 101.101, 'Lakshya');
 147 Statement Executed: Rows Affected = 1
 148 echo INSERT INTO T7 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 149 Statement Executed: Rows Affected = 1
 150 echo INSERT INTO T7 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
 151 Statement Executed: Rows Affected = 1
 152 echo INSERT INTO T7 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 153 Statement execute failed with error -21
 154 echo INSERT INTO T8 VALUES(1, 10, 101, 101.101, 'Lakshya');
 155 Statement Executed: Rows Affected = 1
 156 echo INSERT INTO T8 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 157 Statement Executed: Rows Affected = 1
 158 echo INSERT INTO T8 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
 159 Statement Executed: Rows Affected = 1
 160 echo INSERT INTO T8 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 161 Statement execute failed with error -21
 162 echo INSERT INTO T8 VALUES(2, 20, 201, 101.101, 'Lakshya');
 163 Statement Executed: Rows Affected = 1
 164 echo INSERT INTO T8 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 165 Statement Executed: Rows Affected = 1
 166 echo INSERT INTO T8 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
 167 Statement Executed: Rows Affected = 1
 168 echo INSERT INTO T8 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 169 Statement execute failed with error -21
 170 echo INSERT INTO T9 VALUES(1, 10, 101, 101.101, 'Lakshya');
 171 Statement Executed: Rows Affected = 1
 172 echo INSERT INTO T9 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 173 Statement Executed: Rows Affected = 1
 174 echo INSERT INTO T9 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
 175 Statement Executed: Rows Affected = 1
 176 echo INSERT INTO T9 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 177 Statement execute failed with error -21
 178 echo INSERT INTO T9 VALUES(2, 20, 201, 101.101, 'Lakshya');
 179 Statement Executed: Rows Affected = 1
 180 echo INSERT INTO T9 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 181 Statement Executed: Rows Affected = 1
 182 echo INSERT INTO T9 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
 183 Statement Executed: Rows Affected = 1
 184 echo INSERT INTO T9 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 185 Statement execute failed with error -21
 186 echo INSERT INTO T10 VALUES(1, 10, 101, 101.101, 'Lakshya');
 187 Statement Executed: Rows Affected = 1
 188 echo INSERT INTO T10 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 189 Statement Executed: Rows Affected = 1
 190 echo INSERT INTO T10 VALUES(1, 11, 111, 101.101, 'LAKSHYA');
 191 Statement Executed: Rows Affected = 1
 192 echo INSERT INTO T10 VALUES(1, 11, 101, 101.101, 'LAKSHYA');
 193 Statement execute failed with error -21
 194 echo INSERT INTO T10 VALUES(2, 20, 201, 101.101, 'Lakshya');
 195 Statement Executed: Rows Affected = 1
 196 echo INSERT INTO T10 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 197 Statement Executed: Rows Affected = 1
 198 echo INSERT INTO T10 VALUES(2, 21, 211, 101.101, 'LAKSHYA');
 199 Statement Executed: Rows Affected = 1
 200 echo INSERT INTO T10 VALUES(2, 21, 201, 101.101, 'LAKSHYA');
 201 Statement execute failed with error -21
 202 echo SELECT * FROM T1;
 203 ---------------------------------------------------------
 204         T1.f1   T1.f2   T1.f3   T1.f4   T1.f5
 205 ---------------------------------------------------------
 206         1       10      101     101.100998      Lakshya
 207         1       11      101     101.100998      LAKSHYA
 208         1       11      111     101.100998      LAKSHYA
 209         2       20      201     101.100998      Lakshya
 210         2       21      201     101.100998      LAKSHYA
 211         2       21      211     101.100998      LAKSHYA
 212
 213 echo SELECT * FROM T2;
 214 ---------------------------------------------------------
 215         T2.f1   T2.f2   T2.f3   T2.f4   T2.f5
 216 ---------------------------------------------------------
 217         1       10      101     101.100998      Lakshya
 218         1       11      101     101.100998      LAKSHYA
 219         1       11      111     101.100998      LAKSHYA
 220         2       20      201     101.100998      Lakshya
 221         2       21      201     101.100998      LAKSHYA
 222         2       21      211     101.100998      LAKSHYA
 223
 224 echo SELECT * FROM T3;
 225 ---------------------------------------------------------
 226         T3.f1   T3.f2   T3.f3   T3.f4   T3.f5
 227 ---------------------------------------------------------
 228         1       10      101     101.100998      Lakshya
 229         1       11      101     101.100998      LAKSHYA
 230         1       11      111     101.100998      LAKSHYA
 231         2       20      201     101.100998      Lakshya
 232         2       21      201     101.100998      LAKSHYA
 233         2       21      211     101.100998      LAKSHYA
 234
 235 echo SELECT * FROM T4;
 236 ---------------------------------------------------------
 237         T4.f1   T4.f2   T4.f3   T4.f4   T4.f5
 238 ---------------------------------------------------------
 239         1       10      101     101.100998      Lakshya
 240         1       11      101     101.100998      LAKSHYA
 241         1       11      111     101.100998      LAKSHYA
 242         2       20      201     101.100998      Lakshya
 243         2       21      201     101.100998      LAKSHYA
 244         2       21      211     101.100998      LAKSHYA
 245
 246 echo SELECT * FROM T5;
 247 ---------------------------------------------------------
 248         T5.f1   T5.f2   T5.f3   T5.f4   T5.f5
 249 ---------------------------------------------------------
 250         1       10      101     101.100998      Lakshya
 251         1       11      101     101.100998      LAKSHYA
 252         1       11      111     101.100998      LAKSHYA
 253         2       20      201     101.100998      Lakshya
 254         2       21      201     101.100998      LAKSHYA
 255         2       21      211     101.100998      LAKSHYA
 256
 257 echo SELECT * FROM T6;
 258 ---------------------------------------------------------
 259         T6.f1   T6.f2   T6.f3   T6.f4   T6.f5
 260 ---------------------------------------------------------
 261         1       10      101     101.100998      Lakshya
 262         1       11      101     101.100998      LAKSHYA
 263         1       11      111     101.100998      LAKSHYA
 264         2       20      201     101.100998      Lakshya
 265         2       21      201     101.100998      LAKSHYA
 266         2       21      211     101.100998      LAKSHYA
 267
 268 echo SELECT * FROM T7;
 269 ---------------------------------------------------------
 270         T7.f1   T7.f2   T7.f3   T7.f4   T7.f5
 271 ---------------------------------------------------------
 272         1       10      101     101.100998      Lakshya
 273         1       11      101     101.100998      LAKSHYA
 274         1       11      111     101.100998      LAKSHYA
 275         2       20      201     101.100998      Lakshya
 276         2       21      201     101.100998      LAKSHYA
 277         2       21      211     101.100998      LAKSHYA
 278
 279 echo SELECT * FROM T8;
 280 ---------------------------------------------------------
 281         T8.f1   T8.f2   T8.f3   T8.f4   T8.f5
 282 ---------------------------------------------------------
 283         1       10      101     101.100998      Lakshya
 284         1       11      101     101.100998      LAKSHYA
 285         1       11      111     101.100998      LAKSHYA
 286         2       20      201     101.100998      Lakshya
 287         2       21      201     101.100998      LAKSHYA
 288         2       21      211     101.100998      LAKSHYA
 289
 290 echo SELECT * FROM T9;
 291 ---------------------------------------------------------
 292         T9.f1   T9.f2   T9.f3   T9.f4   T9.f5
 293 ---------------------------------------------------------
 294         1       10      101     101.100998      Lakshya
 295         1       11      101     101.100998      LAKSHYA
 296         1       11      111     101.100998      LAKSHYA
 297         2       20      201     101.100998      Lakshya
 298         2       21      201     101.100998      LAKSHYA
 299         2       21      211     101.100998      LAKSHYA
 300
 301 echo SELECT * FROM T10;
 302 ---------------------------------------------------------
 303         T10.f1  T10.f2  T10.f3  T10.f4  T10.f5
 304 ---------------------------------------------------------
 305         1       10      101     101.100998      Lakshya
 306         1       11      101     101.100998      LAKSHYA
 307         1       11      111     101.100998      LAKSHYA
 308         2       20      201     101.100998      Lakshya
 309         2       21      201     101.100998      LAKSHYA
 310         2       21      211     101.100998      LAKSHYA
 311
 312 Server Killed
 313 Durablity = TRUE
 314 Checking Durability
 315 Server Started
 316 UPDATING RECORDS IN TABLE
 317 echo UPDATE T1 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 318 Statement Executed: Rows Affected = 3
 319 echo UPDATE T1 SET f1=3 WHERE f1=2;
 320 Statement prepare failed with error -21
 321 echo UPDATE T2 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 322 Statement Executed: Rows Affected = 3
 323 echo UPDATE T2 SET f1=3 WHERE f1=2;
 324 Statement prepare failed with error -21
 325 echo UPDATE T3 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 326 Statement Executed: Rows Affected = 3
 327 echo UPDATE T3 SET f1=3 WHERE f1=2;
 328 Statement prepare failed with error -21
 329 echo UPDATE T4 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 330 Statement Executed: Rows Affected = 3
 331 echo UPDATE T4 SET f1=3 WHERE f1=2;
 332 Statement prepare failed with error -21
 333 echo UPDATE T5 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 334 Statement Executed: Rows Affected = 3
 335 echo UPDATE T5 SET f1=3 WHERE f1=2;
 336 Statement prepare failed with error -21
 337 echo UPDATE T6 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 338 Statement Executed: Rows Affected = 3
 339 echo UPDATE T6 SET f1=3 WHERE f1=2;
 340 Statement prepare failed with error -21
 341 echo UPDATE T7 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 342 Statement Executed: Rows Affected = 3
 343 echo UPDATE T7 SET f1=3 WHERE f1=2;
 344 Statement prepare failed with error -21
 345 echo UPDATE T8 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 346 Statement Executed: Rows Affected = 3
 347 echo UPDATE T8 SET f1=3 WHERE f1=2;
 348 Statement prepare failed with error -21
 349 echo UPDATE T9 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 350 Statement Executed: Rows Affected = 3
 351 echo UPDATE T9 SET f1=3 WHERE f1=2;
 352 Statement prepare failed with error -21
 353 echo UPDATE T10 SET f4 = 20.02,f5 = 'Jagannath' WHERE f1=2;
 354 Statement Executed: Rows Affected = 3
 355 echo UPDATE T10 SET f1=3 WHERE f1=2;
 356 Statement prepare failed with error -21
 357 echo SELECT * FROM T1;
 358 ---------------------------------------------------------
 359         T1.f1   T1.f2   T1.f3   T1.f4   T1.f5
 360 ---------------------------------------------------------
 361         1       10      101     101.100998      Lakshya
 362         1       11      101     101.100998      LAKSHYA
 363         1       11      111     101.100998      LAKSHYA
 364         2       20      201     20.020000       Jagannath
 365         2       21      201     20.020000       Jagannath
 366         2       21      211     20.020000       Jagannath
 367
 368 echo SELECT * FROM T2;
 369 ---------------------------------------------------------
 370         T2.f1   T2.f2   T2.f3   T2.f4   T2.f5
 371 ---------------------------------------------------------
 372         1       10      101     101.100998      Lakshya
 373         1       11      101     101.100998      LAKSHYA
 374         1       11      111     101.100998      LAKSHYA
 375         2       20      201     20.020000       Jagannath
 376         2       21      201     20.020000       Jagannath
 377         2       21      211     20.020000       Jagannath
 378
 379 echo SELECT * FROM T3;
 380 ---------------------------------------------------------
 381         T3.f1   T3.f2   T3.f3   T3.f4   T3.f5
 382 ---------------------------------------------------------
 383         1       10      101     101.100998      Lakshya
 384         1       11      101     101.100998      LAKSHYA
 385         1       11      111     101.100998      LAKSHYA
 386         2       20      201     20.020000       Jagannath
 387         2       21      201     20.020000       Jagannath
 388         2       21      211     20.020000       Jagannath
 389
 390 echo SELECT * FROM T4;
 391 ---------------------------------------------------------
 392         T4.f1   T4.f2   T4.f3   T4.f4   T4.f5
 393 ---------------------------------------------------------
 394         1       10      101     101.100998      Lakshya
 395         1       11      101     101.100998      LAKSHYA
 396         1       11      111     101.100998      LAKSHYA
 397         2       20      201     20.020000       Jagannath
 398         2       21      201     20.020000       Jagannath
 399         2       21      211     20.020000       Jagannath
 400
 401 echo SELECT * FROM T5;
 402 ---------------------------------------------------------
 403         T5.f1   T5.f2   T5.f3   T5.f4   T5.f5
 404 ---------------------------------------------------------
 405         1       10      101     101.100998      Lakshya
 406         1       11      101     101.100998      LAKSHYA
 407         1       11      111     101.100998      LAKSHYA
 408         2       20      201     20.020000       Jagannath
 409         2       21      201     20.020000       Jagannath
 410         2       21      211     20.020000       Jagannath
 411
 412 echo SELECT * FROM T6;
 413 ---------------------------------------------------------
 414         T6.f1   T6.f2   T6.f3   T6.f4   T6.f5
 415 ---------------------------------------------------------
 416         1       10      101     101.100998      Lakshya
 417         1       11      101     101.100998      LAKSHYA
 418         1       11      111     101.100998      LAKSHYA
 419         2       20      201     20.020000       Jagannath
 420         2       21      201     20.020000       Jagannath
 421         2       21      211     20.020000       Jagannath
 422
 423 echo SELECT * FROM T7;
 424 ---------------------------------------------------------
 425         T7.f1   T7.f2   T7.f3   T7.f4   T7.f5
 426 ---------------------------------------------------------
 427         1       10      101     101.100998      Lakshya
 428         1       11      101     101.100998      LAKSHYA
 429         1       11      111     101.100998      LAKSHYA
 430         2       20      201     20.020000       Jagannath
 431         2       21      201     20.020000       Jagannath
 432         2       21      211     20.020000       Jagannath
 433
 434 echo SELECT * FROM T8;
 435 ---------------------------------------------------------
 436         T8.f1   T8.f2   T8.f3   T8.f4   T8.f5
 437 ---------------------------------------------------------
 438         1       10      101     101.100998      Lakshya
 439         1       11      101     101.100998      LAKSHYA
 440         1       11      111     101.100998      LAKSHYA
 441         2       20      201     20.020000       Jagannath
 442         2       21      201     20.020000       Jagannath
 443         2       21      211     20.020000       Jagannath
 444
 445 echo SELECT * FROM T9;
 446 ---------------------------------------------------------
 447         T9.f1   T9.f2   T9.f3   T9.f4   T9.f5
 448 ---------------------------------------------------------
 449         1       10      101     101.100998      Lakshya
 450         1       11      101     101.100998      LAKSHYA
 451         1       11      111     101.100998      LAKSHYA
 452         2       20      201     20.020000       Jagannath
 453         2       21      201     20.020000       Jagannath
 454         2       21      211     20.020000       Jagannath
 455
 456 echo SELECT * FROM T10;
 457 ---------------------------------------------------------
 458         T10.f1  T10.f2  T10.f3  T10.f4  T10.f5
 459 ---------------------------------------------------------
 460         1       10      101     101.100998      Lakshya
 461         1       11      101     101.100998      LAKSHYA
 462         1       11      111     101.100998      LAKSHYA
 463         2       20      201     20.020000       Jagannath
 464         2       21      201     20.020000       Jagannath
 465         2       21      211     20.020000       Jagannath
 466
 467 Server Killed
 468 Durablity = TRUE
 469 Checking Durability
 470 Server Started
 471 DELETING RECORDS FROM TABLE
 472 echo DELETE FROM T1 WHERE f1 = 1;
 473 Statement Executed: Rows Affected = 3
 474 echo DELETE FROM T2 WHERE f1 = 1;
 475 Statement Executed: Rows Affected = 3
 476 echo DELETE FROM T3 WHERE f1 = 1;
 477 Statement Executed: Rows Affected = 3
 478 echo DELETE FROM T4 WHERE f1 = 1;
 479 Statement Executed: Rows Affected = 3
 480 echo DELETE FROM T5 WHERE f1 = 1;
 481 Statement Executed: Rows Affected = 3
 482 echo DELETE FROM T6 WHERE f1 = 1;
 483 Statement Executed: Rows Affected = 3
 484 echo DELETE FROM T7 WHERE f1 = 1;
 485 Statement Executed: Rows Affected = 3
 486 echo DELETE FROM T8 WHERE f1 = 1;
 487 Statement Executed: Rows Affected = 3
 488 echo DELETE FROM T9 WHERE f1 = 1;
 489 Statement Executed: Rows Affected = 3
 490 echo DELETE FROM T10 WHERE f1 = 1;
 491 Statement Executed: Rows Affected = 3
 492 echo SELECT * FROM T1;
 493 ---------------------------------------------------------
 494         T1.f1   T1.f2   T1.f3   T1.f4   T1.f5
 495 ---------------------------------------------------------
 496         2       20      201     20.020000       Jagannath
 497         2       21      201     20.020000       Jagannath
 498         2       21      211     20.020000       Jagannath
 499
 500 echo SELECT * FROM T2;
 501 ---------------------------------------------------------
 502         T2.f1   T2.f2   T2.f3   T2.f4   T2.f5
 503 ---------------------------------------------------------
 504         2       20      201     20.020000       Jagannath
 505         2       21      201     20.020000       Jagannath
 506         2       21      211     20.020000       Jagannath
 507
 508 echo SELECT * FROM T3;
 509 ---------------------------------------------------------
 510         T3.f1   T3.f2   T3.f3   T3.f4   T3.f5
 511 ---------------------------------------------------------
 512         2       20      201     20.020000       Jagannath
 513         2       21      201     20.020000       Jagannath
 514         2       21      211     20.020000       Jagannath
 515
 516 echo SELECT * FROM T4;
 517 ---------------------------------------------------------
 518         T4.f1   T4.f2   T4.f3   T4.f4   T4.f5
 519 ---------------------------------------------------------
 520         2       20      201     20.020000       Jagannath
 521         2       21      201     20.020000       Jagannath
 522         2       21      211     20.020000       Jagannath
 523
 524 echo SELECT * FROM T5;
 525 ---------------------------------------------------------
 526         T5.f1   T5.f2   T5.f3   T5.f4   T5.f5
 527 ---------------------------------------------------------
 528         2       20      201     20.020000       Jagannath
 529         2       21      201     20.020000       Jagannath
 530         2       21      211     20.020000       Jagannath
 531
 532 echo SELECT * FROM T6;
 533 ---------------------------------------------------------
 534         T6.f1   T6.f2   T6.f3   T6.f4   T6.f5
 535 ---------------------------------------------------------
 536         2       20      201     20.020000       Jagannath
 537         2       21      201     20.020000       Jagannath
 538         2       21      211     20.020000       Jagannath
 539
 540 echo SELECT * FROM T7;
 541 ---------------------------------------------------------
 542         T7.f1   T7.f2   T7.f3   T7.f4   T7.f5
 543 ---------------------------------------------------------
 544         2       20      201     20.020000       Jagannath
 545         2       21      201     20.020000       Jagannath
 546         2       21      211     20.020000       Jagannath
 547
 548 echo SELECT * FROM T8;
 549 ---------------------------------------------------------
 550         T8.f1   T8.f2   T8.f3   T8.f4   T8.f5
 551 ---------------------------------------------------------
 552         2       20      201     20.020000       Jagannath
 553         2       21      201     20.020000       Jagannath
 554         2       21      211     20.020000       Jagannath
 555
 556 echo SELECT * FROM T9;
 557 ---------------------------------------------------------
 558         T9.f1   T9.f2   T9.f3   T9.f4   T9.f5
 559 ---------------------------------------------------------
 560         2       20      201     20.020000       Jagannath
 561         2       21      201     20.020000       Jagannath
 562         2       21      211     20.020000       Jagannath
 563
 564 echo SELECT * FROM T10;
 565 ---------------------------------------------------------
 566         T10.f1  T10.f2  T10.f3  T10.f4  T10.f5
 567 ---------------------------------------------------------
 568         2       20      201     20.020000       Jagannath
 569         2       21      201     20.020000       Jagannath
 570         2       21      211     20.020000       Jagannath
 571
 572 Server Killed
 573 Durablity = TRUE
 574 Checking Durability
 575 Server Started
 576 DROPPING TABLE
 577 echo DROP TABLE T1;
 578 Statement Executed
 579 echo DROP TABLE T2;
 580 Statement Executed
 581 echo DROP TABLE T3;
 582 Statement Executed
 583 echo DROP TABLE T4;
 584 Statement Executed
 585 echo DROP TABLE T5;
 586 Statement Executed
 587 echo DROP TABLE T6;
 588 Statement Executed
 589 echo DROP TABLE T7;
 590 Statement Executed
 591 echo DROP TABLE T8;
 592 Statement Executed
 593 echo DROP TABLE T9;
 594 Statement Executed
 595 echo DROP TABLE T10;
 596 Statement Executed