add tests for new decimal data type

phoenixluo · phoenixluo · commit 54d66ccac9b3 · 2013-07-26T11:35:24.000+08:00
diff --git a/pymysqlreplication/tests/test_data_type.py b/pymysqlreplication/tests/test_data_type.py
@@ -58,6 +58,31 @@ def test_decimal_long_values(self):
         event = self.create_and_insert_value(create_query, insert_query)
         self.assertEqual(event.rows[0]["values"]["test"], Decimal("42000.123456"))
 
+    def test_decimal_long_values_1(self):
+        create_query = "CREATE TABLE test (\
+            test DECIMAL(20,10) \
+        )"
+        insert_query = "INSERT INTO test VALUES(9000000001.123456)"
+        event = self.create_and_insert_value(create_query, insert_query)
+        self.assertEqual(event.rows[0]["values"]["test"], Decimal("9000000001.123456"))
+
+    def test_decimal_long_values_1(self):
+        create_query = "CREATE TABLE test (\
+            test DECIMAL(20,10) \
+        )"
+        insert_query = "INSERT INTO test VALUES(9000000123.123456)"
+        event = self.create_and_insert_value(create_query, insert_query)
+        self.assertEqual(event.rows[0]["values"]["test"], Decimal("9000000123.123456"))
+
+    def test_decimal_long_values_2(self):
+        create_query = "CREATE TABLE test (\
+            test DECIMAL(20,10) \
+        )"
+        insert_query = "INSERT INTO test VALUES(9000000123.0000012345)"
+        event = self.create_and_insert_value(create_query, insert_query)
+        self.assertEqual(event.rows[0]["values"]["test"],
+                Decimal("9000000123.0000012345"))
+
     def test_decimal_negative_values(self):
         create_query = "CREATE TABLE test (\
             test DECIMAL(20,10) \
