test/sql/Datatype/exp.test006.ksh

   1 echo create table t1 (f1 varchar(10), f2 smallint);
   2 Statement Executed
   3 echo create table t2 (f1 varchar(10), f2 smallint);
   4 Statement Executed
   5 echo create index idx1 on t1(f1) tree;
   6 Statement execute failed with error -16
   7 echo create index idx2 on t2(f1) tree unique;
   8 Statement execute failed with error -16
   9 <Table Information of all tables>
  10   <TableInfo>
  11     <TableName> t1 </TableName>
  12       <FieldInfo>
  13         <FieldName> f1 </FieldName>
  14         <Type> 32 </Type>
  15         <Length> 12 </Length>
  16         <Primary> 0 </Primary>
  17         <Null> 0 </Null>
  18         <Default> 0 </Default>
  19         <DefaultValue>  </DefaultValue>
  20       </FieldInfo>
  21       <FieldInfo>
  22         <FieldName> f2 </FieldName>
  23         <Type> 3 </Type>
  24         <Length> 4 </Length>
  25         <Primary> 0 </Primary>
  26         <Null> 0 </Null>
  27         <Default> 0 </Default>
  28         <DefaultValue>  </DefaultValue>
  29       </FieldInfo>
  30   </TableInfo>
  31   <TableInfo>
  32     <TableName> t2 </TableName>
  33       <FieldInfo>
  34         <FieldName> f1 </FieldName>
  35         <Type> 32 </Type>
  36         <Length> 12 </Length>
  37         <Primary> 0 </Primary>
  38         <Null> 0 </Null>
  39         <Default> 0 </Default>
  40         <DefaultValue>  </DefaultValue>
  41       </FieldInfo>
  42       <FieldInfo>
  43         <FieldName> f2 </FieldName>
  44         <Type> 3 </Type>
  45         <Length> 4 </Length>
  46         <Primary> 0 </Primary>
  47         <Null> 0 </Null>
  48         <Default> 0 </Default>
  49         <DefaultValue>  </DefaultValue>
  50       </FieldInfo>
  51   </TableInfo>
  52 </Table Information of all tables>
  53 <Index Information of all Indexs>
  54 </Index Information of all Indexs>
  55 Statement Executed
  56 Statement Executed