Fix: unittest failing due to BIGINT UNSIGNED VALUE

isrgomez · isrgomez · commit 6591779a45da · 2018-11-27T23:24:03.000-06:00
A unittest was failing due to the conversion of a BIGINT unsigned
giving as result an OperationalError: BIGINT UNSIGNED value is out
of range in '(1997 - year(curdate()))
The test was corrected to generate the valid value.
diff --git a/tests/test_mysqlx_crud.py b/tests/test_mysqlx_crud.py
@@ -1431,12 +1431,12 @@ def test_modify_patch(self):
         result = collection.modify('TRUE').patch(
             {"actors_bio": {"current": {
                 "age": mysqlx.expr(
-                    'CAST(SUBSTRING_INDEX($.actors_bio.bd, " ", 1)'
-                    ' AS DECIMAL) - Year(CURDATE())')}}
+                    'CAST(Year(CURDATE()) - '
+                    'SUBSTRING_INDEX($.actors_bio.bd, " ", 1) AS DECIMAL)')}}
             }).execute()
         self.assertEqual(8, result.get_affected_items_count())
-        res = self.session.sql("select 1997 - Year(CURDATE())").execute()
-        age = res.fetch_all()[0]["1997 - Year(CURDATE())"]
+        res = self.session.sql("select Year(CURDATE()) - 1997").execute()
+        age = res.fetch_all()[0]["Year(CURDATE()) - 1997"]
         doc = collection.find(
             "actors_bio.rn = 'Maisie Williams'").execute().fetch_all()[0]
         self.assertEqual(
