test/cache/CacheTable/exp.test032.ksh

   1 t1create.sql file created
   2 select file created
   3 Select * from t1 in CSQL
   4 ---------------------------------------------------------
   5         t1.f1   t1.f2
   6 ---------------------------------------------------------
   7         1       INDIA1
   8         11      NULL
   9         2       INDIA2
  10         12      NULL
  11         3       INDIA3
  12         13      NULL
  13         4       INDIA4
  14         14      NULL
  15         5       INDIA5
  16         15      NULL
  17
  18 Checking for table created or not
  19 <Table Information of all tables>
  20   <TableInfo>
  21     <TableName> t1 </TableName>
  22       <FieldInfo>
  23         <FieldName> f1 </FieldName>
  24         <Type> 0 </Type>
  25         <Length> 4 </Length>
  26         <Primary> 1 </Primary>
  27         <Null> 1 </Null>
  28         <Default> 0 </Default>
  29         <DefaultValue>  </DefaultValue>
  30       </FieldInfo>
  31       <FieldInfo>
  32         <FieldName> f2 </FieldName>
  33         <Type> 30 </Type>
  34         <Length> 12 </Length>
  35         <Primary> 0 </Primary>
  36         <Null> 0 </Null>
  37         <Default> 0 </Default>
  38         <DefaultValue>  </DefaultValue>
  39       </FieldInfo>
  40   </TableInfo>
  41 </Table Information of all tables>
  42 <Index Information of all Indexs>
  43     <Index Name> t1_PRIMARY </Index Name>
  44         <Index Type> Hash Index </Index Type>
  45         <Table Name> t1 </Table Name>
  46         <Field Name> f1 </Field Name>
  47 </Index Information of all Indexs>
  48 cache table 't1' unloaded by -u option