forbitdata.out

derby database source code.good for you.

  40 0423a1fd (4)   70 0b27a2fd016de2356690 (10) 
  50 0423a2ff (4)   50 0423a2ff (4) 
  50 0423a2ff (4)   70 0b27a2fd016de2356690 (10) 
  60 0423a2fd20 (5)   30 0423a2fd (4) 
  60 0423a2fd20 (5)   50 0423a2ff (4) 
  60 0423a2fd20 (5)   60 0423a2fd20 (5) 
  60 0423a2fd20 (5)   70 0b27a2fd016de2356690 (10) 
  70 0b27a2fd016de2356690 (10)   70 0b27a2fd016de2356690 (10) 
SELECT T.ID, T.C2, O.ID, O.C2 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C2 > O.C2 ORDER BY 1,3
  30 0423a2fd (4)   40 0423a1fd (4) 
  50 0423a2ff (4)   30 0423a2fd (4) 
  50 0423a2ff (4)   40 0423a1fd (4) 
  50 0423a2ff (4)   60 0423a2fd20 (5) 
  60 0423a2fd20 (5)   40 0423a1fd (4) 
  70 0b27a2fd016de2356690 (10)   30 0423a2fd (4) 
  70 0b27a2fd016de2356690 (10)   40 0423a1fd (4) 
  70 0b27a2fd016de2356690 (10)   50 0423a2ff (4) 
  70 0b27a2fd016de2356690 (10)   60 0423a2fd20 (5) 
SELECT T.ID, T.C2, O.ID, O.C2 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C2 >= O.C2 ORDER BY 1,3
  30 0423a2fd (4)   30 0423a2fd (4) 
  30 0423a2fd (4)   40 0423a1fd (4) 
  30 0423a2fd (4)   60 0423a2fd20 (5) 
  40 0423a1fd (4)   40 0423a1fd (4) 
  50 0423a2ff (4)   30 0423a2fd (4) 
  50 0423a2ff (4)   40 0423a1fd (4) 
  50 0423a2ff (4)   50 0423a2ff (4) 
  50 0423a2ff (4)   60 0423a2fd20 (5) 
  60 0423a2fd20 (5)   30 0423a2fd (4) 
  60 0423a2fd20 (5)   40 0423a1fd (4) 
  60 0423a2fd20 (5)   60 0423a2fd20 (5) 
  70 0b27a2fd016de2356690 (10)   30 0423a2fd (4) 
  70 0b27a2fd016de2356690 (10)   40 0423a1fd (4) 
  70 0b27a2fd016de2356690 (10)   50 0423a2ff (4) 
  70 0b27a2fd016de2356690 (10)   60 0423a2fd20 (5) 
  70 0b27a2fd016de2356690 (10)   70 0b27a2fd016de2356690 (10) 
