public void testCompare() { for (float x : VALUES) { for (float y : VALUES) { // note: spec requires only that the sign is the same assertEquals(x + ", " + y, Float.valueOf(x).compareTo(y), Floats.compare(x, y)); } } }
final float val = vals[j]; final float indexedVal = indexed.get(j); if (Floats.compare(val, indexedVal) != 0) { failureHappened.set(true); reason.set(StringUtils.format("Thread1[%d]: %f != %f", j, val, indexedVal));
final float val = vals[j]; final float indexedVal = indexed2.get(j); if (Floats.compare(val, indexedVal) != 0) { failureHappened.set(true); reason.set(StringUtils.format("Thread2[%d]: %f != %f", j, val, indexedVal));
@ExpectWarning(value="RV_CHECK_COMPARETO_FOR_SPECIFIC_RETURN_VALUE", num = 9) public static int testGuavaPrimitiveCompareCalls() { int count = 0; if (Booleans.compare(false, true) == -1) count++; if (Chars.compare('a', 'b') == -1) count++; if (Doubles.compare(1, 2) == -1) count++; if (Floats.compare(1, 2) == -1) count++; if (Ints.compare(1, 2) == -1) count++; if (Longs.compare(1, 2) == -1) count++; if (Shorts.compare((short) 1, (short) 2) == -1) count++; if (SignedBytes.compare((byte) 1, (byte) 2) == -1) count++; if (UnsignedBytes.compare((byte) 1, (byte) 2) == -1) count++; return count; }
@Test public void testRoundFloat() throws Exception { Connection conn = DriverManager.getConnection(getUrl()); ResultSet rs = conn.createStatement().executeQuery( "SELECT ROUND(fl), ROUND(fl, 1), ROUND(fl, 2), ROUND(fl, 3) FROM " + tableName); assertTrue(rs.next()); assertEquals(0, Floats.compare(1, rs.getFloat(1))); assertEquals(0, Floats.compare(1.3f, rs.getFloat(2))); assertEquals(0, Floats.compare(1.26f, rs.getFloat(3))); assertEquals(0, Floats.compare(1.264f, rs.getFloat(4))); }
@Test public void testRoundUnsignedFloat() throws Exception { Connection conn = DriverManager.getConnection(getUrl()); ResultSet rs = conn.createStatement().executeQuery( "SELECT ROUND(unfl), ROUND(unfl, 1), ROUND(unfl, 2), ROUND(unfl, 3) FROM " + tableName); assertTrue(rs.next()); assertEquals(0, Floats.compare(1, rs.getFloat(1))); assertEquals(0, Floats.compare(1.3f, rs.getFloat(2))); assertEquals(0, Floats.compare(1.26f, rs.getFloat(3))); assertEquals(0, Floats.compare(1.264f, rs.getFloat(4))); }
@Test public void testRoundUnsignedDouble() throws Exception { Connection conn = DriverManager.getConnection(getUrl()); ResultSet rs = conn.createStatement().executeQuery( "SELECT ROUND(undoub), ROUND(undoub, 1), ROUND(undoub, 2), ROUND(undoub, 3) FROM " + tableName); assertTrue(rs.next()); assertEquals(0, Floats.compare(1, rs.getFloat(1))); assertEquals(0, Floats.compare(1.3f, rs.getFloat(2))); assertEquals(0, Floats.compare(1.26f, rs.getFloat(3))); assertEquals(0, Floats.compare(1.264f, rs.getFloat(4))); }
@Test public void testNotEqualsByFloat() throws Exception { String query = "SELECT a_float -- and here comment\n" + "FROM aTable WHERE organization_id=? and a_float != 0.01d and a_float <= 0.02d"; Properties props = new Properties(TEST_PROPERTIES); props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts + 2)); // Execute at timestamp 2 Connection conn = DriverManager.getConnection(PHOENIX_JDBC_URL, props); try { PreparedStatement statement = conn.prepareStatement(query); statement.setString(1, tenantId); ResultSet rs = statement.executeQuery(); assertTrue (rs.next()); assertTrue(Floats.compare(rs.getFloat(1), 0.02f) == 0); assertFalse(rs.next()); } finally { conn.close(); } }
@Test public void testNotEqualsByUnsignedFloat() throws Exception { String query = "SELECT a_unsigned_float -- and here comment\n" + "FROM aTable WHERE organization_id=? and a_unsigned_float != 0.01d and a_unsigned_float <= 0.02d"; Properties props = new Properties(TEST_PROPERTIES); props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts + 2)); // Execute at timestamp 2 Connection conn = DriverManager.getConnection(PHOENIX_JDBC_URL, props); try { PreparedStatement statement = conn.prepareStatement(query); statement.setString(1, tenantId); ResultSet rs = statement.executeQuery(); assertTrue (rs.next()); assertTrue(Floats.compare(rs.getFloat(1), 0.02f) == 0); assertFalse(rs.next()); } finally { conn.close(); } }
@Test public void testSumFloat() throws Exception { initSumDoubleValues(null); String query = "SELECT SUM(f) FROM SumDoubleTest"; Properties props = new Properties(TEST_PROPERTIES); Connection conn = DriverManager.getConnection(PHOENIX_JDBC_URL, props); try { PreparedStatement statement = conn.prepareStatement(query); ResultSet rs = statement.executeQuery(); assertTrue (rs.next()); assertTrue(Floats.compare(rs.getFloat(1), 0.15f)==0); assertFalse(rs.next()); } finally { conn.close(); } }
@Test public void testSumUnsignedFloat() throws Exception { initSumDoubleValues(null); String query = "SELECT SUM(uf) FROM SumDoubleTest"; Properties props = new Properties(TEST_PROPERTIES); Connection conn = DriverManager.getConnection(PHOENIX_JDBC_URL, props); try { PreparedStatement statement = conn.prepareStatement(query); ResultSet rs = statement.executeQuery(); assertTrue (rs.next()); assertTrue(Floats.compare(rs.getFloat(1), 0.15f)==0); assertFalse(rs.next()); } finally { conn.close(); } }
@Test public void testScanByUnsignedFloatValue() throws Exception { String query = "SELECT a_string, b_string, a_unsigned_float FROM aTable WHERE ?=organization_id and ?=a_unsigned_float"; Properties props = new Properties(TEST_PROPERTIES); props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts + 2)); // Execute at timestamp 2 Connection conn = DriverManager.getConnection(PHOENIX_JDBC_URL, props); try { PreparedStatement statement = conn.prepareStatement(query); statement.setString(1, tenantId); statement.setFloat(2, 0.01f); ResultSet rs = statement.executeQuery(); assertTrue (rs.next()); assertEquals(rs.getString(1), A_VALUE); assertEquals(rs.getString("B_string"), B_VALUE); assertTrue(Floats.compare(rs.getFloat(3), 0.01f) == 0); assertFalse(rs.next()); } finally { conn.close(); } }
@Test public void testScanByFloatValue() throws Exception { String query = "SELECT a_string, b_string, a_float FROM aTable WHERE ?=organization_id and ?=a_float"; Properties props = new Properties(TEST_PROPERTIES); props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, Long.toString(ts + 2)); // Execute at timestamp 2 Connection conn = DriverManager.getConnection(PHOENIX_JDBC_URL, props); try { PreparedStatement statement = conn.prepareStatement(query); statement.setString(1, tenantId); statement.setFloat(2, 0.01f); ResultSet rs = statement.executeQuery(); assertTrue (rs.next()); assertEquals(rs.getString(1), A_VALUE); assertEquals(rs.getString("B_string"), B_VALUE); assertTrue(Floats.compare(rs.getFloat(3), 0.01f) == 0); assertFalse(rs.next()); } finally { conn.close(); } }
@Test public void testNotEqualsByUnsignedFloat() throws Exception { String query = "SELECT a_unsigned_float -- and here comment\n" + "FROM " + tableName + " WHERE organization_id=? and a_unsigned_float != 0.01 and a_unsigned_float <= 0.02"; Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES); Connection conn = DriverManager.getConnection(getUrl(), props); try { PreparedStatement statement = conn.prepareStatement(query); statement.setString(1, tenantId); ResultSet rs = statement.executeQuery(); assertTrue (rs.next()); assertTrue(Floats.compare(rs.getFloat(1), 0.02f) == 0); assertFalse(rs.next()); } finally { conn.close(); } }
@Test public void testNotEqualsByFloat() throws Exception { String query = "SELECT a_float -- and here comment\n" + "FROM " + tableName + " WHERE organization_id=? and a_float != CAST(0.01 AS FLOAT) and a_float <= CAST(0.02 AS FLOAT)"; Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES); Connection conn = DriverManager.getConnection(getUrl(), props); try { PreparedStatement statement = conn.prepareStatement(query); statement.setString(1, tenantId); ResultSet rs = statement.executeQuery(); assertTrue (rs.next()); assertTrue(Floats.compare(rs.getFloat(1), 0.02f) == 0); assertFalse(rs.next()); } finally { conn.close(); } }
@Test public void testScanByFloatValue() throws Exception { String query = "SELECT a_string, b_string, a_float FROM " + tableName + " WHERE ?=organization_id and ?=a_float"; Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES); Connection conn = DriverManager.getConnection(getUrl(), props); try { PreparedStatement statement = conn.prepareStatement(query); statement.setString(1, getOrganizationId()); statement.setFloat(2, 0.01f); ResultSet rs = statement.executeQuery(); assertTrue (rs.next()); assertEquals(rs.getString(1), A_VALUE); assertEquals(rs.getString("B_string"), B_VALUE); assertTrue(Floats.compare(rs.getFloat(3), 0.01f) == 0); assertFalse(rs.next()); } finally { conn.close(); } }
@Test public void testScanByUnsignedFloatValue() throws Exception { String query = "SELECT a_string, b_string, a_unsigned_float FROM " + tableName + " WHERE ?=organization_id and ?=a_unsigned_float"; Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES); Connection conn = DriverManager.getConnection(getUrl(), props); try { PreparedStatement statement = conn.prepareStatement(query); statement.setString(1, getOrganizationId()); statement.setFloat(2, 0.01f); ResultSet rs = statement.executeQuery(); assertTrue (rs.next()); assertEquals(rs.getString(1), A_VALUE); assertEquals(rs.getString("B_string"), B_VALUE); assertTrue(Floats.compare(rs.getFloat(3), 0.01f) == 0); assertFalse(rs.next()); } finally { conn.close(); } }
@Test public void testSumFloat() throws Exception { String tableName = "TBL_" + generateUniqueName(); initSumDoubleValues(tableName, null, getUrl()); String query = "SELECT SUM(f) FROM " + tableName ; Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES); Connection conn = DriverManager.getConnection(getUrl(), props); try { PreparedStatement statement = conn.prepareStatement(query); ResultSet rs = statement.executeQuery(); assertTrue (rs.next()); assertTrue(Floats.compare(rs.getFloat(1), 0.15f)==0); assertFalse(rs.next()); } finally { conn.close(); } }
@Test public void testSumUnsignedFloat() throws Exception { String tableName = "TBL_" + generateUniqueName(); initSumDoubleValues(tableName, null, getUrl()); String query = "SELECT SUM(uf) FROM " + tableName; Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES); Connection conn = DriverManager.getConnection(getUrl(), props); try { PreparedStatement statement = conn.prepareStatement(query); ResultSet rs = statement.executeQuery(); assertTrue (rs.next()); assertTrue(Floats.compare(rs.getFloat(1), 0.15f)==0); assertFalse(rs.next()); } finally { conn.close(); } }
assertEquals("[25.343, 36.763, 37.56, 386.63]", rs.getString(1)); assertEquals(rs.getString("B_string"), B_VALUE); assertTrue(Floats.compare(rs.getFloat(3), 0.01f) == 0); assertFalse(rs.next()); } finally {