Toad World® Forums

Change column datatype to smallint from int - No changes detected


#1

When using the Object Explorer - Select a Table - View Detail - Columns - Alter Columns. I selected a column which is of int datatype and part of a PK. I needed to change its datatype to smallint. After selecting smallint and pressing OK, the tool says no changes detected and does not alter the column as specified.


#2

Hi,

Thanks for you feedback, it’s a bug and I have created TSS-1200

We will fix it as soon as possible.

Thanks,

Cathy.


#3

What is the status of this bug? I am still seeing it in the latest version.


#4

Hi,

This bug TSS-1200 has been fixed. Please try in next Beta.

Best Regards,

Kelly


#5

We are having a similar problem, and I think it’s the same as this bug.

I’ve simply added a new column to a table at the end of the table. TOAD recognised this and it’s ok. But if I move the new column into the middle of the table (change its position in the table), the program reports “NO CHANGES DETECTED”. This is a serious flaw, that again was working in older versions but suddenly now it doesn’t. Why does Dell programmers keep breaking the program at almost every Beta!? Very frustrating.