test/tools/catalog/exp.test007.ksh

   1 Case 1: create two table t4,t5
   2 echo create table t4 (f1 int,f2 int,primary key(f1));
   3 Statement Executed
   4 echo create table t5 (f1 int,f2 int,primary key(f1, f2));
   5 Statement Executed
   6 Case 2: With -l option after for primary flag checking:
   7 <Table Information of all tables>
   8   <TableInfo>
   9     <TableName> t4 </TableName>
  10       <FieldInfo>
  11         <FieldName> f1 </FieldName>
  12         <Type> 0 </Type>
  13         <Length> 4 </Length>
  14         <Primary> 1 </Primary>
  15         <Null> 1 </Null>
  16         <Default> 0 </Default>
  17         <DefaultValue>  </DefaultValue>
  18       </FieldInfo>
  19       <FieldInfo>
  20         <FieldName> f2 </FieldName>
  21         <Type> 0 </Type>
  22         <Length> 4 </Length>
  23         <Primary> 0 </Primary>
  24         <Null> 0 </Null>
  25         <Default> 0 </Default>
  26         <DefaultValue>  </DefaultValue>
  27       </FieldInfo>
  28   </TableInfo>
  29   <TableInfo>
  30     <TableName> t5 </TableName>
  31       <FieldInfo>
  32         <FieldName> f1 </FieldName>
  33         <Type> 0 </Type>
  34         <Length> 4 </Length>
  35         <Primary> 1 </Primary>
  36         <Null> 1 </Null>
  37         <Default> 0 </Default>
  38         <DefaultValue>  </DefaultValue>
  39       </FieldInfo>
  40       <FieldInfo>
  41         <FieldName> f2 </FieldName>
  42         <Type> 0 </Type>
  43         <Length> 4 </Length>
  44         <Primary> 1 </Primary>
  45         <Null> 1 </Null>
  46         <Default> 0 </Default>
  47         <DefaultValue>  </DefaultValue>
  48       </FieldInfo>
  49   </TableInfo>
  50 </Table Information of all tables>
  51 <Index Information of all Indexs>
  52     <Index Name> t4_idx1_Primary </Index Name>
  53         <Index Type> Hash Index </Index Type>
  54         <Table Name> t4 </Table Name>
  55         <Field Name> f1 </Field Name>
  56     <Index Name> t5_idx1_Primary </Index Name>
  57         <Index Type> Hash Index </Index Type>
  58         <Table Name> t5 </Table Name>
  59         <Field Name> f1 </Field Name>
  60         <Field Name> f2 </Field Name>
  61 </Index Information of all Indexs>
  62 case 3 : drop two table
  63 Statement Executed
  64 Statement Executed
  65 t4 ,t5 table droped