I'm using Loopback 3.x with the MySQL connector, and setting the MySQL data type to "bigint" on my model property does not seem to pull through when I seed the database (using auto-migration):
"dcapacity": {
"type": "number",
"mysql": {
"dataType": "bigint"
}
}
The value I am trying to seed into the db field:
dcapacity: 2325510656
But I keep getting the MySQL "out of range value for column dcapacity" error when I try to seed the db. I know everything works correctly because I can reduce the size of the number then it works fine. When I look in the db it never seems to change the dcapacity column data type from 'int' to 'bigint'.
I also tried setting the "supportBigNumbers" property on the connector to true in datasources.json, but that did not seem to help either. I am not sure what I am doing wrong here, any input is greatly appreciated ;)
Thank you for your time!