SELECT T.ID, T.C2, O.ID, O.C3 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C2 = O.C3 ORDER BY 1,3
42818 types not comparable C2 ... C3
SELECT T.ID, T.C2, O.ID, O.C3 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C2 <> O.C3 ORDER BY 1,3
42818 types not comparable C2 ... C3
SELECT T.ID, T.C2, O.ID, O.C3 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C2 < O.C3 ORDER BY 1,3
42818 types not comparable C2 ... C3
SELECT T.ID, T.C2, O.ID, O.C3 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C2 <= O.C3 ORDER BY 1,3
42818 types not comparable C2 ... C3
SELECT T.ID, T.C2, O.ID, O.C3 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C2 > O.C3 ORDER BY 1,3
42818 types not comparable C2 ... C3
SELECT T.ID, T.C2, O.ID, O.C3 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C2 >= O.C3 ORDER BY 1,3
42818 types not comparable C2 ... C3
SELECT T.ID, T.C2, O.ID, O.C4 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C2 = O.C4 ORDER BY 1,3
42818 types not comparable C2 ... C4
SELECT T.ID, T.C2, O.ID, O.C4 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C2 <> O.C4 ORDER BY 1,3
42818 types not comparable C2 ... C4
SELECT T.ID, T.C2, O.ID, O.C4 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C2 < O.C4 ORDER BY 1,3
42818 types not comparable C2 ... C4
SELECT T.ID, T.C2, O.ID, O.C4 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C2 <= O.C4 ORDER BY 1,3
42818 types not comparable C2 ... C4
SELECT T.ID, T.C2, O.ID, O.C4 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C2 > O.C4 ORDER BY 1,3
42818 types not comparable C2 ... C4
SELECT T.ID, T.C2, O.ID, O.C4 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C2 >= O.C4 ORDER BY 1,3
42818 types not comparable C2 ... C4
SELECT T.ID, T.C3, O.ID, O.C1 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 = O.C1 ORDER BY 1,3
42818 types not comparable C3 ... C1
SELECT T.ID, T.C3, O.ID, O.C1 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 <> O.C1 ORDER BY 1,3
42818 types not comparable C3 ... C1
SELECT T.ID, T.C3, O.ID, O.C1 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 < O.C1 ORDER BY 1,3
42818 types not comparable C3 ... C1
SELECT T.ID, T.C3, O.ID, O.C1 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 <= O.C1 ORDER BY 1,3
42818 types not comparable C3 ... C1
SELECT T.ID, T.C3, O.ID, O.C1 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 > O.C1 ORDER BY 1,3
42818 types not comparable C3 ... C1
SELECT T.ID, T.C3, O.ID, O.C1 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 >= O.C1 ORDER BY 1,3
42818 types not comparable C3 ... C1
SELECT T.ID, T.C3, O.ID, O.C2 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 = O.C2 ORDER BY 1,3
42818 types not comparable C3 ... C2
SELECT T.ID, T.C3, O.ID, O.C2 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 <> O.C2 ORDER BY 1,3
42818 types not comparable C3 ... C2
SELECT T.ID, T.C3, O.ID, O.C2 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 < O.C2 ORDER BY 1,3
42818 types not comparable C3 ... C2
SELECT T.ID, T.C3, O.ID, O.C2 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 <= O.C2 ORDER BY 1,3
42818 types not comparable C3 ... C2
SELECT T.ID, T.C3, O.ID, O.C2 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 > O.C2 ORDER BY 1,3
42818 types not comparable C3 ... C2
SELECT T.ID, T.C3, O.ID, O.C2 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 >= O.C2 ORDER BY 1,3
42818 types not comparable C3 ... C2
SELECT T.ID, T.C3, O.ID, O.C3 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 = O.C3 ORDER BY 1,3
42818 types not comparable C3 ... C3
SELECT T.ID, T.C3, O.ID, O.C3 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 <> O.C3 ORDER BY 1,3
42818 types not comparable C3 ... C3
SELECT T.ID, T.C3, O.ID, O.C3 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 < O.C3 ORDER BY 1,3
42818 types not comparable C3 ... C3
SELECT T.ID, T.C3, O.ID, O.C3 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 <= O.C3 ORDER BY 1,3
42818 types not comparable C3 ... C3
SELECT T.ID, T.C3, O.ID, O.C3 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 > O.C3 ORDER BY 1,3
42818 types not comparable C3 ... C3
SELECT T.ID, T.C3, O.ID, O.C3 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 >= O.C3 ORDER BY 1,3
42818 types not comparable C3 ... C3
SELECT T.ID, T.C3, O.ID, O.C4 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 = O.C4 ORDER BY 1,3
42818 types not comparable C3 ... C4
SELECT T.ID, T.C3, O.ID, O.C4 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 <> O.C4 ORDER BY 1,3
42818 types not comparable C3 ... C4
SELECT T.ID, T.C3, O.ID, O.C4 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 < O.C4 ORDER BY 1,3
42818 types not comparable C3 ... C4
SELECT T.ID, T.C3, O.ID, O.C4 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 <= O.C4 ORDER BY 1,3
42818 types not comparable C3 ... C4
SELECT T.ID, T.C3, O.ID, O.C4 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 > O.C4 ORDER BY 1,3
42818 types not comparable C3 ... C4
SELECT T.ID, T.C3, O.ID, O.C4 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C3 >= O.C4 ORDER BY 1,3
42818 types not comparable C3 ... C4
SELECT T.ID, T.C4, O.ID, O.C1 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 = O.C1 ORDER BY 1,3
42818 types not comparable C4 ... C1
SELECT T.ID, T.C4, O.ID, O.C1 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 <> O.C1 ORDER BY 1,3
42818 types not comparable C4 ... C1
SELECT T.ID, T.C4, O.ID, O.C1 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 < O.C1 ORDER BY 1,3
42818 types not comparable C4 ... C1
SELECT T.ID, T.C4, O.ID, O.C1 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 <= O.C1 ORDER BY 1,3
42818 types not comparable C4 ... C1
SELECT T.ID, T.C4, O.ID, O.C1 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 > O.C1 ORDER BY 1,3
42818 types not comparable C4 ... C1
SELECT T.ID, T.C4, O.ID, O.C1 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 >= O.C1 ORDER BY 1,3
42818 types not comparable C4 ... C1
SELECT T.ID, T.C4, O.ID, O.C2 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 = O.C2 ORDER BY 1,3
42818 types not comparable C4 ... C2
SELECT T.ID, T.C4, O.ID, O.C2 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 <> O.C2 ORDER BY 1,3
42818 types not comparable C4 ... C2
SELECT T.ID, T.C4, O.ID, O.C2 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 < O.C2 ORDER BY 1,3
42818 types not comparable C4 ... C2
SELECT T.ID, T.C4, O.ID, O.C2 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 <= O.C2 ORDER BY 1,3
42818 types not comparable C4 ... C2
SELECT T.ID, T.C4, O.ID, O.C2 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 > O.C2 ORDER BY 1,3
42818 types not comparable C4 ... C2
SELECT T.ID, T.C4, O.ID, O.C2 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 >= O.C2 ORDER BY 1,3
42818 types not comparable C4 ... C2
SELECT T.ID, T.C4, O.ID, O.C3 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 = O.C3 ORDER BY 1,3
42818 types not comparable C4 ... C3
SELECT T.ID, T.C4, O.ID, O.C3 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 <> O.C3 ORDER BY 1,3
42818 types not comparable C4 ... C3
SELECT T.ID, T.C4, O.ID, O.C3 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 < O.C3 ORDER BY 1,3
42818 types not comparable C4 ... C3
SELECT T.ID, T.C4, O.ID, O.C3 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 <= O.C3 ORDER BY 1,3
42818 types not comparable C4 ... C3
SELECT T.ID, T.C4, O.ID, O.C3 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 > O.C3 ORDER BY 1,3
42818 types not comparable C4 ... C3
SELECT T.ID, T.C4, O.ID, O.C3 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 >= O.C3 ORDER BY 1,3
42818 types not comparable C4 ... C3
SELECT T.ID, T.C4, O.ID, O.C4 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 = O.C4 ORDER BY 1,3
42818 types not comparable C4 ... C4
SELECT T.ID, T.C4, O.ID, O.C4 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 <> O.C4 ORDER BY 1,3
42818 types not comparable C4 ... C4
SELECT T.ID, T.C4, O.ID, O.C4 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 < O.C4 ORDER BY 1,3
42818 types not comparable C4 ... C4
SELECT T.ID, T.C4, O.ID, O.C4 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 <= O.C4 ORDER BY 1,3
42818 types not comparable C4 ... C4
SELECT T.ID, T.C4, O.ID, O.C4 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 > O.C4 ORDER BY 1,3
42818 types not comparable C4 ... C4
SELECT T.ID, T.C4, O.ID, O.C4 FROM FBDVAL.T001 O, FBDVAL.T002 T WHERE T.C4 >= O.C4 ORDER BY 1,3
42818 types not comparable C4 ... C4
END testCompare
START testEncodedLengths
 EL byte[] 10 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL stream 10 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL byte[] 10 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL stream 10 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL byte[] 30 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL stream 30 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL byte[] 30 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL stream 30 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL byte[] 31 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL stream 31 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL byte[] 31 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL stream 31 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL byte[] 32 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL stream 32 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL byte[] 32 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL stream 32 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL byte[] 1345 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL stream 1345 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL byte[] 1345 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL stream 1345 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL byte[] 23456 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL stream 23456 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL byte[] 23456 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL stream 23456 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL byte[] 32672 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL stream 32672 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL byte[] 32672 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL stream 32672 C1 OK DATA OK C2 OK DATA OK C3 OK DATA OK
 EL byte[] 32700 C1 NULL C2 OK DATA OK C3 OK DATA OK
 EL stream 32700 C1 NULL C2 OK DATA OK C3 OK DATA OK
 EL byte[] 32700 C1 NULL C2 OK DATA OK C3 OK DATA OK
 EL stream 32700 C1 NULL C2 OK DATA OK C3 OK DATA OK
 EL byte[] 32767 C1 NULL C2 NULL C3 OK DATA OK
 EL stream 32767 C1 NULL C2 NULL C3 OK DATA OK
 EL byte[] 32767 C1 NULL C2 NULL C3 OK DATA OK
 EL stream 32767 C1 NULL C2 NULL C3 OK DATA OK
 EL byte[] 32768 C1 NULL C2 NULL C3 OK DATA OK
 EL stream 32768 C1 NULL C2 NULL C3 OK DATA OK
 EL byte[] 32768 C1 NULL C2 NULL C3 OK DATA OK
 EL stream 32768 C1 NULL C2 NULL C3 OK DATA OK
 EL byte[] 32769 C1 NULL C2 NULL C3 OK DATA OK
 EL stream 32769 C1 NULL C2 NULL C3 OK DATA OK
 EL byte[] 32769 C1 NULL C2 NULL C3 OK DATA OK
 EL stream 32769 C1 NULL C2 NULL C3 OK DATA OK
 EL byte[] 65535 C1 NULL C2 NULL C3 OK DATA OK
 EL stream 65535 C1 NULL C2 NULL C3 OK DATA OK
 EL byte[] 65535 C1 NULL C2 NULL C3 OK DATA OK
 EL stream 65535 C1 NULL C2 NULL C3 OK DATA OK
 EL byte[] 65536 C1 NULL C2 NULL C3 OK DATA OK
 EL stream 65536 C1 NULL C2 NULL C3 OK DATA OK
 EL byte[] 65536 C1 NULL C2 NULL C3 OK DATA OK
 EL stream 65536 C1 NULL C2 NULL C3 OK DATA OK
 EL byte[] 65537 C1 NULL C2 NULL C3 OK DATA OK
 EL stream 65537 C1 NULL C2 NULL C3 OK DATA OK
 EL byte[] 65537 C1 NULL C2 NULL C3 OK DATA OK
 EL stream 65537 C1 NULL C2 NULL C3 OK DATA OK
 EL byte[] 115882 C1 NULL C2 NULL C3 OK DATA OK
 EL stream 115882 C1 NULL C2 NULL C3 OK DATA OK
 EL byte[] 115882 C1 NULL C2 NULL C3 OK DATA OK
 EL stream 115882 C1 NULL C2 NULL C3 OK DATA OK
END testEncodedLengths