MySQL Driver - 64 Character Identifier Limit

[sethcenterbar]

I love the idea behind this project and think it will be incredibly useful for many organizations. I'm hoping to be a contributor here, so let me know how I can help!

When running the example.config.yml, ec2 instances attempts to create a column named 'capacity_reservation_target_capacity_reservation_resource_group_arn'.

Error: Error 1059: Identifier name 'capacity_reservation_target_capacity_reservation_resource_group_arn' is too long

MySQL has a 64 character limit for identifiers, so we should find a way to identify and compact names > 64 characters long when using the MySQL driver. For the sake of autocomplete and api similarity, I actually think simply taking the first 64 characters will be the best bet in most situations.

[ghost]

@sethcenterbar Thanks! I've removed the prefix capacity_reservation_target from this column so hopefully this should solve it. can you test it please?

In other situation we can take your approach though I think we should avoid really long columns.