From f4ec2e8420252f35311df5e16851141e01f1bd7c Mon Sep 17 00:00:00 2001 From: kishoramballi Date: Fri, 8 May 2009 10:45:58 +0000 Subject: [PATCH] expected files changed with respect to the autoincrement changes --- test/tools/catalog/exp.test005.ksh | 6 +- test/tools/catalog/exp.test006.ksh | 568 ------------------------------------- 2 files changed, 3 insertions(+), 571 deletions(-) rewrite test/tools/catalog/exp.test006.ksh (100%) diff --git a/test/tools/catalog/exp.test005.ksh b/test/tools/catalog/exp.test005.ksh index ea1bf369..01f89942 100644 --- a/test/tools/catalog/exp.test005.ksh +++ b/test/tools/catalog/exp.test005.ksh @@ -59,7 +59,7 @@ Case 1: With -D chunk option with empty database 1 FieldTableId 0 - 132 + 144 FixedSizeAllocator 14 1 @@ -156,7 +156,7 @@ Case 2: With -D chunk option after table creation: 1 FieldTableId 2 - 132 + 144 FixedSizeAllocator 14 1 @@ -250,7 +250,7 @@ Case 3: With -D chunk option after drop t1 : 1 FieldTableId 0 - 132 + 144 FixedSizeAllocator 14 1 diff --git a/test/tools/catalog/exp.test006.ksh b/test/tools/catalog/exp.test006.ksh dissimilarity index 100% index dd7b1ce7..e69de29b 100644 --- a/test/tools/catalog/exp.test006.ksh +++ b/test/tools/catalog/exp.test006.ksh @@ -1,568 +0,0 @@ -echo create table t2 and constraints with three integer fields and primary key f1; -Statement Executed -Statement Executed -Table created -Case 1: With -D chunk option after table creation: - - - 0 - 1 - UserChunkTableId - 5 - 112 - FixedSizeAllocator - 1 - 1 - LockTableHashBucketId - 1 - 57348 - FixedSizeAllocator - 2 - 1 - LockTableMutexId - 0 - 49156 - FixedSizeAllocator - 3 - 1 - LockTableId - 0 - 20 - FixedSizeAllocator - 4 - 1 - TransHasTableId - 0 - 12 - FixedSizeAllocator - 5 - 1 - UndoLogTableId - 0 - 0 - VariableSizeAllocator - 10 - 1 - DatabaseTableId - 0 - 84 - FixedSizeAllocator - 11 - 1 - UserTableId - 1 - 132 - FixedSizeAllocator - 12 - 1 - TableTableId - 1 - 88 - FixedSizeAllocator - 13 - 1 - FieldTableId - 3 - 132 - FixedSizeAllocator - 14 - 1 - AccessTableId - 0 - 132 - FixedSizeAllocator - 15 - 1 - IndexTableId - 2 - 104 - FixedSizeAllocator - 16 - 1 - IndexFieldTableId - 2 - 20 - FixedSizeAllocator - - - 101 - 1 - t2 - 0 - 20 - FixedSizeAllocator - 102 - 1 - t2_idx1_Primary - 1 - 28256 - FixedSizeAllocator - 103 - 1 - t2_idx1_Primary - 0 - 16 - FixedSizeAllocator - 104 - 1 - t2Uniqueidx - 1 - 28256 - FixedSizeAllocator - 105 - 1 - t2Uniqueidx - 0 - 16 - FixedSizeAllocator - - -echo insert into t2 20 tuples; -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Statement Executed: Rows Affected = 1 -Tuples insered -Case 2: With -D chunk option after insert 20 tuples: - - - 0 - 1 - UserChunkTableId - 5 - 112 - FixedSizeAllocator - 1 - 1 - LockTableHashBucketId - 1 - 57348 - FixedSizeAllocator - 2 - 1 - LockTableMutexId - 0 - 49156 - FixedSizeAllocator - 3 - 1 - LockTableId - 0 - 20 - FixedSizeAllocator - 4 - 1 - TransHasTableId - 0 - 12 - FixedSizeAllocator - 5 - 1 - UndoLogTableId - 0 - 0 - VariableSizeAllocator - 10 - 1 - DatabaseTableId - 0 - 84 - FixedSizeAllocator - 11 - 1 - UserTableId - 1 - 132 - FixedSizeAllocator - 12 - 1 - TableTableId - 1 - 88 - FixedSizeAllocator - 13 - 1 - FieldTableId - 3 - 132 - FixedSizeAllocator - 14 - 1 - AccessTableId - 0 - 132 - FixedSizeAllocator - 15 - 1 - IndexTableId - 2 - 104 - FixedSizeAllocator - 16 - 1 - IndexFieldTableId - 2 - 20 - FixedSizeAllocator - - - 101 - 1 - t2 - 20 - 20 - FixedSizeAllocator - 102 - 1 - t2_idx1_Primary - 1 - 28256 - FixedSizeAllocator - 103 - 1 - t2_idx1_Primary - 20 - 16 - FixedSizeAllocator - 104 - 1 - t2Uniqueidx - 1 - 28256 - FixedSizeAllocator - 105 - 1 - t2Uniqueidx - 20 - 16 - FixedSizeAllocator - - -echo delete 10 tuples; -Statement Executed: Rows Affected = 10 -10 tuples deleted -Case 3: With -D chunk option after deleting 10 tuples : - - - 0 - 1 - UserChunkTableId - 5 - 112 - FixedSizeAllocator - 1 - 1 - LockTableHashBucketId - 1 - 57348 - FixedSizeAllocator - 2 - 1 - LockTableMutexId - 0 - 49156 - FixedSizeAllocator - 3 - 1 - LockTableId - 0 - 20 - FixedSizeAllocator - 4 - 1 - TransHasTableId - 0 - 12 - FixedSizeAllocator - 5 - 1 - UndoLogTableId - 0 - 0 - VariableSizeAllocator - 10 - 1 - DatabaseTableId - 0 - 84 - FixedSizeAllocator - 11 - 1 - UserTableId - 1 - 132 - FixedSizeAllocator - 12 - 1 - TableTableId - 1 - 88 - FixedSizeAllocator - 13 - 1 - FieldTableId - 3 - 132 - FixedSizeAllocator - 14 - 1 - AccessTableId - 0 - 132 - FixedSizeAllocator - 15 - 1 - IndexTableId - 2 - 104 - FixedSizeAllocator - 16 - 1 - IndexFieldTableId - 2 - 20 - FixedSizeAllocator - - - 101 - 1 - t2 - 10 - 20 - FixedSizeAllocator - 102 - 1 - t2_idx1_Primary - 1 - 28256 - FixedSizeAllocator - 103 - 1 - t2_idx1_Primary - 10 - 16 - FixedSizeAllocator - 104 - 1 - t2Uniqueidx - 1 - 28256 - FixedSizeAllocator - 105 - 1 - t2Uniqueidx - 10 - 16 - FixedSizeAllocator - - -echo drop index t2Uniqueidx; -Statement Executed -Index droped -Case 4: With -D chunk option after Index droped : - - - 0 - 1 - UserChunkTableId - 3 - 112 - FixedSizeAllocator - 1 - 1 - LockTableHashBucketId - 1 - 57348 - FixedSizeAllocator - 2 - 1 - LockTableMutexId - 0 - 49156 - FixedSizeAllocator - 3 - 1 - LockTableId - 0 - 20 - FixedSizeAllocator - 4 - 1 - TransHasTableId - 0 - 12 - FixedSizeAllocator - 5 - 1 - UndoLogTableId - 0 - 0 - VariableSizeAllocator - 10 - 1 - DatabaseTableId - 0 - 84 - FixedSizeAllocator - 11 - 1 - UserTableId - 1 - 132 - FixedSizeAllocator - 12 - 1 - TableTableId - 1 - 88 - FixedSizeAllocator - 13 - 1 - FieldTableId - 3 - 132 - FixedSizeAllocator - 14 - 1 - AccessTableId - 0 - 132 - FixedSizeAllocator - 15 - 1 - IndexTableId - 1 - 104 - FixedSizeAllocator - 16 - 1 - IndexFieldTableId - 1 - 20 - FixedSizeAllocator - - - 101 - 1 - t2 - 10 - 20 - FixedSizeAllocator - 102 - 1 - t2_idx1_Primary - 1 - 28256 - FixedSizeAllocator - 103 - 1 - t2_idx1_Primary - 10 - 16 - FixedSizeAllocator - - -echo drop table t2; -Statement Executed -t2 table droped with index -Case 5: With -D chunk option after drop t2 : - - - 0 - 1 - UserChunkTableId - 0 - 112 - FixedSizeAllocator - 1 - 1 - LockTableHashBucketId - 1 - 57348 - FixedSizeAllocator - 2 - 1 - LockTableMutexId - 0 - 49156 - FixedSizeAllocator - 3 - 1 - LockTableId - 0 - 20 - FixedSizeAllocator - 4 - 1 - TransHasTableId - 0 - 12 - FixedSizeAllocator - 5 - 1 - UndoLogTableId - 0 - 0 - VariableSizeAllocator - 10 - 1 - DatabaseTableId - 0 - 84 - FixedSizeAllocator - 11 - 1 - UserTableId - 1 - 132 - FixedSizeAllocator - 12 - 1 - TableTableId - 0 - 88 - FixedSizeAllocator - 13 - 1 - FieldTableId - 0 - 132 - FixedSizeAllocator - 14 - 1 - AccessTableId - 0 - 132 - FixedSizeAllocator - 15 - 1 - IndexTableId - 0 - 104 - FixedSizeAllocator - 16 - 1 - IndexFieldTableId - 0 - 20 - FixedSizeAllocator - - - - -- 2.11.4.GIT