Case-sensitive enum type casts

SeaQL / sea-query

🔱 A dynamic SQL query builder for MySQL, Postgres and SQLite

https://www.sea-ql.org

Other

1.12k stars 182 forks source link

Case-sensitive enum type casts #789

Open niklaskorz opened 2 months ago

niklaskorz commented 2 months ago

PR Info

Closes https://github.com/SeaQL/sea-query/issues/725
Dependents:
- https://github.com/SeaQL/sea-orm/pull/2271

Bug Fixes

[x] Casting to an enum whose type name was declared case-sensitive does not crash anymore

Breaking Changes

[x] Enum type casts are now case sensitive, so casting to SomeEnum will now cast to "SomeEnum" on PostgreSQL, while it previously casted to someenum.

niklaskorz commented 2 months ago

This still has problems with arrays, as sea-orm constructs array types directly as {enum_name}[], making it hard to only quote the type name but not the array brackets from sea-query.