select into outfile time1 year(4) default '2030', Inconsistent data 「tidb 4.0.9 vs mysql 5.7」 #22159
Closed
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
create table tm1(time1 year(4) default '2030');
insert into tm1 values(2010);
insert into tm1 values(2011);
insert into tm1 values(2012);
select * from tm1;
+-------+
| time1 |
+-------+
| 2010 |
| 2011 |
| 2012 |
+-------+
3 rows in set (0.00 sec)
2. What did you expect to see? (Required)
MySQL
MySQL [test]> select * from tm1 into outfile '/var/lib/mysql-files/tm1' fields terminated by ',' optionally enclosed by '=' lines terminated by '\n';
Query OK, 3 rows affected (0.00 sec)
[root@101 mysql-files]# cat tm1
2010
2011
2012
[root@101 mysql-files]#
3. What did you see instead (Required)
TiDB
MySQL [out]> select * from tm1 into outfile '/opt/t100/tm1' fields terminated by ',' optionally enclosed by '"' lines terminated by '\n';
Query OK, 0 rows affected (0.00 sec)
// Print three line space
[root@101 t100]# cat tm1
[root@101 t100]#
4. What is your TiDB version? (Required)
TiDB 4.0.9
Activity