# Test for Bug#91072

--disable_result_log

### "SELECT (success)", "SET", "SELECT" doesn't occur Bug#91072
connect (open_success, localhost, root,,);
connection open_success;
SELECT * FROM sys.statement_analysis;
--disable_warnings
SET SESSION default_collation_for_utf8mb4 = 'utf8mb4_general_ci';
--enable_warnings
SELECT * FROM sys.statement_analysis;

### Just "SET", "SELECT" can reproduce Bug#91072
connect (open_fail, localhost, root,,);
connection open_fail;
--disable_warnings
SET SESSION default_collation_for_utf8mb4 = 'utf8mb4_general_ci';
--enable_warnings

### Here raises 1267 (ER_CANT_AGGREGATE_2COLLATIONS): Illegal mix of collations (%s,%s) and (%s,%s) for operation '%s'
--error 1267
SELECT * FROM sys.statement_analysis;

--enable_result_log