apache / apache/doris-website

SUBSTRING_INDEX函数 分隔符出现的次数不支持动态变化

Open
#3,023 1 comment 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.