SUBSTRING_INDEX函数 分隔符出现的次数不支持动态变化
- Dominant language
- MDX
- Stars
- 133
- Forks
- 464
- Avg merge
- 1d 1h
- Merged PRs (30d)
- 50
Description
sql:
SELECT n,SUBSTRING_INDEX(bindedition, ',', n)
FROM (
SELECT "_35_,_21_,_30_,_33_" bindedition
) t1
INNER JOIN
(
SELECT 1 AS n
UNION ALL
SELECT 2 AS n
UNION ALL
SELECT 3 AS n
)t2 ON 1=1
mysql:
"n" "SUBSTRING_INDEX(bindedition, ',', n)"
"1" "_35_"
"2" "_35_,_21_"
"3" "_35_,_21_,_30_"
Version : doris-2.1.5-rc02
doris:
n|substring_index(`bindedition`, ',', CAST(`n` AS INT))|
-+-----------------------------------------------------+
1|_35_ |
2|_35_ |
3|_35_ |
SUBSTRING_INDEX(, , )
| 需要截取的字符串。类型:VARCHAR
| 分隔符,大小写敏感且多字节安全。类型:VARCHAR
| 分隔符出现的次数。正数从左计数,负数从右计数。类型:INT
doris里面关联出来的结果始终是, SELECT SUBSTRING_INDEX("_35_,_21_,_30_,_33_", ',', 1) n=1时的结果,与mysql查询结果有差异
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.