pattern, FORMAT(), LOWER(), LTRIM(), RTRIM(), SUBSTRING_INDEX(), TRIM(), UCASE(), UPPER() 48 * Mathematical functions: ROUND (decimal, int) * Date and time functions: HOUR(), MICROSECOND(), MINUTE(), SEC- of SQL statements. The �→ numbers below are the cumulative values of counter type (scientific �→ notation). tidb_executor_statement_total{type="Delete"} 520197 tidb_executor_statement_total{type="Explain"} be pushed down to TiFlash. Currently, TiFlash supports the following push-down expressions: • Mathematical functions: +, -, /, *, %, >=, <=, =, !=, <, >, round, abs, �→ floor(int), ceil(int), ceiling(int)

MOD / %, LIKE – Add string functions: ASCII(), COALESCE(), LENGTH(), POSITION(), TRIM() – Add mathematical functions: CONV(), CRC32(), DEGREES(), EXP(), LN(), LOG(), LOG10(), LOG2(), POW(), RADIANS(), of SQL statements. The �→ numbers below are the cumulative values of counter type (scientific �→ notation). tidb_executor_statement_total{type="Delete"} 520197 tidb_executor_statement_total{type="Explain"} be pushed down to TiFlash. Currently, TiFlash supports the following push-down expressions: • Mathematical functions: +, -, /, *, %, >=, <=, =, !=, <, >, round(int), �→ round(double), round(decimal),

str_to_date('20090101 00:00:00', '%Y%m%d %H:%i:%s') 4.11.2.2.4 Other specifications • Do not perform mathematical operations or functions on the index column in the WHERE condition. • Replace OR with IN or of SQL statements. The �→ numbers below are the cumulative values of counter type (scientific �→ notation). tidb_executor_statement_total{type="Delete"} 520197 tidb_executor_statement_total{type="Explain"} 2575 14.3.6.2 Push-down expressions TiFlash supports the following push-down expressions: • Mathematical functions: +, -, /, *, %, >=, <=, =, !=, <, >, round, abs, �→ floor(int), ceil(int), ceiling(int)

of SQL statements. The �→ numbers below are the cumulative values of counter type (scientific �→ notation). tidb_executor_statement_total{type="Delete"} 520197 tidb_executor_statement_total{type="Explain"} be pushed down to TiFlash. Currently, TiFlash supports the following push-down expressions: • Mathematical functions: +, -, /, *, %, >=, <=, =, !=, <, >, round, abs, �→ floor(int), ceil(int), ceiling(int) represented as 1, .2, 3.4, -5, -6.78, +9.10. Numeric literals can also be represented in scientific notation, such as 1.2E3, 1.2E-3, �→ -1.2E3, -1.2E-3. For more information, see Numeric Literals in MySQL

str_to_date('20090101 00:00:00', '%Y%m%d %H:%i:%s') 642 4.12.2.2.4 Other specifications • Do not perform mathematical operations or functions on the index column in the WHERE condition. • Replace OR with IN or of SQL statements. The �→ numbers below are the cumulative values of counter type (scientific �→ notation). tidb_executor_statement_total{type="Delete"} 520197 tidb_executor_statement_total{type="Explain"} represented as 1, .2, 3.4, -5, -6.78, +9.10. Numeric literals can also be represented in scientific notation, such as 1.2E3, 1.2E-3, �→ -1.2E3, -1.2E-3. For more information, see Numeric Literals in MySQL

str_to_date('20090101 00:00:00', '%Y%m%d %H:%i:%s') 553 4.11.2.2.4 Other specifications • Do not perform mathematical operations or functions on the index column in the WHERE condition. • Replace OR with IN or of SQL statements. The �→ numbers below are the cumulative values of counter type (scientific �→ notation). tidb_executor_statement_total{type="Delete"} 520197 tidb_executor_statement_total{type="Explain"} represented as 1, .2, 3.4, -5, -6.78, +9.10. Numeric literals can also be represented in scientific notation, such as 1.2E3, 1.2E-3, �→ -1.2E3, -1.2E-3. For more information, see Numeric Literals in MySQL

str_to_date('20090101 00:00:00', '%Y%m%d %H:%i:%s') 556 4.11.2.2.4 Other specifications • Do not perform mathematical operations or functions on the index column in the WHERE condition. • Replace OR with IN or of SQL statements. The �→ numbers below are the cumulative values of counter type (scientific �→ notation). tidb_executor_statement_total{type="Delete"} 520197 tidb_executor_statement_total{type="Explain"} represented as 1, .2, 3.4, -5, -6.78, +9.10. Numeric literals can also be represented in scientific notation, such as 1.2E3, 1.2E-3, �→ -1.2E3, -1.2E-3. For more information, see Numeric Literals in MySQL

str_to_date('20090101 00:00:00', '%Y%m%d %H:%i:%s') 637 4.12.2.2.4 Other specifications • Do not perform mathematical operations or functions on the index column in the WHERE condition. • Replace OR with IN or of SQL statements. The �→ numbers below are the cumulative values of counter type (scientific �→ notation). tidb_executor_statement_total{type="Delete"} 520197 tidb_executor_statement_total{type="Explain"} represented as 1, .2, 3.4, -5, -6.78, +9.10. Numeric literals can also be represented in scientific notation, such as 1.2E3, 1.2E-3, �→ -1.2E3, -1.2E-3. For more information, see Numeric Literals in MySQL

str_to_date('20090101 00:00:00', '%Y%m%d %H:%i:%s') 553 4.11.2.2.4 Other specifications • Do not perform mathematical operations or functions on the index column in the WHERE condition. • Replace OR with IN or of SQL statements. The �→ numbers below are the cumulative values of counter type (scientific �→ notation). tidb_executor_statement_total{type="Delete"} 520197 tidb_executor_statement_total{type="Explain"} represented as 1, .2, 3.4, -5, -6.78, +9.10. Numeric literals can also be represented in scientific notation, such as 1.2E3, 1.2E-3, �→ -1.2E3, -1.2E-3. For more information, see Numeric Literals in MySQL

str_to_date('20090101 00:00:00', '%Y%m%d %H:%i:%s') 4.11.2.2.4 Other specifications • Do not perform mathematical operations or functions on the index column in the WHERE condition. • Replace OR with IN or of SQL statements. The �→ numbers below are the cumulative values of counter type (scientific �→ notation). tidb_executor_statement_total{type="Delete"} 520197 tidb_executor_statement_total{type="Explain"} represented as 1, .2, 3.4, -5, -6.78, +9.10. Numeric literals can also be represented in scientific notation, such as 1.2E3, 1.2E-3, �→ -1.2E3, -1.2E-3. For more information, see Numeric Literals in MySQL