test/sqlapi/Csql/DDLStmt/exp.test008.ksh

   1 Connection opened
   2 Table t1 Created
   3 Tree Index Created on TINYINT field f1
   4 Tree Index Created on SMALLINT field f2
   5 Tree Index Created on INT field f3
   6 Tree Index Created on BIGINT field f4
   7 Tree Index Created on CHAR field f5
   8 Tree Index Created on VARCHAR field f6
   9 Tree Index Created on FLOAT field f7
  10 Tree Index Created on DOUBLE field f8
  11 Tree Index Created on DATE field f9
  12 Tree Index Created on TIME field f10
  13 Tree Index Created on TIMESTAMP field f11
  14          TABLES
  15         --------
  16         t1
  17 Connection Closed
  18 <Table Information of all tables>
  19   <TableInfo>
  20     <TableName> t1 </TableName>
  21       <FieldInfo>
  22         <FieldName> f1 </FieldName>
  23         <Type> 4 </Type>
  24         <Length> 4 </Length>
  25         <Primary> 0 </Primary>
  26         <Null> 0 </Null>
  27         <Default> 0 </Default>
  28         <DefaultValue>  </DefaultValue>
  29       </FieldInfo>
  30       <FieldInfo>
  31         <FieldName> f2 </FieldName>
  32         <Type> 3 </Type>
  33         <Length> 4 </Length>
  34         <Primary> 0 </Primary>
  35         <Null> 0 </Null>
  36         <Default> 0 </Default>
  37         <DefaultValue>  </DefaultValue>
  38       </FieldInfo>
  39       <FieldInfo>
  40         <FieldName> f3 </FieldName>
  41         <Type> 0 </Type>
  42         <Length> 4 </Length>
  43         <Primary> 0 </Primary>
  44         <Null> 0 </Null>
  45         <Default> 0 </Default>
  46         <DefaultValue>  </DefaultValue>
  47       </FieldInfo>
  48       <FieldInfo>
  49         <FieldName> f4 </FieldName>
  50         <Type> 2 </Type>
  51         <Length> 8 </Length>
  52         <Primary> 0 </Primary>
  53         <Null> 0 </Null>
  54         <Default> 0 </Default>
  55         <DefaultValue>  </DefaultValue>
  56       </FieldInfo>
  57       <FieldInfo>
  58         <FieldName> f5 </FieldName>
  59         <Type> 30 </Type>
  60         <Length> 20 </Length>
  61         <Primary> 0 </Primary>
  62         <Null> 0 </Null>
  63         <Default> 0 </Default>
  64         <DefaultValue>  </DefaultValue>
  65       </FieldInfo>
  66       <FieldInfo>
  67         <FieldName> f6 </FieldName>
  68         <Type> 32 </Type>
  69         <Length> 32 </Length>
  70         <Primary> 0 </Primary>
  71         <Null> 0 </Null>
  72         <Default> 0 </Default>
  73         <DefaultValue>  </DefaultValue>
  74       </FieldInfo>
  75       <FieldInfo>
  76         <FieldName> f7 </FieldName>
  77         <Type> 11 </Type>
  78         <Length> 4 </Length>
  79         <Primary> 0 </Primary>
  80         <Null> 0 </Null>
  81         <Default> 0 </Default>
  82         <DefaultValue>  </DefaultValue>
  83       </FieldInfo>
  84       <FieldInfo>
  85         <FieldName> f8 </FieldName>
  86         <Type> 10 </Type>
  87         <Length> 8 </Length>
  88         <Primary> 0 </Primary>
  89         <Null> 0 </Null>
  90         <Default> 0 </Default>
  91         <DefaultValue>  </DefaultValue>
  92       </FieldInfo>
  93       <FieldInfo>
  94         <FieldName> f9 </FieldName>
  95         <Type> 20 </Type>
  96         <Length> 4 </Length>
  97         <Primary> 0 </Primary>
  98         <Null> 0 </Null>
  99         <Default> 0 </Default>
 100         <DefaultValue>  </DefaultValue>
 101       </FieldInfo>
 102       <FieldInfo>
 103         <FieldName> f10 </FieldName>
 104         <Type> 21 </Type>
 105         <Length> 4 </Length>
 106         <Primary> 0 </Primary>
 107         <Null> 0 </Null>
 108         <Default> 0 </Default>
 109         <DefaultValue>  </DefaultValue>
 110       </FieldInfo>
 111       <FieldInfo>
 112         <FieldName> f11 </FieldName>
 113         <Type> 22 </Type>
 114         <Length> 8 </Length>
 115         <Primary> 0 </Primary>
 116         <Null> 0 </Null>
 117         <Default> 0 </Default>
 118         <DefaultValue>  </DefaultValue>
 119       </FieldInfo>
 120   </TableInfo>
 121 </Table Information of all tables>
 122 <Index Information of all Indexs>
 123     <Index Name> idxtiny </Index Name>
 124         <Index Type> Tree Index </Index Type>
 125         <Table Name> t1 </Table Name>
 126         <Field Name> f1 </Field Name>
 127     <Index Name> idxsmall </Index Name>
 128         <Index Type> Tree Index </Index Type>
 129         <Table Name> t1 </Table Name>
 130         <Field Name> f2 </Field Name>
 131     <Index Name> idxint </Index Name>
 132         <Index Type> Tree Index </Index Type>
 133         <Table Name> t1 </Table Name>
 134         <Field Name> f3 </Field Name>
 135     <Index Name> idxbig </Index Name>
 136         <Index Type> Tree Index </Index Type>
 137         <Table Name> t1 </Table Name>
 138         <Field Name> f4 </Field Name>
 139     <Index Name> idxchar </Index Name>
 140         <Index Type> Tree Index </Index Type>
 141         <Table Name> t1 </Table Name>
 142         <Field Name> f5 </Field Name>
 143     <Index Name> idxvarchar </Index Name>
 144         <Index Type> Tree Index </Index Type>
 145         <Table Name> t1 </Table Name>
 146         <Field Name> f6 </Field Name>
 147     <Index Name> idxfloat </Index Name>
 148         <Index Type> Tree Index </Index Type>
 149         <Table Name> t1 </Table Name>
 150         <Field Name> f7 </Field Name>
 151     <Index Name> idxdouble </Index Name>
 152         <Index Type> Tree Index </Index Type>
 153         <Table Name> t1 </Table Name>
 154         <Field Name> f8 </Field Name>
 155     <Index Name> idxdate </Index Name>
 156         <Index Type> Tree Index </Index Type>
 157         <Table Name> t1 </Table Name>
 158         <Field Name> f9 </Field Name>
 159     <Index Name> idxtime </Index Name>
 160         <Index Type> Tree Index </Index Type>
 161         <Table Name> t1 </Table Name>
 162         <Field Name> f10 </Field Name>
 163     <Index Name> idxtimestamp </Index Name>
 164         <Index Type> Tree Index </Index Type>
 165         <Table Name> t1 </Table Name>
 166         <Field Name> f11 </Field Name>
 167 </Index Information of all Indexs>
 168 echo drop table t1;
 169 Statement Executed