Skip to content

Fixed-size column types as part of identifiers do not work on MySQL #1778

@tomhoule

Description

@tomhoule

On mysql, models with an ID column of a fixed size type (like binary(16) or char(16)) will fail on create: we insert the record including the ID, and when trying to fetch it back we use the ID we inserted, but MySQL will have padded the value with null bytes for us, so the ID doesn't actually match.

We would need the type information to pad the value ourselves when fetching it back.

See #1772 for a schema where that happens.

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions