类型转换相关源码的链接:https://github.com/pingcap/tidb/blob/master/types/convert.go
一、字符串转数值类型
func StrToInt(sc *stmtctx.StatementContext, str string, isFuncCast bool) (int64, error) {
str = strings.TrimSpace(str)
validPrefix, err := getValidIntPrefix(sc, str, isFuncCast)
iVal, err1 := strconv.ParseInt(validPrefix, 10, 64)
if err1 != nil {
return iVal, ErrOverflow.GenWithStackByArgs("BIGINT", validPrefix)
}
return iVal, errors.Trace(err)
}
func getValidIntPrefix(sc *stmtctx.StatementContext, str string, isFuncCast bool) (string, error) {
if !isFuncCast {
floatPrefix, err := getValidFloatPrefix(sc, str, isFuncCast)
if err != nil {
return floatPrefix, errors.Trace(err)
}
return floatStrToIntStr(sc, floatPrefix, str)
}
validLen := 0
for i := 0; i < len(str); i++ {
c := str[i]
if (c == '+' || c == '-') && i == 0 {
continue
}
if c >= '0' && c <= '9' {
validLen = i + 1
continue
}
break
}
valid := str[:validLen]
if valid == "" {
valid = "0"
}
if validLen == 0 || validLen != len(str) {
return valid, errors.Trace(sc.HandleTruncate(ErrTruncatedWrongVal.GenWithStackByArgs("INTEGER", str)))
}
return valid, nil
}
解读: 通过上面看到会对字符串做个去空格的操作,然后对字符串从左到右进行遍历,如果最左位是正负号或者数字则继续,否侧停止,每循环一次validLen就加1,如果一次都没有循环,那么valid := str[:validLen]=valid := str[:0]就是"",所以为0,这也解释了select “abc”=0 的结果为true的现象,该现象在mysql和tidb中相同