test/tools/csql/exp.test036.ksh

   1 echo create table t2 ( f1 int, f2 int, primary key(f1, f2));
   2 Statement Executed
   3 echo create index ind on t2(f1);
   4 Statement Executed
   5 echo create table t1 (f1 int,f2 char(10),f3 smallint,f4 tinyint,primary key(f1,f2));
   6 Statement Executed
   7 echo create index indx1 on t1 (f1,f3);
   8 Statement Executed
   9 echo create index indx2 on t1 (f3);
  10 Statement Executed
  11 echo create index indx3 on t1 (f2,f4);
  12 Statement Executed
  13 echo create index indx4 on t1 (f2,f3);
  14 Statement Executed
  15 echo create index indx5 on t1 (f1,f3,f4);
  16 Statement Executed
  17 echo create index indx6 on t1 (f1,f3,f2);
  18 Statement Executed
  19 echo create index indx7 on t1 (f1,f3,f2);
  20 Statement Executed
  21 echo create table t3 (f1 int,f2 char(10),f3 smallint,f4 tinyint,primary key(f1,f2));
  22 Statement Executed
  23 echo create index indx11 on t3 (f1,f3);
  24 Statement Executed
  25 echo create index indx12 on t3 (f3);
  26 Statement Executed
  27 echo create index indx13 on t3 (f2,f4);
  28 Statement Executed
  29 echo create index indx14 on t3 (f2,f3);
  30 Statement Executed
  31 echo create index indx15 on t1 (f1,f3,f4);
  32 Statement Executed
  33 echo create index indx16 on t1 (f1,f3,f2);
  34 Statement Executed
  35 echo create index indx17 on t1 (f1,f3,f2);
  36 Statement Executed
  37 echo create table t4 (f1 int);
  38 Statement Executed
  39 echo create index indx18 on t4(f1,f1);
  40 Statement execute failed with error -4
  41 <Table Information of all tables>
  42   <TableInfo>
  43     <TableName> t2 </TableName>
  44       <FieldInfo>
  45         <FieldName> f1 </FieldName>
  46         <Type> 0 </Type>
  47         <Length> 4 </Length>
  48         <Primary> 1 </Primary>
  49         <Null> 1 </Null>
  50         <Default> 0 </Default>
  51         <DefaultValue>  </DefaultValue>
  52       </FieldInfo>
  53       <FieldInfo>
  54         <FieldName> f2 </FieldName>
  55         <Type> 0 </Type>
  56         <Length> 4 </Length>
  57         <Primary> 1 </Primary>
  58         <Null> 1 </Null>
  59         <Default> 0 </Default>
  60         <DefaultValue>  </DefaultValue>
  61       </FieldInfo>
  62   </TableInfo>
  63   <TableInfo>
  64     <TableName> t1 </TableName>
  65       <FieldInfo>
  66         <FieldName> f1 </FieldName>
  67         <Type> 0 </Type>
  68         <Length> 4 </Length>
  69         <Primary> 1 </Primary>
  70         <Null> 1 </Null>
  71         <Default> 0 </Default>
  72         <DefaultValue>  </DefaultValue>
  73       </FieldInfo>
  74       <FieldInfo>
  75         <FieldName> f2 </FieldName>
  76         <Type> 30 </Type>
  77         <Length> 12 </Length>
  78         <Primary> 1 </Primary>
  79         <Null> 1 </Null>
  80         <Default> 0 </Default>
  81         <DefaultValue>  </DefaultValue>
  82       </FieldInfo>
  83       <FieldInfo>
  84         <FieldName> f3 </FieldName>
  85         <Type> 3 </Type>
  86         <Length> 4 </Length>
  87         <Primary> 0 </Primary>
  88         <Null> 0 </Null>
  89         <Default> 0 </Default>
  90         <DefaultValue>  </DefaultValue>
  91       </FieldInfo>
  92       <FieldInfo>
  93         <FieldName> f4 </FieldName>
  94         <Type> 4 </Type>
  95         <Length> 4 </Length>
  96         <Primary> 0 </Primary>
  97         <Null> 0 </Null>
  98         <Default> 0 </Default>
  99         <DefaultValue>  </DefaultValue>
 100       </FieldInfo>
 101   </TableInfo>
 102   <TableInfo>
 103     <TableName> t3 </TableName>
 104       <FieldInfo>
 105         <FieldName> f1 </FieldName>
 106         <Type> 0 </Type>
 107         <Length> 4 </Length>
 108         <Primary> 1 </Primary>
 109         <Null> 1 </Null>
 110         <Default> 0 </Default>
 111         <DefaultValue>  </DefaultValue>
 112       </FieldInfo>
 113       <FieldInfo>
 114         <FieldName> f2 </FieldName>
 115         <Type> 30 </Type>
 116         <Length> 12 </Length>
 117         <Primary> 1 </Primary>
 118         <Null> 1 </Null>
 119         <Default> 0 </Default>
 120         <DefaultValue>  </DefaultValue>
 121       </FieldInfo>
 122       <FieldInfo>
 123         <FieldName> f3 </FieldName>
 124         <Type> 3 </Type>
 125         <Length> 4 </Length>
 126         <Primary> 0 </Primary>
 127         <Null> 0 </Null>
 128         <Default> 0 </Default>
 129         <DefaultValue>  </DefaultValue>
 130       </FieldInfo>
 131       <FieldInfo>
 132         <FieldName> f4 </FieldName>
 133         <Type> 4 </Type>
 134         <Length> 4 </Length>
 135         <Primary> 0 </Primary>
 136         <Null> 0 </Null>
 137         <Default> 0 </Default>
 138         <DefaultValue>  </DefaultValue>
 139       </FieldInfo>
 140   </TableInfo>
 141   <TableInfo>
 142     <TableName> t4 </TableName>
 143       <FieldInfo>
 144         <FieldName> f1 </FieldName>
 145         <Type> 0 </Type>
 146         <Length> 4 </Length>
 147         <Primary> 0 </Primary>
 148         <Null> 0 </Null>
 149         <Default> 0 </Default>
 150         <DefaultValue>  </DefaultValue>
 151       </FieldInfo>
 152   </TableInfo>
 153 </Table Information of all tables>
 154 <Index Information of all Indexs>
 155     <Index Name> t2_idx1_Primary </Index Name>
 156         <Index Type> Hash Index </Index Type>
 157         <Table Name> t2 </Table Name>
 158         <Field Name> f1 </Field Name>
 159         <Field Name> f2 </Field Name>
 160     <Index Name> ind </Index Name>
 161         <Index Type> Hash Index </Index Type>
 162         <Table Name> t2 </Table Name>
 163         <Field Name> f1 </Field Name>
 164     <Index Name> t1_idx1_Primary </Index Name>
 165         <Index Type> Hash Index </Index Type>
 166         <Table Name> t1 </Table Name>
 167         <Field Name> f1 </Field Name>
 168         <Field Name> f2 </Field Name>
 169     <Index Name> indx1 </Index Name>
 170         <Index Type> Hash Index </Index Type>
 171         <Table Name> t1 </Table Name>
 172         <Field Name> f1 </Field Name>
 173         <Field Name> f3 </Field Name>
 174     <Index Name> indx2 </Index Name>
 175         <Index Type> Hash Index </Index Type>
 176         <Table Name> t1 </Table Name>
 177         <Field Name> f3 </Field Name>
 178     <Index Name> indx3 </Index Name>
 179         <Index Type> Hash Index </Index Type>
 180         <Table Name> t1 </Table Name>
 181         <Field Name> f2 </Field Name>
 182         <Field Name> f4 </Field Name>
 183     <Index Name> indx4 </Index Name>
 184         <Index Type> Hash Index </Index Type>
 185         <Table Name> t1 </Table Name>
 186         <Field Name> f2 </Field Name>
 187         <Field Name> f3 </Field Name>
 188     <Index Name> indx5 </Index Name>
 189         <Index Type> Hash Index </Index Type>
 190         <Table Name> t1 </Table Name>
 191         <Field Name> f1 </Field Name>
 192         <Field Name> f3 </Field Name>
 193         <Field Name> f4 </Field Name>
 194     <Index Name> indx6 </Index Name>
 195         <Index Type> Hash Index </Index Type>
 196         <Table Name> t1 </Table Name>
 197         <Field Name> f1 </Field Name>
 198         <Field Name> f3 </Field Name>
 199         <Field Name> f2 </Field Name>
 200     <Index Name> indx7 </Index Name>
 201         <Index Type> Hash Index </Index Type>
 202         <Table Name> t1 </Table Name>
 203         <Field Name> f1 </Field Name>
 204         <Field Name> f4 </Field Name>
 205         <Field Name> f2 </Field Name>
 206     <Index Name> t3_idx1_Primary </Index Name>
 207         <Index Type> Hash Index </Index Type>
 208         <Table Name> t3 </Table Name>
 209         <Field Name> f1 </Field Name>
 210         <Field Name> f2 </Field Name>
 211     <Index Name> indx11 </Index Name>
 212         <Index Type> Hash Index </Index Type>
 213         <Table Name> t3 </Table Name>
 214         <Field Name> f1 </Field Name>
 215         <Field Name> f3 </Field Name>
 216     <Index Name> indx12 </Index Name>
 217         <Index Type> Hash Index </Index Type>
 218         <Table Name> t3 </Table Name>
 219         <Field Name> f3 </Field Name>
 220     <Index Name> indx13 </Index Name>
 221         <Index Type> Hash Index </Index Type>
 222         <Table Name> t3 </Table Name>
 223         <Field Name> f2 </Field Name>
 224         <Field Name> f4 </Field Name>
 225     <Index Name> indx14 </Index Name>
 226         <Index Type> Hash Index </Index Type>
 227         <Table Name> t3 </Table Name>
 228         <Field Name> f2 </Field Name>
 229         <Field Name> f3 </Field Name>
 230     <Index Name> indx15 </Index Name>
 231         <Index Type> Hash Index </Index Type>
 232         <Table Name> t3 </Table Name>
 233         <Field Name> f1 </Field Name>
 234         <Field Name> f3 </Field Name>
 235         <Field Name> f4 </Field Name>
 236     <Index Name> indx16 </Index Name>
 237         <Index Type> Hash Index </Index Type>
 238         <Table Name> t3 </Table Name>
 239         <Field Name> f1 </Field Name>
 240         <Field Name> f3 </Field Name>
 241         <Field Name> f2 </Field Name>
 242     <Index Name> indx17 </Index Name>
 243         <Index Type> Hash Index </Index Type>
 244         <Table Name> t3 </Table Name>
 245         <Field Name> f1 </Field Name>
 246         <Field Name> f4 </Field Name>
 247         <Field Name> f2 </Field Name>
 248 </Index Information of all Indexs>
 249 echo drop table t1;
 250 echo drop table t2;
 251 echo drop table t3;
 252 Statement Executed
 253 Statement Executed
 254 Statement Executed
 255 echo drop table t4;
 256 Statement Executed