fix: Flaky testPositionalQueryParameters (#2059)

prash-mi · web-flow · commit 3764b5967c69 · 2022-05-24T14:56:21.000Z
String comparison of values, eg `1.40845209522E9` vs `1408452095.22` seems to be failing, so comparing the values as epoc (Long) instead Fixes #2056 ☕️
diff --git a/google-cloud-bigquery/src/test/java/com/google/cloud/bigquery/it/ITBigQueryTest.java b/google-cloud-bigquery/src/test/java/com/google/cloud/bigquery/it/ITBigQueryTest.java
@@ -3438,7 +3438,12 @@ public void testPositionalQueryParameters() throws InterruptedException {
     assertEquals(QUERY_RESULT_SCHEMA_BIGNUMERIC, result.getSchema());
     assertEquals(2, Iterables.size(result.getValues()));
     for (FieldValueList values : result.iterateAll()) {
-      assertEquals("1.40845209522E9", values.get(0).getValue());
+      // https://github.com/googleapis/java-bigquery/issues/2056. String comparison of values, eg
+      // 1.40845209522E9 vs 1408452095.22 seems to be failing, so comparing the values as epoc
+      // (Long) instead
+      assertEquals(
+          (long) Double.parseDouble("1.40845209522E9"),
+          (long) Double.parseDouble(values.get(0).getValue().toString()));
       assertEquals("stringValue", values.get(1).getValue());
       assertEquals(false, values.get(2).getBooleanValue());
       assertEquals("0.33333333333333333333333333333333333333", values.get(3).getValue());
