SELECT CONCAT('aaa',0xF09F988E,'bbb') INTO OUTFILE '/tmp/test.txt';

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8);

LOAD DATA INFILE '/tmp/test.txt' INTO TABLE t1 CHARACTER SET utf8;

SHOW WARNINGS;

SELECT * FROM t1;

MariaDB [test]> DROP TABLE IF EXISTS t1;

Query OK, 0 rows affected (0.01 sec)

MariaDB [test]> CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8);

Query OK, 0 rows affected (0.01 sec)

MariaDB [test]> LOAD DATA INFILE '/tmp/test.txt' INTO TABLE t1 CHARACTER SET utf8;

Query OK, 1 row affected, 1 warning (0.00 sec)       

Records: 1  Deleted: 0  Skipped: 0  Warnings: 1

MariaDB [test]> SHOW WARNINGS;

+---------+------+-------------------------------------------------------------------------+

| Level   | Code | Message                                                                 |

+---------+------+-------------------------------------------------------------------------+

| Warning | 1366 | Incorrect string value: '\xF0\x9F\x98\x8Ebb...' for column 'a' at row 1 |

+---------+------+-------------------------------------------------------------------------+

1 row in set (0.00 sec)

MariaDB [test]> SELECT * FROM t1;

+------+

| a    |

+------+

| aaa  |

+------+

MariaDB [test]> DROP TABLE IF EXISTS t1;

Query OK, 0 rows affected (0.02 sec)

MariaDB [test]> CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET utf8);

Query OK, 0 rows affected (0.05 sec)

MariaDB [test]> LOAD DATA INFILE '/tmp/test.txt' INTO TABLE t1 CHARACTER SET utf8;

ERROR 1300 (HY000): Invalid utf8 character string: 'aaa'

MariaDB [test]> SHOW WARNINGS;                       

+-------+------+--------------------------------------+

| Level | Code | Message                              |

+-------+------+--------------------------------------+

| Error | 1300 | Invalid utf8 character string: 'aaa' |

+-------+------+--------------------------------------+

1 row in set (0.00 sec)

MariaDB [test]> SELECT * FROM t1;

Empty set (0.00 sec)

commit 9f7288e2e0179db478d20c74f57b5c7d6c95f793

Author: Thayumanavar S <thayumanavar.x.sachithanantha@oracle.com>

Date:   Mon Jun 20 11:35:43 2016 +0530

    BUG#23080148 - BACKPORT BUG 14653594 AND BUG 20683959 TO

                   MYSQL-5.5

    The bug asks for a backport of bug#1463594 and bug#20682959. This

    is required because of the fact that if replication is enabled, master

    transaction can commit whereas slave can't commit due to not exact

    'enviroment'. This manifestation is seen in bug#22024200.