@Test
public void testArrayValue() throws Exception {
Value[] v = new Value[7];
for (int i = 0; i < v.length; i++) {
v[i] = ValueFactory.createValue(i);
}
ValueCollection av = ValueFactory.createValue(v);
for (int i = 0; i < v.length; i++) {
v[i] = ValueFactory.createValue(i);
}
ValueCollection av2 = ValueFactory.createValue(v);
assertTrue((av.equals(av2)).getAsBoolean());
assertEquals(av.hashCode(), av2.hashCode());
for (int i = 0; i < 7; i++) {
assertTrue((av.get(i).equals(ValueFactory.createValue(i))).getAsBoolean());
}
}
/** Tests the NullValues operations */
@Test
public void testNullValueOperations() throws Exception {
Value n = ValueFactory.createNullValue();
ValueCollection b = ValueFactory.createValue(new Value[0]);
assertTrue((b.equals(n)).isNull());
assertTrue(b.notEquals(n).isNull());
Value v = ValueFactory.createValue(true);
v.and(n);
v.or(n);
// SQL UNKNOWN
assertNull((v.equals(n)).getAsBoolean());
assertNull((v.notEquals(n)).getAsBoolean());
Value i = ValueFactory.createValue(1);
i.equals(n);
i.notEquals(n);
assertTrue((i.less(n)).isNull());
assertTrue((i.lessEqual(n)).isNull());
assertTrue((i.greater(n)).isNull());
assertTrue((i.greaterEqual(n)).isNull());
Value s = ValueFactory.createValue("test");
assertTrue((s.equals(n)).isNull());
assertTrue((s.notEquals(n)).isNull());
assertTrue((s.less(n)).isNull());
assertTrue((s.lessEqual(n)).isNull());
assertTrue((s.greater(n)).isNull());
assertTrue((s.greaterEqual(n)).isNull());
s.matches(n);
Value d = ValueFactory.createValue(new Date());
assertTrue((d.equals(n)).isNull());
assertTrue((d.notEquals(n)).isNull());
assertTrue((d.less(n)).isNull());
assertTrue((d.lessEqual(n)).isNull());
assertTrue((d.greater(n)).isNull());
assertTrue((d.greaterEqual(n)).isNull());
Value t = ValueFactory.createValue(new Time(12));
assertTrue((t.equals(n)).isNull());
assertTrue((t.notEquals(n)).isNull());
assertTrue((t.less(n)).isNull());
assertTrue((t.lessEqual(n)).isNull());
assertTrue((t.greater(n)).isNull());
assertTrue((t.greaterEqual(n)).isNull());
Value ts = ValueFactory.createValue(new Timestamp(12));
assertTrue((ts.equals(n)).isNull());
assertTrue((ts.notEquals(n)).isNull());
assertTrue((ts.less(n)).isNull());
assertTrue((ts.lessEqual(n)).isNull());
assertTrue((ts.greater(n)).isNull());
assertTrue((ts.greaterEqual(n)).isNull());
assertTrue((n.equals(n)).isNull());
assertTrue((n.notEquals(n)).isNull());
assertTrue((n.less(n)).isNull());
assertTrue((n.lessEqual(n)).isNull());
assertTrue((n.greater(n)).isNull());
assertTrue((n.greaterEqual(n)).isNull());
n.matches(n);
}
@Test
public void testValueCollectionComparisons() {
ValueCollection v1 =
ValueFactory.createValue(
new Value[] {ValueFactory.createValue(18), ValueFactory.createValue("abc")});
ValueCollection v2 =
ValueFactory.createValue(
new Value[] {ValueFactory.createValue(18), ValueFactory.createValue("acc")});
ValueCollection v3 =
ValueFactory.createValue(
new Value[] {ValueFactory.createValue(19), ValueFactory.createValue("abc")});
ValueCollection v4 =
ValueFactory.createValue(
new Value[] {ValueFactory.createValue(-12), ValueFactory.createValue("abc")});
assertEquals(0, v1.compareTo(v1));
assertEquals(1, v2.compareTo(v1));
assertEquals(-1, v1.compareTo(v3));
assertEquals(1, v1.compareTo(v4));
assertTrue(v1.less(v2).getAsBoolean());
assertTrue(v2.lessEqual(v2).getAsBoolean());
assertTrue(v3.greater(v2).getAsBoolean());
assertTrue(v4.greaterEqual(v4).getAsBoolean());
assertTrue(v3.greaterEqual(v4).getAsBoolean());
}
