← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/transaction_log/tests/r/transaction_log_update.result

  • Committer: Lee Bieber
  • Date: 2010-12-09 19:40:05 UTC
  • mfrom: (1991.1.2 build)
  • Revision ID: kalebral@gmail.com-20101209194005-hpxailmc9afmvelh
Remove disabling of drizzleslap test
Merge Shrews - fix bug 683147: Large row affecting statements failing mid-transaction may not get undone properly by TransactionServices if part of multi-message Transaction

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/transaction_log/tests/r/transaction_log_update.result
1371
1371
 
1372
1372
 
1373
1373
START TRANSACTION;
1374
 
UPDATE t1 SET col0_int = 2000 WHERE id = 1;
1375
 
UPDATE t1 SET col0_int = 200 WHERE id = 2;
1376
 
COMMIT;
1377
 
Check transaction_log_entries
1378
 
SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1379
 
COUNT(*)
1380
 
6
1381
 
 
1382
 
Check transaction_log_transactions
1383
 
SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1384
 
COUNT(*)
1385
 
6
1386
 
Check transaction log contents
1387
 
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1388
 
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1389
 
transaction_context {
1390
 
  server_id: 1
1391
 
  TRANSACTION_ID
1392
 
  START_TIMESTAMP
1393
 
  END_TIMESTAMP
1394
 
}
1395
 
statement {
1396
 
  type: UPDATE
1397
 
  START_TIMESTAMP
1398
 
  END_TIMESTAMP
1399
 
  update_header {
1400
 
    table_metadata {
1401
 
      schema_name: "test"
1402
 
      table_name: "t1"
1403
 
    }
1404
 
    key_field_metadata {
1405
 
      type: INTEGER
1406
 
      name: "id"
1407
 
    }
1408
 
    set_field_metadata {
1409
 
      type: INTEGER
1410
 
      name: "col0_int"
1411
 
    }
1412
 
  }
1413
 
  update_data {
1414
 
    segment_id: 1
1415
 
    end_segment: true
1416
 
    record {
1417
 
      key_value: "1"
1418
 
      after_value: "2000"
1419
 
      is_null: false
1420
 
    }
1421
 
    record {
1422
 
      key_value: "2"
1423
 
      after_value: "200"
1424
 
      is_null: false
1425
 
    }
1426
 
  }
1427
 
}
1428
 
 
1429
 
 
1430
 
 
1431
 
START TRANSACTION;
1432
1374
UPDATE t1 SET col0_int = 20000,  col1_int = 30,  col2_int = 40 where id = 1;
1433
1375
UPDATE t1 SET  col0_int = 2000,  col1_int = 3000  where id = 2;
1434
1376
COMMIT;
1435
1377
Check transaction_log_entries
1436
1378
SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1437
1379
COUNT(*)
1438
 
7
 
1380
6
1439
1381
 
1440
1382
Check transaction_log_transactions
1441
1383
SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1442
1384
COUNT(*)
1443
 
7
 
1385
6
1444
1386
Check transaction log contents
1445
1387
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1446
1388
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1534
1476
Check transaction_log_entries
1535
1477
SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1536
1478
COUNT(*)
1537
 
8
 
1479
7
1538
1480
 
1539
1481
Check transaction_log_transactions
1540
1482
SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1541
1483
COUNT(*)
1542
 
8
 
1484
7
1543
1485
Check transaction log contents
1544
1486
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1545
1487
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))