The fix for () seems to be making columnDefinition value ignored.

Reproducer

Mostly copied from MySqlExistingEnumColumnValidationTest:

Expected result

Since signPositionAsChar is both declared as char(20) in the SQL query and the columnDefinition, the test should be passed.

Actual result

Schema-validation: wrong column type encountered in column [sign_position_as_char] in table [en]; found [char (Types#CHAR)], but expecting [char(20) (Types#VARCHAR)]

Comments

• ColumnDefinitions.getSqlType(Column, Metadata) returns enum ('AFTER_NO_SPACE','AFTER_WITH_SPACE','BEFORE_NO_SPACE','BEFORE_WITH_SPACE') and column.getSqlType( metadata ) properly returns char(20). I think there should exist a check for the pre-configured sqlType.

• The message of SchemaManagementException is not matched to ColumnDefinitions.getSqlType(Column, Metadata) but since it’s a private method, AbstractSchemaValidator.validateColumnType cannot know what’s going on exactly.

• Maybe it’s related to or but they say that those are occurring prior to 6.2.5.
  I’ve confirmed this issue is not affected until 6.2.2 (via Spring Boot 3.1.0), also 6.2.3 nor 6.2.4 (checked manually by changing ext['hibernate.version']) so it can be not related, though.

Naive solution

Didn’t run the full test, but confirmed fixes this issue.