dbal icon indicating copy to clipboard operation
dbal copied to clipboard

support mysql8+ default values for text data types

Open paulmhh opened this issue 1 month ago • 1 comments

mysql requires text type column defaults to be written as expressions https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html

=> correct mysql8+ syntax is: DEFAULT ('text literal')

Q A
Type bug/improvement
Fixed issues NA

Summary

mysql8+ does support default values for text typed columns (text, blob, json, geometry) doctrine disallows this and silently drops the default value

paulmhh avatar Dec 04 '25 13:12 paulmhh

Thank you. Please add tests.

derrabus avatar Dec 04 '25 14:12 derrabus