CharsetRegressionTest.java
5.13 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
/*
Copyright (c) 2014, 2016, Oracle and/or its affiliates. All rights reserved.
The MySQL Connector/J is licensed under the terms of the GPLv2
<http://www.gnu.org/licenses/old-licenses/gpl-2.0.html>, like most MySQL Connectors.
There are special exceptions to the terms and conditions of the GPLv2 as it is applied to
this software, see the FOSS License Exception
<http://www.mysql.com/about/legal/licensing/foss-exception.html>.
This program is free software; you can redistribute it and/or modify it under the terms
of the GNU General Public License as published by the Free Software Foundation; version 2
of the License.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this
program; if not, write to the Free Software Foundation, Inc., 51 Franklin St, Fifth
Floor, Boston, MA 02110-1301 USA
*/
package testsuite.regression;
import java.sql.SQLException;
import java.util.Properties;
import java.util.concurrent.Callable;
import com.mysql.jdbc.MySQLConnection;
import com.mysql.jdbc.ResultSetInternalMethods;
import testsuite.BaseStatementInterceptor;
import testsuite.BaseTestCase;
public class CharsetRegressionTest extends BaseTestCase {
public CharsetRegressionTest(String name) {
super(name);
}
/**
* Tests fix for Bug#73663 (19479242), utf8mb4 does not work for connector/j >=5.1.13
*
* This test is only run when character_set_server=utf8mb4 and collation-server set to one of utf8mb4 collations (it's better to test two configurations:
* with default utf8mb4_general_ci and one of non-default, say utf8mb4_bin)
*
* @throws Exception
*/
public void testBug73663() throws Exception {
this.rs = this.stmt.executeQuery("show variables like 'collation_server'");
this.rs.next();
String collation = this.rs.getString(2);
if (collation != null && collation.startsWith("utf8mb4") && "utf8mb4".equals(((MySQLConnection) this.conn).getServerVariable("character_set_server"))) {
Properties p = new Properties();
p.setProperty("characterEncoding", "UTF-8");
p.setProperty("statementInterceptors", Bug73663StatementInterceptor.class.getName());
getConnectionWithProps(p);
// exception will be thrown from the statement interceptor if any "SET NAMES utf8" statement is issued instead of "SET NAMES utf8mb4"
} else {
System.out.println(
"testBug73663 was skipped: This test is only run when character_set_server=utf8mb4 and collation-server set to one of utf8mb4 collations.");
}
}
/**
* Statement interceptor used to implement preceding test.
*/
public static class Bug73663StatementInterceptor extends BaseStatementInterceptor {
@Override
public ResultSetInternalMethods preProcess(String sql, com.mysql.jdbc.Statement interceptedStatement, com.mysql.jdbc.Connection connection)
throws SQLException {
if (sql.contains("SET NAMES utf8") && !sql.contains("utf8mb4")) {
throw new SQLException("Character set statement issued: " + sql);
}
return null;
}
}
/**
* Tests fix for Bug#72630 (18758686), NullPointerException during handshake in some situations
*
* @throws Exception
*/
public void testBug72630() throws Exception {
// bug is related to authentication plugins, available only in 5.5.7+
if (versionMeetsMinimum(5, 5, 7)) {
try {
createUser("'Bug72630User'@'%'", "IDENTIFIED WITH mysql_native_password AS 'pwd'");
this.stmt.execute("GRANT ALL ON *.* TO 'Bug72630User'@'%'");
final Properties props = new Properties();
props.setProperty("user", "Bug72630User");
props.setProperty("password", "pwd");
props.setProperty("characterEncoding", "NonexistentEncoding");
assertThrows(SQLException.class, "Unsupported character encoding 'NonexistentEncoding'.", new Callable<Void>() {
public Void call() throws Exception {
getConnectionWithProps(props);
return null;
}
});
props.remove("characterEncoding");
props.setProperty("passwordCharacterEncoding", "NonexistentEncoding");
assertThrows(SQLException.class, "Unsupported character encoding 'NonexistentEncoding' for 'passwordCharacterEncoding' or 'characterEncoding'.",
new Callable<Void>() {
public Void call() throws Exception {
getConnectionWithProps(props);
return null;
}
});
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}