Merge lp:~linuxjedi/drizzle/trunk-bug-707832 into lp:drizzle/7.0

[Andrew Hutchings]

Support float(N) in a create table statment, basically it now ignores the braces. More compatible with the MySQL way of doing it.

=== modified file 'drizzled/sql_yacc.yy'
--- drizzled/sql_yacc.yy	2011-01-25 08:34:23 +0000
+++ drizzled/sql_yacc.yy	2011-01-26 12:40:22 +0000
@@ -1526,8 +1526,12 @@
         ;
 
 opt_precision:
-          /* empty */ {}
-        | precision {}
+          /* empty */
+          { Lex->dec=Lex->length= (char*)0; }
+        | '(' NUM ')'
+          { Lex->length=Lex->dec= (char*)0; }
+        | precision
+          {}
         ;
 
 opt_attribute:

=== added file 'tests/suite/regression/r/707832.result'
--- tests/suite/regression/r/707832.result	1970-01-01 00:00:00 +0000
+++ tests/suite/regression/r/707832.result	2011-01-26 12:40:22 +0000
@@ -0,0 +1,13 @@
+drop table if exists t1;
+create table t1 (a int, b float(5));
+show create table t1;
+Table	Create Table
+t1	CREATE TABLE `t1` (
+  `a` INT DEFAULT NULL,
+  `b` DOUBLE DEFAULT NULL
+) ENGINE=InnoDB COLLATE = utf8_general_ci
+insert into t1 values (1, 99.99);
+select * from t1;
+a	b
+1	99.99
+drop table t1;

=== added file 'tests/suite/regression/t/707832.test'
--- tests/suite/regression/t/707832.test	1970-01-01 00:00:00 +0000
+++ tests/suite/regression/t/707832.test	2011-01-26 12:40:22 +0000
@@ -0,0 +1,8 @@
+--disable_warnings
+drop table if exists t1;
+--enable_warnings
+create table t1 (a int, b float(5));
+show create table t1;
+insert into t1 values (1, 99.99);
+select * from t1;
+drop table t1;