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

   1 Connection opened
   2 Table t1 Created
   3 Index Created
   4 Index Created
   5 Index Created
   6 Index Created
   7 Index Created
   8 Index Created
   9 Index Created
  10 Index Already Exist
  11 Index Created
  12 Index Created
  13 Index Created
  14 Index Created
  15 Index Created
  16 Index Created
  17 Index Already Exist
  18 Index Already Exist
  19 Index Created
  20 Index Created
  21 Index Created
  22 Index Created
  23 Index Created
  24 Index Already Exist
  25 Index Already Exist
  26 Index Already Exist
  27 Index Created
  28 Index Created
  29 Index Created
  30 Index Created
  31 Index Already Exist
  32 Index Already Exist
  33 Index Already Exist
  34 Index Already Exist
  35 Index Created
  36 Index Created
  37 Index Created
  38 Index Already Exist
  39 Index Already Exist
  40 Index Already Exist
  41 Index Already Exist
  42 Index Already Exist
  43 Index Created
  44 Index Created
  45 Index Already Exist
  46 Index Already Exist
  47 Index Already Exist
  48 Index Already Exist
  49 Index Already Exist
  50 Index Already Exist
  51 Index Created
  52 Index Already Exist
  53 Index Already Exist
  54 Index Already Exist
  55 Index Already Exist
  56 Index Already Exist
  57 Index Already Exist
  58 Index Already Exist
  59 Index Created
  60 Index Created
  61 Index Created
  62 Index Created
  63 Index Created
  64 Index Created
  65          TABLES
  66         --------
  67         t1
  68 Connection Closed
  69 <Table Information of all tables>
  70   <TableInfo>
  71     <TableName> t1 </TableName>
  72       <FieldInfo>
  73         <FieldName> f1 </FieldName>
  74         <Type> 4 </Type>
  75         <Length> 4 </Length>
  76         <Primary> 0 </Primary>
  77         <Null> 0 </Null>
  78         <Default> 0 </Default>
  79         <DefaultValue>  </DefaultValue>
  80       </FieldInfo>
  81       <FieldInfo>
  82         <FieldName> f2 </FieldName>
  83         <Type> 3 </Type>
  84         <Length> 4 </Length>
  85         <Primary> 0 </Primary>
  86         <Null> 0 </Null>
  87         <Default> 0 </Default>
  88         <DefaultValue>  </DefaultValue>
  89       </FieldInfo>
  90       <FieldInfo>
  91         <FieldName> f3 </FieldName>
  92         <Type> 0 </Type>
  93         <Length> 4 </Length>
  94         <Primary> 0 </Primary>
  95         <Null> 0 </Null>
  96         <Default> 0 </Default>
  97         <DefaultValue>  </DefaultValue>
  98       </FieldInfo>
  99       <FieldInfo>
 100         <FieldName> f4 </FieldName>
 101         <Type> 2 </Type>
 102         <Length> 8 </Length>
 103         <Primary> 0 </Primary>
 104         <Null> 0 </Null>
 105         <Default> 0 </Default>
 106         <DefaultValue>  </DefaultValue>
 107       </FieldInfo>
 108       <FieldInfo>
 109         <FieldName> f5 </FieldName>
 110         <Type> 30 </Type>
 111         <Length> 20 </Length>
 112         <Primary> 0 </Primary>
 113         <Null> 0 </Null>
 114         <Default> 0 </Default>
 115         <DefaultValue>  </DefaultValue>
 116       </FieldInfo>
 117       <FieldInfo>
 118         <FieldName> f6 </FieldName>
 119         <Type> 32 </Type>
 120         <Length> 32 </Length>
 121         <Primary> 0 </Primary>
 122         <Null> 0 </Null>
 123         <Default> 0 </Default>
 124         <DefaultValue>  </DefaultValue>
 125       </FieldInfo>
 126       <FieldInfo>
 127         <FieldName> f7 </FieldName>
 128         <Type> 11 </Type>
 129         <Length> 4 </Length>
 130         <Primary> 0 </Primary>
 131         <Null> 0 </Null>
 132         <Default> 0 </Default>
 133         <DefaultValue>  </DefaultValue>
 134       </FieldInfo>
 135       <FieldInfo>
 136         <FieldName> f8 </FieldName>
 137         <Type> 10 </Type>
 138         <Length> 8 </Length>
 139         <Primary> 0 </Primary>
 140         <Null> 0 </Null>
 141         <Default> 0 </Default>
 142         <DefaultValue>  </DefaultValue>
 143       </FieldInfo>
 144       <FieldInfo>
 145         <FieldName> f9 </FieldName>
 146         <Type> 20 </Type>
 147         <Length> 4 </Length>
 148         <Primary> 0 </Primary>
 149         <Null> 0 </Null>
 150         <Default> 0 </Default>
 151         <DefaultValue>  </DefaultValue>
 152       </FieldInfo>
 153       <FieldInfo>
 154         <FieldName> f10 </FieldName>
 155         <Type> 21 </Type>
 156         <Length> 4 </Length>
 157         <Primary> 0 </Primary>
 158         <Null> 0 </Null>
 159         <Default> 0 </Default>
 160         <DefaultValue>  </DefaultValue>
 161       </FieldInfo>
 162       <FieldInfo>
 163         <FieldName> f11 </FieldName>
 164         <Type> 22 </Type>
 165         <Length> 8 </Length>
 166         <Primary> 0 </Primary>
 167         <Null> 0 </Null>
 168         <Default> 0 </Default>
 169         <DefaultValue>  </DefaultValue>
 170       </FieldInfo>
 171   </TableInfo>
 172 </Table Information of all tables>
 173 <Index Information of all Indexs>
 174     <Index Name> idxtinyint_smallint </Index Name>
 175         <Index Type> Hash Index </Index Type>
 176         <Table Name> t1 </Table Name>
 177         <Field Name> f1 </Field Name>
 178         <Field Name> f2 </Field Name>
 179     <Index Name> idxtinyint_int </Index Name>
 180         <Index Type> Hash Index </Index Type>
 181         <Table Name> t1 </Table Name>
 182         <Field Name> f1 </Field Name>
 183         <Field Name> f3 </Field Name>
 184     <Index Name> idxtinyint_bigint </Index Name>
 185         <Index Type> Hash Index </Index Type>
 186         <Table Name> t1 </Table Name>
 187         <Field Name> f1 </Field Name>
 188         <Field Name> f4 </Field Name>
 189     <Index Name> idxtinyint_char </Index Name>
 190         <Index Type> Hash Index </Index Type>
 191         <Table Name> t1 </Table Name>
 192         <Field Name> f1 </Field Name>
 193         <Field Name> f5 </Field Name>
 194     <Index Name> idxtinyint_varchar </Index Name>
 195         <Index Type> Hash Index </Index Type>
 196         <Table Name> t1 </Table Name>
 197         <Field Name> f1 </Field Name>
 198         <Field Name> f6 </Field Name>
 199     <Index Name> idxtinyint_date </Index Name>
 200         <Index Type> Hash Index </Index Type>
 201         <Table Name> t1 </Table Name>
 202         <Field Name> f1 </Field Name>
 203         <Field Name> f9 </Field Name>
 204     <Index Name> idxtinyint_time </Index Name>
 205         <Index Type> Hash Index </Index Type>
 206         <Table Name> t1 </Table Name>
 207         <Field Name> f1 </Field Name>
 208         <Field Name> f10 </Field Name>
 209     <Index Name> idxsmallint_int </Index Name>
 210         <Index Type> Hash Index </Index Type>
 211         <Table Name> t1 </Table Name>
 212         <Field Name> f2 </Field Name>
 213         <Field Name> f3 </Field Name>
 214     <Index Name> idxsmallint_bigint </Index Name>
 215         <Index Type> Hash Index </Index Type>
 216         <Table Name> t1 </Table Name>
 217         <Field Name> f2 </Field Name>
 218         <Field Name> f4 </Field Name>
 219     <Index Name> idxsmallint_char </Index Name>
 220         <Index Type> Hash Index </Index Type>
 221         <Table Name> t1 </Table Name>
 222         <Field Name> f2 </Field Name>
 223         <Field Name> f5 </Field Name>
 224     <Index Name> idxsmallint_varchar </Index Name>
 225         <Index Type> Hash Index </Index Type>
 226         <Table Name> t1 </Table Name>
 227         <Field Name> f2 </Field Name>
 228         <Field Name> f6 </Field Name>
 229     <Index Name> idxsmallint_date </Index Name>
 230         <Index Type> Hash Index </Index Type>
 231         <Table Name> t1 </Table Name>
 232         <Field Name> f2 </Field Name>
 233         <Field Name> f9 </Field Name>
 234     <Index Name> idxsmallint_time </Index Name>
 235         <Index Type> Hash Index </Index Type>
 236         <Table Name> t1 </Table Name>
 237         <Field Name> f2 </Field Name>
 238         <Field Name> f10 </Field Name>
 239     <Index Name> idxint_bigint </Index Name>
 240         <Index Type> Hash Index </Index Type>
 241         <Table Name> t1 </Table Name>
 242         <Field Name> f3 </Field Name>
 243         <Field Name> f4 </Field Name>
 244     <Index Name> idxint_char </Index Name>
 245         <Index Type> Hash Index </Index Type>
 246         <Table Name> t1 </Table Name>
 247         <Field Name> f3 </Field Name>
 248         <Field Name> f5 </Field Name>
 249     <Index Name> idxint_varchar </Index Name>
 250         <Index Type> Hash Index </Index Type>
 251         <Table Name> t1 </Table Name>
 252         <Field Name> f3 </Field Name>
 253         <Field Name> f6 </Field Name>
 254     <Index Name> idxint_date </Index Name>
 255         <Index Type> Hash Index </Index Type>
 256         <Table Name> t1 </Table Name>
 257         <Field Name> f3 </Field Name>
 258         <Field Name> f9 </Field Name>
 259     <Index Name> idxint_time </Index Name>
 260         <Index Type> Hash Index </Index Type>
 261         <Table Name> t1 </Table Name>
 262         <Field Name> f3 </Field Name>
 263         <Field Name> f10 </Field Name>
 264     <Index Name> idxbigint_char </Index Name>
 265         <Index Type> Hash Index </Index Type>
 266         <Table Name> t1 </Table Name>
 267         <Field Name> f4 </Field Name>
 268         <Field Name> f5 </Field Name>
 269     <Index Name> idxbigint_varchar </Index Name>
 270         <Index Type> Hash Index </Index Type>
 271         <Table Name> t1 </Table Name>
 272         <Field Name> f4 </Field Name>
 273         <Field Name> f6 </Field Name>
 274     <Index Name> idxbigint_date </Index Name>
 275         <Index Type> Hash Index </Index Type>
 276         <Table Name> t1 </Table Name>
 277         <Field Name> f4 </Field Name>
 278         <Field Name> f9 </Field Name>
 279     <Index Name> idxbigint_time </Index Name>
 280         <Index Type> Hash Index </Index Type>
 281         <Table Name> t1 </Table Name>
 282         <Field Name> f4 </Field Name>
 283         <Field Name> f10 </Field Name>
 284     <Index Name> idxchar_varchar </Index Name>
 285         <Index Type> Hash Index </Index Type>
 286         <Table Name> t1 </Table Name>
 287         <Field Name> f5 </Field Name>
 288         <Field Name> f6 </Field Name>
 289     <Index Name> idxchar_date </Index Name>
 290         <Index Type> Hash Index </Index Type>
 291         <Table Name> t1 </Table Name>
 292         <Field Name> f5 </Field Name>
 293         <Field Name> f9 </Field Name>
 294     <Index Name> idxchar_time </Index Name>
 295         <Index Type> Hash Index </Index Type>
 296         <Table Name> t1 </Table Name>
 297         <Field Name> f5 </Field Name>
 298         <Field Name> f10 </Field Name>
 299     <Index Name> idxvarchar_date </Index Name>
 300         <Index Type> Hash Index </Index Type>
 301         <Table Name> t1 </Table Name>
 302         <Field Name> f6 </Field Name>
 303         <Field Name> f9 </Field Name>
 304     <Index Name> idxvarchar_time </Index Name>
 305         <Index Type> Hash Index </Index Type>
 306         <Table Name> t1 </Table Name>
 307         <Field Name> f6 </Field Name>
 308         <Field Name> f10 </Field Name>
 309     <Index Name> idxdate_time </Index Name>
 310         <Index Type> Hash Index </Index Type>
 311         <Table Name> t1 </Table Name>
 312         <Field Name> f9 </Field Name>
 313         <Field Name> f10 </Field Name>
 314     <Index Name> idxtinyint_smallint_int </Index Name>
 315         <Index Type> Hash Index </Index Type>
 316         <Table Name> t1 </Table Name>
 317         <Field Name> f1 </Field Name>
 318         <Field Name> f2 </Field Name>
 319         <Field Name> f3 </Field Name>
 320     <Index Name> idxtinyint_smallint_int_bigint </Index Name>
 321         <Index Type> Hash Index </Index Type>
 322         <Table Name> t1 </Table Name>
 323         <Field Name> f1 </Field Name>
 324         <Field Name> f2 </Field Name>
 325         <Field Name> f3 </Field Name>
 326         <Field Name> f4 </Field Name>
 327     <Index Name> idxtinyint_smallint_int_bigint_char </Index Name>
 328         <Index Type> Hash Index </Index Type>
 329         <Table Name> t1 </Table Name>
 330         <Field Name> f1 </Field Name>
 331         <Field Name> f2 </Field Name>
 332         <Field Name> f3 </Field Name>
 333         <Field Name> f4 </Field Name>
 334         <Field Name> f5 </Field Name>
 335     <Index Name> idxtinyint_smallint_int_bigint_char_varchar </Index Name>
 336         <Index Type> Hash Index </Index Type>
 337         <Table Name> t1 </Table Name>
 338         <Field Name> f1 </Field Name>
 339         <Field Name> f2 </Field Name>
 340         <Field Name> f3 </Field Name>
 341         <Field Name> f4 </Field Name>
 342         <Field Name> f5 </Field Name>
 343         <Field Name> f6 </Field Name>
 344     <Index Name> idxtinyint_smallint_int_bigint_char_varchar_date </Index Name>
 345         <Index Type> Hash Index </Index Type>
 346         <Table Name> t1 </Table Name>
 347         <Field Name> f1 </Field Name>
 348         <Field Name> f2 </Field Name>
 349         <Field Name> f3 </Field Name>
 350         <Field Name> f4 </Field Name>
 351         <Field Name> f5 </Field Name>
 352         <Field Name> f6 </Field Name>
 353         <Field Name> f9 </Field Name>
 354     <Index Name> idxtinyint_smallint_int_bigint_char_varchar_date_time </Index Name>
 355         <Index Type> Hash Index </Index Type>
 356         <Table Name> t1 </Table Name>
 357         <Field Name> f1 </Field Name>
 358         <Field Name> f2 </Field Name>
 359         <Field Name> f3 </Field Name>
 360         <Field Name> f4 </Field Name>
 361         <Field Name> f5 </Field Name>
 362         <Field Name> f6 </Field Name>
 363         <Field Name> f9 </Field Name>
 364         <Field Name> f10 </Field Name>
 365 </Index Information of all Indexs>
 366 echo drop table t1;
 367 Statement Executed