pingcap/tidb

Enable more expressions to be pushdown to TiKV

Open

#26.954 aperta il 6 ago 2021

Vedi su GitHub
 (5 commenti) (0 reazioni) (0 assegnatari)Go (6186 fork)batch import
component/jsonhelp wantedsig/executiontype/enhancement

Metriche repository

Star
 (40.090 star)
Metriche merge PR
 (Merge medio 14g 4h) (346 PR mergiate in 30 g)

Descrizione

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

Guida contributor