Skip to content
Merged
Changes from 1 commit
Commits
File filter

Filter by extension

Filter by extension

Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
formatting fixes via spotlessApply
  • Loading branch information
nicky6s committed Aug 17, 2024
commit 0503e3273576c8540cbc068bcf174ec5fd545106
14 changes: 9 additions & 5 deletions src/test/java/net/sf/jsqlparser/statement/alter/AlterTest.java
Original file line number Diff line number Diff line change
Expand Up @@ -1024,20 +1024,24 @@ public void testIssue1875() throws JSQLParserException {
}

@Test
public void testIssue2027() throws JSQLParserException{
public void testIssue2027() throws JSQLParserException {
String sql = "ALTER TABLE `foo_bar` ADD COLUMN `baz` text";
assertSqlCanBeParsedAndDeparsed(sql);

String sqlText = "ALTER TABLE `foo_bar` ADD COLUMN `baz` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL";
String sqlText =
"ALTER TABLE `foo_bar` ADD COLUMN `baz` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL";
assertSqlCanBeParsedAndDeparsed(sqlText);

String sqlTinyText = "ALTER TABLE `foo_bar` ADD COLUMN `baz` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL";
String sqlTinyText =
"ALTER TABLE `foo_bar` ADD COLUMN `baz` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL";
assertSqlCanBeParsedAndDeparsed(sqlTinyText);

String sqlMediumText = "ALTER TABLE `foo_bar` ADD COLUMN `baz` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL";
String sqlMediumText =
"ALTER TABLE `foo_bar` ADD COLUMN `baz` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL";
assertSqlCanBeParsedAndDeparsed(sqlMediumText);

String sqlLongText = "ALTER TABLE `foo_bar` ADD COLUMN `baz` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL";
String sqlLongText =
"ALTER TABLE `foo_bar` ADD COLUMN `baz` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL";
assertSqlCanBeParsedAndDeparsed(sqlLongText);
}
}