| 1 |
CREATE TABLE bug44032(c CHAR(3) CHARACTER SET UTF8) ROW_FORMAT=REDUNDANT |
| 2 |
ENGINE=InnoDB; |
| 3 |
Warnings: |
| 4 |
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
| 5 |
INSERT INTO bug44032 VALUES('abc'),(0xEFBCA4EFBCA4EFBCA4); |
| 6 |
UPDATE bug44032 SET c='DDD' WHERE c=0xEFBCA4EFBCA4EFBCA4; |
| 7 |
UPDATE bug44032 SET c=NULL WHERE c='DDD'; |
| 8 |
UPDATE bug44032 SET c='DDD' WHERE c IS NULL; |
| 9 |
DROP TABLE bug44032; |