From 2b464cae9b25da31b5152e115ac0a477f98566c6 Mon Sep 17 00:00:00 2001
From: unknown <jani@rhols221.adsl.netsonic.fi>
Date: Tue, 7 Sep 2004 11:40:27 +0300
Subject: Fixed Bug#3645, "PROCEDURE ANALYSE() recommends illegal FLOAT
 columns".

---
 sql/sql_analyse.cc | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'sql/sql_analyse.cc')

diff --git a/sql/sql_analyse.cc b/sql/sql_analyse.cc
index 3847849d6a7..0723c274a17 100644
--- a/sql/sql_analyse.cc
+++ b/sql/sql_analyse.cc
@@ -810,6 +810,13 @@ void field_real::get_opt_type(String *answer,
     if (min_arg >= 0)
       answer->append(" UNSIGNED");
   }
+  else if (item->decimals == NOT_FIXED_DEC)
+  {
+    if (min_arg >= -FLT_MAX && max_arg <= FLT_MAX)
+      answer->append("FLOAT", 5);      
+    else
+      answer->append("DOUBLE", 6);
+  }
   else
   {
     if (min_arg >= -FLT_MAX && max_arg <= FLT_MAX)
-- 
cgit v1.2.1