mypipe
mypipe copied to clipboard
MySql Unsigned Int treated as a normal Int
I've a MySql table with a primary key of type Int (unsigned), when the id is bigger than the max Int value the id becomes a negative value, as expected.
I found what I think could be the root of the problem, the query on the information schema done by the MySQLMetadataManager, is using the DATA_TYPE column value, and this value is always int even for the unsigned kind.
I think an idea for a possible solution is to look also at the COLUMN_TYPE that is where the unsigned information is stored and cast this values to long?