Bug #84877 test cases in suite opt_trace fail when changing default character set

• Submitted: 8 Feb 2017 9:41
• Modified: 14 Feb 2017 14:22
• Reporter: Xing Zhang
• Status: Closed
• Category: MySQL Server: Charsets
• Severity: S3 (Non-critical)
• Version: 8.0.1
• OS: Any
• CPU Architecture: Any

[8 Feb 2017 9:41] Xing Zhang

Description:
Following test cases in suite opt_trace fails when changing default character set to utf8mb4.
i_opt_trace.bugs_no_prot
i_opt_trace.bugs_ps_prot
opt_trace.bugs_no_prot_all
opt_trace.bugs_no_prot_none
opt_trace.bugs_ps_prot_all
opt_trace.bugs_ps_prot_none
opt_trace.charset
opt_trace.general2_no_prot
opt_trace.general2_ps_prot
opt_trace.general_no_prot_all
opt_trace.general_no_prot_none
opt_trace.general_ps_prot_all
opt_trace.general_ps_prot_none
opt_trace.range_no_prot
opt_trace.range_ps_prot
opt_trace.subquery_no_prot
opt_trace.subquery_ps_prot
opt_trace.temp_table

How to repeat:
./mtr --mem --charset-for-testdb=utf8mb4
i_opt_trace.bugs_no_prot
opt_trace.bugs_no_prot_all
opt_trace.bugs_no_prot_none
opt_trace.charset
opt_trace.general2_no_prot
opt_trace.general_no_prot_all
opt_trace.general_no_prot_none
opt_trace.range_no_prot
opt_trace.subquery_no_prot
opt_trace.temp_table

./mtr --mem --charset-for-testdb=utf8mb4 --ps-protocol
i_opt_trace.bugs_ps_prot
opt_trace.bugs_ps_prot_all
opt_trace.bugs_ps_prot_none
opt_trace.general2_ps_prot
opt_trace.general_ps_prot_all
opt_trace.general_ps_prot_none
opt_trace.range_ps_prot
opt_trace.subquery_ps_prot

Suggested fix:
change to use explicit charset latin1 or utf8mb4.

[14 Feb 2017 14:22] Paul DuBois

Posted by developer:
 
Fixed in 8.0.1.

Work was done for test suite. No changelog entry needed.