test/sql/Datatype/exp.test005.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) hash;
   6 Statement Executed
   7 echo create index idx2 on t2(f1) hash unique;
   8 Statement Executed
   9 Statement Executed: Rows Affected = 1
  10 echo insert into t2 values('Lakshya1',20);
  11 Statement execute failed with error -21
  12 echo select * from t1;
  13 ---------------------------------------------------------
  14         t1.f1   t1.f2
  15 ---------------------------------------------------------
  16
  17 echo select * from t2;
  18 ---------------------------------------------------------
  19         t2.f1   t2.f2
  20 ---------------------------------------------------------
  21         Lakshya1        10
  22
  23 <Table Information of all tables>
  24   <TableInfo>
  25     <TableName> t1 </TableName>
  26       <FieldInfo>
  27         <FieldName> f1 </FieldName>
  28         <Type> 32 </Type>
  29         <Length> 11 </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> 1 </Length>
  39         <Primary> 0 </Primary>
  40         <Null> 0 </Null>
  41         <Default> 0 </Default>
  42         <DefaultValue>  </DefaultValue>
  43       </FieldInfo>
  44   </TableInfo>
  45   <TableInfo>
  46     <TableName> t2 </TableName>
  47       <FieldInfo>
  48         <FieldName> f1 </FieldName>
  49         <Type> 32 </Type>
  50         <Length> 11 </Length>
  51         <Primary> 0 </Primary>
  52         <Null> 0 </Null>
  53         <Default> 0 </Default>
  54         <DefaultValue>  </DefaultValue>
  55       </FieldInfo>
  56       <FieldInfo>
  57         <FieldName> f2 </FieldName>
  58         <Type> 3 </Type>
  59         <Length> 1 </Length>
  60         <Primary> 0 </Primary>
  61         <Null> 0 </Null>
  62         <Default> 0 </Default>
  63         <DefaultValue>  </DefaultValue>
  64       </FieldInfo>
  65   </TableInfo>
  66 </Table Information of all tables>
  67 <Index Information of all Indexs>
  68     <Index Name> idx1 </Index Name>
  69         <Index Type> Hash Index </Index Type>
  70         <Table Name> t1 </Table Name>
  71         <Field Name> f1 </Field Name>
  72     <Index Name> idx2 </Index Name>
  73         <Index Type> Hash Index </Index Type>
  74         <Table Name> t2 </Table Name>
  75         <Field Name> f1 </Field Name>
  76 </Index Information of all Indexs>
  77 Statement Executed
  78 Statement Executed