Tracking issue for Migrate functions from TiDB

This is a list of functions that can be migrated from TiDB to TiKV.

Update on 2021-09-01: this list is outdated, see https://github.com/tikv/tikv/issues/5751#issuecomment-909765143 for the updated list.

• CastIntAsInt
• CastIntAsReal
• CastIntAsString
• CastIntAsDecimal
• CastIntAsTime
• CastIntAsDuration
• CastIntAsJson
• CastRealAsInt
• CastRealAsReal
• CastRealAsString
• CastRealAsDecimal
• CastRealAsTime
• CastRealAsDuration
• CastRealAsJson
• CastDecimalAsInt
• CastDecimalAsReal
• CastDecimalAsString
• CastDecimalAsDecimal
• CastDecimalAsTime
• CastDecimalAsDuration
• CastDecimalAsJson
• CastStringAsInt
• CastStringAsReal
• CastStringAsString
• CastStringAsDecimal
• CastStringAsTime
• CastStringAsDuration
• CastStringAsJson
• CastTimeAsInt
• CastTimeAsReal
• CastTimeAsString
• CastTimeAsDecimal
• CastTimeAsTime
• CastTimeAsDuration
• CastTimeAsJson
• CastDurationAsInt
• CastDurationAsReal
• CastDurationAsString
• CastDurationAsDecimal
• CastDurationAsTime
• CastDurationAsDuration
• CastDurationAsJson
• CastJsonAsInt
• CastJsonAsReal
• CastJsonAsString
• CastJsonAsDecimal
• CastJsonAsTime
• CastJsonAsDuration
• CastJsonAsJson
• CoalesceInt
• CoalesceReal
• CoalesceDecimal
• CoalesceString
• CoalesceTime
• CoalesceDuration
• CoalesceJson
• LTInt
• LTReal
• LTDecimal
• LTString
• LTTime
• LTDuration
• LTJson
• LEInt
• LEReal
• LEDecimal
• LEString
• LETime
• LEDuration
• LEJson
• GTInt
• GTReal
• GTDecimal
• GTString
• GTTime
• GTDuration
• GTJson
• GreatestInt
• GreatestReal
• GreatestDecimal
• GreatestString
• GreatestTime
• LeastInt
• LeastReal
• LeastDecimal
• LeastString
• LeastTime
• IntervalInt
• IntervalReal
• GEInt
• GEReal
• GEDecimal
• GEString
• GETime
• GEDuration
• GEJson
• EQInt
• EQReal
• EQDecimal
• EQString
• EQTime
• EQDuration
• EQJson
• NEInt
• NEReal
• NEDecimal
• NEString
• NETime
• NEDuration
• NEJson
• NullEQInt
• NullEQReal
• NullEQDecimal
• NullEQString
• NullEQTime
• NullEQDuration
• NullEQJson
• PlusReal
• PlusDecimal
• PlusInt
• MinusReal
• MinusDecimal
• MinusInt
• MultiplyReal
• MultiplyDecimal
• MultiplyInt
• DivideReal
• DivideDecimal
• IntDivideInt
• IntDivideDecimal
• ModReal
• ModDecimal
• ModInt
• MultiplyIntUnsigned
• PlusIntUnsignedUnsigned
• PlusIntUnsignedSigned
• PlusIntSignedUnsigned
• PlusIntSignedSigned
• ModIntUnsignedUnsigned
• ModIntUnsignedSigned
• ModIntSignedUnsigned
• ModIntSignedSigned
• AbsInt
• AbsUInt
• AbsReal
• AbsDecimal
• CeilIntToDec
• CeilIntToInt
• CeilDecToInt
• CeilDecToDec
• CeilReal
• FloorIntToDec
• FloorIntToInt
• FloorDecToInt
• FloorDecToDec
• FloorReal
• RoundReal
• RoundInt
• RoundDec
• RoundWithFracReal
• RoundWithFracInt
• RoundWithFracDec
• Log1Arg
• Log2Args
• Log2
• Log10
• Rand
• RandWithSeedFirstGen
• Pow
• Conv
• CRC32
• Sign
• Sqrt
• Acos
• Asin
• Atan1Arg
• Atan2Args
• Cos
• Cot
• Degrees
• Exp
• PI
• Radians
• Sin
• Tan
• TruncateInt
• TruncateReal
• TruncateDecimal
• TruncateUint
• LogicalAnd
• LogicalOr
• LogicalXor
• UnaryNotInt
• UnaryNotDecimal
• UnaryNotReal
• UnaryMinusInt
• UnaryMinusReal
• UnaryMinusDecimal
• DecimalIsNull
• DurationIsNull
• RealIsNull
• StringIsNull
• TimeIsNull
• IntIsNull
• JsonIsNull
• BitAndSig
• BitOrSig
• BitXorSig
• BitNegSig
• IntIsTrue
• RealIsTrue
• DecimalIsTrue
• IntIsFalse
• RealIsFalse
• DecimalIsFalse
• LeftShift
• RightShift
• IntIsTrueWithNull
• RealIsTrueWithNull
• DecimalIsTrueWithNull
• IntIsFalseWithNull
• RealIsFalseWithNull
• DecimalIsFalseWithNull
• BitCount
• GetParamString
• GetVar
• RowSig
• SetVar
• ValuesDecimal
• ValuesDuration
• ValuesInt
• ValuesJSON
• ValuesReal
• ValuesString
• ValuesTime
• InInt
• InReal
• InDecimal
• InString
• InTime
• InDuration
• InJson
• IfNullInt
• IfNullReal
• IfNullDecimal
• IfNullString
• IfNullTime
• IfNullDuration
• IfInt
• IfReal
• IfDecimal
• IfString
• IfTime
• IfDuration
• IfNullJson
• IfJson
• CaseWhenInt
• CaseWhenReal
• CaseWhenDecimal
• CaseWhenString
• CaseWhenTime
• CaseWhenDuration
• CaseWhenJson
• AesDecrypt
• AesEncrypt
• Compress
• MD5
• Password
• RandomBytes
• SHA1
• SHA2
• Uncompress
• UncompressedLength
• AesDecryptIV
• AesEncryptIV
• Encode
• Decode
• Database
• FoundRows
• CurrentUser
• User
• ConnectionID
• LastInsertID
• LastInsertIDWithID
• Version
• TiDBVersion
• RowCount
• Sleep
• Lock
• ReleaseLock
• DecimalAnyValue
• DurationAnyValue
• IntAnyValue
• JSONAnyValue
• RealAnyValue
• StringAnyValue
• TimeAnyValue
• InetAton
• InetNtoa
• Inet6Aton
• Inet6Ntoa
• IsIPv4
• IsIPv4Compat
• IsIPv4Mapped
• IsIPv6
• UUID
• LikeSig
• RegexpSig
• RegexpUTF8Sig
• JsonExtractSig
• JsonUnquoteSig
• JsonTypeSig
• JsonSetSig
• JsonInsertSig
• JsonReplaceSig
• JsonRemoveSig
• JsonMergeSig
• JsonObjectSig
• JsonArraySig
• JsonValidJsonSig
• JsonContainsSig
• JsonArrayAppendSig
• JsonArrayInsertSig
• JsonMergePatchSig
• JsonMergePreserveSig
• JsonContainsPathSig
• JsonPrettySig
• JsonQuoteSig
• JsonSearchSig
• JsonStorageSizeSig
• JsonDepthSig
• JsonKeysSig
• JsonLengthSig
• JsonKeys2ArgsSig
• JsonValidStringSig
• JsonValidOthersSig
• DateFormatSig
• DateLiteral
• DateDiff
• NullTimeDiff
• TimeStringTimeDiff
• DurationStringTimeDiff
• DurationDurationTimeDiff
• StringTimeTimeDiff
• StringDurationTimeDiff
• StringStringTimeDiff
• TimeTimeTimeDiff
• Date
• Hour
• Minute
• Second
• MicroSecond
• Month
• MonthName
• NowWithArg
• NowWithoutArg
• DayName
• DayOfMonth
• DayOfWeek
• DayOfYear
• WeekWithMode
• WeekWithoutMode
• WeekDay
• WeekOfYear
• Year
• YearWeekWithMode
• YearWeekWithoutMode
• GetFormat
• SysDateWithFsp
• SysDateWithoutFsp
• CurrentDate
• CurrentTime0Arg
• CurrentTime1Arg
• Time
• TimeLiteral
• UTCDate
• UTCTimestampWithArg
• UTCTimestampWithoutArg
• AddDatetimeAndDuration
• AddDatetimeAndString
• AddTimeDateTimeNull
• AddStringAndDuration
• AddStringAndString
• AddTimeStringNull
• AddDurationAndDuration
• AddDurationAndString
• AddTimeDurationNull
• AddDateAndDuration
• AddDateAndString
• SubDatetimeAndDuration
• SubDatetimeAndString
• SubTimeDateTimeNull
• SubStringAndDuration
• SubStringAndString
• SubTimeStringNull
• SubDurationAndDuration
• SubDurationAndString
• SubTimeDurationNull
• SubDateAndDuration
• SubDateAndString
• UnixTimestampCurrent
• UnixTimestampInt
• UnixTimestampDec
• ConvertTz
• MakeDate
• MakeTime
• PeriodAdd
• PeriodDiff
• Quarter
• SecToTime
• TimeToSec
• TimestampAdd
• ToDays
• ToSeconds
• UTCTimeWithArg
• UTCTimeWithoutArg
• Timestamp1Arg
• Timestamp2Args
• TimestampLiteral
• LastDay
• StrToDateDate
• StrToDateDatetime
• StrToDateDuration
• FromUnixTime1Arg
• FromUnixTime2Arg
• ExtractDatetime
• ExtractDuration
• AddDateStringString
• AddDateStringInt
• AddDateStringDecimal
• AddDateIntString
• AddDateIntInt
• AddDateDatetimeString
• AddDateDatetimeInt
• SubDateStringString
• SubDateStringInt
• SubDateStringDecimal
• SubDateIntString
• SubDateIntInt
• SubDateDatetimeString
• SubDateDatetimeInt
• FromDays
• TimeFormat
• TimestampDiff
• SubDateStringReal
• SubDateIntReal
• SubDateIntDecimal
• SubDateDatetimeReal
• SubDateDatetimeDecimal
• SubDateDurationString
• SubDateDurationInt
• SubDateDurationReal
• SubDateDurationDecimal
• AddDateStringReal
• AddDateIntReal
• AddDateIntDecimal
• AddDateDatetimeReal
• AddDateDatetimeDecimal
• AddDateDurationString
• AddDateDurationInt
• AddDateDurationReal
• AddDateDurationDecimal
• BitLength
• Bin
• ASCII
• Char
• CharLengthUTF8
• Concat
• ConcatWS
• Convert
• Elt
• ExportSet3Arg
• ExportSet4Arg
• ExportSet5Arg
• FieldInt
• FieldReal
• FieldString
• FindInSet
• Format
• FormatWithLocale
• FromBase64
• HexIntArg
• HexStrArg
• InsertUTF8
• Insert
• InstrUTF8
• Instr
• LTrim
• LeftUTF8
• Left
• Length
• Locate2ArgsUTF8
• Locate3ArgsUTF8
• Locate2Args
• Locate3Args
• Lower
• LpadUTF8
• Lpad
• MakeSet
• OctInt
• OctString
• Ord
• Quote
• RTrim
• Repeat
• Replace
• ReverseUTF8
• Reverse
• RightUTF8
• Right
• RpadUTF8
• Rpad
• Space
• Strcmp
• Substring2ArgsUTF8
• Substring3ArgsUTF8
• Substring2Args
• Substring3Args
• SubstringIndex
• ToBase64
• Trim1Arg
• Trim2Args
• Trim3Args
• UnHex
• UpperUTF8
• Upper
• CharLength