← Back to branch summary

~xnox/ubuntu/saucy/drizzle/merge

« back to all changes in this revision

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

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2011-01-01 13:55:03 UTC
  • Revision ID: james.westby@ubuntu.com-20110101135503-x2ub1akxoisgwi6z
Tags: 2010.12.06-0ubuntu4
* Fixed missing build depends.
* Added Lee to uploaders.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/transaction_log/tests/r/transaction_log_drop.result
5
5
Check transaction_log_entries
6
6
SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
7
7
COUNT(*)
8
 
3
 
8
2
9
9
 
10
10
Check transaction_log_transactions
11
11
SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
12
12
COUNT(*)
13
 
3
 
13
2
14
14
Check transaction log contents
15
15
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
16
16
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
29
29
      schema_name: "test"
30
30
      table_name: "t1"
31
31
    }
32
 
    if_exists_clause: false
33
32
  }
34
33
}
35
34
 
60
59
      schema_name: "test"
61
60
      table_name: "t3"
62
61
    }
63
 
    if_exists_clause: false
64
62
  }
65
63
}
66
64
 
79
77
      schema_name: "test"
80
78
      table_name: "t2"
81
79
    }
82
 
    if_exists_clause: false
83
80
  }
84
81
}
85
82
 
98
95
      schema_name: "test"
99
96
      table_name: "t1"
100
97
    }
101
 
    if_exists_clause: false
102
98
  }
103
99
}
104
100
 
111
107
Check transaction_log_entries
112
108
SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
113
109
COUNT(*)
114
 
3
 
110
2
115
111
 
116
112
Check transaction_log_transactions
117
113
SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
118
114
COUNT(*)
119
 
3
 
115
2
120
116
Check transaction log contents
121
117
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
122
118
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
135
131
      schema_name: "test"
136
132
      table_name: "t1"
137
133
    }
138
 
    if_exists_clause: true
139
134
  }
140
135
}
141
136
 
143
138
 
144
139
SET GLOBAL transaction_log_truncate_debug= true;
145
140
 
146
 
Testing DROP IF EXISTS negative
 
141
Bug#674471
 
142
DROP SCHEMA/TABLE IF EXISTS being logged even if the object didn't exist  
147
143
DROP TABLE IF EXISTS t1;
148
144
Warnings:
149
145
Note    1051    Unknown table 't1'
150
 
Check transaction_log_entries
151
 
SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
152
 
COUNT(*)
153
 
1
154
 
 
155
 
Check transaction_log_transactions
156
 
SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
157
 
COUNT(*)
158
 
1
159
 
Check transaction log contents
160
 
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
161
 
PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
162
 
transaction_context {
163
 
  server_id: 1
164
 
  TRANSACTION_ID
165
 
  START_TIMESTAMP
166
 
  END_TIMESTAMP
167
 
}
168
 
statement {
169
 
  type: DROP_TABLE
170
 
  START_TIMESTAMP
171
 
  END_TIMESTAMP
172
 
  drop_table_statement {
173
 
    table_metadata {
174
 
      schema_name: "test"
175
 
      table_name: "t1"
176
 
    }
177
 
    if_exists_clause: true
178
 
  }
179
 
}
180
 
 
181
 
 
 
146
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log', entry_offset) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
 
147
PRINT_TRANSACTION_MESSAGE('transaction.log', entry_offset)
 
148
 
 
149
DROP SCHEMA IF EXISTS t1;
 
150
Warnings:
 
151
Note    1008    Can't drop schema 't1'; schema doesn't exist
 
152
SELECT PRINT_TRANSACTION_MESSAGE('transaction.log', entry_offset) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
 
153
PRINT_TRANSACTION_MESSAGE('transaction.log', entry_offset)
182
154
 
183
155
SET GLOBAL transaction_log_truncate_debug= true;
184
156