CharsetRegressionTest

java.lang.Object
- testsuite.BaseTestCase
- - testsuite.regression.CharsetRegressionTest

public class CharsetRegressionTest
extends BaseTestCase

Nested Class Summary

Nested Classes
Modifier and Type	Class and Description
`static class`	`CharsetRegressionTest.Bug71038QueryInterceptor` Counts the number of issued "SHOW COLLATION" statements.
`static class`	`CharsetRegressionTest.Bug72712QueryInterceptor` Statement interceptor used to implement preceding test.
`static class`	`CharsetRegressionTest.Bug73663QueryInterceptor` Statement interceptor used to implement preceding test.
`static class`	`CharsetRegressionTest.Bug95139QueryInterceptor`
`static class`	`CharsetRegressionTest.TestBug64205QueryInterceptor`
`static class`	`CharsetRegressionTest.TestSetNamesQueryInterceptor`

Nested classes/interfaces inherited from class testsuite.BaseTestCase
BaseTestCase.MockConnectionConfiguration

Field Summary
- Fields inherited from class testsuite.BaseTestCase
  conn, dbClass, dbName, dbUrl, isOpenSSL, mainConnectionUrl, pstmt, rs, serverVersion, stmt, timeZoneFreeDbUrl

Constructor Summary

Constructors
Constructor and Description

CharsetRegressionTest()

