copr-test failed with some new issues

[leiysky]

Prepare data: https://github.com/leiysky/copr-test/blob/master/push-down-test/prepare/0_data.sql

Failed SQLs:

-- Arithmetic
-- Verified caused by https://github.com/pingcap/tics/issues/1682
SELECT 0 * ( - ( ( 5898 % -20848 ) - '1982-05-07 15:44:33.055162' ) ) AS field1 FROM `table10_int_autoinc` WHERE `col_tinyint_key` / `col_decimal_key` /* QNO 839 CON_ID 92 */ ;

-- Logical
-- Verified can be fixed by https://github.com/pingcap/tics/pull/1757
SELECT ( 5991757829239734272 << 17207 ) OR `col_date_key` AS field1, ( NOT 'piqpeeqfybmcddrieoknkhppgxnywibstnndnfdlytrgdfciduvizckvsaeghxasqiqglrwqysiscqkfdvxkmhpawlsgyspfwn' ) >> 'iqpeeqfybmcddrieoknkhppgxnywibstnndnfdlytrgdfciduvizckvsaeghxasqiqglrwqysiscqkfdvxkmhpawlsgyspfwnvjthxmluvggfbfnadhvxikbbkoxovtfhlxpdhvafoslnqkcggxesgrqucyutlrqavcwbpvtirokznvpokgspfioawmyvkshpjoxwndnvyipvsmuwsslelfelptzwsyeglopgaltunrefd' AS field2 FROM `table1000_int_autoinc` WHERE ~ `col_smallint_unsigned_key` /* QNO 1362 CON_ID 192 */ ;
SELECT ( -21464 & ( ( `col_decimal` << `col_bit_key` ) AND `col_int` ) ) AND `col_double_key` AS field1, ~ NULL AS field2 FROM `table10_int_autoinc` WHERE ~ `col_smallint_unsigned_key` /* QNO 1533 CON_ID 192 */ ;
SELECT ( NOT `col_int_unsigned_key` ) XOR `col_float` AS field1, '02:45:27.013140' ^ NULL AS field2, ( `col_varchar_1_key` & ( ( NOT `col_timestamp_key` ) ^ ( ( 'e' ^ ( `col_decimal_unsigned` << 'tdjepsbddesihtthildubswhialkcthwwfrzowqpdzntdkcmmpltjnvzfbarnpbazjlyiijcajizkhpi' ) ) >> `col_binary_8` ) ) ) & '19:03:13.041277' AS field3 FROM `table1000_int_autoinc` WHERE ~ `col_smallint_unsigned` /* QNO 2080 CON_ID 192 */ ;

-- Verified can be fixed by https://github.com/pingcap/tics/pull/1760
SELECT 8066 XOR -8716717078775595008 AS field1 FROM `table1000_int_autoinc` WHERE ( `col_timestamp` & `col_float` ) ^ 'rzowqpdzntdkcmmpltjnvzfbarnpbazjlyiijcajizkhpijsiegljoaovfgqspxyldqjdqumeuvctjzxhzaetyazfuacpzpnsejjdbgukcjtcmkqrgqtzquzafrzfbimdzqmxeqatdzhjzmtmpaidmeljzqwcfwvqiktloctojqzthkuen' /* QNO 2161 CON_ID 192 */ ;

-- Cast
-- Verified related to https://github.com/pingcap/tidb/issues/23993
SELECT CONVERT( NULL, DECIMAL(47,29) ) AS field1, CAST( ( CAST( ( BINARY ( CONVERT( ( CONVERT( ( CONVERT( `col_datetime`, BINARY(8) ) ), DECIMAL(15,13) ) ) USING latin1 ) ) ) AS DECIMAL ) ) AS SIGNED ) AS field2 FROM `table20_int_autoinc` WHERE CONVERT( `col_float_key`, TIME ) /* QNO 446 CON_ID 104 */ ;
SELECT CONVERT( `col_varchar_64_key`, DECIMAL(4) ) AS field1, CONVERT( '1996-09-01' USING latin1 ) AS field2 FROM `table10_int_autoinc` WHERE CONVERT( `col_double_key`, TIME ) /* QNO 880 CON_ID 104 */ ;

-- Verified related to https://github.com/pingcap/tics/issues/1761
SELECT CONVERT( `col_year`, DATE ) AS field1 FROM `table20_int_autoinc` WHERE CAST( `col_char_255_key` AS UNSIGNED ) /* QNO 794 CON_ID 104 */ ;
SELECT CAST( `col_time` AS DATETIME ) AS field1, CAST( ( CONVERT( 'm', TIME ) ) AS SIGNED ) AS field2 FROM `table1000_int_autoinc` WHERE CAST( `col_char_2` AS UNSIGNED ) /* QNO 256 CON_ID 104 */ ;

-- Verified related to https://github.com/pingcap/tics/issues/1764
SELECT CAST( '1996-03-18' AS DECIMAL(1) ) AS field1, CONVERT( 'ttxlkyyenkolkvbqiunbaghhrwroszjgaybvfywsdpnxqipqmnycipdohcmobvunclcsqibcjanciehabadzhrbcehzpozngovwwhcsvhxvafsgzuennpiwbeqrvkhrcjzbbjimjdnicailnccgigesfc', BINARY(4) ) AS field2, BINARY `col_char_2_key` AS field3 FROM `table10_int_autoinc` WHERE CAST( `col_smallint_unsigned` AS DATE ) /* QNO 85 CON_ID 104 */ ;

