I came across the strangest issue I have no idea how it happened. In
my development environment, I created a new migration and model that
uses a couple of decimal column types (among others). Everything
works great with sqlite and the development environment, business as
usual. However, I deployed to production and for some completely
unknown reason, this particular table (only this one) shows up with
“integer” column types.
To clarify, when I investigate the MYSQL db in production, MYSQL shows
that the columns are decimal types. However, when type in the model
class name into the production console, it shows the column types as
integer. This is a problem for me because it’s holding prices, so I’m
losing my cents (no pun intended).
How does rails determine the column types? The migration shows
decimal column types, by the way.
Thanks to anyone that has any insight.