Bug #33558 Test "stress.ddl_csv" needs nullable columns which CSV does not support
Submitted: 28 Dec 2007 17:32 Modified: 25 Feb 2008 18:03
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Engine Severity:S3 (Non-critical)
Version:6.0.4-alpha OS:Any
Assigned to: Patrick Crews CPU Architecture:Any

[28 Dec 2007 17:32] Joerg Bruehe 
Description:
stress.ddl_csv                 [ fail ]

mysqltest: In included file "./suite/stress/include/ddl3.inc": At line 50: query '$create_table' failed: 1178: The storage engine for the table doesn't support nullable columns

Happens on all build platforms in the build of 6.0.4-alpha.
This test passed in 6.0.3-alpha, and the relevant files for this test in 6.0.3 and 6.0.4 are identical.

How to repeat:
Run the "extra" tests.
[3 Jan 2008 18:24] Patrick Crews 
This test is failing due to changes made for Bug#31473.

The CSV engine does not allow nullable columns -- the changes made now require all columns in a CREATE TABLE statement to be declared NOT NULL.

Have started work on updating this test as well as any other csv related tests.
[24 Jan 2008 20:28] Patrick Crews 
Pushed tests to 5.1 and 6.0 build trees.

Original failing test has been updated to work with CSV engine and new tests have been written to test the change in CSV engine behavior

Wrote the following bug to enable certain tests that are awaiting bug fixes to execute properly:

Bug#33970:  Test main.csv_alter_table disabled.

Need to update documentation to reflect need for explicit NOT NULL's / lack of NULLable columns for CSV tables.
[24 Jan 2008 21:11] Patrick Crews 
Need to update 5.1 and 6.0 manuals to reflect that CSV engine does not support NULLable columns and requires explicit NOT NULL clauses for all columns in a CREATE TABLE statement.

This is an incompatible change from 5.0 to 5.1 and 6.0
[12 Feb 2008 21:04] Paul DuBois 
Test case change. No changelog entry needed.

(The change that CSV no longer supports NULL columns has already been documented in connection with Bug#32050)
[25 Feb 2008 16:00] Bugs System 
Pushed into 5.1.24-rc
[25 Feb 2008 16:06] Bugs System 
Pushed into 6.0.5-alpha
[25 Feb 2008 17:54] Paul DuBois 
Test case change. No changelog entry needed.