00001 # 00002 # Simple test of the transaction log for statements involving 00003 # BLOB fields. 00004 # 00005 00006 --disable_warnings 00007 DROP TABLE IF EXISTS t1, t2; 00008 --enable_warnings 00009 00010 CREATE TABLE t1 ( 00011 id INT NOT NULL 00012 , padding BLOB NOT NULL 00013 , PRIMARY KEY (id) 00014 ); 00015 00016 INSERT INTO t1 VALUES (1, 'test\0me'); 00017 INSERT INTO t1 VALUES (2, 'test\0you'); 00018 00019 UPDATE t1 SET padding = 'test\0you' WHERE padding = 'test\0me'; 00020 00021 DELETE FROM t1 WHERE padding = 'test\0you'; 00022 00023 CREATE TABLE t2 ( 00024 id INT NOT NULL 00025 , padding BLOB 00026 , PRIMARY KEY (id) 00027 ); 00028 00029 INSERT INTO t2 VALUES (1, NULL); 00030 INSERT INTO t2 VALUES (2, 'test\0you'); 00031 UPDATE t2 SET padding = NULL WHERE padding = 'test\0you'; 00032 DELETE FROM t2 WHERE padding IS NULL; 00033 00034 DROP TABLE t1, t2;