copr-test always fail

[lysu]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

run corp-test in master

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

pass

3. What did you see instead (Required)

all PRs failed at

[2020-08-31T06:28:36.707Z] Statement: #779 -  SELECT CAST( `col_double_unsigned_key` AS DATE ) AS field1, BINARY NULL AS field2 FROM `table10_int_autoinc` WHERE CAST( ( BINARY ( CONVERT( ( CONVERT( '2018-01-06 06:43:13.006798', SIGNED ) ) USING latin1 ) ) ) AS CHAR(5) ) ORDER BY field1, field2 LIMIT 1 /* QNO 786 CON_ID 104 */ ;

[2020-08-31T06:28:36.707Z] NoPushDown Output: 

[2020-08-31T06:28:36.707Z] field1	field2

[2020-08-31T06:28:36.707Z] NULL	NULL

[2020-08-31T06:28:36.707Z] 

[2020-08-31T06:28:36.707Z] 

[2020-08-31T06:28:36.707Z] WithPushDown Output: 

[2020-08-31T06:28:36.707Z] field1	field2

[2020-08-31T06:28:36.707Z] 0000-00-00 00:00:00	NULL

[2020-08-31T06:28:36.707Z] 

[2020-08-31T06:28:36.707Z] 

[2020-08-31T06:28:36.707Z] 

[2020-08-31T06:28:36.707Z] NoPushDown Plan: 

[2020-08-31T06:28:36.707Z] id	estRows	task	access object	operator info

[2020-08-31T06:28:36.707Z] Projection_7	1.00	root		cast(push_down_test_db.table10_int_autoinc.col_double_unsigned_key, date BINARY)->Column#62, <nil>->Column#63

[2020-08-31T06:28:36.707Z] └─Projection_19	1.00	root		push_down_test_db.table10_int_autoinc.col_double_unsigned_key

[2020-08-31T06:28:36.707Z]   └─TopN_8	1.00	root		Column#64, offset:0, count:1

[2020-08-31T06:28:36.707Z]     └─Projection_20	1.00	root		push_down_test_db.table10_int_autoinc.col_double_unsigned_key, cast(push_down_test_db.table10_int_autoinc.col_double_unsigned_key, date BINARY)->Column#64

[2020-08-31T06:28:36.707Z]       └─IndexReader_14	1.00	root		index:TopN_13

[2020-08-31T06:28:36.707Z]         └─TopN_13	1.00	cop[tikv]		cast(push_down_test_db.table10_int_autoinc.col_double_unsigned_key), offset:0, count:1

[2020-08-31T06:28:36.707Z]           └─IndexFullScan_12	10000.00	cop[tikv]	table:table10_int_autoinc, index:col_double_unsigned_key(col_double_unsigned_key)	keep order:false, stats:pseudo

[2020-08-31T06:28:36.707Z] 

[2020-08-31T06:28:36.707Z] 

[2020-08-31T06:28:36.707Z] WithPushDown Plan: 

[2020-08-31T06:28:36.707Z] id	estRows	task	access object	operator info

[2020-08-31T06:28:36.707Z] Projection_7	1.00	root		cast(push_down_test_db.table10_int_autoinc.col_double_unsigned_key, date BINARY)->Column#62, <nil>->Column#63

[2020-08-31T06:28:36.707Z] └─Projection_19	1.00	root		push_down_test_db.table10_int_autoinc.col_double_unsigned_key

[2020-08-31T06:28:36.707Z]   └─TopN_8	1.00	root		Column#64, offset:0, count:1

[2020-08-31T06:28:36.707Z]     └─Projection_20	1.00	root		push_down_test_db.table10_int_autoinc.col_double_unsigned_key, cast(push_down_test_db.table10_int_autoinc.col_double_unsigned_key, date BINARY)->Column#64

[2020-08-31T06:28:36.707Z]       └─IndexReader_14	1.00	root		index:TopN_13

[2020-08-31T06:28:36.707Z]         └─TopN_13	1.00	cop[tikv]		cast(push_down_test_db.table10_int_autoinc.col_double_unsigned_key), offset:0, count:1

[2020-08-31T06:28:36.708Z]           └─IndexFullScan_12	10000.00	cop[tikv]	table:table10_int_autoinc, index:col_double_unsigned_key(col_double_unsigned_key)	keep order:false, stats:pseudo

[2020-08-31T06:28:36.708Z] 

[2020-08-31T06:28:36.708Z] 

[2020-08-31T06:28:36.708Z] 

4. What is your TiDB version? (Required)

master

[lysu]

it caused by #19485 @dyzsr PTAL