| 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; |