ALTER TABLE does not change column collations

[GaoYusong]

{
		Name: "ALTER TABLE does not change column collations",
		SetUpScript: []string{
			"CREATE TABLE test1 (v1 VARCHAR(200), v2 ENUM('a'), v3 SET('a'));",
			"CREATE TABLE test2 (v1 VARCHAR(200), v2 ENUM('a'), v3 SET('a')) COLLATE=utf8mb4_general_ci;",
			"CREATE TABLE test3 (v1 VARCHAR(200) COLLATE utf8mb4_general_ci, v2 ENUM('a'), v3 SET('a') CHARACTER SET utf8mb3) COLLATE=utf8mb4_general_ci",
			"CREATE TABLE test4 (v1 VARCHAR(200) COLLATE utf8mb4_0900_ai_ci, v2 ENUM('a') COLLATE utf8mb4_general_ci, v3 SET('a') COLLATE utf8mb4_unicode_ci) COLLATE=utf8mb4_bin;",
		},
		Assertions: []ScriptTestAssertion{
			{
				Query: "SHOW CREATE TABLE test1",
				Expected: []sql.Row{{"test1",
					"CREATE TABLE `test1` (\n" +
						"  `v1` varchar(200),\n" +
						"  `v2` enum('a'),\n" +
						"  `v3` set('a')\n" +
						") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin"}},
			},
			{
				Query: "SHOW CREATE TABLE test2",
				Expected: []sql.Row{{"test2",
					"CREATE TABLE `test2` (\n" +
						"  `v1` varchar(200),\n" +
						"  `v2` enum('a'),\n" +
						"  `v3` set('a')\n" +
						") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci"}},
			},
			{
				Query: "SHOW CREATE TABLE test3",
				Expected: []sql.Row{{"test3",
					"CREATE TABLE `test3` (\n" +
						"  `v1` varchar(200),\n" +
						"  `v2` enum('a'),\n" +
						"  `v3` set('a') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci\n" +
						") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci"}},
			},
			{
				Query: "SHOW CREATE TABLE test4",
				Expected: []sql.Row{{"test4",
					"CREATE TABLE `test4` (\n" +
						"  `v1` varchar(200) COLLATE utf8mb4_0900_ai_ci,\n" +
						"  `v2` enum('a') COLLATE utf8mb4_general_ci,\n" +
						"  `v3` set('a') COLLATE utf8mb4_unicode_ci\n" +
						") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin"}},
			},
			{
				Query:    "ALTER TABLE test1 COLLATE utf8mb4_general_ci;",
				Expected: []sql.Row{{types.NewOkResult(0)}},
			},
			{
				Query:    "ALTER TABLE test2 COLLATE utf8mb4_0900_bin;",
				Expected: []sql.Row{{types.NewOkResult(0)}},
			},
			{
				Query:    "ALTER TABLE test3 COLLATE utf8mb4_0900_bin;",
				Expected: []sql.Row{{types.NewOkResult(0)}},
			},
			{
				Query:    "ALTER TABLE test4 COLLATE utf8mb4_unicode_ci;",
				Expected: []sql.Row{{types.NewOkResult(0)}},
			},
			{
				Query: "SHOW CREATE TABLE test1",
				Expected: []sql.Row{{"test1",
					"CREATE TABLE `test1` (\n" +
						"  `v1` varchar(200) COLLATE utf8mb4_0900_bin,\n" +
						"  `v2` enum('a') COLLATE utf8mb4_0900_bin,\n" +
						"  `v3` set('a') COLLATE utf8mb4_0900_bin\n" +
						") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci"}},
			},
			{
				Query: "SHOW CREATE TABLE test2",
				Expected: []sql.Row{{"test2",
					"CREATE TABLE `test2` (\n" +
						"  `v1` varchar(200) COLLATE utf8mb4_general_ci,\n" +
						"  `v2` enum('a') COLLATE utf8mb4_general_ci,\n" +
						"  `v3` set('a') COLLATE utf8mb4_general_ci\n" +
						") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin"}},
			},
			{
				Query: "SHOW CREATE TABLE test3",
				Expected: []sql.Row{{"test3",
					"CREATE TABLE `test3` (\n" +
						"  `v1` varchar(200) COLLATE utf8mb4_general_ci,\n" +
						"  `v2` enum('a') COLLATE utf8mb4_general_ci,\n" +
						"  `v3` set('a') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci\n" +
						") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin"}},
			},
			{
				Query: "SHOW CREATE TABLE test4",
				Expected: []sql.Row{{"test4",
					"CREATE TABLE `test4` (\n" +
						"  `v1` varchar(200) COLLATE utf8mb4_0900_ai_ci,\n" +
						"  `v2` enum('a') COLLATE utf8mb4_general_ci,\n" +
						"  `v3` set('a')\n" +
						") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci"}},
			},
		},
	},

--- FAIL: TestAlterTable/ALTER_TABLE_does_not_change_column_collations (0.11s)
        --- FAIL: TestAlterTable/ALTER_TABLE_does_not_change_column_collations/SHOW_CREATE_TABLE_test2 (0.01s)
            /Users/shannon/code/myduckserver/evaluation.go:726: 
                	Error Trace:	/Users/shannon/go/pkg/mod/github.com/dolthub/go-mysql-server@v0.18.2-0.20240815142344-761713e36043/enginetest/evaluation.go:726
                	            				/Users/shannon/go/pkg/mod/github.com/dolthub/go-mysql-server@v0.18.2-0.20240815142344-761713e36043/enginetest/evaluation.go:357
                	Error:      	Not equal: 
                	            	expected: []sql.Row{sql.Row{"test2", "CREATE TABLE `test2` (\n  `v1` varchar(200),\n  `v2` enum('a'),\n  `v3` set('a')\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci"}}
                	            	actual  : []sql.Row{sql.Row{"test2", "CREATE TABLE `test2` (\n  `v1` varchar(200) COLLATE utf8mb4_general_ci,\n  `v2` enum('a') COLLATE utf8mb4_general_ci,\n  `v3` set('a') COLLATE utf8mb4_general_ci\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin"}}
                	            	
                	            	Diff:
                	            	--- Expected
                	            	+++ Actual
                	            	@@ -3,3 +3,3 @@
                	            	   (string) (len=5) "test2",
                	            	-  (string) (len=144) "CREATE TABLE `test2` (\n  `v1` varchar(200),\n  `v2` enum('a'),\n  `v3` set('a')\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci"
                	            	+  (string) (len=223) "CREATE TABLE `test2` (\n  `v1` varchar(200) COLLATE utf8mb4_general_ci,\n  `v2` enum('a') COLLATE utf8mb4_general_ci,\n  `v3` set('a') COLLATE utf8mb4_general_ci\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin"
                	            	  }
                	Test:       	TestAlterTable/ALTER_TABLE_does_not_change_column_collations/