#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]
Thread |
---|
• bzr commit into mysql-5.1-bugteam branch (sandeep.doddaballapur:3535)Bug#33971 | Sandeep Doddaballapur | 21 Dec |