maria-developers team mailing list archive

[Zardosht Kasheff <zardosht@xxxxxxxxx>]

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@xxxxxxxxxxxx> 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