~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to storage/innobase/mysql-test/innodb_bug44032.test

• browse files at revision 641.2.3
• compare with another revision
• compare with revision 2165.1.3
• download diff
• download tarball
• view history from revision 641.2.3

Show diffs side-by-side

added

removed

storage/innobase/mysql-test/innodb_bug44032.test

 

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

-- source include/have_innodb.inc

 

6

 

 

7

CREATE TABLE bug44032(c CHAR(3) CHARACTER SET UTF8) ROW_FORMAT=REDUNDANT

 

8

ENGINE=InnoDB;

 

9

INSERT INTO bug44032 VALUES('abc'),(0xEFBCA4EFBCA4EFBCA4);

 

10

UPDATE bug44032 SET c='DDD' WHERE c=0xEFBCA4EFBCA4EFBCA4;

 

11

UPDATE bug44032 SET c=NULL WHERE c='DDD';

 

12

UPDATE bug44032 SET c='DDD' WHERE c IS NULL;

 

13

DROP TABLE bug44032;

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1