Bug #33970 Test main.csv_alter_table disabled

• Submitted: 22 Jan 2008 1:57
• Modified: 8 Dec 2008 13:02
• Reporter: Patrick Crews
• Status: Closed
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.1, 6.0
• OS: Any
• Assigned to: Patrick Crews
• CPU Architecture: Any
• Tags: csv, disabled, Tests

[22 Jan 2008 1:57] Patrick Crews

Description:
The test csv_alter_table has been disabled due to Bug#33696 - CSV storage engine allows nullable columns via ALTER TABLE statements

No .result file can be generated due to negative tests not failing as they should.

Will need to generate .result file once the prerequisite bug has been corrected.

Tests have been reviewed as part of the fix for Bug#33558 - Test "stress.ddl_csv" needs nullable columns which CSV does not support.

How to repeat:
Run the mysql-test-run program:

./mysql-test-run --do-test csv

Expected output

=======================================================

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

main.csv                       [ pass ]           1015
main.csv_alter_table           [ disabled ]  Bug#33696 2008-01-21 pcrews no .result file - bug allows NULL columns in CSV tables
main.csv_not_null              [ pass ]             54
main.partition_csv             [ pass ]            165
-------------------------------------------------------

Suggested fix:
Re-enable the test once Bug#33696 is corrected.

[17 Nov 2008 20:25] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/58997

2710 Patrick Crews	2008-11-17
      Bug#33970 Test main.csv_alter_table disabled.
      
      Re-enabling this test in 5.1 tree since the bug that caused disabling
      (Bug#33696 CSV storage engine allows nullable colums via ALTER TABLE statements)
      doesn't appear in 5.1 (6.0 only)
      
      Recorded .result file and removed test from the main.disabled.def file.

[17 Nov 2008 20:26] Patrick Crews

Submitted patch to re-enable this test in 5.1 since the Bug only appears in the 6.0 tree.
See Bug#33696 - CSV storage engine allows nullable columns via ALTER TABLE statements.

[19 Nov 2008 18:48] Matthias Leich

ok to push

[26 Nov 2008 21:45] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/59980

2754 Patrick Crews	2008-11-26 [merge]
      Bug#33970 merge 5.1 -> 6.0

[8 Dec 2008 10:19] Bugs System

Pushed into 5.1.31  (revid:[e-mail]-20081117202527-f8irx2jqlz2j59au) (version source revid:[e-mail]-20081117202527-f8irx2jqlz2j59au) (pib:5)

[8 Dec 2008 11:30] Bugs System

Pushed into 6.0.9-alpha  (revid:[e-mail]-20081126214457-r81fm5360ei6bkhz) (version source revid:[e-mail]-20081126214457-r81fm5360ei6bkhz) (pib:5)

[8 Dec 2008 13:02] Paul DuBois

Test case changes. No changelog entry needed.

[19 Jan 2009 11:27] Bugs System

Pushed into 5.1.31-ndb-6.2.17 (revid:[e-mail]-20090119095303-uwwvxiibtr38djii) (version source revid:[e-mail]-20090108105244-8opp3i85jw0uj5ib) (merge vers: 5.1.31-ndb-6.2.17) (pib:6)

[19 Jan 2009 13:04] Bugs System

Pushed into 5.1.31-ndb-6.3.21 (revid:[e-mail]-20090119104956-guxz190n2kh31fxl) (version source revid:[e-mail]-20090119104956-guxz190n2kh31fxl) (merge vers: 5.1.31-ndb-6.3.21) (pib:6)

[19 Jan 2009 16:10] Bugs System

Pushed into 5.1.31-ndb-6.4.1 (revid:[e-mail]-20090119144033-4aylstx5czzz88i5) (version source revid:[e-mail]-20090119144033-4aylstx5czzz88i5) (merge vers: 5.1.31-ndb-6.4.1) (pib:6)