Constructors
Constructor and Description
`CharsetRegressionTest()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`private void`	`checkCollationConnection(java.util.Properties props, java.lang.String query, boolean expectQueryIsIssued, java.lang.String expectedCollation)`
`void`	`testAsciiCharConversion()` Tests character conversion bug.
`void`	`testBug100606()` Tests fix for Bug#100606 (31818423), UNECESARY CALL TO "SET NAMES 'UTF8' COLLATE 'UTF8_GENERAL_CI'".
`void`	`testBug10496()` Tests fix for BUG#10496 - SQLException is thrown when using property "characterSetResults"
`void`	`testBug12752()` Tests fix for BUG#12752 - Cp1251 incorrectly mapped to win1251 for servers newer than 4.0.x.
`void`	`testBug15544()` Tests fix for BUG#15544, no "dos" character set in MySQL > 4.1.0
`void`	`testBug24840()` Tests fix for BUG#24840 - character encoding of "US-ASCII" doesn't map correctly for 4.1 or newer
`void`	`testBug25504578()` Tests fix for Bug#25504578, CONNECT FAILS WHEN CONNECTIONCOLLATION=ISO-8859-13
`void`	`testBug25554464_1()` Tests fix for Bug#25554464, CONNECT FAILS WITH NPE WHEN THE SERVER STARTED WITH CUSTOM COLLATION.
`void`	`testBug25554464_2()` Tests fix for Bug#25554464, CONNECT FAILS WITH NPE WHEN THE SERVER STARTED WITH CUSTOM COLLATION.
`void`	`testBug34090350()` Tests fix for Bug#34090350, Update mappings for utf8mb3 and utf8mb4 collations.
`void`	`testBug37931()`
`void`	`testBug41730()` Bug #41730 - SQL Injection when using U+00A5 and SJIS/Windows-31J
`void`	`testBug64205()` Tests fix for Bug#64205 (13702427), Connected through Connector/J 5.1 to MySQL 5.5, the error message is garbled.
`void`	`testBug71038()` Tests fix for Bug#71038, Add an option for custom collations detection
`void`	`testBug72630()` Tests fix for Bug#72630 (18758686), NullPointerException during handshake in some situations
`void`	`testBug72712()` Test for Bug#72712 - SET NAMES issued unnecessarily.
`void`	`testBug73663()` 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)
`void`	`testBug7607()` Tests fix for BUG#7607 - MS932, SHIFT_JIS and Windows_31J not recog.
`void`	`testBug81196()` Tests fix for Bug#81196 (23227334), CONNECTOR/J NOT FOLLOWING DATABASE CHARACTER SET.
`void`	`testBug91317()` Tests fix for Bug#91317 (28207422), Wrong defaults on collation mappings.
`void`	`testBug9206()` Tests fix for BUG#9206, can not use 'UTF-8' for characterSetResults configuration property.
`void`	`testBug95139()` Tests fix for Bug#95139 (29807572), CACHESERVERCONFIGURATION APPEARS TO THWART CHARSET DETECTION.
`private void`	`testBug95139CheckVariables(java.util.Properties p, int queryVarsCnt, java.lang.String expSetNamesQuery, java.lang.String expSetCharacterSetResultsquery)`
`void`	`testEncodingRegression()` Tests for regression of encoding forced by user, reported by Jive Software
`void`	`testEscapeSJISDoubleEscapeBug()` Tests fix for BUG#879
`void`	`testGreekUtf8411()`
`void`	`testPasswordCharacterEncoding()`

Methods inherited from class testsuite.BaseTestCase
appendRequiredProperties, assertByteArrayEquals, assertConnectionsHistory, assertEqualsFSAware, assertNonSecureConnection, assertResultSetLength, assertResultSetsEqual, assertSecureConnection, assertSecureConnection, assertSessionStatusEquals, assertThrows, assertThrows, assertThrows, assertThrows, cleanupTempFiles, createDatabase, createDatabase, createFunction, createFunction, createProcedure, createProcedure, createSchemaObject, createSchemaObject, createTable, createTable, createTable, createTable, createUser, createUser, createView, createView, currentTimeMillis, dropDatabase, dropDatabase, dropFunction, dropFunction, dropProcedure, dropProcedure, dropSchemaObject, dropSchemaObject, dropTable, dropTable, dropUser, dropUser, dropView, dropView, fillPrimitiveDefaults, getConnectionWithProps, getConnectionWithProps, getConnectionWithProps, getConnectionWithProps, getEncodedHostFromTestsuiteUrl, getEncodedHostPortPairFromTestsuiteUrl, getFailoverConnection, getFailoverConnection, getHostFreePropertiesFromTestsuiteUrl, getHostFreePropertiesFromTestsuiteUrl, getHostFromTestsuiteUrl, getInstanceNumber, getLoadBalancedConnection, getLoadBalancedConnection, getLoadBalancedConnection, getMysqlVariable, getMysqlVariable, getNewConnection, getNoDbUrl, getPort, getPortFreeHostname, getPortFromTestsuiteUrl, getPropertiesFromTestsuiteUrl, getPropertiesFromUrl, getRowCount, getSingleIndexedValueWithQuery, getSingleIndexedValueWithQuery, getSingleValue, getSingleValueWithQuery, getSourceReplicaReplicationConnection, getSourceReplicaReplicationConnection, getSourceReplicaUrl, getSourceReplicaUrl, getUnreliableFailoverConnection, getUnreliableFailoverConnection, getUnreliableLoadBalancedConnection, getUnreliableLoadBalancedConnection, getUnreliableMultiHostConnection, getUnreliableReplicationConnection, getUnreliableReplicationConnection, getUnreliableReplicationConnection, isClassAvailable, isCommunityEdition, isEnterpriseEdition, isMysqlRunningLocally, isRunningOnJRockit, isServerRunningOnWindows, isSysPropDefined, logDebug, newTempBinaryFile, randomString, removeHostRelatedProps, removeSqlMode, runLongTests, setUpBase, supportsLoadLocalInfile, supportsTestCachingSha2PasswordKeys, supportsTestCertificates, supportsTestSha256PasswordKeys, supportsTimeZoneNames, supportsTLSv1_2, tearDownBase, versionMeetsMinimum, versionMeetsMinimum

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Constructor Detail
  - CharsetRegressionTest
```
public CharsetRegressionTest()
```
- Method Detail
  - testBug7607
```
@Test
public void testBug7607()
                       throws java.lang.Exception
