When creating a table info from a physical table in the database, we first create the ColumnInfo using the metadata the database provides. In this case there are certain fields of the ColumnInfo that we will not override using the xml schema. "datatype" is one of them.

see ColumnInfo.loadFromXml() and ColumnInfo.createFromDatabaseMetaData(). Also note the "false" parameter in the call to ColumnInfo.loadFromXml() from SchemaTableInfo.loadFromXml() at line 620.

If the field can never be a float, isn't there a way to set the type in the CREATE TABLE statement to enforce that, so that LabKey will know it is really an INT column?