ARE USED

Description:

There are two issues as follows
a)main.ddl_i18n_utf8.test and main.ddl_i18n_koi8r.test are skipped
  when tried with mtr.
b)As test cases were skipped, 5.7 has got regression with collations.

Analysis:

a) Due to change in 'show collation' command behavior, new records
   returned by 'SHOW COLLATIONS' started to mismatch what's stored
   within r/have_xxx.require. This caused the tests to skip.

b) Regression was developed by the fix of the Bug#13520710.
   Fix made sure that while writing view statement, client character
   set is used. Regression arised in the case the view statement has
   different character set than client character set.

FIX :

a) Changed r/have_xxx.require files with the latest result of
   'SHOW COLLATIONS' statement. Test cases will not be skipped now.
   As the test case was disabled for a long time, result file got
   outdated. Updated result file.
b) Fixed code to use the character set if provided in the statement.