test/sql/Datatype/exp.test009.ksh

   1 echo Create table t1(f1 tinyint, f2 smallint, f3 int, f4 bigint, f5 char(10), f6 varchar(10), f7 float, f8 double,f9 Date, f10 Time, f11 Timestamp);
   2 Statement Executed
   3 echo create index hashidxtinyvar on t1(f1, f6);
   4 Statement Executed
   5 echo create index hashidxsmallvar on t1(f2, f6);
   6 Statement Executed
   7 echo create index hashidxvarint on t1(f6, f3);
   8 Statement Executed
   9 echo create index hashidxvarbig on t1(f6, f4);
  10 Statement Executed
  11 echo create index hashidxcharvar on t1(f5, f6);
  12 Statement Executed
  13 echo create index hashidxvardate on t1(f6, f9);
  14 Statement Executed
  15 echo create index hashidxvartime on t1(f6, f10);
  16 Statement Executed
  17 echo create index hashidxvarfloat on t1(f6, f7);
  18 Statement execute failed with error -16
  19 echo create index hashidxvardouble on t1(f6, f8);
  20 Statement execute failed with error -16
  21 echo create index hashidxvartimestamp on t1(f6, f11);
  22 Statement execute failed with error -16
  23 <Table Information of all tables>
  24   <TableInfo>
  25     <TableName> t1 </TableName>
  26       <FieldInfo>
  27         <FieldName> f1 </FieldName>
  28         <Type> 4 </Type>
  29         <Length> 4 </Length>
  30         <Primary> 0 </Primary>
  31         <Null> 0 </Null>
  32         <Default> 0 </Default>
  33         <DefaultValue>  </DefaultValue>
  34       </FieldInfo>
  35       <FieldInfo>
  36         <FieldName> f2 </FieldName>
  37         <Type> 3 </Type>
  38         <Length> 4 </Length>
  39         <Primary> 0 </Primary>
  40         <Null> 0 </Null>
  41         <Default> 0 </Default>
  42         <DefaultValue>  </DefaultValue>
  43       </FieldInfo>
  44       <FieldInfo>
  45         <FieldName> f3 </FieldName>
  46         <Type> 0 </Type>
  47         <Length> 4 </Length>
  48         <Primary> 0 </Primary>
  49         <Null> 0 </Null>
  50         <Default> 0 </Default>
  51         <DefaultValue>  </DefaultValue>
  52       </FieldInfo>
  53       <FieldInfo>
  54         <FieldName> f4 </FieldName>
  55         <Type> 2 </Type>
  56         <Length> 8 </Length>
  57         <Primary> 0 </Primary>
  58         <Null> 0 </Null>
  59         <Default> 0 </Default>
  60         <DefaultValue>  </DefaultValue>
  61       </FieldInfo>
  62       <FieldInfo>
  63         <FieldName> f5 </FieldName>
  64         <Type> 30 </Type>
  65         <Length> 12 </Length>
  66         <Primary> 0 </Primary>
  67         <Null> 0 </Null>
  68         <Default> 0 </Default>
  69         <DefaultValue>  </DefaultValue>
  70       </FieldInfo>
  71       <FieldInfo>
  72         <FieldName> f6 </FieldName>
  73         <Type> 32 </Type>
  74         <Length> 12 </Length>
  75         <Primary> 0 </Primary>
  76         <Null> 0 </Null>
  77         <Default> 0 </Default>
  78         <DefaultValue>  </DefaultValue>
  79       </FieldInfo>
  80       <FieldInfo>
  81         <FieldName> f7 </FieldName>
  82         <Type> 11 </Type>
  83         <Length> 4 </Length>
  84         <Primary> 0 </Primary>
  85         <Null> 0 </Null>
  86         <Default> 0 </Default>
  87         <DefaultValue>  </DefaultValue>
  88       </FieldInfo>
  89       <FieldInfo>
  90         <FieldName> f8 </FieldName>
  91         <Type> 10 </Type>
  92         <Length> 8 </Length>
  93         <Primary> 0 </Primary>
  94         <Null> 0 </Null>
  95         <Default> 0 </Default>
  96         <DefaultValue>  </DefaultValue>
  97       </FieldInfo>
  98       <FieldInfo>
  99         <FieldName> f9 </FieldName>
 100         <Type> 20 </Type>
 101         <Length> 4 </Length>
 102         <Primary> 0 </Primary>
 103         <Null> 0 </Null>
 104         <Default> 0 </Default>
 105         <DefaultValue>  </DefaultValue>
 106       </FieldInfo>
 107       <FieldInfo>
 108         <FieldName> f10 </FieldName>
 109         <Type> 21 </Type>
 110         <Length> 4 </Length>
 111         <Primary> 0 </Primary>
 112         <Null> 0 </Null>
 113         <Default> 0 </Default>
 114         <DefaultValue>  </DefaultValue>
 115       </FieldInfo>
 116       <FieldInfo>
 117         <FieldName> f11 </FieldName>
 118         <Type> 22 </Type>
 119         <Length> 8 </Length>
 120         <Primary> 0 </Primary>
 121         <Null> 0 </Null>
 122         <Default> 0 </Default>
 123         <DefaultValue>  </DefaultValue>
 124       </FieldInfo>
 125   </TableInfo>
 126 </Table Information of all tables>
 127 <Index Information of all Indexs>
 128     <Index Name> hashidxtinyvar </Index Name>
 129         <Index Type> Hash Index </Index Type>
 130         <Table Name> t1 </Table Name>
 131         <Field Name> f1 </Field Name>
 132         <Field Name> f6 </Field Name>
 133     <Index Name> hashidxsmallvar </Index Name>
 134         <Index Type> Hash Index </Index Type>
 135         <Table Name> t1 </Table Name>
 136         <Field Name> f2 </Field Name>
 137         <Field Name> f6 </Field Name>
 138     <Index Name> hashidxvarint </Index Name>
 139         <Index Type> Hash Index </Index Type>
 140         <Table Name> t1 </Table Name>
 141         <Field Name> f6 </Field Name>
 142         <Field Name> f3 </Field Name>
 143     <Index Name> hashidxvarbig </Index Name>
 144         <Index Type> Hash Index </Index Type>
 145         <Table Name> t1 </Table Name>
 146         <Field Name> f6 </Field Name>
 147         <Field Name> f4 </Field Name>
 148     <Index Name> hashidxcharvar </Index Name>
 149         <Index Type> Hash Index </Index Type>
 150         <Table Name> t1 </Table Name>
 151         <Field Name> f5 </Field Name>
 152         <Field Name> f6 </Field Name>
 153     <Index Name> hashidxvardate </Index Name>
 154         <Index Type> Hash Index </Index Type>
 155         <Table Name> t1 </Table Name>
 156         <Field Name> f6 </Field Name>
 157         <Field Name> f9 </Field Name>
 158     <Index Name> hashidxvartime </Index Name>
 159         <Index Type> Hash Index </Index Type>
 160         <Table Name> t1 </Table Name>
 161         <Field Name> f6 </Field Name>
 162         <Field Name> f10 </Field Name>
 163 </Index Information of all Indexs>
 164 Statement Executed