SELECT CONVERT( `col_time_key` USING latin1 ) AS field1, BINARY `col_smallint_unsigned` AS field2 FROM `table1000_int_autoinc` WHERE CONVERT( ( BINARY `col_decimal_key` ), DATETIME ) /* QNO 87 CON_ID 104 */ ;

SELECT CAST( 6623950626931867648 AS DECIMAL(16,3) ) AS field1, CAST( NULL AS CHAR ) AS field2, CONVERT( '02:46:53.025460', SIGNED ) AS field3, CAST( 'u' AS UNSIGNED ) AS field4, CONVERT( 'yyenkolkvbqiunbaghhrwroszjgaybvfywsdpnxqipqmnycipdohcmobvunclcsqibcjan', BINARY(0) ) AS field5 FROM `table10_int_autoinc` WHERE CONVERT( `col_decimal_unsigned_key`, DATETIME ) /* QNO 99 CON_ID 104 */ ;

SELECT CONVERT( -4722 USING utf8 ) AS field1, CAST( 'hhrwroszjgaybvfywsdpnxqipqmnycipdohcmobvunclcsqibcjanciehabadzhrbcehzpozngovwwhcsvhxvafsgz' AS CHAR ) AS field2 FROM `table1000_int_autoinc` WHERE CAST( `col_int_unsigned` AS DATETIME ) /* QNO 170 CON_ID 104 */ ;

SELECT CAST( ( CONVERT( ( BINARY 0 ), BINARY ) ) AS BINARY(7) ) AS field1, CONVERT( ( CAST( ( CONVERT( ( CONVERT( ( BINARY ( CONVERT( 'rwroszjgaybvfywsdpnxqipqmnycipdohcmobvunclcsqibcjanciehabadzhrbcehzpozngovwwhcsvhxvafsgzuennpiwbe', BINARY ) ) ), DATETIME ) ) USING latin1 ) ) AS DATE ) ) USING utf8 ) AS field2, CONVERT( ( CAST( -10776 AS BINARY(9) ) ) USING utf8 ) AS field3 FROM `table20_int_autoinc` WHERE CONVERT( ( BINARY `col_bigint` ), DATE ) /* QNO 174 CON_ID 104 */ ;

SELECT CONVERT( '1994-12-22 09:45:38.013332', CHAR(5) ) AS field1 FROM `table10_int_autoinc` WHERE CONVERT( `col_double_unsigned`, DATE ) /* QNO 205 CON_ID 104 */ ;

SELECT CAST( -20341 AS DECIMAL ) AS field1 FROM `table1000_int_autoinc` WHERE CAST( ( BINARY ( BINARY `col_blob_key` ) ) AS DATETIME ) /* QNO 281 CON_ID 104 */ ;

SELECT CONVERT( `col_year_key` USING latin1 ) AS field1, CAST( ( BINARY `col_varbinary_32_key` ) AS UNSIGNED ) AS field2 FROM `table20_int_autoinc` WHERE CAST( `col_varchar_1` AS DECIMAL(0,0) ) /* QNO 612 CON_ID 104 */ ;

SELECT BINARY ( BINARY ( BINARY ( CONVERT( `col_text_key` USING utf8 ) ) ) ) AS field1, BINARY ( CONVERT( '1998-12-05', TIME ) ) AS field2 FROM `table1000_int_autoinc` WHERE CAST( `col_char_255` AS DATETIME ) /* QNO 789 CON_ID 104 */ ;

SELECT CAST( '06:59:36.030273' AS CHAR ) AS field1, CONVERT( NULL USING latin1 ) AS field2 FROM `table10_int_autoinc` WHERE CAST( `col_int` AS DATETIME ) /* QNO 876 CON_ID 104 */ ;

SELECT CAST( `col_bit` AS CHAR(2) ) AS field1 FROM `table1000_int_autoinc` WHERE CAST( `col_text_key` AS DATE ) /* QNO 890 CON_ID 104 */ ;

SELECT CONVERT( `col_set_key`, BINARY ) AS field1 FROM `table10_int_autoinc`  /* QNO 892 CON_ID 104 */ ;

SELECT CONVERT( ( CONVERT( 'ilnccgigesfctrvkyibnsscbdfamsybhmhmycjnaoeujktssgjpbcvxufdlywxxvorrivbqkioapjlpfmznirabjaltkuikneiwxggykeaicyrmheclphxkoarykwttffengmjjisqioajnisxfugwvwfvonrrmqdt', CHAR(3) ) ) USING latin1 ) AS field1 FROM `table20_int_autoinc` WHERE CONVERT( `col_float_key`, CHAR(0) ) /* QNO 956 CON_ID 104 */ ;

SELECT CAST( 25378 AS TIME ) AS field1 FROM `table20_int_autoinc` WHERE CAST( ( BINARY `col_varbinary_32` ) AS DATETIME ) /* QNO 978 CON_ID 104 */ ;

Related issues:

• Cast int as time may produce wront result #1764
• Cast string as unsigned may produce wrong result #1761
• Cast datetime as int will return wrong value #1759
• Behavior of bitwise negation is different between TiFlash and TiDB #1756
• expression: Fix incorrect pushdown function list. tidb#23982
• Different behavior of error handling in CAST expression between TiDB and TiKV coprocessor tidb#23993