```
    Tests fix for BUG#7607 - MS932, SHIFT_JIS and Windows_31J not recog. as aliases for sjis.
    
    Throws:
    
    java.lang.Exception
  - testBug9206
```
@Test
public void testBug9206()
                       throws java.lang.Exception
```
    Tests fix for BUG#9206, can not use 'UTF-8' for characterSetResults configuration property.
    
    Throws:
    
    java.lang.Exception
  - testBug10496
```
@Test
public void testBug10496()
                        throws java.lang.Exception
```
    Tests fix for BUG#10496 - SQLException is thrown when using property "characterSetResults"
    
    Throws:
    
    java.lang.Exception
  - testBug12752
```
@Test
public void testBug12752()
                        throws java.lang.Exception
```
    Tests fix for BUG#12752 - Cp1251 incorrectly mapped to win1251 for servers newer than 4.0.x.
    
    Throws:
    
    java.lang.Exception
  - testBug15544
```
@Test
public void testBug15544()
                        throws java.lang.Exception
```
    Tests fix for BUG#15544, no "dos" character set in MySQL > 4.1.0
    
    Throws:
    
    java.lang.Exception
  - testBug37931
```
@Test
public void testBug37931()
                        throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testBug64205
```
@Test
public void testBug64205()
                        throws java.lang.Exception
```
    Tests fix for Bug#64205 (13702427), Connected through Connector/J 5.1 to MySQL 5.5, the error message is garbled.
    
    Throws:
    
    java.lang.Exception
  - testBug41730
```
@Test
public void testBug41730()
                        throws java.lang.Exception
```
    Bug #41730 - SQL Injection when using U+00A5 and SJIS/Windows-31J
    
    Throws:
    
    java.lang.Exception
  - testAsciiCharConversion
```
@Test
public void testAsciiCharConversion()
                                   throws java.lang.Exception
```
    Tests character conversion bug.
    
    Throws:
    
    java.lang.Exception
  - testEncodingRegression
```
@Test
public void testEncodingRegression()
                                  throws java.lang.Exception
```
    Tests for regression of encoding forced by user, reported by Jive Software
    
    Throws:
    
    java.lang.Exception
  - testEscapeSJISDoubleEscapeBug
```
@Test
public void testEscapeSJISDoubleEscapeBug()
                                         throws java.lang.Exception
```
    Tests fix for BUG#879
    
    Throws:
    
    java.lang.Exception
  - testGreekUtf8411
```
@Test
public void testGreekUtf8411()
                            throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testBug24840
```
@Test
public void testBug24840()
                        throws java.lang.Exception
```
    Tests fix for BUG#24840 - character encoding of "US-ASCII" doesn't map correctly for 4.1 or newer
    
    Throws:
    
    java.lang.Exception
  - testBug73663
```
@Test
public void testBug73663()
                        throws java.lang.Exception
```
    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:
    
    java.lang.Exception
  - testBug72630
```
@Test
public void testBug72630()
                        throws java.lang.Exception
```
    Tests fix for Bug#72630 (18758686), NullPointerException during handshake in some situations
    
    Throws:
    
    java.lang.Exception
  - testBug25504578
```
@Test
public void testBug25504578()
                           throws java.lang.Exception
```
    Tests fix for Bug#25504578, CONNECT FAILS WHEN CONNECTIONCOLLATION=ISO-8859-13
    
    Throws:
    
    java.lang.Exception
  - testBug81196
```
@Test
public void testBug81196()
                        throws java.lang.Exception
```
    Tests fix for Bug#81196 (23227334), CONNECTOR/J NOT FOLLOWING DATABASE CHARACTER SET.
    
    Throws:
    
    java.lang.Exception
  - testBug100606
```
@Test
public void testBug100606()
                         throws java.lang.Exception
```
    Tests fix for Bug#100606 (31818423), UNECESARY CALL TO "SET NAMES 'UTF8' COLLATE 'UTF8_GENERAL_CI'".
    
    Throws:
    
    java.lang.Exception
  - testBug25554464_1
```
@Test
public void testBug25554464_1()
                             throws java.lang.Exception
