Re: Dangerous ALTER table ...
You said originally, "we had a simple table with one field" which I took to mean that the table had only one column, since you didn't mention any others.
Did you do a SHOW WARNINGS? What was the result? Any significance to the numbers 65535 or 166227 in relation to the original table data? Did all rows contain NULLs for the cpr column after the query, or only those with more than 25-character values to start with?
(I suspect you may have found a bug, I'm just fishing for some additional info.)
Jon Stephens
MySQL Documentation Team @ Oracle
MySQL Dev Zone
MySQL Server Documentation
Oracle
Subject
Views
Written By
Posted
3633
February 22, 2005 04:56AM
2193
February 23, 2005 04:38AM
2148
February 23, 2005 04:56AM
Re: Dangerous ALTER table ...
2406
February 23, 2005 05:58AM
2459
February 23, 2005 07:13AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.