release/src/router/mysql/mysql-test/suite/binlog/r/binlog_stm_ctype_ucs.result

   1 SET TIMESTAMP=10000;
   2 create table t2 (c char(30)) charset=ucs2;
   3 set @v=convert('abc' using ucs2);
   4 reset master;
   5 insert into t2 values (@v);
   6 show binlog events from <binlog_start>;
   7 Log_name        Pos     Event_type      Server_id       End_log_pos     Info
   8 master-bin.000001       #       User var        #       #       @`v`=_ucs2 0x006100620063 COLLATE ucs2_general_ci
   9 master-bin.000001       #       Query   #       #       use `test`; insert into t2 values (@v)
  10 flush logs;
  11 /*!40019 SET @@session.max_insert_delayed_threads=0*/;
  12 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
  13 DELIMITER /*!*/;
  14 ROLLBACK/*!*/;
  15 SET @`v`:=_ucs2 0x006100620063 COLLATE `ucs2_general_ci`/*!*/;
  16 use `test`/*!*/;
  17 SET TIMESTAMP=10000/*!*/;
  18 SET @@session.pseudo_thread_id=999999999/*!*/;
  19 SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
  20 SET @@session.sql_mode=0/*!*/;
  21 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
  22 /*!\C latin1 *//*!*/;
  23 SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
  24 SET @@session.lc_time_names=0/*!*/;
  25 SET @@session.collation_database=DEFAULT/*!*/;
  26 insert into t2 values (@v)
  27 /*!*/;
  28 DELIMITER ;
  29 # End of log file
  30 ROLLBACK /* added by mysqlbinlog */;
  31 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
  32 drop table t2;