minor typo - switched positive and negative infinities maintaining order [-inf, +inf, NaN] (googleapis#4397)

chemelnucfin · web-flow · commit 23f75dbec0a9 · 2017-11-15T12:04:37.000-08:00
diff --git a/spanner/tests/system/test_system.py b/spanner/tests/system/test_system.py
@@ -1150,19 +1150,19 @@ def test_execute_sql_w_query_param_transfinite(self):
         # Find -inf
         self._check_sql_results(
             snapshot,
-            sql='SELECT eye_d FROM all_types WHERE approx_value = @pos_inf',
-            params={'pos_inf': float('+inf')},
-            param_types={'pos_inf': Type(code=FLOAT64)},
-            expected=[(107,)],
+            sql='SELECT eye_d FROM all_types WHERE approx_value = @neg_inf',
+            params={'neg_inf': float('-inf')},
+            param_types={'neg_inf': Type(code=FLOAT64)},
+            expected=[(207,)],
         )
 
         # Find +inf
         self._check_sql_results(
             snapshot,
-            sql='SELECT eye_d FROM all_types WHERE approx_value = @neg_inf',
-            params={'neg_inf': float('-inf')},
-            param_types={'neg_inf': Type(code=FLOAT64)},
-            expected=[(207,)],
+            sql='SELECT eye_d FROM all_types WHERE approx_value = @pos_inf',
+            params={'pos_inf': float('+inf')},
+            param_types={'pos_inf': Type(code=FLOAT64)},
+            expected=[(107,)],
         )
 
         rows = list(snapshot.execute_sql(
