pingcap/tidb

Enable more expressions to be pushdown to TiKV

Open

#26,954 创建于 2021年8月6日

在 GitHub 查看
 (5 评论) (0 反应) (0 负责人)Go (6,186 fork)batch import
component/jsonhelp wantedsig/executiontype/enhancement

仓库指标

Star
 (40,090 star)
PR 合并指标
 (平均合并 14天 4小时) (30 天内合并 346 个 PR)

描述

Enhancement

There are some expressions that has been implemented in TiKV copr but the push down is not enabled. There are two reasons:

  1. The test is insufficient.
  2. The implementation is not compatible with MySQL because the underlying library is different(such as the math library).

For the first situation, we can add more testcase to ensure its correctness. Especially when Projection push down is finished, We can do testing with greater efficiency.

Misc

  • AnyValue
  • InetNtoa
  • InetAton
  • Inet6Ntoa
  • Inet6Aton
  • IsIPv4
  • IsIPv4Compat
  • IsIPv4Mapped
  • IsIPv6
  • BitAnd
  • BitOr
  • BitCount
  • Bin
  • UnHex
  • Sha2
  • Compress
  • Uncompress
  • RandomBytes
  • Password
  • FromBase64

Json

  • JsonDepth
  • JsonReplace
  • JsonKeys
  • JsonQuote

Math

  • abs
  • Pi
  • Sin
  • Asin
  • Cos
  • Acos
  • Tan
  • Atan
  • Atan2
  • Cot

String

  • locate
  • truncate
  • Regexp
  • ord
  • lpad
  • rpad
  • left
  • right
  • insert
  • upper
  • lower
  • makeset
  • substringIndex
  • instr
  • quote
  • octant
  • findInSet
  • CharLength
  • ToBase64
  • repeat

Time

  • WeekOfYear
  • DayOfWeek
  • Week
  • WeekDay
  • ToDays
  • ToSeconds
  • DateDiff
  • NullTimeDiff
  • AddDate
  • MakeDate
  • Hour
  • Minute
  • Second
  • MicroSecond
  • DayName
  • TimestampDiff
  • DateAdd
  • FromUnixTime

贡献者指南