```
    Tests fix for Bug#25554464, CONNECT FAILS WITH NPE WHEN THE SERVER STARTED WITH CUSTOM COLLATION. This test requires a special server configuration with:
    - character-set-server = custom
    - collation-server = custom_bin
    where 'custom_bin' is not a primary collation for 'custom' character set and has an index == 1024 on MySQL 8.0+ or index == 253 for older servers.
    Throws:
    
    java.lang.Exception
  - testBug25554464_2
```
@Test
public void testBug25554464_2()
                             throws java.lang.Exception
```
    Tests fix for Bug#25554464, CONNECT FAILS WITH NPE WHEN THE SERVER STARTED WITH CUSTOM COLLATION. This test requires a special server configuration with:
    - character-set-server = custom
    - collation-server = custom_general_ci
    where 'custom_general_ci' is a primary collation for 'custom' character set and has an index == 1025 on MySQL 8.0+ or index == 254 for older servers.
    Throws:
    
    java.lang.Exception
  - testPasswordCharacterEncoding
```
@Test
public void testPasswordCharacterEncoding()
                                         throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - checkCollationConnection
```
private void checkCollationConnection(java.util.Properties props,
                                      java.lang.String query,
                                      boolean expectQueryIsIssued,
                                      java.lang.String expectedCollation)
                               throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testBug71038
```
@Test
public void testBug71038()
                        throws java.lang.Exception
```
    Tests fix for Bug#71038, Add an option for custom collations detection
    
    Throws:
    
    java.lang.Exception
  - testBug91317
```
@Test
public void testBug91317()
                        throws java.lang.Exception
```
    Tests fix for Bug#91317 (28207422), Wrong defaults on collation mappings.
    
    Throws:
    
    java.lang.Exception
  - testBug72712
```
@Test
public void testBug72712()
                        throws java.lang.Exception
```
    Test for Bug#72712 - SET NAMES issued unnecessarily. Using a statement interceptor, ensure that SET NAMES is not called if the encoding requested by the client application matches that of character_set_server. Also test that character_set_results is not set unnecessarily.
    
    Throws:
    
    java.lang.Exception
  - testBug95139
```
@Test
public void testBug95139()
                        throws java.lang.Exception
```
    Tests fix for Bug#95139 (29807572), CACHESERVERCONFIGURATION APPEARS TO THWART CHARSET DETECTION.
    
    Throws:
    
    java.lang.Exception
  - testBug95139CheckVariables
```
private void testBug95139CheckVariables(java.util.Properties p,
                                        int queryVarsCnt,
                                        java.lang.String expSetNamesQuery,
                                        java.lang.String expSetCharacterSetResultsquery)
                                 throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testBug34090350
```
@Test
public void testBug34090350()
                           throws java.lang.Exception
```
    Tests fix for Bug#34090350, Update mappings for utf8mb3 and utf8mb4 collations.
    
    Throws:
    
    java.lang.Exception

Class CharsetRegressionTest

Nested Class Summary

Nested classes/interfaces inherited from class testsuite.BaseTestCase

Field Summary

Fields inherited from class testsuite.BaseTestCase

Constructor Summary

Method Summary

Methods inherited from class testsuite.BaseTestCase

Methods inherited from class java.lang.Object

Constructor Detail

CharsetRegressionTest

Method Detail

testBug7607

testBug9206

testBug10496

testBug12752

testBug15544

testBug37931

testBug64205

testBug41730

testAsciiCharConversion

testEncodingRegression

testEscapeSJISDoubleEscapeBug

testGreekUtf8411

testBug24840

testBug73663

testBug72630

testBug25504578

testBug81196

testBug100606

testBug25554464_1

testBug25554464_2

testPasswordCharacterEncoding

checkCollationConnection

testBug71038

testBug91317

testBug72712

testBug95139

testBug95139CheckVariables

testBug34090350