Bug #33558 Test "stress.ddl_csv" needs nullable columns which CSV does not support
Submitted: 28 Dec 2007 18:32 Modified: 25 Feb 2008 19:03
Reporter: Joerg Bruehe
Status: Closed
Category:Tests: Engine Severity:S3 (Non-critical)
Version:6.0.4-alpha OS:Any
Assigned to: Patrick Crews Target Version:
Triage: D3 (Medium) / R3 (Medium) / E1 (None/Negligible)

[28 Dec 2007 18: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 19: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 21: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 22: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 22: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 17:00] Bugs System 
Pushed into 5.1.24-rc
[25 Feb 2008 17:06] Bugs System 
Pushed into 6.0.5-alpha
[25 Feb 2008 18:54] Paul DuBois 
Test case change. No changelog entry needed.