rm -rf 87624
scripts/mysql_install_db --basedir=$PWD --datadir=$PWD/87624 -v
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/87624 --core-file --socket=/tmp/mysql_ushastry.sock  --port=3306 --log-error=$PWD/87624/log.err  --log-bin --binlog-format=statement --server-id=1 2>&1 &

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.37: bin/mysql -uroot -S /tmp/mysql_ushastry.sock                                                           
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.37-log MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

root@localhost [(none)]> use test
Database changed
root@localhost [test]> set session binlog_format=STATEMENT;
Query OK, 0 rows affected (0.00 sec)

root@localhost [test]> CREATE TABLE t1 (
    ->  id int(11) DEFAULT NULL,
    ->  nm varchar(10) DEFAULT NULL
    ->  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Query OK, 0 rows affected (0.00 sec)

root@localhost [test]>
root@localhost [test]>  CREATE TABLE t11 (
    ->  id int(11) DEFAULT NULL,
    ->  nm varchar(10) DEFAULT NULL,
    ->  cmt varchar(300) DEFAULT NULL
    ->  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Query OK, 0 rows affected (0.00 sec)

root@localhost [test]>

root@localhost [test]> delimiter //
root@localhost [test]>  CREATE DEFINER=root@localhost PROCEDURE sp_test_t11_ins()
    ->  BEGIN
    ->  DECLARE v_id INT;
    ->  SET v_id=2017;
    ->  INSERT INTO test.t11 (id,nm, cmt)
    ->  SELECT
    ->  id
    ->  ,nm
    ->  ,CONCAT( v_id, ' ???????') AS cmt
    ->  FROM test.t1;
    ->  END;
    ->  //
Query OK, 0 rows affected (0.00 sec)

root@localhost [test]> delimiter ;
root@localhost [test]> insert into t1 values(1,'aaa');
Query OK, 1 row affected (0.01 sec)

root@localhost [test]> CALL test.sp_test_t11_ins();
Query OK, 1 row affected (0.00 sec)

root@localhost [test]> select * from t11;
+------+------+----------------------------+
| id   | nm   | cmt                        |
+------+------+----------------------------+
|    1 | aaa  | 2017 ???????        |
+------+------+----------------------------+
1 row in set (0.00 sec)

root@localhost [test]> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| hod03-bin.000001 |     1375 |              |                  |                   |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0.00 sec)

root@localhost [test]> \q
Bye

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.37: bin/mysqlbinlog -vv -uroot 87624/hod03-bin.000001
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#170901  8:54:24 server id 1  end_log_pos 120 CRC32 0x8fc676f8  Start: binlog v 4, server v 5.6.37-log created 170901  8:54:24 at startup
# Warning: this binlog is either in use or was not closed properly.
ROLLBACK/*!*/;
BINLOG '
IASpWQ8BAAAAdAAAAHgAAAABAAQANS42LjM3LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAgBKlZEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAAfh2
xo8=
'/*!*/;
# at 120
#170901  8:54:50 server id 1  end_log_pos 307 CRC32 0xeebc64ff  Query   thread_id=1     exec_time=0     error_code=0
use `test`/*!*/;
SET TIMESTAMP=1504248890/*!*/;
SET @@session.pseudo_thread_id=1/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
SET @@session.sql_mode=1073741824/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=8/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
CREATE TABLE t1 (
 id int(11) DEFAULT NULL,
 nm varchar(10) DEFAULT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
/*!*/;
# at 307
#170901  8:54:50 server id 1  end_log_pos 527 CRC32 0xdda4f415  Query   thread_id=1     exec_time=0     error_code=0
SET TIMESTAMP=1504248890/*!*/;
CREATE TABLE t11 (
 id int(11) DEFAULT NULL,
 nm varchar(10) DEFAULT NULL,
 cmt varchar(300) DEFAULT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
/*!*/;
# at 527
#170901  8:55:29 server id 1  end_log_pos 843 CRC32 0xc057df82  Query   thread_id=2     exec_time=0     error_code=0
SET TIMESTAMP=1504248929/*!*/;
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_test_t11_ins`()
BEGIN
 DECLARE v_id INT;
 SET v_id=2017;
 INSERT INTO test.t11 (id,nm, cmt)
 SELECT
 id
 ,nm
 ,CONCAT( v_id, ' ???????') AS cmt

 FROM test.t1;
 END
/*!*/;
# at 843
#170901  8:55:43 server id 1  end_log_pos 922 CRC32 0x298592bb  Query   thread_id=2     exec_time=0     error_code=0
SET TIMESTAMP=1504248943/*!*/;
BEGIN
/*!*/;
# at 922
#170901  8:55:43 server id 1  end_log_pos 1026 CRC32 0x397e3781         Query   thread_id=2     exec_time=0     error_code=0
SET TIMESTAMP=1504248943/*!*/;
insert into t1 values(1,'aaa')
/*!*/;
# at 1026
#170901  8:55:43 server id 1  end_log_pos 1057 CRC32 0x279cf271         Xid = 15
COMMIT/*!*/;
# at 1057
#170901  8:55:43 server id 1  end_log_pos 1136 CRC32 0x7ca25e3e         Query   thread_id=2     exec_time=0     error_code=0
SET TIMESTAMP=1504248943/*!*/;
BEGIN
/*!*/;
# at 1136
#170901  8:55:43 server id 1  end_log_pos 1344 CRC32 0x243f26ca         Query   thread_id=2     exec_time=0     error_code=0
SET TIMESTAMP=1504248943/*!*/;
INSERT INTO test.t11 (id,nm, cmt)
 SELECT
 id
 ,nm
 ,CONCAT(  NAME_CONST('v_id',2017), ' ???????') AS cmt

 FROM test.t1
/*!*/;
# at 1344
#170901  8:55:43 server id 1  end_log_pos 1375 CRC32 0xf0eae955         Xid = 19
COMMIT/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.37: bin/mysql -uroot -S /tmp/mysql_ushastry.sock test -e 'drop table t1, t11'
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.37: bin/mysql -uroot -S /tmp/mysql_ushastry.sock test -e 'drop procedure sp_test_t11_ins'
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.37:
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.37: bin/mysqlbinlog -vv -uroot --stop-position=1793 87624/hod03-bin.000001 |bin/mysql -uroot -S /tmp/mysql_ushastry.sock test
ERROR 1267 (HY000) at line 77: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'concat'