Two more test cases

alex · alex · commit 95a9b19f56e5 · 2013-08-25T07:55:08.000-07:00
diff --git a/pymysqlreplication/tests/test_data_type.py b/pymysqlreplication/tests/test_data_type.py
@@ -222,13 +222,15 @@ def test_longlong(self):
         self.assertEqual(event.rows[0]["values"]["test"], -9223372036854775808)
 
     def test_int24(self):
-        create_query = "CREATE TABLE test (id MEDIUMINT UNSIGNED NOT NULL, test MEDIUMINT, test2 MEDIUMINT, test3 MEDIUMINT)"
-        insert_query = "INSERT INTO test VALUES(16777215, 8388607, -8388608, 8)"
+        create_query = "CREATE TABLE test (id MEDIUMINT UNSIGNED NOT NULL, test MEDIUMINT, test2 MEDIUMINT, test3 MEDIUMINT, test4 MEDIUMINT, test5 MEDIUMINT)"
+        insert_query = "INSERT INTO test VALUES(16777215, 8388607, -8388608, 8, -8, 0)"
         event = self.create_and_insert_value(create_query, insert_query)
         self.assertEqual(event.rows[0]["values"]["id"], 16777215)
         self.assertEqual(event.rows[0]["values"]["test"], 8388607)
         self.assertEqual(event.rows[0]["values"]["test2"], -8388608)
         self.assertEqual(event.rows[0]["values"]["test3"], 8)
+        self.assertEqual(event.rows[0]["values"]["test4"], -8)
+        self.assertEqual(event.rows[0]["values"]["test5"], 0)
 
     def test_date(self):
         create_query = "CREATE TABLE test (test DATE);"
