test/system/Allocator/exp.test002.ksh

   1 Table created
   2 Index created for f1
   3 Tables and Indexes are created
   4 Total Tuples inserted is 1000
   5 Tuples inserted into table
   6 Case 1: -T option for t1: with 1000 tuple
   7 Tables and Indexes are created
   8 <Table Info>
   9   <TableName> t1 </TableName>
  10   <TupleCount> 1000 </TupleCount>
  11   <PagesUsed> 2 </PagesUsed>
  12   <SpaceUsed> 16032 </SpaceUsed>
  13   <Indexes> 1 <Indexes>
  14   <TupleLength> 12 </TupleLength>
  15   <Fields> 2 </Fields>
  16   <Indexes>
  17 <IndexName> t1idx1 </IndexName>
  18   </Indexes>
  19 </Table Info>
  20 Case 2: -I option for idx1 of t1, with 1000 tuple
  21 <Index Info>
  22 <IndexName> t1idx1 </IndexName>
  23 <Unique> 1 </Unique>
  24 <Type> Hash Index </Type>
  25 <HashBucket>
  26   <TotalPages> 1 </TotalPages>
  27   <TotalBuckets> 1009 </TotalBuckets>
  28 </HashBucket>
  29 <IndexNodes>
  30   <TotalPages> 2 </TotalPages>
  31   <TotalNodes> 1000 </TotalNodes>
  32 <IndexNodes>
  33 <Index Info>
  34 Total Tuples deleted is 1000
  35 Tuples deleted from table
  36 Case 3: -T option for t1: after removing 1000 tuple
  37 <Table Info>
  38   <TableName> t1 </TableName>
  39   <TupleCount> 0 </TupleCount>
  40   <PagesUsed> 2 </PagesUsed>
  41   <SpaceUsed> 32 </SpaceUsed>
  42   <Indexes> 1 <Indexes>
  43   <TupleLength> 12 </TupleLength>
  44   <Fields> 2 </Fields>
  45   <Indexes>
  46 <IndexName> t1idx1 </IndexName>
  47   </Indexes>
  48 </Table Info>
  49 Case 4: -I option for idx1 of t1, after removing 1000 tuple
  50 <Index Info>
  51 <IndexName> t1idx1 </IndexName>
  52 <Unique> 1 </Unique>
  53 <Type> Hash Index </Type>
  54 <HashBucket>
  55   <TotalPages> 1 </TotalPages>
  56   <TotalBuckets> 1009 </TotalBuckets>
  57 </HashBucket>
  58 <IndexNodes>
  59   <TotalPages> 2 </TotalPages>
  60   <TotalNodes> 0 </TotalNodes>
  61 <IndexNodes>
  62 <Index Info>
  63 Table Dropped
  64 Tables and Indexes are dropped