Drizzle

Merge lp:~skinny.moey/drizzle/transaction_id_innodb into lp:drizzle/7.0

  1. transaction_id_innodb
  2. Merge into 7.0
Proposed by Joe Daly
Status: Merged
Approved by: Joe Daly
Approved revision: 1877
Merged at revision: 1900
Proposed branch: lp:~skinny.moey/drizzle/transaction_id_innodb
Merge into: lp:drizzle/7.0
Diff against target: 9648 lines (+2104/-3825)
58 files modified
drizzled/main.cc (+4/-0)
drizzled/plugin/xa_resource_manager.h (+14/-0)
drizzled/session.cc (+1/-0)
drizzled/session.h (+13/-0)
drizzled/transaction_services.cc (+45/-2)
drizzled/transaction_services.h (+11/-29)
plugin/innobase/handler/ha_innodb.cc (+31/-0)
plugin/schema_engine/schema.cc (+10/-0)
plugin/transaction_log/tests/r/bug660779.result (+3/-3)
plugin/transaction_log/tests/r/bulk_commit.result (+3/-9)
plugin/transaction_log/tests/r/bulk_rollback.result (+3/-9)
plugin/transaction_log/tests/r/ddl_transaction_id.result (+220/-19)
plugin/transaction_log/tests/r/information_schema.result (+208/-17)
plugin/transaction_log/tests/r/transaction_log_alter.result (+203/-484)
plugin/transaction_log/tests/r/transaction_log_create.result (+126/-270)
plugin/transaction_log/tests/r/transaction_log_data_type.result (+602/-1694)
plugin/transaction_log/tests/r/transaction_log_delete.result (+77/-236)
plugin/transaction_log/tests/r/transaction_log_drop.result (+28/-99)
plugin/transaction_log/tests/r/transaction_log_large_blob.result (+7/-16)
plugin/transaction_log/tests/r/transaction_log_loaddata.result (+7/-16)
plugin/transaction_log/tests/r/transaction_log_replace.result (+28/-82)
plugin/transaction_log/tests/r/transaction_log_rollback.result (+7/-16)
plugin/transaction_log/tests/r/transaction_log_schema.result (+36/-79)
plugin/transaction_log/tests/r/transaction_log_transaction.result (+98/-284)
plugin/transaction_log/tests/r/transaction_log_update.result (+140/-416)
plugin/transaction_log/tests/t/bug660779.test (+3/-3)
plugin/transaction_log/tests/t/bulk_check.inc (+1/-4)
plugin/transaction_log/tests/t/bulk_commit.test (+5/-0)
plugin/transaction_log/tests/t/check_transaction_log.inc (+7/-7)
plugin/transaction_log/tests/t/ddl_transaction_id.test (+5/-6)
plugin/transaction_log/tests/t/information_schema.test (+4/-6)
plugin/transaction_log/tests/t/insert.test (+6/-0)
plugin/transaction_log/tests/t/insert_multi.test (+6/-0)
plugin/transaction_log/tests/t/insert_on_duplicate_update.test (+5/-0)
plugin/transaction_log/tests/t/insert_select.test (+6/-0)
plugin/transaction_log/tests/t/multi_column_primary_key.test (+5/-0)
plugin/transaction_log/tests/t/multi_table.test (+6/-0)
plugin/transaction_log/tests/t/no_modification.test (+6/-0)
plugin/transaction_log/tests/t/no_primary_key.test (+5/-0)
plugin/transaction_log/tests/t/null_values.test (+6/-0)
plugin/transaction_log/tests/t/rand.test (+7/-0)
plugin/transaction_log/tests/t/rename.test (+5/-0)
plugin/transaction_log/tests/t/replace.test (+6/-0)
plugin/transaction_log/tests/t/rollback.test (+5/-0)
plugin/transaction_log/tests/t/schema.test (+5/-0)
plugin/transaction_log/tests/t/select_for_update.test (+6/-0)
plugin/transaction_log/tests/t/transaction_log_create.test (+5/-0)
plugin/transaction_log/tests/t/transaction_log_data_type.test (+6/-0)
plugin/transaction_log/tests/t/transaction_log_delete.test (+6/-0)
plugin/transaction_log/tests/t/transaction_log_drop.test (+10/-17)
plugin/transaction_log/tests/t/transaction_log_large_blob.test (+5/-0)
plugin/transaction_log/tests/t/transaction_log_loaddata.test (+6/-0)
plugin/transaction_log/tests/t/transaction_log_replace.test (+6/-0)
plugin/transaction_log/tests/t/transaction_log_rollback.test (+6/-0)
plugin/transaction_log/tests/t/transaction_log_schema.test (+7/-1)
plugin/transaction_log/tests/t/transaction_log_transaction.test (+6/-0)
plugin/transaction_log/tests/t/transaction_log_update.test (+6/-0)
plugin/transaction_log/transaction_log.cc (+0/-1)
To merge this branch: bzr merge lp:~skinny.moey/drizzle/transaction_id_innodb
Reviewer Review Type Date Requested Status
Drizzle Developers Pending
Review via email: mp+39722@code.launchpad.net

This proposal supersedes a proposal from 2010-10-26.

Description of the change

This is to solicit general feedback. This should be moved to work in progress after some folks take a look or when someone gets annoyed that its in the queue. At a minimum it is missing tests, and there needs to be a check if innodb is not loaded.

This change uses the innodb transaction id, for the transaction id in the transaction log. For cases where a transction id is not generated, schema changes, and other storage engines, a new innodb transaction id is generated.

To post a comment you must log in.
Revision history for this message
Joe Daly (skinny.moey) wrote : Posted in a previous version of this proposal

moved to work in progress, this was meant to get some general feedback there needs to still be a couple tests added

Revision history for this message
Joe Daly (skinny.moey) wrote :

I ran performance tests on this and the performance was the same as what is in trunk currently for the transaction log.

Revision history for this message
Brian Aker (brianaker) wrote :

I am fine with this, want to have it merged? (is so mark it approved).

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'drizzled/main.cc'
2--- drizzled/main.cc 2010-10-22 07:38:49 +0000
3+++ drizzled/main.cc 2010-10-31 22:34:08 +0000
4@@ -335,6 +335,8 @@
5 /* Send server startup event */
6 if ((session= new Session(plugin::Listen::getNullClient())))
7 {
8+ currentSession().release();
9+ currentSession().reset(session);
10 transaction_services.sendStartupEvent(session);
11 session->lockForDelete();
12 delete session;
13@@ -360,6 +362,8 @@
14 /* Send server shutdown event */
15 if ((session= new Session(plugin::Listen::getNullClient())))
16 {
17+ currentSession().release();
18+ currentSession().reset(session);
19 transaction_services.sendShutdownEvent(session);
20 session->lockForDelete();
21 delete session;
22
23=== modified file 'drizzled/plugin/xa_resource_manager.h'
24--- drizzled/plugin/xa_resource_manager.h 2010-08-20 20:54:13 +0000
25+++ drizzled/plugin/xa_resource_manager.h 2010-10-31 22:34:08 +0000
26@@ -71,6 +71,16 @@
27 return doXaRecover(append_to, len);
28 }
29
30+ uint64_t getCurrentTransactionId(Session *session)
31+ {
32+ return doGetCurrentTransactionId(session);
33+ }
34+
35+ uint64_t getNewTransactionId(Session *session)
36+ {
37+ return doGetNewTransactionId(session);
38+ }
39+
40 typedef ::boost::unordered_set<my_xid> commit_list_set;
41 /**
42 * The below static class methods wrap the interaction
43@@ -117,6 +127,10 @@
44 * for this engine.
45 */
46 virtual int doXaRecover(XID * append_to, size_t len)= 0;
47+
48+ virtual uint64_t doGetCurrentTransactionId(Session *session)= 0;
49+
50+ virtual uint64_t doGetNewTransactionId(Session *session)= 0;
51 };
52
53 } /* namespace plugin */
54
55=== modified file 'drizzled/session.cc'
56--- drizzled/session.cc 2010-10-28 09:15:33 +0000
57+++ drizzled/session.cc 2010-10-31 22:34:08 +0000
58@@ -157,6 +157,7 @@
59 Session::Session(plugin::Client *client_arg) :
60 Open_tables_state(refresh_version),
61 mem_root(&main_mem_root),
62+ xa_id(0),
63 lex(&main_lex),
64 catalog("LOCAL"),
65 client(client_arg),
66
67=== modified file 'drizzled/session.h'
68--- drizzled/session.h 2010-10-30 01:19:00 +0000
69+++ drizzled/session.h 2010-10-31 22:34:08 +0000
70@@ -366,6 +366,19 @@
71 {
72 return mem_root;
73 }
74+
75+ uint64_t xa_id;
76+
77+ uint64_t getXaId()
78+ {
79+ return xa_id;
80+ }
81+
82+ void setXaId(uint64_t in_xa_id)
83+ {
84+ xa_id= in_xa_id;
85+ }
86+
87 /**
88 * Uniquely identifies each statement object in thread scope; change during
89 * statement lifetime.
90
91=== modified file 'drizzled/transaction_services.cc'
92--- drizzled/transaction_services.cc 2010-10-29 00:42:43 +0000
93+++ drizzled/transaction_services.cc 2010-10-31 22:34:08 +0000
94@@ -69,6 +69,7 @@
95 #include "drizzled/plugin/monitored_in_transaction.h"
96 #include "drizzled/plugin/transactional_storage_engine.h"
97 #include "drizzled/plugin/xa_resource_manager.h"
98+#include "drizzled/plugin/xa_storage_engine.h"
99 #include "drizzled/internal/my_sys.h"
100
101 #include <vector>
102@@ -299,6 +300,19 @@
103 * transaction after all DDLs, just like the statement transaction
104 * is always committed at the end of all statements.
105 */
106+TransactionServices::TransactionServices()
107+{
108+ plugin::StorageEngine *engine= plugin::StorageEngine::findByName("InnoDB");
109+ if (engine)
110+ {
111+ xa_storage_engine= (plugin::XaStorageEngine*)engine;
112+ }
113+ else
114+ {
115+ xa_storage_engine= NULL;
116+ }
117+}
118+
119 void TransactionServices::registerResourceForStatement(Session *session,
120 plugin::MonitoredInTransaction *monitored,
121 plugin::TransactionalStorageEngine *engine)
122@@ -426,6 +440,29 @@
123 registerResourceForStatement(session, monitored, engine, resource_manager);
124 }
125
126+void TransactionServices::allocateNewTransactionId()
127+{
128+ ReplicationServices &replication_services= ReplicationServices::singleton();
129+ if (! replication_services.isActive())
130+ {
131+ return;
132+ }
133+
134+ Session *my_session= current_session;
135+ uint64_t xa_id= xa_storage_engine->getNewTransactionId(my_session);
136+ my_session->setXaId(xa_id);
137+}
138+
139+uint64_t TransactionServices::getCurrentTransactionId(Session *session)
140+{
141+ if (session->getXaId() == 0)
142+ {
143+ session->setXaId(xa_storage_engine->getNewTransactionId(session));
144+ }
145+
146+ return session->getXaId();
147+}
148+
149 /**
150 @retval
151 0 ok
152@@ -976,7 +1013,14 @@
153 trx->set_server_id(in_session->getServerId());
154
155 if (should_inc_trx_id)
156- trx->set_transaction_id(getNextTransactionId());
157+ {
158+ trx->set_transaction_id(getCurrentTransactionId(in_session));
159+ in_session->setXaId(0);
160+ }
161+ else
162+ {
163+ trx->set_transaction_id(0);
164+ }
165
166 trx->set_start_timestamp(in_session->getCurrentTimestamp());
167 }
168@@ -1029,7 +1073,6 @@
169 {
170 statement.set_type(in_type);
171 statement.set_start_timestamp(in_session->getCurrentTimestamp());
172- /** @TODO Set sql string optionally */
173 }
174
175 void TransactionServices::finalizeStatementMessage(message::Statement &statement,
176
177=== modified file 'drizzled/transaction_services.h'
178--- drizzled/transaction_services.h 2010-10-20 18:39:38 +0000
179+++ drizzled/transaction_services.h 2010-10-31 22:34:08 +0000
180@@ -36,13 +36,14 @@
181 {
182 class MonitoredInTransaction;
183 class XaResourceManager;
184+ class XaStorageEngine;
185 class TransactionalStorageEngine;
186 }
187
188 class Session;
189 class NamedSavepoint;
190 class Field;
191-
192+
193 /**
194 * This is a class which manages the XA transaction processing
195 * in the server
196@@ -51,17 +52,8 @@
197 {
198 public:
199 static const size_t DEFAULT_RECORD_SIZE= 100;
200- typedef uint64_t TransactionId;
201- /**
202- * Constructor
203- */
204- TransactionServices()
205- {
206- /**
207- * @todo set transaction ID to the last one from an applier...
208- */
209- current_transaction_id= 0;
210- }
211+
212+ TransactionServices();
213
214 /**
215 * Singleton method
216@@ -435,22 +427,11 @@
217 plugin::MonitoredInTransaction *monitored,
218 plugin::TransactionalStorageEngine *engine,
219 plugin::XaResourceManager *resource_manager);
220- TransactionId getNextTransactionId()
221- {
222- return current_transaction_id.increment();
223- }
224- TransactionId getCurrentTransactionId()
225- {
226- return current_transaction_id;
227- }
228- /**
229- * DEBUG ONLY. See plugin::TransactionLog::truncate()
230- */
231- void resetTransactionId()
232- {
233- current_transaction_id= 0;
234- }
235-
236+
237+ uint64_t getCurrentTransactionId(Session *session);
238+
239+ void allocateNewTransactionId();
240+
241 /**************
242 * Events API
243 **************/
244@@ -476,7 +457,6 @@
245 bool sendShutdownEvent(Session *session);
246
247 private:
248- atomic<TransactionId> current_transaction_id;
249
250 /**
251 * Checks if a field has been updated
252@@ -520,6 +500,8 @@
253 Table *in_table,
254 const unsigned char *old_record,
255 const unsigned char *new_record);
256+
257+ plugin::XaStorageEngine *xa_storage_engine;
258 };
259
260 } /* namespace drizzled */
261
262=== modified file 'plugin/innobase/handler/ha_innodb.cc'
263--- plugin/innobase/handler/ha_innodb.cc 2010-10-27 04:22:26 +0000
264+++ plugin/innobase/handler/ha_innodb.cc 2010-10-31 22:34:08 +0000
265@@ -348,6 +348,8 @@
266 {
267 return doRollback(session, all); /* XA rollback just does a SQL ROLLBACK */
268 }
269+ virtual uint64_t doGetCurrentTransactionId(Session *session);
270+ virtual uint64_t doGetNewTransactionId(Session *session);
271 virtual int doCommit(Session* session, bool all);
272 virtual int doRollback(Session* session, bool all);
273
274@@ -4139,6 +4141,8 @@
275
276 error = row_insert_for_mysql((byte*) record, prebuilt);
277
278+ user_session->setXaId((ib_uint64_t) ut_conv_dulint_to_longlong(trx->id));
279+
280 /* Handle duplicate key errors */
281 if (auto_inc_used) {
282 ulint err;
283@@ -4455,6 +4459,8 @@
284
285 error = row_update_for_mysql((byte*) old_row, prebuilt);
286
287+ user_session->setXaId((ib_uint64_t) ut_conv_dulint_to_longlong(trx->id));
288+
289 /* We need to do some special AUTOINC handling for the following case:
290
291 INSERT INTO t (c1,c2) VALUES(x,y) ON DUPLICATE KEY UPDATE ...
292@@ -4545,6 +4551,8 @@
293
294 error = row_update_for_mysql((byte*) record, prebuilt);
295
296+ user_session->setXaId((ib_uint64_t) ut_conv_dulint_to_longlong(trx->id));
297+
298 innodb_srv_conc_exit_innodb(trx);
299
300 error = convert_error_code_to_mysql(
301@@ -5820,6 +5828,8 @@
302 lex_identified_temp_table ? name2 : NULL,
303 iflags);
304
305+ session.setXaId((ib_uint64_t) ut_conv_dulint_to_longlong(trx->id));
306+
307 if (error) {
308 goto cleanup;
309 }
310@@ -6070,6 +6080,8 @@
311 session_sql_command(&session)
312 == SQLCOM_DROP_DB);
313
314+ session.setXaId((ib_uint64_t) ut_conv_dulint_to_longlong(trx->id));
315+
316 /* Flush the log to reduce probability that the .frm files and
317 the InnoDB data dictionary get out-of-sync if the user runs
318 with innodb_flush_log_at_trx_commit = 0 */
319@@ -6291,6 +6303,8 @@
320
321 error = innobase_rename_table(trx, from.getPath().c_str(), to.getPath().c_str(), TRUE);
322
323+ session.setXaId((ib_uint64_t) ut_conv_dulint_to_longlong(trx->id));
324+
325 /* Tell the InnoDB server that there might be work for
326 utility threads: */
327
328@@ -8259,6 +8273,23 @@
329 return(error);
330 }
331
332+uint64_t InnobaseEngine::doGetCurrentTransactionId(Session *session)
333+{
334+ trx_t *trx= session_to_trx(session);
335+ return (ib_uint64_t) ut_conv_dulint_to_longlong(trx->id);
336+}
337+
338+uint64_t InnobaseEngine::doGetNewTransactionId(Session *session)
339+{
340+ trx_t *trx= innobase_trx_allocate(session);
341+
342+ mutex_enter(&kernel_mutex);
343+ trx->id= trx_sys_get_new_trx_id();
344+ mutex_exit(&kernel_mutex);
345+
346+ return (ib_uint64_t) ut_conv_dulint_to_longlong(trx->id);
347+}
348+
349 /*******************************************************************//**
350 This function is used to recover X/Open XA distributed transactions.
351 @return number of prepared transactions stored in xid_list */
352
353=== modified file 'plugin/schema_engine/schema.cc'
354--- plugin/schema_engine/schema.cc 2010-10-10 11:41:42 +0000
355+++ plugin/schema_engine/schema.cc 2010-10-31 22:34:08 +0000
356@@ -30,6 +30,7 @@
357 #include "drizzled/data_home.h"
358
359 #include "drizzled/internal/my_sys.h"
360+#include "drizzled/transaction_services.h"
361
362 #include <fcntl.h>
363 #include <sys/stat.h>
364@@ -156,6 +157,9 @@
365 }
366 mutex.unlock();
367
368+ TransactionServices &transaction_services= TransactionServices::singleton();
369+ transaction_services.allocateNewTransactionId();
370+
371 return true;
372 }
373
374@@ -196,6 +200,9 @@
375 schema_cache.erase(schema_identifier.getPath());
376 mutex.unlock();
377
378+ TransactionServices &transaction_services= TransactionServices::singleton();
379+ transaction_services.allocateNewTransactionId();
380+
381 return true;
382 }
383
384@@ -221,6 +228,9 @@
385 }
386 }
387 mutex.unlock();
388+
389+ TransactionServices &transaction_services= TransactionServices::singleton();
390+ transaction_services.allocateNewTransactionId();
391 }
392
393 return true;
394
395=== modified file 'plugin/transaction_log/tests/r/bug660779.result'
396--- plugin/transaction_log/tests/r/bug660779.result 2010-10-20 16:40:44 +0000
397+++ plugin/transaction_log/tests/r/bug660779.result 2010-10-31 22:34:08 +0000
398@@ -19,7 +19,7 @@
399 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
400 transaction_context {
401 server_id: 1
402- transaction_id: 1
403+ TRANSACTION_ID
404 START_TIMESTAMP
405 END_TIMESTAMP
406 }
407@@ -77,7 +77,7 @@
408 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
409 transaction_context {
410 server_id: 1
411- transaction_id: 2
412+ TRANSACTION_ID
413 START_TIMESTAMP
414 END_TIMESTAMP
415 }
416@@ -169,7 +169,7 @@
417 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
418 transaction_context {
419 server_id: 1
420- transaction_id: 5
421+ TRANSACTION_ID
422 START_TIMESTAMP
423 END_TIMESTAMP
424 }
425
426=== modified file 'plugin/transaction_log/tests/r/bulk_commit.result'
427--- plugin/transaction_log/tests/r/bulk_commit.result 2010-10-05 08:06:38 +0000
428+++ plugin/transaction_log/tests/r/bulk_commit.result 2010-10-31 22:34:08 +0000
429@@ -2,17 +2,11 @@
430 START TRANSACTION;
431 COMMIT;
432
433-SELECT server_id, transaction_id, num_statements FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
434-server_id transaction_id num_statements
435-1 1 1
436-1 2 1
437-1 2 1
438-
439 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log', ENTRY_OFFSET) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
440 PRINT_TRANSACTION_MESSAGE('transaction.log', ENTRY_OFFSET)
441 transaction_context {
442 server_id: 1
443- transaction_id: 1
444+ TRANSACTION_ID
445 START_TIMESTAMP
446 END_TIMESTAMP
447 }
448@@ -75,7 +69,7 @@
449
450 transaction_context {
451 server_id: 1
452- transaction_id: 2
453+ TRANSACTION_ID
454 START_TIMESTAMP
455 END_TIMESTAMP
456 }
457@@ -55353,7 +55347,7 @@
458
459 transaction_context {
460 server_id: 1
461- transaction_id: 2
462+ TRANSACTION_ID
463 START_TIMESTAMP
464 END_TIMESTAMP
465 }
466
467=== modified file 'plugin/transaction_log/tests/r/bulk_rollback.result'
468--- plugin/transaction_log/tests/r/bulk_rollback.result 2010-10-05 08:06:38 +0000
469+++ plugin/transaction_log/tests/r/bulk_rollback.result 2010-10-31 22:34:08 +0000
470@@ -2,17 +2,11 @@
471 START TRANSACTION;
472 ROLLBACK;
473
474-SELECT server_id, transaction_id, num_statements FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
475-server_id transaction_id num_statements
476-1 1 1
477-1 2 1
478-1 2 1
479-
480 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log', ENTRY_OFFSET) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
481 PRINT_TRANSACTION_MESSAGE('transaction.log', ENTRY_OFFSET)
482 transaction_context {
483 server_id: 1
484- transaction_id: 1
485+ TRANSACTION_ID
486 START_TIMESTAMP
487 END_TIMESTAMP
488 }
489@@ -75,7 +69,7 @@
490
491 transaction_context {
492 server_id: 1
493- transaction_id: 2
494+ TRANSACTION_ID
495 START_TIMESTAMP
496 END_TIMESTAMP
497 }
498@@ -55353,7 +55347,7 @@
499
500 transaction_context {
501 server_id: 1
502- transaction_id: 2
503+ TRANSACTION_ID
504 START_TIMESTAMP
505 END_TIMESTAMP
506 }
507
508=== modified file 'plugin/transaction_log/tests/r/ddl_transaction_id.result'
509--- plugin/transaction_log/tests/r/ddl_transaction_id.result 2010-04-01 16:41:45 +0000
510+++ plugin/transaction_log/tests/r/ddl_transaction_id.result 2010-10-31 22:34:08 +0000
511@@ -14,23 +14,224 @@
512 SELECT * FROM t1 WHERE id = 3;
513 id less_padding
514 DROP TABLE t1;
515-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
516-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
517-transaction.log X 6 6 1 6 X X X
518-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
519-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
520-X TRANSACTION X
521-X TRANSACTION X
522-X TRANSACTION X
523-X TRANSACTION X
524-X TRANSACTION X
525-X TRANSACTION X
526-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
527-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
528-X 1 1 X X 1 0
529-X 2 1 X X 1 0
530-X 3 1 X X 1 0
531-X 4 1 X X 1 0
532-X 5 1 X X 1 0
533-X 6 1 X X 1 0
534+Check transaction_log_entries
535+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
536+COUNT(*)
537+6
538+
539+Check transaction_log_transactions
540+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
541+COUNT(*)
542+6
543+Check transaction log contents
544+SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
545+PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
546+transaction_context {
547+ server_id: 1
548+ TRANSACTION_ID
549+ START_TIMESTAMP
550+ END_TIMESTAMP
551+}
552+statement {
553+ type: DROP_TABLE
554+ START_TIMESTAMP
555+ END_TIMESTAMP
556+ drop_table_statement {
557+ table_metadata {
558+ schema_name: "test"
559+ table_name: "t1"
560+ }
561+ if_exists_clause: false
562+ }
563+}
564+
565+
566+SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
567+PRINT_TRANSACTION_MESSAGE('transaction.log',entry_offset)
568+transaction_context {
569+ server_id: 1
570+ TRANSACTION_ID
571+ START_TIMESTAMP
572+ END_TIMESTAMP
573+}
574+statement {
575+ type: DROP_TABLE
576+ START_TIMESTAMP
577+ END_TIMESTAMP
578+ drop_table_statement {
579+ table_metadata {
580+ schema_name: "test"
581+ table_name: "t1"
582+ }
583+ if_exists_clause: true
584+ }
585+}
586+
587+transaction_context {
588+ server_id: 1
589+ TRANSACTION_ID
590+ START_TIMESTAMP
591+ END_TIMESTAMP
592+}
593+statement {
594+ type: CREATE_TABLE
595+ START_TIMESTAMP
596+ END_TIMESTAMP
597+ create_table_statement {
598+ table {
599+ name: "t1"
600+ engine {
601+ name: "InnoDB"
602+ }
603+ field {
604+ name: "id"
605+ type: INTEGER
606+ constraints {
607+ is_nullable: false
608+ }
609+ }
610+ field {
611+ name: "padding"
612+ type: VARCHAR
613+ constraints {
614+ is_nullable: false
615+ }
616+ string_options {
617+ length: 200
618+ collation_id: 45
619+ collation: "utf8_general_ci"
620+ }
621+ }
622+ indexes {
623+ name: "PRIMARY"
624+ is_primary: true
625+ is_unique: true
626+ type: UNKNOWN_INDEX
627+ key_length: 4
628+ index_part {
629+ fieldnr: 0
630+ compare_length: 4
631+ }
632+ options {
633+ }
634+ }
635+ type: STANDARD
636+ schema: "test"
637+ options {
638+ has_user_set_auto_increment_value: false
639+ collation: "utf8_general_ci"
640+ collation_id: 45
641+ }
642+ CREATE_TIMESTAMP
643+ UPDATE_TIMESTAMP
644+
645+ version: 1
646+ }
647+ }
648+}
649+
650+transaction_context {
651+ server_id: 1
652+ TRANSACTION_ID
653+ START_TIMESTAMP
654+ END_TIMESTAMP
655+}
656+statement {
657+ type: INSERT
658+ START_TIMESTAMP
659+ END_TIMESTAMP
660+ insert_header {
661+ table_metadata {
662+ schema_name: "test"
663+ table_name: "t1"
664+ }
665+ field_metadata {
666+ type: INTEGER
667+ name: "id"
668+ }
669+ field_metadata {
670+ type: VARCHAR
671+ name: "padding"
672+ }
673+ }
674+ insert_data {
675+ segment_id: 1
676+ end_segment: true
677+ record {
678+ insert_value: "1"
679+ insert_value: "I love testing."
680+ is_null: false
681+ is_null: false
682+ }
683+ }
684+}
685+
686+transaction_context {
687+ server_id: 1
688+ TRANSACTION_ID
689+ START_TIMESTAMP
690+ END_TIMESTAMP
691+}
692+statement {
693+ type: INSERT
694+ START_TIMESTAMP
695+ END_TIMESTAMP
696+ insert_header {
697+ table_metadata {
698+ schema_name: "test"
699+ table_name: "t1"
700+ }
701+ field_metadata {
702+ type: INTEGER
703+ name: "id"
704+ }
705+ field_metadata {
706+ type: VARCHAR
707+ name: "padding"
708+ }
709+ }
710+ insert_data {
711+ segment_id: 1
712+ end_segment: true
713+ record {
714+ insert_value: "2"
715+ insert_value: "I hate testing."
716+ is_null: false
717+ is_null: false
718+ }
719+ }
720+}
721+
722+transaction_context {
723+ server_id: 1
724+ TRANSACTION_ID
725+ START_TIMESTAMP
726+ END_TIMESTAMP
727+}
728+statement {
729+ type: RAW_SQL
730+ START_TIMESTAMP
731+ END_TIMESTAMP
732+ sql: "ALTER TABLE t1 CHANGE COLUMN padding less_padding VARCHAR(180) NOT NULL"
733+}
734+
735+transaction_context {
736+ server_id: 1
737+ TRANSACTION_ID
738+ START_TIMESTAMP
739+ END_TIMESTAMP
740+}
741+statement {
742+ type: DROP_TABLE
743+ START_TIMESTAMP
744+ END_TIMESTAMP
745+ drop_table_statement {
746+ table_metadata {
747+ schema_name: "test"
748+ table_name: "t1"
749+ }
750+ if_exists_clause: false
751+ }
752+}
753+
754 SET GLOBAL transaction_log_truncate_debug= true;
755
756=== modified file 'plugin/transaction_log/tests/r/information_schema.result'
757--- plugin/transaction_log/tests/r/information_schema.result 2010-08-30 23:46:45 +0000
758+++ plugin/transaction_log/tests/r/information_schema.result 2010-10-31 22:34:08 +0000
759@@ -7,21 +7,212 @@
760 INSERT INTO t1 VALUES (1, "I love testing.");
761 INSERT INTO t1 VALUES (2, "I hate testing.");
762 DROP TABLE t1;
763-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
764-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
765-transaction.log X 5 5 1 5 X X X
766-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
767-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
768-X TRANSACTION X
769-X TRANSACTION X
770-X TRANSACTION X
771-X TRANSACTION X
772-X TRANSACTION X
773-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
774-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
775-X 1 1 X X 1 0
776-X 2 1 X X 1 0
777-X 3 1 X X 1 0
778-X 4 1 X X 1 0
779-X 5 1 X X 1 0
780+Check transaction_log_entries
781+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
782+COUNT(*)
783+5
784+
785+Check transaction_log_transactions
786+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
787+COUNT(*)
788+5
789+Check transaction log contents
790+SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
791+PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
792+transaction_context {
793+ server_id: 1
794+ TRANSACTION_ID
795+ START_TIMESTAMP
796+ END_TIMESTAMP
797+}
798+statement {
799+ type: DROP_TABLE
800+ START_TIMESTAMP
801+ END_TIMESTAMP
802+ drop_table_statement {
803+ table_metadata {
804+ schema_name: "test"
805+ table_name: "t1"
806+ }
807+ if_exists_clause: false
808+ }
809+}
810+
811+
812+Dump log contents
813+SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
814+PRINT_TRANSACTION_MESSAGE('transaction.log',entry_offset)
815+transaction_context {
816+ server_id: 1
817+ TRANSACTION_ID
818+ START_TIMESTAMP
819+ END_TIMESTAMP
820+}
821+statement {
822+ type: DROP_TABLE
823+ START_TIMESTAMP
824+ END_TIMESTAMP
825+ drop_table_statement {
826+ table_metadata {
827+ schema_name: "test"
828+ table_name: "t1"
829+ }
830+ if_exists_clause: true
831+ }
832+}
833+
834+transaction_context {
835+ server_id: 1
836+ TRANSACTION_ID
837+ START_TIMESTAMP
838+ END_TIMESTAMP
839+}
840+statement {
841+ type: CREATE_TABLE
842+ START_TIMESTAMP
843+ END_TIMESTAMP
844+ create_table_statement {
845+ table {
846+ name: "t1"
847+ engine {
848+ name: "InnoDB"
849+ }
850+ field {
851+ name: "id"
852+ type: INTEGER
853+ constraints {
854+ is_nullable: false
855+ }
856+ }
857+ field {
858+ name: "padding"
859+ type: VARCHAR
860+ constraints {
861+ is_nullable: false
862+ }
863+ string_options {
864+ length: 200
865+ collation_id: 45
866+ collation: "utf8_general_ci"
867+ }
868+ }
869+ indexes {
870+ name: "PRIMARY"
871+ is_primary: true
872+ is_unique: true
873+ type: UNKNOWN_INDEX
874+ key_length: 4
875+ index_part {
876+ fieldnr: 0
877+ compare_length: 4
878+ }
879+ options {
880+ }
881+ }
882+ type: STANDARD
883+ schema: "test"
884+ options {
885+ has_user_set_auto_increment_value: false
886+ collation: "utf8_general_ci"
887+ collation_id: 45
888+ }
889+ CREATE_TIMESTAMP
890+ UPDATE_TIMESTAMP
891+
892+ version: 1
893+ }
894+ }
895+}
896+
897+transaction_context {
898+ server_id: 1
899+ TRANSACTION_ID
900+ START_TIMESTAMP
901+ END_TIMESTAMP
902+}
903+statement {
904+ type: INSERT
905+ START_TIMESTAMP
906+ END_TIMESTAMP
907+ insert_header {
908+ table_metadata {
909+ schema_name: "test"
910+ table_name: "t1"
911+ }
912+ field_metadata {
913+ type: INTEGER
914+ name: "id"
915+ }
916+ field_metadata {
917+ type: VARCHAR
918+ name: "padding"
919+ }
920+ }
921+ insert_data {
922+ segment_id: 1
923+ end_segment: true
924+ record {
925+ insert_value: "1"
926+ insert_value: "I love testing."
927+ is_null: false
928+ is_null: false
929+ }
930+ }
931+}
932+
933+transaction_context {
934+ server_id: 1
935+ TRANSACTION_ID
936+ START_TIMESTAMP
937+ END_TIMESTAMP
938+}
939+statement {
940+ type: INSERT
941+ START_TIMESTAMP
942+ END_TIMESTAMP
943+ insert_header {
944+ table_metadata {
945+ schema_name: "test"
946+ table_name: "t1"
947+ }
948+ field_metadata {
949+ type: INTEGER
950+ name: "id"
951+ }
952+ field_metadata {
953+ type: VARCHAR
954+ name: "padding"
955+ }
956+ }
957+ insert_data {
958+ segment_id: 1
959+ end_segment: true
960+ record {
961+ insert_value: "2"
962+ insert_value: "I hate testing."
963+ is_null: false
964+ is_null: false
965+ }
966+ }
967+}
968+
969+transaction_context {
970+ server_id: 1
971+ TRANSACTION_ID
972+ START_TIMESTAMP
973+ END_TIMESTAMP
974+}
975+statement {
976+ type: DROP_TABLE
977+ START_TIMESTAMP
978+ END_TIMESTAMP
979+ drop_table_statement {
980+ table_metadata {
981+ schema_name: "test"
982+ table_name: "t1"
983+ }
984+ if_exists_clause: false
985+ }
986+}
987+
988 SET GLOBAL transaction_log_truncate_debug= true;
989
990=== modified file 'plugin/transaction_log/tests/r/transaction_log_alter.result'
991--- plugin/transaction_log/tests/r/transaction_log_alter.result 2010-10-05 08:06:38 +0000
992+++ plugin/transaction_log/tests/r/transaction_log_alter.result 2010-10-31 22:34:08 +0000
993@@ -2,32 +2,21 @@
994 DROP TABLE IF EXISTS t1, t1_new_name;
995 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, PRIMARY KEY(a), KEY b_key1 (b));
996 ALTER TABLE t1 RENAME TO t1_new_name;
997-# check transaction_log
998-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
999-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1000-transaction.log 492 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1001-
1002 Check transaction_log_entries
1003-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1004-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1005-0 TRANSACTION 75
1006-75 TRANSACTION 84
1007-159 TRANSACTION 237
1008-396 TRANSACTION 96
1009+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1010+COUNT(*)
1011+4
1012
1013 Check transaction_log_transactions
1014-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1015-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1016-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1017-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1018-159 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1019-396 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
1020+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1021+COUNT(*)
1022+4
1023 Check transaction log contents
1024 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1025 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1026 transaction_context {
1027 server_id: 1
1028- transaction_id: 4
1029+ TRANSACTION_ID
1030 START_TIMESTAMP
1031 END_TIMESTAMP
1032 }
1033@@ -49,32 +38,21 @@
1034 CREATE TABLE t2 LIKE t1;
1035 ALTER TABLE t1 RENAME TO t2;
1036 ERROR 42S01: Table 'test.t2' already exists
1037-# check transaction_log
1038-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1039-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1040-transaction.log 626 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1041-
1042 Check transaction_log_entries
1043-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1044-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1045-0 TRANSACTION 75
1046-75 TRANSACTION 75
1047-150 TRANSACTION 237
1048-387 TRANSACTION 239
1049+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1050+COUNT(*)
1051+4
1052
1053 Check transaction_log_transactions
1054-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1055-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1056-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1057-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1058-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1059-387 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
1060+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1061+COUNT(*)
1062+4
1063 Check transaction log contents
1064 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1065 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1066 transaction_context {
1067 server_id: 1
1068- transaction_id: 4
1069+ TRANSACTION_ID
1070 START_TIMESTAMP
1071 END_TIMESTAMP
1072 }
1073@@ -155,32 +133,21 @@
1074 CREATE TABLE t2 LIKE t1;
1075 ALTER TABLE t1 RENAME TO t2;
1076 ERROR 42S01: Table 'test.t2' already exists
1077-# check transaction_log
1078-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1079-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1080-transaction.log 626 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1081-
1082 Check transaction_log_entries
1083-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1084-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1085-0 TRANSACTION 75
1086-75 TRANSACTION 75
1087-150 TRANSACTION 237
1088-387 TRANSACTION 239
1089+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1090+COUNT(*)
1091+4
1092
1093 Check transaction_log_transactions
1094-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1095-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1096-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1097-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1098-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1099-387 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
1100+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1101+COUNT(*)
1102+4
1103 Check transaction log contents
1104 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1105 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1106 transaction_context {
1107 server_id: 1
1108- transaction_id: 4
1109+ TRANSACTION_ID
1110 START_TIMESTAMP
1111 END_TIMESTAMP
1112 }
1113@@ -261,36 +228,21 @@
1114 CREATE TABLE t2(a INT NOT NULL, b INT , PRIMARY KEY(a), KEY b_key (b),
1115 CONSTRAINT fk_constraint_t2 FOREIGN KEY (b) REFERENCES t1(b) ON DELETE SET NULL ON UPDATE CASCADE);
1116 ALTER TABLE t1 RENAME to t1_new_name;
1117-# check transaction_log
1118-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1119-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1120-transaction.log 841 6 6 1 6 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1121-
1122 Check transaction_log_entries
1123-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1124-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1125-0 TRANSACTION 75
1126-75 TRANSACTION 75
1127-150 TRANSACTION 84
1128-234 TRANSACTION 237
1129-471 TRANSACTION 274
1130-745 TRANSACTION 96
1131+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1132+COUNT(*)
1133+6
1134
1135 Check transaction_log_transactions
1136-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1137-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1138-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1139-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1140-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1141-234 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
1142-471 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
1143-745 6 1 START_TIMESTAMP END_TIMESTAMP 1 0
1144+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1145+COUNT(*)
1146+6
1147 Check transaction log contents
1148 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1149 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1150 transaction_context {
1151 server_id: 1
1152- transaction_id: 6
1153+ TRANSACTION_ID
1154 START_TIMESTAMP
1155 END_TIMESTAMP
1156 }
1157@@ -319,30 +271,21 @@
1158 DROP TABLE IF EXISTS t1 ;
1159 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, PRIMARY KEY(a));
1160 ALTER TABLE t1 ADD COLUMN c CHAR(100) NOT NULL;
1161-# check transaction_log
1162-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1163-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1164-transaction.log 392 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1165-
1166 Check transaction_log_entries
1167-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1168-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1169-0 TRANSACTION 75
1170-75 TRANSACTION 211
1171-286 TRANSACTION 106
1172+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1173+COUNT(*)
1174+3
1175
1176 Check transaction_log_transactions
1177-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1178-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1179-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1180-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1181-286 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1182+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1183+COUNT(*)
1184+3
1185 Check transaction log contents
1186 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1187 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1188 transaction_context {
1189 server_id: 1
1190- transaction_id: 3
1191+ TRANSACTION_ID
1192 START_TIMESTAMP
1193 END_TIMESTAMP
1194 }
1195@@ -363,28 +306,21 @@
1196 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, PRIMARY KEY(a));
1197 ALTER TABLE t1 ADD COLUMN b CHAR(100) NOT NULL;
1198 ERROR 42S21: Duplicate column name 'b'
1199-# check transaction_log
1200-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1201-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1202-transaction.log 286 2 2 1 2 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1203-
1204 Check transaction_log_entries
1205-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1206-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1207-0 TRANSACTION 75
1208-75 TRANSACTION 211
1209+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1210+COUNT(*)
1211+2
1212
1213 Check transaction_log_transactions
1214-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1215-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1216-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1217-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1218+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1219+COUNT(*)
1220+2
1221 Check transaction log contents
1222 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1223 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1224 transaction_context {
1225 server_id: 1
1226- transaction_id: 2
1227+ TRANSACTION_ID
1228 START_TIMESTAMP
1229 END_TIMESTAMP
1230 }
1231@@ -449,30 +385,21 @@
1232 DROP TABLE IF EXISTS t1 ;
1233 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, PRIMARY KEY(a));
1234 ALTER TABLE t1 ADD COLUMN c CHAR(100) NOT NULL AFTER a;
1235-# check transaction_log
1236-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1237-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1238-transaction.log 400 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1239-
1240 Check transaction_log_entries
1241-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1242-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1243-0 TRANSACTION 75
1244-75 TRANSACTION 211
1245-286 TRANSACTION 114
1246+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1247+COUNT(*)
1248+3
1249
1250 Check transaction_log_transactions
1251-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1252-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1253-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1254-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1255-286 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1256+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1257+COUNT(*)
1258+3
1259 Check transaction log contents
1260 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1261 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1262 transaction_context {
1263 server_id: 1
1264- transaction_id: 3
1265+ TRANSACTION_ID
1266 START_TIMESTAMP
1267 END_TIMESTAMP
1268 }
1269@@ -492,30 +419,21 @@
1270 DROP TABLE IF EXISTS t1 ;
1271 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, PRIMARY KEY(a));
1272 ALTER TABLE t1 ADD COLUMN c CHAR(100) NOT NULL FIRST ;
1273-# check transaction_log
1274-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1275-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1276-transaction.log 398 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1277-
1278 Check transaction_log_entries
1279-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1280-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1281-0 TRANSACTION 75
1282-75 TRANSACTION 211
1283-286 TRANSACTION 112
1284+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1285+COUNT(*)
1286+3
1287
1288 Check transaction_log_transactions
1289-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1290-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1291-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1292-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1293-286 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1294+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1295+COUNT(*)
1296+3
1297 Check transaction log contents
1298 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1299 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1300 transaction_context {
1301 server_id: 1
1302- transaction_id: 3
1303+ TRANSACTION_ID
1304 START_TIMESTAMP
1305 END_TIMESTAMP
1306 }
1307@@ -535,30 +453,21 @@
1308 DROP TABLE IF EXISTS t1 ;
1309 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, PRIMARY KEY(a));
1310 ALTER TABLE t1 ADD COLUMN c CHAR(100) NOT NULL FIRST, ADD COLUMN d BLOB AFTER a ;
1311-# check transaction_log
1312-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1313-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1314-transaction.log 425 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1315-
1316 Check transaction_log_entries
1317-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1318-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1319-0 TRANSACTION 75
1320-75 TRANSACTION 211
1321-286 TRANSACTION 139
1322+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1323+COUNT(*)
1324+3
1325
1326 Check transaction_log_transactions
1327-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1328-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1329-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1330-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1331-286 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1332+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1333+COUNT(*)
1334+3
1335 Check transaction log contents
1336 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1337 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1338 transaction_context {
1339 server_id: 1
1340- transaction_id: 3
1341+ TRANSACTION_ID
1342 START_TIMESTAMP
1343 END_TIMESTAMP
1344 }
1345@@ -578,30 +487,21 @@
1346 DROP TABLE IF EXISTS t1 ;
1347 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, PRIMARY KEY(a));
1348 ALTER TABLE t1 DROP COLUMN b ;
1349-# check transaction_log
1350-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1351-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1352-transaction.log 374 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1353-
1354 Check transaction_log_entries
1355-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1356-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1357-0 TRANSACTION 75
1358-75 TRANSACTION 211
1359-286 TRANSACTION 88
1360+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1361+COUNT(*)
1362+3
1363
1364 Check transaction_log_transactions
1365-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1366-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1367-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1368-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1369-286 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1370+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1371+COUNT(*)
1372+3
1373 Check transaction log contents
1374 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1375 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1376 transaction_context {
1377 server_id: 1
1378- transaction_id: 3
1379+ TRANSACTION_ID
1380 START_TIMESTAMP
1381 END_TIMESTAMP
1382 }
1383@@ -621,30 +521,21 @@
1384 DROP TABLE IF EXISTS t1 ;
1385 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, c BLOB, d DATE, PRIMARY KEY(a));
1386 ALTER TABLE t1 DROP COLUMN b, DROP COLUMN d ;
1387-# check transaction_log
1388-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1389-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1390-transaction.log 423 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1391-
1392 Check transaction_log_entries
1393-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1394-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1395-0 TRANSACTION 75
1396-75 TRANSACTION 245
1397-320 TRANSACTION 103
1398+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1399+COUNT(*)
1400+3
1401
1402 Check transaction_log_transactions
1403-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1404-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1405-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1406-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1407-320 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1408+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1409+COUNT(*)
1410+3
1411 Check transaction log contents
1412 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1413 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1414 transaction_context {
1415 server_id: 1
1416- transaction_id: 3
1417+ TRANSACTION_ID
1418 START_TIMESTAMP
1419 END_TIMESTAMP
1420 }
1421@@ -665,28 +556,21 @@
1422 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, PRIMARY KEY(a));
1423 ALTER TABLE t1 DROP COLUMN a, DROP COLUMN b ;
1424 ERROR 42000: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
1425-# check transaction_log
1426-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1427-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1428-transaction.log 286 2 2 1 2 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1429-
1430 Check transaction_log_entries
1431-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1432-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1433-0 TRANSACTION 75
1434-75 TRANSACTION 211
1435+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1436+COUNT(*)
1437+2
1438
1439 Check transaction_log_transactions
1440-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1441-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1442-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1443-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1444+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1445+COUNT(*)
1446+2
1447 Check transaction log contents
1448 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1449 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1450 transaction_context {
1451 server_id: 1
1452- transaction_id: 2
1453+ TRANSACTION_ID
1454 START_TIMESTAMP
1455 END_TIMESTAMP
1456 }
1457@@ -753,30 +637,21 @@
1458 ALTER TABLE t1 DISABLE KEYS ;
1459 Warnings:
1460 Note 1031 Table storage engine for 't1' doesn't have this option
1461-# check transaction_log
1462-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1463-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1464-transaction.log 404 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1465-
1466 Check transaction_log_entries
1467-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1468-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1469-0 TRANSACTION 75
1470-75 TRANSACTION 242
1471-317 TRANSACTION 87
1472+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1473+COUNT(*)
1474+3
1475
1476 Check transaction_log_transactions
1477-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1478-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1479-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1480-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1481-317 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1482+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1483+COUNT(*)
1484+3
1485 Check transaction log contents
1486 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1487 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1488 transaction_context {
1489 server_id: 1
1490- transaction_id: 3
1491+ TRANSACTION_ID
1492 START_TIMESTAMP
1493 END_TIMESTAMP
1494 }
1495@@ -792,32 +667,21 @@
1496 ALTER TABLE t1 ENABLE KEYS ;
1497 Warnings:
1498 Note 1031 Table storage engine for 't1' doesn't have this option
1499-# check transaction_log
1500-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1501-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1502-transaction.log 490 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1503-
1504 Check transaction_log_entries
1505-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1506-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1507-0 TRANSACTION 75
1508-75 TRANSACTION 242
1509-317 TRANSACTION 87
1510-404 TRANSACTION 86
1511+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1512+COUNT(*)
1513+4
1514
1515 Check transaction_log_transactions
1516-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1517-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1518-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1519-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1520-317 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1521-404 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
1522+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1523+COUNT(*)
1524+4
1525 Check transaction log contents
1526 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1527 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1528 transaction_context {
1529 server_id: 1
1530- transaction_id: 4
1531+ TRANSACTION_ID
1532 START_TIMESTAMP
1533 END_TIMESTAMP
1534 }
1535@@ -837,30 +701,21 @@
1536 DROP TABLE IF EXISTS t1 ;
1537 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, PRIMARY KEY(a));
1538 ALTER TABLE t1 ADD INDEX b_key (b,a) ;
1539-# check transaction_log
1540-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1541-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1542-transaction.log 382 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1543-
1544 Check transaction_log_entries
1545-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1546-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1547-0 TRANSACTION 75
1548-75 TRANSACTION 211
1549-286 TRANSACTION 96
1550+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1551+COUNT(*)
1552+3
1553
1554 Check transaction_log_transactions
1555-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1556-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1557-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1558-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1559-286 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1560+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1561+COUNT(*)
1562+3
1563 Check transaction log contents
1564 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1565 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1566 transaction_context {
1567 server_id: 1
1568- transaction_id: 3
1569+ TRANSACTION_ID
1570 START_TIMESTAMP
1571 END_TIMESTAMP
1572 }
1573@@ -874,32 +729,21 @@
1574
1575
1576 ALTER TABLE t1 DROP INDEX b_key;
1577-# check transaction_log
1578-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1579-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1580-transaction.log 473 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1581-
1582 Check transaction_log_entries
1583-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1584-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1585-0 TRANSACTION 75
1586-75 TRANSACTION 211
1587-286 TRANSACTION 96
1588-382 TRANSACTION 91
1589+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1590+COUNT(*)
1591+4
1592
1593 Check transaction_log_transactions
1594-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1595-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1596-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1597-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1598-286 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1599-382 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
1600+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1601+COUNT(*)
1602+4
1603 Check transaction log contents
1604 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1605 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1606 transaction_context {
1607 server_id: 1
1608- transaction_id: 4
1609+ TRANSACTION_ID
1610 START_TIMESTAMP
1611 END_TIMESTAMP
1612 }
1613@@ -919,30 +763,21 @@
1614 DROP TABLE IF EXISTS t1 ;
1615 CREATE TABLE t1(a INT NOT NULL, b CHAR(50) NOT NULL, PRIMARY KEY(a));
1616 ALTER TABLE t1 ADD INDEX b_key (b(10),a) ;
1617-# check transaction_log
1618-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1619-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1620-transaction.log 409 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1621-
1622 Check transaction_log_entries
1623-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1624-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1625-0 TRANSACTION 75
1626-75 TRANSACTION 234
1627-309 TRANSACTION 100
1628+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1629+COUNT(*)
1630+3
1631
1632 Check transaction_log_transactions
1633-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1634-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1635-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1636-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1637-309 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1638+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1639+COUNT(*)
1640+3
1641 Check transaction log contents
1642 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1643 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1644 transaction_context {
1645 server_id: 1
1646- transaction_id: 3
1647+ TRANSACTION_ID
1648 START_TIMESTAMP
1649 END_TIMESTAMP
1650 }
1651@@ -956,32 +791,21 @@
1652
1653
1654 ALTER TABLE t1 DROP INDEX b_key;
1655-# check transaction_log
1656-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1657-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1658-transaction.log 500 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1659-
1660 Check transaction_log_entries
1661-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1662-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1663-0 TRANSACTION 75
1664-75 TRANSACTION 234
1665-309 TRANSACTION 100
1666-409 TRANSACTION 91
1667+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1668+COUNT(*)
1669+4
1670
1671 Check transaction_log_transactions
1672-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1673-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1674-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1675-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1676-309 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1677-409 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
1678+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1679+COUNT(*)
1680+4
1681 Check transaction log contents
1682 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1683 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1684 transaction_context {
1685 server_id: 1
1686- transaction_id: 4
1687+ TRANSACTION_ID
1688 START_TIMESTAMP
1689 END_TIMESTAMP
1690 }
1691@@ -1002,28 +826,21 @@
1692 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, PRIMARY KEY(a), KEY b_key(b));
1693 ALTER TABLE t1 ADD INDEX b_key (b,a) ;
1694 ERROR 42000: Duplicate key name 'b_key'
1695-# check transaction_log
1696-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1697-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1698-transaction.log 311 2 2 1 2 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1699-
1700 Check transaction_log_entries
1701-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1702-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1703-0 TRANSACTION 75
1704-75 TRANSACTION 236
1705+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1706+COUNT(*)
1707+2
1708
1709 Check transaction_log_transactions
1710-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1711-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1712-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1713-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1714+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1715+COUNT(*)
1716+2
1717 Check transaction log contents
1718 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1719 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1720 transaction_context {
1721 server_id: 1
1722- transaction_id: 2
1723+ TRANSACTION_ID
1724 START_TIMESTAMP
1725 END_TIMESTAMP
1726 }
1727@@ -1102,28 +919,21 @@
1728 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, PRIMARY KEY(a));
1729 ALTER TABLE t1 DROP INDEX i_dont_exist ;
1730 ERROR 42000: Can't DROP 'i_dont_exist'; check that column/key exists
1731-# check transaction_log
1732-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1733-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1734-transaction.log 286 2 2 1 2 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1735-
1736 Check transaction_log_entries
1737-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1738-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1739-0 TRANSACTION 75
1740-75 TRANSACTION 211
1741+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1742+COUNT(*)
1743+2
1744
1745 Check transaction_log_transactions
1746-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1747-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1748-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1749-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1750+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1751+COUNT(*)
1752+2
1753 Check transaction log contents
1754 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1755 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1756 transaction_context {
1757 server_id: 1
1758- transaction_id: 2
1759+ TRANSACTION_ID
1760 START_TIMESTAMP
1761 END_TIMESTAMP
1762 }
1763@@ -1188,30 +998,21 @@
1764 DROP TABLE IF EXISTS t1 ;
1765 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, PRIMARY KEY(a));
1766 ALTER TABLE t1 ALTER COLUMN b SET DEFAULT 999 ;
1767-# check transaction_log
1768-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1769-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1770-transaction.log 391 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1771-
1772 Check transaction_log_entries
1773-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1774-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1775-0 TRANSACTION 75
1776-75 TRANSACTION 211
1777-286 TRANSACTION 105
1778+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1779+COUNT(*)
1780+3
1781
1782 Check transaction_log_transactions
1783-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1784-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1785-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1786-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1787-286 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1788+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1789+COUNT(*)
1790+3
1791 Check transaction log contents
1792 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1793 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1794 transaction_context {
1795 server_id: 1
1796- transaction_id: 3
1797+ TRANSACTION_ID
1798 START_TIMESTAMP
1799 END_TIMESTAMP
1800 }
1801@@ -1232,32 +1033,21 @@
1802 PRIMARY KEY (`a`)
1803 ) ENGINE=InnoDB COLLATE = utf8_general_ci
1804 ALTER TABLE t1 ALTER COLUMN b DROP DEFAULT ;
1805-# check transaction_log
1806-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1807-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1808-transaction.log 493 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1809-
1810 Check transaction_log_entries
1811-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1812-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1813-0 TRANSACTION 75
1814-75 TRANSACTION 211
1815-286 TRANSACTION 105
1816-391 TRANSACTION 102
1817+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1818+COUNT(*)
1819+4
1820
1821 Check transaction_log_transactions
1822-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1823-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1824-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1825-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1826-286 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1827-391 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
1828+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1829+COUNT(*)
1830+4
1831 Check transaction log contents
1832 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1833 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1834 transaction_context {
1835 server_id: 1
1836- transaction_id: 4
1837+ TRANSACTION_ID
1838 START_TIMESTAMP
1839 END_TIMESTAMP
1840 }
1841@@ -1284,30 +1074,21 @@
1842 DROP TABLE IF EXISTS t1 ;
1843 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, PRIMARY KEY(a));
1844 ALTER TABLE t1 CHANGE COLUMN b new_b_name CHAR(500) DEFAULT 'I am not an int now' FIRST ;
1845-# check transaction_log
1846-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1847-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1848-transaction.log 433 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1849-
1850 Check transaction_log_entries
1851-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1852-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1853-0 TRANSACTION 75
1854-75 TRANSACTION 211
1855-286 TRANSACTION 147
1856+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1857+COUNT(*)
1858+3
1859
1860 Check transaction_log_transactions
1861-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1862-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1863-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1864-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1865-286 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1866+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1867+COUNT(*)
1868+3
1869 Check transaction log contents
1870 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1871 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1872 transaction_context {
1873 server_id: 1
1874- transaction_id: 3
1875+ TRANSACTION_ID
1876 START_TIMESTAMP
1877 END_TIMESTAMP
1878 }
1879@@ -1334,30 +1115,21 @@
1880 DROP TABLE IF EXISTS t1 ;
1881 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, c DATE, PRIMARY KEY(a));
1882 ALTER TABLE t1 MODIFY COLUMN b CHAR(50) DEFAULT 'I am now a CHAR field' AFTER c ;
1883-# check transaction_log
1884-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1885-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1886-transaction.log 436 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1887-
1888 Check transaction_log_entries
1889-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1890-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1891-0 TRANSACTION 75
1892-75 TRANSACTION 222
1893-297 TRANSACTION 139
1894+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1895+COUNT(*)
1896+3
1897
1898 Check transaction_log_transactions
1899-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1900-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1901-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1902-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1903-297 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1904+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1905+COUNT(*)
1906+3
1907 Check transaction log contents
1908 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1909 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1910 transaction_context {
1911 server_id: 1
1912- transaction_id: 3
1913+ TRANSACTION_ID
1914 START_TIMESTAMP
1915 END_TIMESTAMP
1916 }
1917@@ -1386,28 +1158,21 @@
1918 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, c DATE, PRIMARY KEY(a));
1919 ALTER TABLE t1 MODIFY COLUMN b CHAR(50) DEFAULT 'I am now a CHAR field' AFTER b ;
1920 ERROR 42S22: Unknown column 'b' in 't1'
1921-# check transaction_log
1922-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1923-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1924-transaction.log 297 2 2 1 2 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1925-
1926 Check transaction_log_entries
1927-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1928-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1929-0 TRANSACTION 75
1930-75 TRANSACTION 222
1931+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1932+COUNT(*)
1933+2
1934
1935 Check transaction_log_transactions
1936-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1937-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1938-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1939-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1940+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1941+COUNT(*)
1942+2
1943 Check transaction log contents
1944 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1945 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1946 transaction_context {
1947 server_id: 1
1948- transaction_id: 2
1949+ TRANSACTION_ID
1950 START_TIMESTAMP
1951 END_TIMESTAMP
1952 }
1953@@ -1487,30 +1252,21 @@
1954 DROP TABLE IF EXISTS t1 ;
1955 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, c DATE, PRIMARY KEY(a));
1956 ALTER TABLE t1 MODIFY COLUMN b INT NOT NULL ;
1957-# check transaction_log
1958-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1959-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1960-transaction.log 400 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1961-
1962 Check transaction_log_entries
1963-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1964-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
1965-0 TRANSACTION 75
1966-75 TRANSACTION 222
1967-297 TRANSACTION 103
1968+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
1969+COUNT(*)
1970+3
1971
1972 Check transaction_log_transactions
1973-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1974-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
1975-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
1976-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
1977-297 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
1978+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
1979+COUNT(*)
1980+3
1981 Check transaction log contents
1982 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
1983 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
1984 transaction_context {
1985 server_id: 1
1986- transaction_id: 3
1987+ TRANSACTION_ID
1988 START_TIMESTAMP
1989 END_TIMESTAMP
1990 }
1991@@ -1537,30 +1293,21 @@
1992 Testing ADD/DROP Foreign Key constraints
1993 DROP TABLE IF EXISTS t1, t2;
1994 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, PRIMARY KEY(a), KEY b_key1 (b));
1995-# check transaction_log
1996-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
1997-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
1998-transaction.log 387 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
1999-
2000 Check transaction_log_entries
2001-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2002-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2003-0 TRANSACTION 75
2004-75 TRANSACTION 75
2005-150 TRANSACTION 237
2006+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2007+COUNT(*)
2008+3
2009
2010 Check transaction_log_transactions
2011-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2012-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2013-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2014-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2015-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
2016+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2017+COUNT(*)
2018+3
2019 Check transaction log contents
2020 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2021 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2022 transaction_context {
2023 server_id: 1
2024- transaction_id: 3
2025+ TRANSACTION_ID
2026 START_TIMESTAMP
2027 END_TIMESTAMP
2028 }
2029@@ -1633,34 +1380,21 @@
2030
2031 CREATE TABLE t2(a INT NOT NULL, b INT , PRIMARY KEY(a), KEY b_key (b));
2032 ALTER TABLE t2 ADD CONSTRAINT fk_constraint_t2 FOREIGN KEY(b) REFERENCES t1(b) ON DELETE SET NULL ON UPDATE CASCADE;
2033-# check transaction_log
2034-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2035-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2036-transaction.log 801 5 5 1 5 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2037-
2038 Check transaction_log_entries
2039-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2040-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2041-0 TRANSACTION 75
2042-75 TRANSACTION 75
2043-150 TRANSACTION 237
2044-387 TRANSACTION 238
2045-625 TRANSACTION 176
2046+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2047+COUNT(*)
2048+5
2049
2050 Check transaction_log_transactions
2051-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2052-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2053-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2054-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2055-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
2056-387 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
2057-625 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
2058+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2059+COUNT(*)
2060+5
2061 Check transaction log contents
2062 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2063 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2064 transaction_context {
2065 server_id: 1
2066- transaction_id: 5
2067+ TRANSACTION_ID
2068 START_TIMESTAMP
2069 END_TIMESTAMP
2070 }
2071@@ -1674,36 +1408,21 @@
2072
2073
2074 ALTER TABLE t2 DROP FOREIGN KEY fk_constraint_t2 ;
2075-# check transaction_log
2076-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2077-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2078-transaction.log 909 6 6 1 6 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2079-
2080 Check transaction_log_entries
2081-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2082-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2083-0 TRANSACTION 75
2084-75 TRANSACTION 75
2085-150 TRANSACTION 237
2086-387 TRANSACTION 238
2087-625 TRANSACTION 176
2088-801 TRANSACTION 108
2089+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2090+COUNT(*)
2091+6
2092
2093 Check transaction_log_transactions
2094-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2095-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2096-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2097-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2098-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
2099-387 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
2100-625 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
2101-801 6 1 START_TIMESTAMP END_TIMESTAMP 1 0
2102+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2103+COUNT(*)
2104+6
2105 Check transaction log contents
2106 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2107 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2108 transaction_context {
2109 server_id: 1
2110- transaction_id: 6
2111+ TRANSACTION_ID
2112 START_TIMESTAMP
2113 END_TIMESTAMP
2114 }
2115
2116=== modified file 'plugin/transaction_log/tests/r/transaction_log_create.result'
2117--- plugin/transaction_log/tests/r/transaction_log_create.result 2010-10-05 08:06:38 +0000
2118+++ plugin/transaction_log/tests/r/transaction_log_create.result 2010-10-31 22:34:08 +0000
2119@@ -1,28 +1,21 @@
2120 Testing simple CREATE
2121 DROP TABLE IF EXISTS t1;
2122 CREATE TABLE t1(a INT NOT NULL, PRIMARY KEY(a));
2123-# check transaction_log
2124-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2125-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2126-transaction.log 275 2 2 1 2 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2127-
2128 Check transaction_log_entries
2129-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2130-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2131-0 TRANSACTION 75
2132-75 TRANSACTION 200
2133+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2134+COUNT(*)
2135+2
2136
2137 Check transaction_log_transactions
2138-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2139-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2140-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2141-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2142+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2143+COUNT(*)
2144+2
2145 Check transaction log contents
2146 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2147 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2148 transaction_context {
2149 server_id: 1
2150- transaction_id: 2
2151+ TRANSACTION_ID
2152 START_TIMESTAMP
2153 END_TIMESTAMP
2154 }
2155@@ -79,28 +72,21 @@
2156 Testing multi-column CREATE
2157 DROP TABLE IF EXISTS t1;
2158 CREATE TABLE t1(a INT NOT NULL, b CHAR, c BLOB, d TEXT, e DATE NOT NULL, f BLOB NOT NULL, PRIMARY KEY(a));
2159-# check transaction_log
2160-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2161-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2162-transaction.log 398 2 2 1 2 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2163-
2164 Check transaction_log_entries
2165-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2166-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2167-0 TRANSACTION 75
2168-75 TRANSACTION 323
2169+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2170+COUNT(*)
2171+2
2172
2173 Check transaction_log_transactions
2174-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2175-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2176-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2177-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2178+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2179+COUNT(*)
2180+2
2181 Check transaction log contents
2182 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2183 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2184 transaction_context {
2185 server_id: 1
2186- transaction_id: 2
2187+ TRANSACTION_ID
2188 START_TIMESTAMP
2189 END_TIMESTAMP
2190 }
2191@@ -209,28 +195,21 @@
2192 Testing CREATE with DEFAULT VALUES
2193 DROP TABLE IF EXISTS t1;
2194 CREATE TABLE t1(a INT NOT NULL, b CHAR(25) NOT NULL DEFAULT 'this_is_a_default_value', PRIMARY KEY(a));
2195-# check transaction_log
2196-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2197-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2198-transaction.log 336 2 2 1 2 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2199-
2200 Check transaction_log_entries
2201-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2202-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2203-0 TRANSACTION 75
2204-75 TRANSACTION 261
2205+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2206+COUNT(*)
2207+2
2208
2209 Check transaction_log_transactions
2210-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2211-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2212-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2213-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2214+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2215+COUNT(*)
2216+2
2217 Check transaction log contents
2218 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2219 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2220 transaction_context {
2221 server_id: 1
2222- transaction_id: 2
2223+ TRANSACTION_ID
2224 START_TIMESTAMP
2225 END_TIMESTAMP
2226 }
2227@@ -302,28 +281,21 @@
2228 Testing CREATE with multi-part key
2229 DROP TABLE IF EXISTS t1;
2230 CREATE TABLE t1(a INT NOT NULL, b CHAR(25) NOT NULL DEFAULT 'this_is_a_default_value', c DATE, d TIMESTAMP, PRIMARY KEY(a,b,d));
2231-# check transaction_log
2232-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2233-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2234-transaction.log 374 2 2 1 2 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2235-
2236 Check transaction_log_entries
2237-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2238-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2239-0 TRANSACTION 75
2240-75 TRANSACTION 299
2241+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2242+COUNT(*)
2243+2
2244
2245 Check transaction_log_transactions
2246-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2247-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2248-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2249-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2250+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2251+COUNT(*)
2252+2
2253 Check transaction log contents
2254 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2255 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2256 transaction_context {
2257 server_id: 1
2258- transaction_id: 2
2259+ TRANSACTION_ID
2260 START_TIMESTAMP
2261 END_TIMESTAMP
2262 }
2263@@ -419,28 +391,21 @@
2264 Testing CREATE with partial key
2265 DROP TABLE IF EXISTS t1;
2266 CREATE TABLE t1(a INT NOT NULL, b CHAR(25) NOT NULL DEFAULT 'this_is_a_default_value', c DATE, d TIMESTAMP, PRIMARY KEY(b(5)));
2267-# check transaction_log
2268-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2269-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2270-transaction.log 364 2 2 1 2 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2271-
2272 Check transaction_log_entries
2273-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2274-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2275-0 TRANSACTION 75
2276-75 TRANSACTION 289
2277+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2278+COUNT(*)
2279+2
2280
2281 Check transaction_log_transactions
2282-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2283-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2284-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2285-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2286+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2287+COUNT(*)
2288+2
2289 Check transaction log contents
2290 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2291 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2292 transaction_context {
2293 server_id: 1
2294- transaction_id: 2
2295+ TRANSACTION_ID
2296 START_TIMESTAMP
2297 END_TIMESTAMP
2298 }
2299@@ -529,28 +494,21 @@
2300 Testing CREATE with multiple keys
2301 DROP TABLE IF EXISTS t1;
2302 CREATE TABLE t1(a INT NOT NULL, b CHAR(25) NOT NULL DEFAULT 'this_is_a_default_value', c DATE, d TIMESTAMP, PRIMARY KEY(b(5)), KEY composite_key(a,b(10),c));
2303-# check transaction_log
2304-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2305-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2306-transaction.log 417 2 2 1 2 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2307-
2308 Check transaction_log_entries
2309-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2310-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2311-0 TRANSACTION 75
2312-75 TRANSACTION 342
2313+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2314+COUNT(*)
2315+2
2316
2317 Check transaction_log_transactions
2318-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2319-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2320-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2321-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2322+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2323+COUNT(*)
2324+2
2325 Check transaction log contents
2326 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2327 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2328 transaction_context {
2329 server_id: 1
2330- transaction_id: 2
2331+ TRANSACTION_ID
2332 START_TIMESTAMP
2333 END_TIMESTAMP
2334 }
2335@@ -664,28 +622,21 @@
2336 Testing CREATE with UNIQUE key
2337 DROP TABLE IF EXISTS t1;
2338 CREATE TABLE t1(a INT NOT NULL, b CHAR(25) NOT NULL DEFAULT 'this_is_a_default_value', c DATE, d TIMESTAMP, PRIMARY KEY(a), UNIQUE KEY unique_key(a,b(20),c));
2339-# check transaction_log
2340-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2341-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2342-transaction.log 408 2 2 1 2 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2343-
2344 Check transaction_log_entries
2345-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2346-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2347-0 TRANSACTION 75
2348-75 TRANSACTION 333
2349+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2350+COUNT(*)
2351+2
2352
2353 Check transaction_log_transactions
2354-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2355-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2356-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2357-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2358+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2359+COUNT(*)
2360+2
2361 Check transaction log contents
2362 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2363 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2364 transaction_context {
2365 server_id: 1
2366- transaction_id: 2
2367+ TRANSACTION_ID
2368 START_TIMESTAMP
2369 END_TIMESTAMP
2370 }
2371@@ -797,28 +748,21 @@
2372 DROP TABLE IF EXISTS t1;
2373 positive test (should pass)
2374 CREATE TABLE IF NOT EXISTS t1(a INT NOT NULL, PRIMARY KEY(a));
2375-# check transaction_log
2376-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2377-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2378-transaction.log 275 2 2 1 2 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2379-
2380 Check transaction_log_entries
2381-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2382-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2383-0 TRANSACTION 75
2384-75 TRANSACTION 200
2385+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2386+COUNT(*)
2387+2
2388
2389 Check transaction_log_transactions
2390-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2391-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2392-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2393-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2394+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2395+COUNT(*)
2396+2
2397 Check transaction log contents
2398 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2399 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2400 transaction_context {
2401 server_id: 1
2402- transaction_id: 2
2403+ TRANSACTION_ID
2404 START_TIMESTAMP
2405 END_TIMESTAMP
2406 }
2407@@ -873,28 +817,21 @@
2408 CREATE TABLE IF NOT EXISTS t1(b CHAR(100) NOT NULL, PRIMARY KEY(b));
2409 Warnings:
2410 Note 1050 Table 't1' already exists
2411-# check transaction_log
2412-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2413-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2414-transaction.log 275 2 2 1 2 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2415-
2416 Check transaction_log_entries
2417-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2418-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2419-0 TRANSACTION 75
2420-75 TRANSACTION 200
2421+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2422+COUNT(*)
2423+2
2424
2425 Check transaction_log_transactions
2426-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2427-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2428-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2429-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2430+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2431+COUNT(*)
2432+2
2433 Check transaction log contents
2434 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2435 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2436 transaction_context {
2437 server_id: 1
2438- transaction_id: 2
2439+ TRANSACTION_ID
2440 START_TIMESTAMP
2441 END_TIMESTAMP
2442 }
2443@@ -951,30 +888,21 @@
2444 Testing Foreign Key constraints
2445 DROP TABLE IF EXISTS t1, t2;
2446 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, PRIMARY KEY(a), KEY b_key1 (b));
2447-# check transaction_log
2448-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2449-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2450-transaction.log 387 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2451-
2452 Check transaction_log_entries
2453-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2454-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2455-0 TRANSACTION 75
2456-75 TRANSACTION 75
2457-150 TRANSACTION 237
2458+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2459+COUNT(*)
2460+3
2461
2462 Check transaction_log_transactions
2463-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2464-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2465-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2466-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2467-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
2468+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2469+COUNT(*)
2470+3
2471 Check transaction log contents
2472 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2473 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2474 transaction_context {
2475 server_id: 1
2476- transaction_id: 3
2477+ TRANSACTION_ID
2478 START_TIMESTAMP
2479 END_TIMESTAMP
2480 }
2481@@ -1047,32 +975,21 @@
2482
2483 CREATE TABLE t2(a INT NOT NULL, b INT , PRIMARY KEY(a), KEY b_key (b),
2484 CONSTRAINT fk_constraint_t2 FOREIGN KEY (b) REFERENCES t1(b) ON DELETE SET NULL ON UPDATE CASCADE);
2485-# check transaction_log
2486-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2487-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2488-transaction.log 661 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2489-
2490 Check transaction_log_entries
2491-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2492-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2493-0 TRANSACTION 75
2494-75 TRANSACTION 75
2495-150 TRANSACTION 237
2496-387 TRANSACTION 274
2497+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2498+COUNT(*)
2499+4
2500
2501 Check transaction_log_transactions
2502-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2503-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2504-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2505-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2506-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
2507-387 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
2508+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2509+COUNT(*)
2510+4
2511 Check transaction log contents
2512 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2513 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2514 transaction_context {
2515 server_id: 1
2516- transaction_id: 4
2517+ TRANSACTION_ID
2518 START_TIMESTAMP
2519 END_TIMESTAMP
2520 }
2521@@ -1160,30 +1077,21 @@
2522 Testing CREATE TABLE...LIKE
2523 DROP TABLE IF EXISTS t1, t2;
2524 CREATE TABLE t1(a INT NOT NULL, b INT NOT NULL, PRIMARY KEY(a), KEY b_key1 (b));
2525-# check transaction_log
2526-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2527-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2528-transaction.log 387 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2529-
2530 Check transaction_log_entries
2531-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2532-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2533-0 TRANSACTION 75
2534-75 TRANSACTION 75
2535-150 TRANSACTION 237
2536+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2537+COUNT(*)
2538+3
2539
2540 Check transaction_log_transactions
2541-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2542-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2543-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2544-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2545-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
2546+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2547+COUNT(*)
2548+3
2549 Check transaction log contents
2550 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2551 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2552 transaction_context {
2553 server_id: 1
2554- transaction_id: 3
2555+ TRANSACTION_ID
2556 START_TIMESTAMP
2557 END_TIMESTAMP
2558 }
2559@@ -1255,32 +1163,21 @@
2560
2561
2562 CREATE TABLE t2 LIKE t1;
2563-# check transaction_log
2564-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2565-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2566-transaction.log 626 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2567-
2568 Check transaction_log_entries
2569-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2570-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2571-0 TRANSACTION 75
2572-75 TRANSACTION 75
2573-150 TRANSACTION 237
2574-387 TRANSACTION 239
2575+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2576+COUNT(*)
2577+4
2578
2579 Check transaction_log_transactions
2580-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2581-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2582-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2583-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2584-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
2585-387 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
2586+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2587+COUNT(*)
2588+4
2589 Check transaction log contents
2590 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2591 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2592 transaction_context {
2593 server_id: 1
2594- transaction_id: 4
2595+ TRANSACTION_ID
2596 START_TIMESTAMP
2597 END_TIMESTAMP
2598 }
2599@@ -1361,30 +1258,21 @@
2600 CREATE TABLE t1(a INT NOT NULL, b CHAR(1000) NOT NULL COLLATE utf8_turkish_ci, c CHAR(10), PRIMARY KEY(a), KEY b_key1 (b));
2601 Warnings:
2602 Warning 1071 Specified key was too long; max key length is 1023 bytes
2603-# check transaction_log
2604-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2605-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2606-transaction.log 454 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2607-
2608 Check transaction_log_entries
2609-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2610-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2611-0 TRANSACTION 75
2612-75 TRANSACTION 75
2613-150 TRANSACTION 304
2614+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2615+COUNT(*)
2616+3
2617
2618 Check transaction_log_transactions
2619-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2620-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2621-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2622-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2623-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
2624+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2625+COUNT(*)
2626+3
2627 Check transaction log contents
2628 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2629 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2630 transaction_context {
2631 server_id: 1
2632- transaction_id: 3
2633+ TRANSACTION_ID
2634 START_TIMESTAMP
2635 END_TIMESTAMP
2636 }
2637@@ -1481,30 +1369,21 @@
2638 Testing collations - table
2639 DROP TABLE IF EXISTS t1, t2;
2640 CREATE TABLE t1(a INT NOT NULL, b CHAR(1000) NOT NULL , c CHAR(1) COLLATE utf8_bin, PRIMARY KEY(a)) COLLATE utf8_turkish_ci;
2641-# check transaction_log
2642-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2643-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2644-transaction.log 414 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2645-
2646 Check transaction_log_entries
2647-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2648-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2649-0 TRANSACTION 75
2650-75 TRANSACTION 75
2651-150 TRANSACTION 264
2652+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2653+COUNT(*)
2654+3
2655
2656 Check transaction_log_transactions
2657-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2658-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2659-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2660-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2661-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
2662+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2663+COUNT(*)
2664+3
2665 Check transaction log contents
2666 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2667 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2668 transaction_context {
2669 server_id: 1
2670- transaction_id: 3
2671+ TRANSACTION_ID
2672 START_TIMESTAMP
2673 END_TIMESTAMP
2674 }
2675@@ -1585,30 +1464,21 @@
2676 Testing charset - column
2677 DROP TABLE IF EXISTS t1, t2;
2678 CREATE TABLE t1(a INT NOT NULL, b BLOB NOT NULL, c CHAR(1) DEFAULT '0', PRIMARY KEY(a));
2679-# check transaction_log
2680-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2681-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2682-transaction.log 408 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2683-
2684 Check transaction_log_entries
2685-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2686-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2687-0 TRANSACTION 75
2688-75 TRANSACTION 75
2689-150 TRANSACTION 258
2690+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2691+COUNT(*)
2692+3
2693
2694 Check transaction_log_transactions
2695-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2696-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2697-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2698-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2699-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
2700+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2701+COUNT(*)
2702+3
2703 Check transaction log contents
2704 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2705 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2706 transaction_context {
2707 server_id: 1
2708- transaction_id: 3
2709+ TRANSACTION_ID
2710 START_TIMESTAMP
2711 END_TIMESTAMP
2712 }
2713@@ -1713,28 +1583,21 @@
2714 , not_null_decimal_field DECIMAL(10,2) NOT NULL
2715 , PRIMARY KEY (autoinc_int_field)
2716 );
2717-# check transaction_log
2718-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2719-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2720-transaction.log 1161 2 2 1 2 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2721-
2722 Check transaction_log_entries
2723-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2724-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2725-0 TRANSACTION 75
2726-75 TRANSACTION 1086
2727+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2728+COUNT(*)
2729+2
2730
2731 Check transaction_log_transactions
2732-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2733-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2734-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2735-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2736+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2737+COUNT(*)
2738+2
2739 Check transaction log contents
2740 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2741 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2742 transaction_context {
2743 server_id: 1
2744- transaction_id: 2
2745+ TRANSACTION_ID
2746 START_TIMESTAMP
2747 END_TIMESTAMP
2748 }
2749@@ -2035,28 +1898,21 @@
2750 , KEY named_key (key2)
2751 , KEY partial_key (key3(30))
2752 );
2753-# check transaction_log
2754-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2755-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2756-transaction.log 451 2 2 1 2 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2757-
2758 Check transaction_log_entries
2759-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2760-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2761-0 TRANSACTION 75
2762-75 TRANSACTION 376
2763+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2764+COUNT(*)
2765+2
2766
2767 Check transaction_log_transactions
2768-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2769-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2770-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2771-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2772+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2773+COUNT(*)
2774+2
2775 Check transaction log contents
2776 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2777 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2778 transaction_context {
2779 server_id: 1
2780- transaction_id: 2
2781+ TRANSACTION_ID
2782 START_TIMESTAMP
2783 END_TIMESTAMP
2784 }
2785
2786=== modified file 'plugin/transaction_log/tests/r/transaction_log_data_type.result'
2787--- plugin/transaction_log/tests/r/transaction_log_data_type.result 2010-10-05 08:06:38 +0000
2788+++ plugin/transaction_log/tests/r/transaction_log_data_type.result 2010-10-31 22:34:08 +0000
2789@@ -4,32 +4,21 @@
2790 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT, b INT, PRIMARY KEY(a));
2791 Testing MIN INT
2792 INSERT INTO t1 (b) VALUES(-2147483648);
2793-# check transaction_log
2794-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2795-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2796-transaction.log 479 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2797-
2798 Check transaction_log_entries
2799-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2800-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2801-0 TRANSACTION 75
2802-75 TRANSACTION 75
2803-150 TRANSACTION 215
2804-365 TRANSACTION 114
2805+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2806+COUNT(*)
2807+4
2808
2809 Check transaction_log_transactions
2810-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2811-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2812-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2813-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2814-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
2815-365 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
2816+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2817+COUNT(*)
2818+4
2819 Check transaction log contents
2820 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2821 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2822 transaction_context {
2823 server_id: 1
2824- transaction_id: 4
2825+ TRANSACTION_ID
2826 START_TIMESTAMP
2827 END_TIMESTAMP
2828 }
2829@@ -67,34 +56,21 @@
2830
2831 Testing MAX INT
2832 INSERT INTO t1 (b) VALUES(2147483647);
2833-# check transaction_log
2834-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2835-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2836-transaction.log 592 5 5 1 5 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2837-
2838 Check transaction_log_entries
2839-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2840-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2841-0 TRANSACTION 75
2842-75 TRANSACTION 75
2843-150 TRANSACTION 215
2844-365 TRANSACTION 114
2845-479 TRANSACTION 113
2846+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2847+COUNT(*)
2848+5
2849
2850 Check transaction_log_transactions
2851-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2852-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2853-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2854-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2855-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
2856-365 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
2857-479 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
2858+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2859+COUNT(*)
2860+5
2861 Check transaction log contents
2862 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2863 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2864 transaction_context {
2865 server_id: 1
2866- transaction_id: 5
2867+ TRANSACTION_ID
2868 START_TIMESTAMP
2869 END_TIMESTAMP
2870 }
2871@@ -133,34 +109,21 @@
2872 Testing MIN-1 INT
2873 INSERT INTO t1 (b) VALUES(-2147483649);
2874 ERROR 22003: Out of range value for column 'b' at row 1
2875-# check transaction_log
2876-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2877-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2878-transaction.log 592 5 5 1 5 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2879-
2880 Check transaction_log_entries
2881-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2882-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2883-0 TRANSACTION 75
2884-75 TRANSACTION 75
2885-150 TRANSACTION 215
2886-365 TRANSACTION 114
2887-479 TRANSACTION 113
2888+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2889+COUNT(*)
2890+5
2891
2892 Check transaction_log_transactions
2893-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2894-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2895-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2896-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2897-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
2898-365 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
2899-479 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
2900+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2901+COUNT(*)
2902+5
2903 Check transaction log contents
2904 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2905 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2906 transaction_context {
2907 server_id: 1
2908- transaction_id: 5
2909+ TRANSACTION_ID
2910 START_TIMESTAMP
2911 END_TIMESTAMP
2912 }
2913@@ -199,34 +162,21 @@
2914 Testing MAX+1 INT
2915 INSERT INTO t1 (b) VALUES(2147483648);
2916 ERROR 22003: Out of range value for column 'b' at row 1
2917-# check transaction_log
2918-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2919-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2920-transaction.log 592 5 5 1 5 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2921-
2922 Check transaction_log_entries
2923-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2924-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2925-0 TRANSACTION 75
2926-75 TRANSACTION 75
2927-150 TRANSACTION 215
2928-365 TRANSACTION 114
2929-479 TRANSACTION 113
2930+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2931+COUNT(*)
2932+5
2933
2934 Check transaction_log_transactions
2935-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2936-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2937-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2938-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2939-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
2940-365 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
2941-479 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
2942+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2943+COUNT(*)
2944+5
2945 Check transaction log contents
2946 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2947 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2948 transaction_context {
2949 server_id: 1
2950- transaction_id: 5
2951+ TRANSACTION_ID
2952 START_TIMESTAMP
2953 END_TIMESTAMP
2954 }
2955@@ -264,36 +214,21 @@
2956
2957 Testing NULL INT
2958 INSERT INTO t1 (b) VALUES(NULL);
2959-# check transaction_log
2960-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
2961-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
2962-transaction.log 695 6 6 1 6 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
2963-
2964 Check transaction_log_entries
2965-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2966-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
2967-0 TRANSACTION 75
2968-75 TRANSACTION 75
2969-150 TRANSACTION 215
2970-365 TRANSACTION 114
2971-479 TRANSACTION 113
2972-592 TRANSACTION 103
2973+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
2974+COUNT(*)
2975+6
2976
2977 Check transaction_log_transactions
2978-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2979-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
2980-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
2981-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
2982-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
2983-365 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
2984-479 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
2985-592 6 1 START_TIMESTAMP END_TIMESTAMP 1 0
2986+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
2987+COUNT(*)
2988+6
2989 Check transaction log contents
2990 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
2991 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
2992 transaction_context {
2993 server_id: 1
2994- transaction_id: 6
2995+ TRANSACTION_ID
2996 START_TIMESTAMP
2997 END_TIMESTAMP
2998 }
2999@@ -332,36 +267,21 @@
3000 Testing BAD INPUT INT1
3001 INSERT INTO t1 (b) VALUES('abbazabba');
3002 ERROR HY000: Incorrect integer value: 'abbazabba' for column 'b' at row 1
3003-# check transaction_log
3004-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3005-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3006-transaction.log 695 6 6 1 6 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3007-
3008 Check transaction_log_entries
3009-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3010-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3011-0 TRANSACTION 75
3012-75 TRANSACTION 75
3013-150 TRANSACTION 215
3014-365 TRANSACTION 114
3015-479 TRANSACTION 113
3016-592 TRANSACTION 103
3017+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3018+COUNT(*)
3019+6
3020
3021 Check transaction_log_transactions
3022-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3023-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3024-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3025-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3026-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3027-365 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3028-479 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
3029-592 6 1 START_TIMESTAMP END_TIMESTAMP 1 0
3030+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3031+COUNT(*)
3032+6
3033 Check transaction log contents
3034 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3035 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3036 transaction_context {
3037 server_id: 1
3038- transaction_id: 6
3039+ TRANSACTION_ID
3040 START_TIMESTAMP
3041 END_TIMESTAMP
3042 }
3043@@ -400,36 +320,21 @@
3044 Testing BAD INPUT INT2
3045 INSERT INTO t1 (b) VALUES('a');
3046 ERROR HY000: Incorrect integer value: 'a' for column 'b' at row 1
3047-# check transaction_log
3048-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3049-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3050-transaction.log 695 6 6 1 6 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3051-
3052 Check transaction_log_entries
3053-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3054-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3055-0 TRANSACTION 75
3056-75 TRANSACTION 75
3057-150 TRANSACTION 215
3058-365 TRANSACTION 114
3059-479 TRANSACTION 113
3060-592 TRANSACTION 103
3061+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3062+COUNT(*)
3063+6
3064
3065 Check transaction_log_transactions
3066-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3067-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3068-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3069-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3070-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3071-365 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3072-479 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
3073-592 6 1 START_TIMESTAMP END_TIMESTAMP 1 0
3074+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3075+COUNT(*)
3076+6
3077 Check transaction log contents
3078 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3079 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3080 transaction_context {
3081 server_id: 1
3082- transaction_id: 6
3083+ TRANSACTION_ID
3084 START_TIMESTAMP
3085 END_TIMESTAMP
3086 }
3087@@ -467,38 +372,21 @@
3088
3089 Testing MULTI_INSERT INT
3090 INSERT INTO t1 (b) VALUES(1),(1),(2),(3),(5);
3091-# check transaction_log
3092-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3093-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3094-transaction.log 847 7 7 1 7 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3095-
3096 Check transaction_log_entries
3097-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3098-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3099-0 TRANSACTION 75
3100-75 TRANSACTION 75
3101-150 TRANSACTION 215
3102-365 TRANSACTION 114
3103-479 TRANSACTION 113
3104-592 TRANSACTION 103
3105-695 TRANSACTION 152
3106+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3107+COUNT(*)
3108+7
3109
3110 Check transaction_log_transactions
3111-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3112-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3113-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3114-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3115-150 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3116-365 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3117-479 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
3118-592 6 1 START_TIMESTAMP END_TIMESTAMP 1 0
3119-695 7 1 START_TIMESTAMP END_TIMESTAMP 1 0
3120+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3121+COUNT(*)
3122+7
3123 Check transaction log contents
3124 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3125 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3126 transaction_context {
3127 server_id: 1
3128- transaction_id: 7
3129+ TRANSACTION_ID
3130 START_TIMESTAMP
3131 END_TIMESTAMP
3132 }
3133@@ -566,30 +454,21 @@
3134 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT, b BIGINT, PRIMARY KEY(a));
3135 Testing MIN BIGINT
3136 INSERT INTO t1 (b) VALUES(-9223372036854775808);
3137-# check transaction_log
3138-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3139-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3140-transaction.log 413 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3141-
3142 Check transaction_log_entries
3143-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3144-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3145-0 TRANSACTION 75
3146-75 TRANSACTION 215
3147-290 TRANSACTION 123
3148+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3149+COUNT(*)
3150+3
3151
3152 Check transaction_log_transactions
3153-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3154-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3155-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3156-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3157-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3158+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3159+COUNT(*)
3160+3
3161 Check transaction log contents
3162 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3163 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3164 transaction_context {
3165 server_id: 1
3166- transaction_id: 3
3167+ TRANSACTION_ID
3168 START_TIMESTAMP
3169 END_TIMESTAMP
3170 }
3171@@ -627,32 +506,21 @@
3172
3173 Testing MAX BIGINT
3174 INSERT INTO t1 (b) VALUES(9223372036854775807);
3175-# check transaction_log
3176-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3177-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3178-transaction.log 535 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3179-
3180 Check transaction_log_entries
3181-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3182-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3183-0 TRANSACTION 75
3184-75 TRANSACTION 215
3185-290 TRANSACTION 123
3186-413 TRANSACTION 122
3187+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3188+COUNT(*)
3189+4
3190
3191 Check transaction_log_transactions
3192-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3193-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3194-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3195-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3196-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3197-413 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3198+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3199+COUNT(*)
3200+4
3201 Check transaction log contents
3202 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3203 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3204 transaction_context {
3205 server_id: 1
3206- transaction_id: 4
3207+ TRANSACTION_ID
3208 START_TIMESTAMP
3209 END_TIMESTAMP
3210 }
3211@@ -691,32 +559,21 @@
3212 Testing MIN-1 BIGINT
3213 INSERT INTO t1 (b) VALUES(-9223372036854775809);
3214 ERROR 22003: Out of range value for column 'b' at row 1
3215-# check transaction_log
3216-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3217-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3218-transaction.log 535 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3219-
3220 Check transaction_log_entries
3221-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3222-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3223-0 TRANSACTION 75
3224-75 TRANSACTION 215
3225-290 TRANSACTION 123
3226-413 TRANSACTION 122
3227+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3228+COUNT(*)
3229+4
3230
3231 Check transaction_log_transactions
3232-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3233-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3234-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3235-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3236-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3237-413 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3238+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3239+COUNT(*)
3240+4
3241 Check transaction log contents
3242 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3243 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3244 transaction_context {
3245 server_id: 1
3246- transaction_id: 4
3247+ TRANSACTION_ID
3248 START_TIMESTAMP
3249 END_TIMESTAMP
3250 }
3251@@ -755,34 +612,21 @@
3252 Testing MAX+1 BIGINT
3253 NOTE: Bug#316221 - 2**63 incorrectly inserted into bigint
3254 INSERT INTO t1 (b) VALUES(9223372036854775808);
3255-# check transaction_log
3256-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3257-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3258-transaction.log 658 5 5 1 5 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3259-
3260 Check transaction_log_entries
3261-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3262-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3263-0 TRANSACTION 75
3264-75 TRANSACTION 215
3265-290 TRANSACTION 123
3266-413 TRANSACTION 122
3267-535 TRANSACTION 123
3268+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3269+COUNT(*)
3270+5
3271
3272 Check transaction_log_transactions
3273-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3274-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3275-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3276-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3277-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3278-413 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3279-535 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
3280+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3281+COUNT(*)
3282+5
3283 Check transaction log contents
3284 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3285 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3286 transaction_context {
3287 server_id: 1
3288- transaction_id: 5
3289+ TRANSACTION_ID
3290 START_TIMESTAMP
3291 END_TIMESTAMP
3292 }
3293@@ -820,36 +664,21 @@
3294
3295 Testing NULL BIGINT
3296 INSERT INTO t1 (b) VALUES(NULL);
3297-# check transaction_log
3298-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3299-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3300-transaction.log 761 6 6 1 6 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3301-
3302 Check transaction_log_entries
3303-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3304-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3305-0 TRANSACTION 75
3306-75 TRANSACTION 215
3307-290 TRANSACTION 123
3308-413 TRANSACTION 122
3309-535 TRANSACTION 123
3310-658 TRANSACTION 103
3311+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3312+COUNT(*)
3313+6
3314
3315 Check transaction_log_transactions
3316-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3317-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3318-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3319-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3320-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3321-413 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3322-535 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
3323-658 6 1 START_TIMESTAMP END_TIMESTAMP 1 0
3324+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3325+COUNT(*)
3326+6
3327 Check transaction log contents
3328 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3329 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3330 transaction_context {
3331 server_id: 1
3332- transaction_id: 6
3333+ TRANSACTION_ID
3334 START_TIMESTAMP
3335 END_TIMESTAMP
3336 }
3337@@ -888,36 +717,21 @@
3338 Testing BAD INPUT BIGINT1
3339 INSERT INTO t1 (b) VALUES('abbazabba');
3340 ERROR HY000: Incorrect integer value: 'abbazabba' for column 'b' at row 1
3341-# check transaction_log
3342-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3343-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3344-transaction.log 761 6 6 1 6 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3345-
3346 Check transaction_log_entries
3347-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3348-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3349-0 TRANSACTION 75
3350-75 TRANSACTION 215
3351-290 TRANSACTION 123
3352-413 TRANSACTION 122
3353-535 TRANSACTION 123
3354-658 TRANSACTION 103
3355+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3356+COUNT(*)
3357+6
3358
3359 Check transaction_log_transactions
3360-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3361-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3362-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3363-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3364-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3365-413 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3366-535 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
3367-658 6 1 START_TIMESTAMP END_TIMESTAMP 1 0
3368+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3369+COUNT(*)
3370+6
3371 Check transaction log contents
3372 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3373 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3374 transaction_context {
3375 server_id: 1
3376- transaction_id: 6
3377+ TRANSACTION_ID
3378 START_TIMESTAMP
3379 END_TIMESTAMP
3380 }
3381@@ -956,36 +770,21 @@
3382 Testing BAD INPUT BIGINT2
3383 INSERT INTO t1 (b) VALUES('a');
3384 ERROR HY000: Incorrect integer value: 'a' for column 'b' at row 1
3385-# check transaction_log
3386-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3387-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3388-transaction.log 761 6 6 1 6 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3389-
3390 Check transaction_log_entries
3391-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3392-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3393-0 TRANSACTION 75
3394-75 TRANSACTION 215
3395-290 TRANSACTION 123
3396-413 TRANSACTION 122
3397-535 TRANSACTION 123
3398-658 TRANSACTION 103
3399+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3400+COUNT(*)
3401+6
3402
3403 Check transaction_log_transactions
3404-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3405-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3406-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3407-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3408-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3409-413 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3410-535 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
3411-658 6 1 START_TIMESTAMP END_TIMESTAMP 1 0
3412+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3413+COUNT(*)
3414+6
3415 Check transaction log contents
3416 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3417 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3418 transaction_context {
3419 server_id: 1
3420- transaction_id: 6
3421+ TRANSACTION_ID
3422 START_TIMESTAMP
3423 END_TIMESTAMP
3424 }
3425@@ -1030,30 +829,21 @@
3426 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT, b DECIMAL(5,2), PRIMARY KEY(a));
3427 Testing MIN DECIMAL simple
3428 INSERT INTO t1 (b) VALUES(-999.99);
3429-# check transaction_log
3430-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3431-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3432-transaction.log 406 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3433-
3434 Check transaction_log_entries
3435-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3436-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3437-0 TRANSACTION 75
3438-75 TRANSACTION 221
3439-296 TRANSACTION 110
3440+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3441+COUNT(*)
3442+3
3443
3444 Check transaction_log_transactions
3445-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3446-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3447-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3448-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3449-296 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3450+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3451+COUNT(*)
3452+3
3453 Check transaction log contents
3454 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3455 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3456 transaction_context {
3457 server_id: 1
3458- transaction_id: 3
3459+ TRANSACTION_ID
3460 START_TIMESTAMP
3461 END_TIMESTAMP
3462 }
3463@@ -1091,32 +881,21 @@
3464
3465 Testing MAX DECIMAL simple
3466 INSERT INTO t1 (b) VALUES(999.99);
3467-# check transaction_log
3468-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3469-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3470-transaction.log 515 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3471-
3472 Check transaction_log_entries
3473-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3474-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3475-0 TRANSACTION 75
3476-75 TRANSACTION 221
3477-296 TRANSACTION 110
3478-406 TRANSACTION 109
3479+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3480+COUNT(*)
3481+4
3482
3483 Check transaction_log_transactions
3484-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3485-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3486-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3487-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3488-296 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3489-406 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3490+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3491+COUNT(*)
3492+4
3493 Check transaction log contents
3494 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3495 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3496 transaction_context {
3497 server_id: 1
3498- transaction_id: 4
3499+ TRANSACTION_ID
3500 START_TIMESTAMP
3501 END_TIMESTAMP
3502 }
3503@@ -1155,32 +934,21 @@
3504 Testing MIN-1 DECIMAL simple
3505 INSERT INTO t1 (b) VALUES(-1000);
3506 ERROR 22003: Out of range value for column 'b' at row 1
3507-# check transaction_log
3508-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3509-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3510-transaction.log 515 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3511-
3512 Check transaction_log_entries
3513-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3514-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3515-0 TRANSACTION 75
3516-75 TRANSACTION 221
3517-296 TRANSACTION 110
3518-406 TRANSACTION 109
3519+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3520+COUNT(*)
3521+4
3522
3523 Check transaction_log_transactions
3524-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3525-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3526-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3527-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3528-296 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3529-406 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3530+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3531+COUNT(*)
3532+4
3533 Check transaction log contents
3534 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3535 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3536 transaction_context {
3537 server_id: 1
3538- transaction_id: 4
3539+ TRANSACTION_ID
3540 START_TIMESTAMP
3541 END_TIMESTAMP
3542 }
3543@@ -1219,32 +987,21 @@
3544 Testing MAX+1 DECIMAL simple
3545 INSERT INTO t1 (b) VALUES(1000);
3546 ERROR 22003: Out of range value for column 'b' at row 1
3547-# check transaction_log
3548-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3549-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3550-transaction.log 515 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3551-
3552 Check transaction_log_entries
3553-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3554-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3555-0 TRANSACTION 75
3556-75 TRANSACTION 221
3557-296 TRANSACTION 110
3558-406 TRANSACTION 109
3559+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3560+COUNT(*)
3561+4
3562
3563 Check transaction_log_transactions
3564-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3565-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3566-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3567-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3568-296 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3569-406 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3570+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3571+COUNT(*)
3572+4
3573 Check transaction log contents
3574 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3575 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3576 transaction_context {
3577 server_id: 1
3578- transaction_id: 4
3579+ TRANSACTION_ID
3580 START_TIMESTAMP
3581 END_TIMESTAMP
3582 }
3583@@ -1282,34 +1039,21 @@
3584
3585 Testing NULL DECIMAL simple
3586 INSERT INTO t1 (b) VALUES(NULL);
3587-# check transaction_log
3588-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3589-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3590-transaction.log 618 5 5 1 5 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3591-
3592 Check transaction_log_entries
3593-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3594-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3595-0 TRANSACTION 75
3596-75 TRANSACTION 221
3597-296 TRANSACTION 110
3598-406 TRANSACTION 109
3599-515 TRANSACTION 103
3600+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3601+COUNT(*)
3602+5
3603
3604 Check transaction_log_transactions
3605-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3606-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3607-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3608-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3609-296 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3610-406 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3611-515 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
3612+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3613+COUNT(*)
3614+5
3615 Check transaction log contents
3616 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3617 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3618 transaction_context {
3619 server_id: 1
3620- transaction_id: 5
3621+ TRANSACTION_ID
3622 START_TIMESTAMP
3623 END_TIMESTAMP
3624 }
3625@@ -1348,34 +1092,21 @@
3626 Testing BAD INPUT DECIMAL simple
3627 INSERT INTO t1 (b) VALUES('abbazabba');
3628 ERROR HY000: Incorrect decimal value: 'abbazabba' for column 'b' at row 1
3629-# check transaction_log
3630-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3631-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3632-transaction.log 618 5 5 1 5 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3633-
3634 Check transaction_log_entries
3635-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3636-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3637-0 TRANSACTION 75
3638-75 TRANSACTION 221
3639-296 TRANSACTION 110
3640-406 TRANSACTION 109
3641-515 TRANSACTION 103
3642+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3643+COUNT(*)
3644+5
3645
3646 Check transaction_log_transactions
3647-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3648-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3649-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3650-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3651-296 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3652-406 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3653-515 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
3654+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3655+COUNT(*)
3656+5
3657 Check transaction log contents
3658 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3659 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3660 transaction_context {
3661 server_id: 1
3662- transaction_id: 5
3663+ TRANSACTION_ID
3664 START_TIMESTAMP
3665 END_TIMESTAMP
3666 }
3667@@ -1414,34 +1145,21 @@
3668 Testing BAD INPUT DECIMAL simple2
3669 INSERT INTO t1 (b) VALUES('a');
3670 ERROR HY000: Incorrect decimal value: 'a' for column 'b' at row 1
3671-# check transaction_log
3672-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3673-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3674-transaction.log 618 5 5 1 5 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3675-
3676 Check transaction_log_entries
3677-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3678-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3679-0 TRANSACTION 75
3680-75 TRANSACTION 221
3681-296 TRANSACTION 110
3682-406 TRANSACTION 109
3683-515 TRANSACTION 103
3684+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3685+COUNT(*)
3686+5
3687
3688 Check transaction_log_transactions
3689-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3690-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3691-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3692-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3693-296 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3694-406 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3695-515 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
3696+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3697+COUNT(*)
3698+5
3699 Check transaction log contents
3700 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3701 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3702 transaction_context {
3703 server_id: 1
3704- transaction_id: 5
3705+ TRANSACTION_ID
3706 START_TIMESTAMP
3707 END_TIMESTAMP
3708 }
3709@@ -1479,36 +1197,21 @@
3710
3711 Testing misc DECIMAL simple
3712 INSERT INTO t1 (b) VALUES(100);
3713-# check transaction_log
3714-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3715-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3716-transaction.log 727 6 6 1 6 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3717-
3718 Check transaction_log_entries
3719-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3720-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3721-0 TRANSACTION 75
3722-75 TRANSACTION 221
3723-296 TRANSACTION 110
3724-406 TRANSACTION 109
3725-515 TRANSACTION 103
3726-618 TRANSACTION 109
3727+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3728+COUNT(*)
3729+6
3730
3731 Check transaction_log_transactions
3732-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3733-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3734-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3735-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3736-296 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3737-406 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3738-515 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
3739-618 6 1 START_TIMESTAMP END_TIMESTAMP 1 0
3740+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3741+COUNT(*)
3742+6
3743 Check transaction log contents
3744 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3745 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3746 transaction_context {
3747 server_id: 1
3748- transaction_id: 6
3749+ TRANSACTION_ID
3750 START_TIMESTAMP
3751 END_TIMESTAMP
3752 }
3753@@ -1547,36 +1250,21 @@
3754 Testing misc DECIMAL simple2
3755 INSERT INTO t1 (b) VALUES(.0898);
3756 ERROR 01000: Data truncated for column 'b' at row 1
3757-# check transaction_log
3758-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3759-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3760-transaction.log 727 6 6 1 6 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3761-
3762 Check transaction_log_entries
3763-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3764-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3765-0 TRANSACTION 75
3766-75 TRANSACTION 221
3767-296 TRANSACTION 110
3768-406 TRANSACTION 109
3769-515 TRANSACTION 103
3770-618 TRANSACTION 109
3771+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3772+COUNT(*)
3773+6
3774
3775 Check transaction_log_transactions
3776-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3777-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3778-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3779-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3780-296 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3781-406 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3782-515 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
3783-618 6 1 START_TIMESTAMP END_TIMESTAMP 1 0
3784+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3785+COUNT(*)
3786+6
3787 Check transaction log contents
3788 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3789 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3790 transaction_context {
3791 server_id: 1
3792- transaction_id: 6
3793+ TRANSACTION_ID
3794 START_TIMESTAMP
3795 END_TIMESTAMP
3796 }
3797@@ -1614,38 +1302,21 @@
3798
3799 Testing misc DECIMAL simple3
3800 INSERT INTO t1 (b) VALUES(.1);
3801-# check transaction_log
3802-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3803-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3804-transaction.log 834 7 7 1 7 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3805-
3806 Check transaction_log_entries
3807-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3808-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3809-0 TRANSACTION 75
3810-75 TRANSACTION 221
3811-296 TRANSACTION 110
3812-406 TRANSACTION 109
3813-515 TRANSACTION 103
3814-618 TRANSACTION 109
3815-727 TRANSACTION 107
3816+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3817+COUNT(*)
3818+7
3819
3820 Check transaction_log_transactions
3821-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3822-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3823-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3824-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3825-296 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3826-406 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3827-515 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
3828-618 6 1 START_TIMESTAMP END_TIMESTAMP 1 0
3829-727 7 1 START_TIMESTAMP END_TIMESTAMP 1 0
3830+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3831+COUNT(*)
3832+7
3833 Check transaction log contents
3834 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3835 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3836 transaction_context {
3837 server_id: 1
3838- transaction_id: 7
3839+ TRANSACTION_ID
3840 START_TIMESTAMP
3841 END_TIMESTAMP
3842 }
3843@@ -1690,30 +1361,21 @@
3844 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT, b FLOAT(5,2), PRIMARY KEY(a));
3845 Testing MIN FLOAT simple
3846 INSERT INTO t1 (b) VALUES(-999.99);
3847-# check transaction_log
3848-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3849-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3850-transaction.log 406 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3851-
3852 Check transaction_log_entries
3853-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3854-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3855-0 TRANSACTION 75
3856-75 TRANSACTION 221
3857-296 TRANSACTION 110
3858+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3859+COUNT(*)
3860+3
3861
3862 Check transaction_log_transactions
3863-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3864-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3865-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3866-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3867-296 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3868+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3869+COUNT(*)
3870+3
3871 Check transaction log contents
3872 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3873 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3874 transaction_context {
3875 server_id: 1
3876- transaction_id: 3
3877+ TRANSACTION_ID
3878 START_TIMESTAMP
3879 END_TIMESTAMP
3880 }
3881@@ -1751,32 +1413,21 @@
3882
3883 Testing MAX FLOAT simple
3884 INSERT INTO t1 (b) VALUES(999.99);
3885-# check transaction_log
3886-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3887-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3888-transaction.log 515 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3889-
3890 Check transaction_log_entries
3891-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3892-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3893-0 TRANSACTION 75
3894-75 TRANSACTION 221
3895-296 TRANSACTION 110
3896-406 TRANSACTION 109
3897+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3898+COUNT(*)
3899+4
3900
3901 Check transaction_log_transactions
3902-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3903-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3904-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3905-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3906-296 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3907-406 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3908+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3909+COUNT(*)
3910+4
3911 Check transaction log contents
3912 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3913 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3914 transaction_context {
3915 server_id: 1
3916- transaction_id: 4
3917+ TRANSACTION_ID
3918 START_TIMESTAMP
3919 END_TIMESTAMP
3920 }
3921@@ -1815,32 +1466,21 @@
3922 Testing MIN-1 FLOAT simple
3923 INSERT INTO t1 (b) VALUES(-1000);
3924 ERROR 22003: Out of range value for column 'b' at row 1
3925-# check transaction_log
3926-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3927-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3928-transaction.log 515 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3929-
3930 Check transaction_log_entries
3931-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3932-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3933-0 TRANSACTION 75
3934-75 TRANSACTION 221
3935-296 TRANSACTION 110
3936-406 TRANSACTION 109
3937+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3938+COUNT(*)
3939+4
3940
3941 Check transaction_log_transactions
3942-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3943-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3944-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3945-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3946-296 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3947-406 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3948+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3949+COUNT(*)
3950+4
3951 Check transaction log contents
3952 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3953 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3954 transaction_context {
3955 server_id: 1
3956- transaction_id: 4
3957+ TRANSACTION_ID
3958 START_TIMESTAMP
3959 END_TIMESTAMP
3960 }
3961@@ -1879,32 +1519,21 @@
3962 Testing MAX+1 FLOAT simple
3963 INSERT INTO t1 (b) VALUES(1000);
3964 ERROR 22003: Out of range value for column 'b' at row 1
3965-# check transaction_log
3966-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
3967-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
3968-transaction.log 515 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
3969-
3970 Check transaction_log_entries
3971-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3972-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
3973-0 TRANSACTION 75
3974-75 TRANSACTION 221
3975-296 TRANSACTION 110
3976-406 TRANSACTION 109
3977+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
3978+COUNT(*)
3979+4
3980
3981 Check transaction_log_transactions
3982-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3983-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
3984-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
3985-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
3986-296 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
3987-406 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
3988+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
3989+COUNT(*)
3990+4
3991 Check transaction log contents
3992 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
3993 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
3994 transaction_context {
3995 server_id: 1
3996- transaction_id: 4
3997+ TRANSACTION_ID
3998 START_TIMESTAMP
3999 END_TIMESTAMP
4000 }
4001@@ -1942,34 +1571,21 @@
4002
4003 Testing NULL FLOAT simple
4004 INSERT INTO t1 (b) VALUES(NULL);
4005-# check transaction_log
4006-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4007-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4008-transaction.log 618 5 5 1 5 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4009-
4010 Check transaction_log_entries
4011-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4012-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4013-0 TRANSACTION 75
4014-75 TRANSACTION 221
4015-296 TRANSACTION 110
4016-406 TRANSACTION 109
4017-515 TRANSACTION 103
4018+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4019+COUNT(*)
4020+5
4021
4022 Check transaction_log_transactions
4023-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4024-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4025-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4026-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4027-296 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4028-406 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4029-515 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
4030+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4031+COUNT(*)
4032+5
4033 Check transaction log contents
4034 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4035 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4036 transaction_context {
4037 server_id: 1
4038- transaction_id: 5
4039+ TRANSACTION_ID
4040 START_TIMESTAMP
4041 END_TIMESTAMP
4042 }
4043@@ -2008,34 +1624,21 @@
4044 Testing BAD INPUT FLOAT simple
4045 INSERT INTO t1 (b) VALUES('abbazabba');
4046 ERROR 01000: Data truncated for column 'b' at row 1
4047-# check transaction_log
4048-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4049-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4050-transaction.log 618 5 5 1 5 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4051-
4052 Check transaction_log_entries
4053-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4054-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4055-0 TRANSACTION 75
4056-75 TRANSACTION 221
4057-296 TRANSACTION 110
4058-406 TRANSACTION 109
4059-515 TRANSACTION 103
4060+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4061+COUNT(*)
4062+5
4063
4064 Check transaction_log_transactions
4065-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4066-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4067-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4068-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4069-296 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4070-406 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4071-515 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
4072+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4073+COUNT(*)
4074+5
4075 Check transaction log contents
4076 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4077 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4078 transaction_context {
4079 server_id: 1
4080- transaction_id: 5
4081+ TRANSACTION_ID
4082 START_TIMESTAMP
4083 END_TIMESTAMP
4084 }
4085@@ -2080,30 +1683,21 @@
4086 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT, b CHAR(10), PRIMARY KEY(a));
4087 Testing MIN CHAR simple
4088 INSERT INTO t1 (b) VALUES("");
4089-# check transaction_log
4090-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4091-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4092-transaction.log 416 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4093-
4094 Check transaction_log_entries
4095-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4096-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4097-0 TRANSACTION 75
4098-75 TRANSACTION 238
4099-313 TRANSACTION 103
4100+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4101+COUNT(*)
4102+3
4103
4104 Check transaction_log_transactions
4105-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4106-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4107-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4108-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4109-313 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4110+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4111+COUNT(*)
4112+3
4113 Check transaction log contents
4114 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4115 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4116 transaction_context {
4117 server_id: 1
4118- transaction_id: 3
4119+ TRANSACTION_ID
4120 START_TIMESTAMP
4121 END_TIMESTAMP
4122 }
4123@@ -2141,32 +1735,21 @@
4124
4125 Testing MAX CHAR simple
4126 INSERT INTO t1 (b) VALUES("zzzzzzzzzz");
4127-# check transaction_log
4128-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4129-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4130-transaction.log 529 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4131-
4132 Check transaction_log_entries
4133-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4134-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4135-0 TRANSACTION 75
4136-75 TRANSACTION 238
4137-313 TRANSACTION 103
4138-416 TRANSACTION 113
4139+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4140+COUNT(*)
4141+4
4142
4143 Check transaction_log_transactions
4144-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4145-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4146-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4147-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4148-313 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4149-416 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4150+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4151+COUNT(*)
4152+4
4153 Check transaction log contents
4154 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4155 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4156 transaction_context {
4157 server_id: 1
4158- transaction_id: 4
4159+ TRANSACTION_ID
4160 START_TIMESTAMP
4161 END_TIMESTAMP
4162 }
4163@@ -2205,32 +1788,21 @@
4164 Testing MAX+1 CHAR simple
4165 INSERT INTO t1 (b) VALUES('zzzzzzzzzzz');
4166 ERROR 22001: Data too long for column 'b' at row 1
4167-# check transaction_log
4168-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4169-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4170-transaction.log 529 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4171-
4172 Check transaction_log_entries
4173-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4174-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4175-0 TRANSACTION 75
4176-75 TRANSACTION 238
4177-313 TRANSACTION 103
4178-416 TRANSACTION 113
4179+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4180+COUNT(*)
4181+4
4182
4183 Check transaction_log_transactions
4184-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4185-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4186-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4187-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4188-313 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4189-416 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4190+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4191+COUNT(*)
4192+4
4193 Check transaction log contents
4194 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4195 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4196 transaction_context {
4197 server_id: 1
4198- transaction_id: 4
4199+ TRANSACTION_ID
4200 START_TIMESTAMP
4201 END_TIMESTAMP
4202 }
4203@@ -2268,34 +1840,21 @@
4204
4205 Testing NULL CHAR simple
4206 INSERT INTO t1 (b) VALUES(NULL);
4207-# check transaction_log
4208-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4209-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4210-transaction.log 632 5 5 1 5 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4211-
4212 Check transaction_log_entries
4213-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4214-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4215-0 TRANSACTION 75
4216-75 TRANSACTION 238
4217-313 TRANSACTION 103
4218-416 TRANSACTION 113
4219-529 TRANSACTION 103
4220+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4221+COUNT(*)
4222+5
4223
4224 Check transaction_log_transactions
4225-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4226-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4227-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4228-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4229-313 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4230-416 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4231-529 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
4232+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4233+COUNT(*)
4234+5
4235 Check transaction log contents
4236 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4237 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4238 transaction_context {
4239 server_id: 1
4240- transaction_id: 5
4241+ TRANSACTION_ID
4242 START_TIMESTAMP
4243 END_TIMESTAMP
4244 }
4245@@ -2333,36 +1892,21 @@
4246
4247 Testing NUMERIC INPUT CHAR simple
4248 INSERT INTO t1 (b) VALUES(1000000);
4249-# check transaction_log
4250-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4251-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4252-transaction.log 742 6 6 1 6 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4253-
4254 Check transaction_log_entries
4255-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4256-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4257-0 TRANSACTION 75
4258-75 TRANSACTION 238
4259-313 TRANSACTION 103
4260-416 TRANSACTION 113
4261-529 TRANSACTION 103
4262-632 TRANSACTION 110
4263+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4264+COUNT(*)
4265+6
4266
4267 Check transaction_log_transactions
4268-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4269-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4270-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4271-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4272-313 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4273-416 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4274-529 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
4275-632 6 1 START_TIMESTAMP END_TIMESTAMP 1 0
4276+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4277+COUNT(*)
4278+6
4279 Check transaction log contents
4280 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4281 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4282 transaction_context {
4283 server_id: 1
4284- transaction_id: 6
4285+ TRANSACTION_ID
4286 START_TIMESTAMP
4287 END_TIMESTAMP
4288 }
4289@@ -2407,30 +1951,21 @@
4290 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT, b ENUM('1','2','3','4','5'), PRIMARY KEY(a));
4291 Testing MIN ENUM simple
4292 INSERT INTO t1 (b) VALUES(1);
4293-# check transaction_log
4294-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4295-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4296-transaction.log 431 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4297-
4298 Check transaction_log_entries
4299-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4300-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4301-0 TRANSACTION 75
4302-75 TRANSACTION 252
4303-327 TRANSACTION 104
4304+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4305+COUNT(*)
4306+3
4307
4308 Check transaction_log_transactions
4309-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4310-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4311-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4312-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4313-327 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4314+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4315+COUNT(*)
4316+3
4317 Check transaction log contents
4318 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4319 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4320 transaction_context {
4321 server_id: 1
4322- transaction_id: 3
4323+ TRANSACTION_ID
4324 START_TIMESTAMP
4325 END_TIMESTAMP
4326 }
4327@@ -2468,32 +2003,21 @@
4328
4329 Testing MAX ENUM simple
4330 INSERT INTO t1 (b) VALUES(5);
4331-# check transaction_log
4332-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4333-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4334-transaction.log 535 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4335-
4336 Check transaction_log_entries
4337-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4338-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4339-0 TRANSACTION 75
4340-75 TRANSACTION 252
4341-327 TRANSACTION 104
4342-431 TRANSACTION 104
4343+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4344+COUNT(*)
4345+4
4346
4347 Check transaction_log_transactions
4348-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4349-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4350-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4351-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4352-327 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4353-431 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4354+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4355+COUNT(*)
4356+4
4357 Check transaction log contents
4358 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4359 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4360 transaction_context {
4361 server_id: 1
4362- transaction_id: 4
4363+ TRANSACTION_ID
4364 START_TIMESTAMP
4365 END_TIMESTAMP
4366 }
4367@@ -2532,32 +2056,21 @@
4368 Testing BAD INPUT ENUM simple
4369 INSERT INTO t1 (b) VALUES(6);
4370 ERROR HY000: Received an invalid enum value '6'.
4371-# check transaction_log
4372-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4373-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4374-transaction.log 535 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4375-
4376 Check transaction_log_entries
4377-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4378-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4379-0 TRANSACTION 75
4380-75 TRANSACTION 252
4381-327 TRANSACTION 104
4382-431 TRANSACTION 104
4383+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4384+COUNT(*)
4385+4
4386
4387 Check transaction_log_transactions
4388-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4389-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4390-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4391-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4392-327 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4393-431 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4394+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4395+COUNT(*)
4396+4
4397 Check transaction log contents
4398 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4399 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4400 transaction_context {
4401 server_id: 1
4402- transaction_id: 4
4403+ TRANSACTION_ID
4404 START_TIMESTAMP
4405 END_TIMESTAMP
4406 }
4407@@ -2595,34 +2108,21 @@
4408
4409 Testing NULL ENUM simple
4410 INSERT INTO t1 (b) VALUES(NULL);
4411-# check transaction_log
4412-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4413-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4414-transaction.log 638 5 5 1 5 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4415-
4416 Check transaction_log_entries
4417-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4418-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4419-0 TRANSACTION 75
4420-75 TRANSACTION 252
4421-327 TRANSACTION 104
4422-431 TRANSACTION 104
4423-535 TRANSACTION 103
4424+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4425+COUNT(*)
4426+5
4427
4428 Check transaction_log_transactions
4429-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4430-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4431-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4432-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4433-327 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4434-431 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4435-535 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
4436+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4437+COUNT(*)
4438+5
4439 Check transaction log contents
4440 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4441 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4442 transaction_context {
4443 server_id: 1
4444- transaction_id: 5
4445+ TRANSACTION_ID
4446 START_TIMESTAMP
4447 END_TIMESTAMP
4448 }
4449@@ -2667,30 +2167,21 @@
4450 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT, b DATE, PRIMARY KEY(a));
4451 Testing MIN DATE
4452 INSERT INTO t1 (b) VALUES('0001-01-01');
4453-# check transaction_log
4454-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4455-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4456-transaction.log 403 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4457-
4458 Check transaction_log_entries
4459-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4460-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4461-0 TRANSACTION 75
4462-75 TRANSACTION 215
4463-290 TRANSACTION 113
4464+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4465+COUNT(*)
4466+3
4467
4468 Check transaction_log_transactions
4469-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4470-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4471-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4472-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4473-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4474+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4475+COUNT(*)
4476+3
4477 Check transaction log contents
4478 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4479 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4480 transaction_context {
4481 server_id: 1
4482- transaction_id: 3
4483+ TRANSACTION_ID
4484 START_TIMESTAMP
4485 END_TIMESTAMP
4486 }
4487@@ -2728,32 +2219,21 @@
4488
4489 Testing MAX DATE
4490 INSERT INTO t1 (b) VALUES('9999-12-31');
4491-# check transaction_log
4492-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4493-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4494-transaction.log 516 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4495-
4496 Check transaction_log_entries
4497-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4498-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4499-0 TRANSACTION 75
4500-75 TRANSACTION 215
4501-290 TRANSACTION 113
4502-403 TRANSACTION 113
4503+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4504+COUNT(*)
4505+4
4506
4507 Check transaction_log_transactions
4508-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4509-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4510-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4511-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4512-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4513-403 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4514+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4515+COUNT(*)
4516+4
4517 Check transaction log contents
4518 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4519 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4520 transaction_context {
4521 server_id: 1
4522- transaction_id: 4
4523+ TRANSACTION_ID
4524 START_TIMESTAMP
4525 END_TIMESTAMP
4526 }
4527@@ -2792,32 +2272,21 @@
4528 Testing MIN-1 DATE
4529 INSERT INTO t1 (b) VALUES('0000-12-31');
4530 ERROR HY000: Received an invalid datetime value '0000-12-31'.
4531-# check transaction_log
4532-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4533-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4534-transaction.log 516 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4535-
4536 Check transaction_log_entries
4537-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4538-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4539-0 TRANSACTION 75
4540-75 TRANSACTION 215
4541-290 TRANSACTION 113
4542-403 TRANSACTION 113
4543+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4544+COUNT(*)
4545+4
4546
4547 Check transaction_log_transactions
4548-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4549-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4550-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4551-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4552-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4553-403 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4554+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4555+COUNT(*)
4556+4
4557 Check transaction log contents
4558 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4559 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4560 transaction_context {
4561 server_id: 1
4562- transaction_id: 4
4563+ TRANSACTION_ID
4564 START_TIMESTAMP
4565 END_TIMESTAMP
4566 }
4567@@ -2856,32 +2325,21 @@
4568 Testing MAX+1 DATE
4569 INSERT INTO t1 (b) VALUES('10000-01-01');
4570 ERROR HY000: Received an invalid datetime value '10000-01-01'.
4571-# check transaction_log
4572-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4573-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4574-transaction.log 516 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4575-
4576 Check transaction_log_entries
4577-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4578-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4579-0 TRANSACTION 75
4580-75 TRANSACTION 215
4581-290 TRANSACTION 113
4582-403 TRANSACTION 113
4583+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4584+COUNT(*)
4585+4
4586
4587 Check transaction_log_transactions
4588-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4589-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4590-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4591-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4592-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4593-403 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4594+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4595+COUNT(*)
4596+4
4597 Check transaction log contents
4598 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4599 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4600 transaction_context {
4601 server_id: 1
4602- transaction_id: 4
4603+ TRANSACTION_ID
4604 START_TIMESTAMP
4605 END_TIMESTAMP
4606 }
4607@@ -2919,34 +2377,21 @@
4608
4609 Testing Alternate input format DATE1
4610 INSERT INTO t1 (b) VALUES('20000101');
4611-# check transaction_log
4612-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4613-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4614-transaction.log 629 5 5 1 5 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4615-
4616 Check transaction_log_entries
4617-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4618-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4619-0 TRANSACTION 75
4620-75 TRANSACTION 215
4621-290 TRANSACTION 113
4622-403 TRANSACTION 113
4623-516 TRANSACTION 113
4624+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4625+COUNT(*)
4626+5
4627
4628 Check transaction_log_transactions
4629-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4630-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4631-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4632-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4633-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4634-403 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4635-516 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
4636+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4637+COUNT(*)
4638+5
4639 Check transaction log contents
4640 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4641 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4642 transaction_context {
4643 server_id: 1
4644- transaction_id: 5
4645+ TRANSACTION_ID
4646 START_TIMESTAMP
4647 END_TIMESTAMP
4648 }
4649@@ -2984,36 +2429,21 @@
4650
4651 Testing Alternate input formate DATE2
4652 INSERT INTO t1 (b) VALUES('990601');
4653-# check transaction_log
4654-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4655-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4656-transaction.log 742 6 6 1 6 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4657-
4658 Check transaction_log_entries
4659-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4660-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4661-0 TRANSACTION 75
4662-75 TRANSACTION 215
4663-290 TRANSACTION 113
4664-403 TRANSACTION 113
4665-516 TRANSACTION 113
4666-629 TRANSACTION 113
4667+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4668+COUNT(*)
4669+6
4670
4671 Check transaction_log_transactions
4672-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4673-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4674-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4675-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4676-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4677-403 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4678-516 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
4679-629 6 1 START_TIMESTAMP END_TIMESTAMP 1 0
4680+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4681+COUNT(*)
4682+6
4683 Check transaction log contents
4684 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4685 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4686 transaction_context {
4687 server_id: 1
4688- transaction_id: 6
4689+ TRANSACTION_ID
4690 START_TIMESTAMP
4691 END_TIMESTAMP
4692 }
4693@@ -3051,38 +2481,21 @@
4694
4695 Testing NULL DATE
4696 INSERT INTO t1 (b) VALUES(NULL);
4697-# check transaction_log
4698-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4699-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4700-transaction.log 845 7 7 1 7 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4701-
4702 Check transaction_log_entries
4703-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4704-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4705-0 TRANSACTION 75
4706-75 TRANSACTION 215
4707-290 TRANSACTION 113
4708-403 TRANSACTION 113
4709-516 TRANSACTION 113
4710-629 TRANSACTION 113
4711-742 TRANSACTION 103
4712+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4713+COUNT(*)
4714+7
4715
4716 Check transaction_log_transactions
4717-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4718-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4719-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4720-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4721-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4722-403 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4723-516 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
4724-629 6 1 START_TIMESTAMP END_TIMESTAMP 1 0
4725-742 7 1 START_TIMESTAMP END_TIMESTAMP 1 0
4726+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4727+COUNT(*)
4728+7
4729 Check transaction log contents
4730 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4731 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4732 transaction_context {
4733 server_id: 1
4734- transaction_id: 7
4735+ TRANSACTION_ID
4736 START_TIMESTAMP
4737 END_TIMESTAMP
4738 }
4739@@ -3121,38 +2534,21 @@
4740 Testing BAD INPUT DATE1
4741 INSERT INTO t1 (b) VALUES('abbazabba');
4742 ERROR HY000: Received an invalid datetime value 'abbazabba'.
4743-# check transaction_log
4744-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4745-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4746-transaction.log 845 7 7 1 7 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4747-
4748 Check transaction_log_entries
4749-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4750-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4751-0 TRANSACTION 75
4752-75 TRANSACTION 215
4753-290 TRANSACTION 113
4754-403 TRANSACTION 113
4755-516 TRANSACTION 113
4756-629 TRANSACTION 113
4757-742 TRANSACTION 103
4758+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4759+COUNT(*)
4760+7
4761
4762 Check transaction_log_transactions
4763-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4764-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4765-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4766-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4767-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4768-403 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4769-516 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
4770-629 6 1 START_TIMESTAMP END_TIMESTAMP 1 0
4771-742 7 1 START_TIMESTAMP END_TIMESTAMP 1 0
4772+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4773+COUNT(*)
4774+7
4775 Check transaction log contents
4776 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4777 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4778 transaction_context {
4779 server_id: 1
4780- transaction_id: 7
4781+ TRANSACTION_ID
4782 START_TIMESTAMP
4783 END_TIMESTAMP
4784 }
4785@@ -3191,38 +2587,21 @@
4786 Testing BAD INPUT DATE2
4787 INSERT INTO t1 (b) VALUES('a');
4788 ERROR HY000: Received an invalid datetime value 'a'.
4789-# check transaction_log
4790-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4791-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4792-transaction.log 845 7 7 1 7 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4793-
4794 Check transaction_log_entries
4795-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4796-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4797-0 TRANSACTION 75
4798-75 TRANSACTION 215
4799-290 TRANSACTION 113
4800-403 TRANSACTION 113
4801-516 TRANSACTION 113
4802-629 TRANSACTION 113
4803-742 TRANSACTION 103
4804+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4805+COUNT(*)
4806+7
4807
4808 Check transaction_log_transactions
4809-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4810-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4811-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4812-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4813-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4814-403 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4815-516 5 1 START_TIMESTAMP END_TIMESTAMP 1 0
4816-629 6 1 START_TIMESTAMP END_TIMESTAMP 1 0
4817-742 7 1 START_TIMESTAMP END_TIMESTAMP 1 0
4818+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4819+COUNT(*)
4820+7
4821 Check transaction log contents
4822 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4823 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4824 transaction_context {
4825 server_id: 1
4826- transaction_id: 7
4827+ TRANSACTION_ID
4828 START_TIMESTAMP
4829 END_TIMESTAMP
4830 }
4831@@ -3267,30 +2646,21 @@
4832 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT, b DATETIME, PRIMARY KEY(a));
4833 Testing MIN DATETIME
4834 INSERT INTO t1 (b) VALUES('0001-01-01 00:00:00');
4835-# check transaction_log
4836-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4837-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4838-transaction.log 412 3 3 1 3 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4839-
4840 Check transaction_log_entries
4841-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4842-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4843-0 TRANSACTION 75
4844-75 TRANSACTION 215
4845-290 TRANSACTION 122
4846+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4847+COUNT(*)
4848+3
4849
4850 Check transaction_log_transactions
4851-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4852-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4853-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4854-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4855-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4856+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4857+COUNT(*)
4858+3
4859 Check transaction log contents
4860 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4861 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4862 transaction_context {
4863 server_id: 1
4864- transaction_id: 3
4865+ TRANSACTION_ID
4866 START_TIMESTAMP
4867 END_TIMESTAMP
4868 }
4869@@ -3328,32 +2698,21 @@
4870
4871 Testing MAX DATETIME
4872 INSERT INTO t1 (b) VALUES('9999-12-31 23:59:59');
4873-# check transaction_log
4874-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4875-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4876-transaction.log 534 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4877-
4878 Check transaction_log_entries
4879-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4880-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4881-0 TRANSACTION 75
4882-75 TRANSACTION 215
4883-290 TRANSACTION 122
4884-412 TRANSACTION 122
4885+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4886+COUNT(*)
4887+4
4888
4889 Check transaction_log_transactions
4890-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4891-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4892-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4893-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4894-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4895-412 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4896+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4897+COUNT(*)
4898+4
4899 Check transaction log contents
4900 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4901 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4902 transaction_context {
4903 server_id: 1
4904- transaction_id: 4
4905+ TRANSACTION_ID
4906 START_TIMESTAMP
4907 END_TIMESTAMP
4908 }
4909@@ -3392,32 +2751,21 @@
4910 Testing MIN-1 DATETIME
4911 INSERT INTO t1 (b) VALUES('0000-01-01');
4912 ERROR HY000: Received an invalid datetime value '0000-01-01'.
4913-# check transaction_log
4914-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4915-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4916-transaction.log 534 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4917-
4918 Check transaction_log_entries
4919-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4920-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4921-0 TRANSACTION 75
4922-75 TRANSACTION 215
4923-290 TRANSACTION 122
4924-412 TRANSACTION 122
4925+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4926+COUNT(*)
4927+4
4928
4929 Check transaction_log_transactions
4930-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4931-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4932-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4933-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4934-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4935-412 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4936+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4937+COUNT(*)
4938+4
4939 Check transaction log contents
4940 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4941 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4942 transaction_context {
4943 server_id: 1
4944- transaction_id: 4
4945+ TRANSACTION_ID
4946 START_TIMESTAMP
4947 END_TIMESTAMP
4948 }
4949@@ -3456,32 +2804,21 @@
4950 Testing MAX+1 DATETIME
4951 INSERT INTO t1 (b) VALUES('10000-01-01');
4952 ERROR HY000: Received an invalid datetime value '10000-01-01'.
4953-# check transaction_log
4954-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4955-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4956-transaction.log 534 4 4 1 4 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4957-
4958 Check transaction_log_entries
4959-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4960-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
4961-0 TRANSACTION 75
4962-75 TRANSACTION 215
4963-290 TRANSACTION 122
4964-412 TRANSACTION 122
4965+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
4966+COUNT(*)
4967+4
4968
4969 Check transaction_log_transactions
4970-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4971-ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
4972-0 1 1 START_TIMESTAMP END_TIMESTAMP 1 0
4973-75 2 1 START_TIMESTAMP END_TIMESTAMP 1 0
4974-290 3 1 START_TIMESTAMP END_TIMESTAMP 1 0
4975-412 4 1 START_TIMESTAMP END_TIMESTAMP 1 0
4976+SELECT COUNT(*) FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
4977+COUNT(*)
4978+4
4979 Check transaction log contents
4980 SELECT PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS));
4981 PRINT_TRANSACTION_MESSAGE('transaction.log',(select max(entry_offset) from DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS))
4982 transaction_context {
4983 server_id: 1
4984- transaction_id: 4
4985+ TRANSACTION_ID
4986 START_TIMESTAMP
4987 END_TIMESTAMP
4988 }
4989@@ -3519,34 +2856,21 @@
4990
4991 Testing Alternate input format DATETIME1
4992 INSERT INTO t1 (b) VALUES(20000101121559);
4993-# check transaction_log
4994-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
4995-FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES
4996-transaction.log 656 5 5 1 5 START_TIMESTAMP END_TIMESTAMP INDEX_SIZE
4997-
4998 Check transaction_log_entries
4999-SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
5000-ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
The diff has been truncated for viewing.

Subscribers

People subscribed via source and target branches