| 1 |
# Bug44032 no update-in-place of UTF-8 columns in ROW_FORMAT=REDUNDANT |
| 2 |
# (btr_cur_update_in_place not invoked when updating from/to NULL; |
| 3 |
# the update is performed by delete and insert instead) |
| 4 |
|
| 5 |
|
| 6 |
CREATE TABLE bug44032(c CHAR(3) CHARACTER SET UTF8) ROW_FORMAT=REDUNDANT |
| 7 |
ENGINE=InnoDB; |
| 8 |
INSERT INTO bug44032 VALUES('abc'),(0xEFBCA4EFBCA4EFBCA4); |
| 9 |
UPDATE bug44032 SET c='DDD' WHERE c=0xEFBCA4EFBCA4EFBCA4; |
| 10 |
UPDATE bug44032 SET c=NULL WHERE c='DDD'; |
| 11 |
UPDATE bug44032 SET c='DDD' WHERE c IS NULL; |
| 12 |
DROP TABLE bug44032; |