ENUM values are always lowercased regardless of actual case

[abmyii]

go-mysql-server/sql/settype.go

Line 102 in 82a31ef

lowercaseValue := strings.ToLower(value)

I'm not sure what the reasoning is behind this, bu it is causing issues with the SQLAlchemy ORM which sees the ENUM values as lowercase, causing it to raise errors like:

'UNSPECIFIED' is not among the defined enum values. Enum name: None. Possible values: inpatient, outpatient, both, unspecified

Schema (https://www.dolthub.com/repositories/dolthub/hospital-price-transparency-v3):

create table prices (
    [...]
    inpatient_outpatient enum('INPATIENT', 'OUTPATIENT', 'BOTH', 'UNSPECIFIED') default 'UNSPECIFIED',
    [...]
);

ENUM name is also None which should also be fixed.

[fulghum]

Hey @abmyii, thanks for reporting this. We've had a couple customer requests for this now, so I'll see if we can knock this one out in the next week or two as we wrap up some other in-flight issues.

We've got an existing issue open for this, so I'm going to resolve this one in favor of: dolthub/dolt#3991

Good point about enum name being dropped, too. Thanks for reporting that! I'll mention that in the other issue to make sure we close that gap, too.

[fulghum]

Hey @abmyii, just closing the loop on this one. We got the fix for this issue released in Dolt 0.40.26.

Thanks for reporting this one!

[abmyii]

Hey @abmyii, just closing the loop on this one. We got the fix for this issue released in Dolt 0.40.26.

Great, thank you for the speedy fix!