I think they had a 5.0 table with the old type, upgraded their system to the new binaries, then did an alter table. Apparently, the alter table preserves the old type, and does not create a table with the new type On Wed, May 8, 2013 at 5:44 AM, Sergei Golubchik <serg@askmonty.org> wrote:
Hi, Zardosht!
On Apr 26, Zardosht Kasheff wrote:
Hello all,
Under what circumstances can a table be created with MYSQL_TYPE_DECIMAL as being one of the columns? I thought MYSQL_TYPE_DECIMAL was deprecated pre 5.1. I thought all new tables use MYSQL_TYPE_NEWDECIMAL.
I've quickly checked the code and couldn't find a way to create a table with the MYSQL_TYPE_DECIMAL column. There are even asserts in the code that show it's impossible.
So, I'm very interested to know how your customer managed to do it :) Please share it, if you'll find it out.
Is there a way to ensure that tables undergoing an alter convert that column to MYSQL_TYPE_NEWDECIMAL?
It's pretty difficult to test, if there's no way to create a table with MYSQL_TYPE_DECIMAL in the first place.
Regards, Sergei