inList check constraints are missing!

[aadrian]

Task List

• Steps to reproduce provided
• Stacktrace (if present) provided
• Example that reproduces the problem uploaded to Github
• Full description of the issue provided (see below)

Steps to Reproduce

For inList fields the check constraints seem to be missing:

• https://github.com/aadrian/fieldbugs1/blob/master/grails-app/domain/com/mycorp/fieldbugs1/TableOne.groovy#L22` should allow only 'S','M','L','XL' and null
• https://github.com/aadrian/fieldbugs1/blob/master/grails-app/domain/com/mycorp/fieldbugs1/TableOne.groovy#L23 should allow only 22, 42, 44, 66
• https://github.com/aadrian/fieldbugs1/blob/master/grails-app/domain/com/mycorp/fieldbugs1/TableOne.groovy#L24 should allow only 'y','n','x'

but the generated DDL https://github.com/aadrian/fieldbugs1/blob/master/ddl.sql does not contain constraints on those fields (only a size limitation)

Expected Behaviour

schema-export (and all dbCreate modes except 'none') should make use of the check constraints, i.e. the generated DB should have them, and when starting an application with dbCreate=validate should warn/error that they're missing (like in the case of other mapping differences).

Actual Behaviour

No check constraints are being used, nor any warning/error is being displayed for dbCreate=validate.

Environment Information

• Operating System: OSX, Linux, Win 7,8,10
• GORM Version: 6.1.9
• Grails Version (if using Grails): 3.3.3
• JDK Version: 1.8.0_162

Example Application

https://github.com/aadrian/fieldbugs1/

Thank you.

[jameskleeh]

I don't think it's possible to create database level constraints to deal with inList

[aadrian]

@jameskleeh why not?

ALTER TABLE <table>
ADD CONSTRAINT chk_val CHECK (col in ('yes','no','maybe'))

is widely supported.

[jameskleeh]

@aadrian I wasn't aware of check constraints. Thanks for letting me know!