| 1 |
CREATE TABLE t1 (a TEXT, ac TEXT COMPRESSED, b TINYTEXT, bc TINYTEXT COMPRESSED, c MEDIUMTEXT, cc MEDIUMTEXT COMPRESSED, d LONGTEXT, dc LONGTEXT COMPRESSED, e VARCHAR(10), ec VARCHAR(10) COMPRESSED); |
| 2 |
# Isolate row event into its own binary log |
| 3 |
FLUSH BINARY LOGS; |
| 4 |
INSERT INTO t1 VALUES ('mya', 'myac', 'myb', 'mybc', 'myc', 'mycc', 'myd', 'mydc', 'mye', 'myec'); |
| 5 |
FLUSH BINARY LOGS; |
| 6 |
# MYSQLBINLOG --base64-output=decode-rows -vv datadir/binlog_file --result-file=result_binlog |
| 7 |
include/assert_grep.inc [Ensure compressed TEXT fields are annotated correctly] |
| 8 |
include/assert_grep.inc [Ensure compressed TINYTEXT fields are annotated correctly] |
| 9 |
include/assert_grep.inc [Ensure compressed MEDIUMTEXT fields are annotated correctly] |
| 10 |
include/assert_grep.inc [Ensure compressed LONGTEXT fields are annotated correctly] |
| 11 |
include/assert_grep.inc [Ensure compressed VARSTRING fields are annotated correctly] |
| 12 |
include/assert_grep.inc [Ensure COMPRESSED only shows up for corresponding fields] |
| 13 |
include/assert_grep.inc [Ensure non-compressed TEXT fields are annotated correctly] |
| 14 |
include/assert_grep.inc [Ensure non-compressed VARSTRING fields are annotated correctly] |
| 15 |
DROP TABLE t1; |