test/system/Allocator/exp.test003.ksh

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