Invalid default value for 'column_name'

[Lloyd-Pottiger]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

mysql> set sql_mode='ansi'; CREATE TABLE test.t (id int, i int default '1.1', f float default 'a', d decimal(10,2) default 'b', y year default 'f');
ERROR 1067 (42000) at line 1: Invalid default value for 'f'

2. What did you expect to see? (Required)

3. What did you see instead (Required)

4. What is your TiFlash version? (Required)

release-8.1