Bug #33970 Test main.csv_alter_table disabled

• Submitted: 22 Jan 2008 2:57
• Modified: 8 Dec 2008 14:02
• Reporter: Patrick Crews
• Status: Closed
• Category: Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.1, 6.0
• OS: Any
• Assigned to: Patrick Crews
• Target Version: 5.1+
• Tags: disabled, Tests, csv
• Triage: Triaged: D3 (Medium) / R2 (Low) / E2 (Low)

[22 Jan 2008 2: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 21: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 21: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 19:48] Matthias Leich

ok to push

[26 Nov 2008 22: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 11: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 12: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 14:02] Paul DuBois

Test case changes. No changelog entry needed.

[19 Jan 12: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 14: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 17: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)