Bug #26354 Critical: Why auto-inc is auto assign to my new column
Submitted: 14 Feb 2007 4:43 Modified: 12 May 2007 14:49
Reporter: Surachet Sendaeng Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Data Types Severity:S3 (Non-critical)
Version:5.0 OS:Windows (WINDOWS XP Pro)
Assigned to: CPU Architecture:Any

[14 Feb 2007 4:43] Surachet Sendaeng 
Description:
I have a question,

I am using sql script like below

" ALTER TABLE A ADD B INT "

After execute sql it work find but i found about MySQL is assign my new column to Auto-Inc, Why ?, And How can i fix it?
This problem is will occur with INT, TTINYINT ,BIGINT.

Antony K. Sakuranovski
sakuranovski@gmail.com

How to repeat:
Please repeat my by e-mail

sakuranovski@gmail.com
[14 Feb 2007 9:35] Valeriy Kravchuk 
Thank you for a problem report. Please, send a complete CREATE TABLE statement for the table you are trying to alter. Indicate also the exact version, 5.0.x, of MySQL server used.
[15 Mar 2007 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[12 Apr 2007 14:49] Valeriy Kravchuk 
Feedback is still needed!
[12 May 2007 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".