Debian Codegraph @

mysql-test/suite/binlog/r/binlog_mysqlbinlog_signedness_metadata.result

raw
1
2 # 1.Create a table with a signed and unsigned column.
3 # Get the binlog in use and flush logs
4 CREATE TABLE `t1` (
5 `col_key` CHAR(255) DEFAULT "",
6 `col_year_key` YEAR DEFAULT NULL,
7 `col_float_key` FLOAT UNSIGNED,
8 `col_bigint_key` BIGINT DEFAULT NULL,
9 PRIMARY KEY (`col_key`)
10 ) ENGINE=InnoDB;
11 Warnings:
12 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
13 INSERT INTO t1 VALUES ('key', '1985', 1.7, 23);
14 FLUSH LOGS;
15
16 # 2. Execute mysqlbinlog with '--print-table-metadata'
17 # Check column metadata correctly reports what columns are signed or not
18 # YEAR is considered unsigned, but not shown as such
19 include/assert_grep.inc [Check the YEAR metadata is marked signed and therefore, omitted info about signedness]
20 include/assert_grep.inc [Check that FLOAT metadata is marked as unsigned]
21 include/assert_grep.inc [Check that BIGINT metadata is marked signed and therefore, omitted info about signedness]
22
23 # 3. Cleanup
24 DROP TABLE t1;
25 RESET MASTER;