bzr commit into mysql-5.1-bugteam branch (sandeep.doddaballapur:3535) Bug#33971

[Sandeep Doddaballapur]

#At file:///home/sandeep/Desktop/work/mysql-5.1-bugteam/ based on revid:sandeep.doddaballapur@stripped

 3535 Sandeep Doddaballapur	2010-12-21
      BUG#33971 : Test of using (default) for INSERT with an enum column not enabled
      
      Recorded the result file by enabling the test case as BUG#33717 is closed.

    modified:
      mysql-test/r/csv_not_null.result
      mysql-test/t/csv_not_null.test
=== modified file 'mysql-test/r/csv_not_null.result'
--- a/mysql-test/r/csv_not_null.result	2009-02-05 09:49:32 +0000
+++ b/mysql-test/r/csv_not_null.result	2010-12-21 05:24:11 +0000
@@ -19,13 +19,16 @@ INSERT INTO t1 VALUES();
 SELECT * FROM t1;
 a	b	c	d	e	f
 0				foo	0000-00-00
+INSERT INTO t1 VALUES(default,default,default,default,default,default);
 SELECT * FROM t1;
 a	b	c	d	e	f
 0				foo	0000-00-00
+0				foo	0000-00-00
 INSERT INTO t1 VALUES(0,'abc','def','ghi','bar','1999-12-31');
 SELECT * FROM t1;
 a	b	c	d	e	f
 0				foo	0000-00-00
+0				foo	0000-00-00
 0	abc	def	ghi	bar	1999-12-31
 # === insert failures ===
 INSERT INTO t1 VALUES(NULL,'ab','a','b','foo','2007-01-01');

=== modified file 'mysql-test/t/csv_not_null.test'
--- a/mysql-test/t/csv_not_null.test	2009-02-05 09:49:32 +0000
+++ b/mysql-test/t/csv_not_null.test	2010-12-21 05:24:11 +0000
@@ -55,10 +55,11 @@ INSERT INTO t1 VALUES();
 SELECT * FROM t1;
 
 -- disable_warnings
-# NOTE - Test disabled due to enum crash for this INSERT
+
+# NOTE - Test enabled as Bug 33717 has been closed.
 # See Bug#33717 - INSERT...(default) fails for enum. 
-# Crashes CSV tables, loads spaces for MyISAM
-#INSERT INTO t1 VALUES(default,default,default,default,default,default);
+# Initially used to Crash CSV tables, loads spaces for MyISAM due to Bug 33717
+ INSERT INTO t1 VALUES(default,default,default,default,default,default);
 -- enable_warnings
 
 SELECT * FROM t1;


Attachment: [text/bzr-bundle]