We're updating the issue view to help you get more done. 

Table with LARGE_TEXT column with default value causes the table build to fail

Description

To reproduce:
Create a table with a LARGE_TEXT column with a default value set for the column.
Result is an error such as:

1 org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [ALTER TABLE T17103280 ADD COLUMN _C72273_ MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT 'test' COMMENT 'LARGETEXT']; nested exception is java.sql.SQLSyntaxErrorException: BLOB, TEXT, GEOMETRY or JSON column '_C72273_' can't have a default value

Environment

None

Status

Assignee

Unassigned

Reporter

John Hill

Labels

None

Validator

Bruce Hoff

Release Version History

None

Affects versions

stack-268

Priority

Minor