Bug #27175 | invalid colum attributes in create/alter table | ||
---|---|---|---|
Submitted: | 15 Mar 2007 14:48 | Modified: | 26 Mar 2008 13:10 |
Reporter: | Martin Friebe (Gold Quality Contributor) (OCA) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DDL | Severity: | S3 (Non-critical) |
Version: | 5.0.38 4.1.23 | OS: | Linux (Linux) |
Assigned to: | Assigned Account | CPU Architecture: | Any |
Tags: | column, Contribution, CREATE TABLE, parser, PatchRefused, qc |
[15 Mar 2007 14:48]
Martin Friebe
[15 Mar 2007 14:49]
Martin Friebe
test case
Attachment: column_creation.tar.gz (application/x-gzip, text), 716 bytes.
[15 Mar 2007 14:50]
Martin Friebe
additional test for patch
Attachment: column_creation2.tar.gz (application/x-gzip, text), 21.57 KiB.
[15 Mar 2007 14:50]
Martin Friebe
patch
Attachment: column_spec.patch (text/x-patch), 10.06 KiB.
[15 Mar 2007 14:51]
Martin Friebe
patch for existing test case (test with broken sql)
Attachment: column_mu_test.patch (text/x-patch), 3.04 KiB.
[15 Mar 2007 15:05]
Valeriy Kravchuk
Thank you for a bug report. Verified just as described with latest 5.0.38-BK on Linux.
[24 Mar 2007 17:01]
Martin Friebe
replacement for intial patch, no more tabs, changed some names and comments (test and other patches can be kept as they are)
Attachment: column_spec.patch (text/x-patch), 13.67 KiB.
[12 Jul 2007 14:51]
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/30788 ChangeSet@1.2508, 2007-07-12 10:49:37-04:00, cmiller@zippy.cornsilk.net +7 -0 Bug#27175: invalid colum attributes in create/alter table One could define columns with contradictory or duplicate attri- butes. E.g. "NULL NOT NULL DEFAULT 'foo' DEFAULT 'bar' NULL NULL" Now, check that explicitly-set or -unset flags are never reset in the same statement.
[21 Dec 2007 16:09]
Trudy Pelzer
Workaround: don't use invalid names.