← Back to branch summary

~ubuntu-branches/ubuntu/saucy/drizzle/saucy-proposed

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Clint Byrum
  • Date: 2012-06-19 10:46:49 UTC
  • mfrom: (1.1.6)
  • mto: This revision was merged to the branch mainline in revision 29.
  • Revision ID: package-import@ubuntu.com-20120619104649-e2l0ggd4oz3um0f4
Tags: upstream-7.1.36-stable
Import upstream version 7.1.36-stable

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/transaction_log/tests/r/transaction_log_loaddata.result
1
 
Testing basic LOAD DATA 
2
 
DROP TABLE IF EXISTS t1;
3
 
CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT, b CHAR(50), PRIMARY KEY(a) );
4
 
LOAD DATA INFILE 'DRIZZLETEST_VARDIR/std_data_ln/translogloaddata.dat' into table t1 ;
5
 
Check transaction_log_entries
6
 
SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
7
 
COUNT(*)
8
 
2
9
 
 
10
 
Check transaction_log_transactions
11
 
SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
12
 
COUNT(*)
13
 
2
14
 
Check transaction log contents
15
 
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
16
 
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
17
 
transaction_context {
18
 
  server_id: 1
19
 
  TRANSACTION_ID
20
 
  START_TIMESTAMP
21
 
  END_TIMESTAMP
22
 
}
23
 
statement {
24
 
  type: INSERT
25
 
  START_TIMESTAMP
26
 
  END_TIMESTAMP
27
 
  insert_header {
28
 
    table_metadata {
29
 
      schema_name: "test"
30
 
      table_name: "t1"
31
 
    }
32
 
    field_metadata {
33
 
      type: INTEGER
34
 
      name: "a"
35
 
    }
36
 
    field_metadata {
37
 
      type: VARCHAR
38
 
      name: "b"
39
 
    }
40
 
  }
41
 
  insert_data {
42
 
    segment_id: 1
43
 
    end_segment: true
44
 
    record {
45
 
      insert_value: "1"
46
 
      insert_value: "abbazabba"
47
 
      is_null: false
48
 
      is_null: false
49
 
    }
50
 
    record {
51
 
      insert_value: "2"
52
 
      insert_value: "my_only_friend"
53
 
      is_null: false
54
 
      is_null: false
55
 
    }
56
 
  }
57
 
}
58
 
segment_id: 1
59
 
end_segment: true
60
 
 
61
 
 
62
 
COMMIT;
63
 
 
64
 
DROP TABLE t1;
65
 
SET GLOBAL transaction_log_truncate_debug= true;
66