maria-developers team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxxx>]

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