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 <s...@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 _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
