From fc4f7e6cf12996f4afce71e97918bff2ab699919 Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Wed, 3 Jun 2009 19:25:27 -0500
Subject: [7947] Use "NUMERIC" type instead of "BIGINT" in mysql_to_pgsql
 convertor. Author: AlexDereka

--HG--
branch : trunk
---
 contrib/mysql_to_pgsql/src/defines.h | 15 +++++++++++++--
 1 file changed, 13 insertions(+), 2 deletions(-)

(limited to 'contrib/mysql_to_pgsql/src')

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:
-- 
cgit v1.2.3