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: Superseded
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+39336@code.launchpad.net

This proposal has been superseded by a proposal from 2010-10-31.

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 :

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

lp:~skinny.moey/drizzle/transaction_id_innodb updated
1868. By Joe Daly

various coding standards corrections

1869. By Joe Daly

fix up startup/shutdown events to set a transaction id

1870. By Joe Daly

allow events to use a transaction id

1871. By Joe Daly

test fixes

1872. By Joe Daly

update with tests from pcrews

1873. By Joe Daly

merge trunk

1874. By Joe Daly

code cleanup, test fixes

1875. By Joe Daly

merge trunk

1876. By Joe Daly

fix valgrind message

1877. By Joe Daly

merge trunk

Unmerged revisions

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:26:48 +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:26:48 +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:26:48 +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:26:48 +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:26:48 +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:26:48 +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:26:48 +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:26:48 +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:26:48 +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:26:48 +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:26:48 +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:26:48 +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:26:48 +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:26:48 +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:26:48 +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:26:48 +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