[7947] Use "NUMERIC" type instead of "BIGINT" in mysql_to_pgsql convertor. Author: AlexDereka

--HG--
branch : trunk

1 files changed, 13 insertions, 2 deletions

diff --git a/contrib/mysql_to_pgsql/src/defines.h b/contrib/mysql_to_pgsql/src/defines.h
index 662a7aab2fd..ed151bf5fae 100644
--- a/contrib/mysql_to_pgsql/src/defines.h
+++ b/contrib/mysql_to_pgsql/src/defines.h
@@ -89,9 +89,20 @@ string ConvertNativeType(enum_field_types mysqlType, uint32 length)
         case FIELD_TYPE_INT24:
             return "integer";
         case FIELD_TYPE_LONGLONG:
-            return "int8";
         case FIELD_TYPE_LONG:
-            return "bigint";
+            {
+                string temp;
+                char str[10];
+                temp = "numeric";
+                if (length)
+                {
+                    temp.append("(");
+                    sprintf(str,"%d",length);
+                    temp.append(str);
+                    temp.append(")");
+                }
+                return temp;
+            }
         case FIELD_TYPE_DECIMAL:
         case FIELD_TYPE_FLOAT:
         case FIELD_TYPE_DOUBLE: