test/sql/Datatype/exp.test008.ksh

   1 echo Create table t1(f1 int, f2 varchar(10), f3 char(10), f4 varchar(10));
   2 Statement Executed
   3 echo Create table t2 as select f2,f1,f4 from t1;
   4 Statement Executed
   5 echo show tables;
   6 =============TableNames===================
   7    t1
   8    t2
   9 ==========================================
  10 <Table Information of all tables>
  11   <TableInfo>
  12     <TableName> t1 </TableName>
  13       <FieldInfo>
  14         <FieldName> f1 </FieldName>
  15         <Type> 0 </Type>
  16         <Length> 4 </Length>
  17         <Primary> 0 </Primary>
  18         <Null> 0 </Null>
  19         <Default> 0 </Default>
  20         <DefaultValue>  </DefaultValue>
  21       </FieldInfo>
  22       <FieldInfo>
  23         <FieldName> f2 </FieldName>
  24         <Type> 32 </Type>
  25         <Length> 12 </Length>
  26         <Primary> 0 </Primary>
  27         <Null> 0 </Null>
  28         <Default> 0 </Default>
  29         <DefaultValue>  </DefaultValue>
  30       </FieldInfo>
  31       <FieldInfo>
  32         <FieldName> f3 </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       <FieldInfo>
  41         <FieldName> f4 </FieldName>
  42         <Type> 32 </Type>
  43         <Length> 12 </Length>
  44         <Primary> 0 </Primary>
  45         <Null> 0 </Null>
  46         <Default> 0 </Default>
  47         <DefaultValue>  </DefaultValue>
  48       </FieldInfo>
  49   </TableInfo>
  50   <TableInfo>
  51     <TableName> t2 </TableName>
  52       <FieldInfo>
  53         <FieldName> f2 </FieldName>
  54         <Type> 32 </Type>
  55         <Length> 12 </Length>
  56         <Primary> 0 </Primary>
  57         <Null> 0 </Null>
  58         <Default> 0 </Default>
  59         <DefaultValue>  </DefaultValue>
  60       </FieldInfo>
  61       <FieldInfo>
  62         <FieldName> f1 </FieldName>
  63         <Type> 0 </Type>
  64         <Length> 4 </Length>
  65         <Primary> 0 </Primary>
  66         <Null> 0 </Null>
  67         <Default> 0 </Default>
  68         <DefaultValue>  </DefaultValue>
  69       </FieldInfo>
  70       <FieldInfo>
  71         <FieldName> f4 </FieldName>
  72         <Type> 32 </Type>
  73         <Length> 12 </Length>
  74         <Primary> 0 </Primary>
  75         <Null> 0 </Null>
  76         <Default> 0 </Default>
  77         <DefaultValue>  </DefaultValue>
  78       </FieldInfo>
  79   </TableInfo>
  80 </Table Information of all tables>
  81 <Index Information of all Indexs>
  82 </Index Information of all Indexs>
  83 Statement Executed
  84 Statement Executed