【详述】url_extract_parameter函数接受列做为参数的时候返回null，常量的时候表现正常
存算分离和存算一体表现一致
存算一体3.5.13-dca7c0a 存算分离3.5.18-b28f68f
复现：
drop table if exists tmp.lmk_0812;
create table tmp.lmk_0812 as select ‘/i/WapV92jtME?appk=dAGjIcTOAsmLGIVmtxe2cj6QbpdIjp15&did=8502e4fd-edef-40e8-b9b5-361a63f786ef&d.pst=1&os=1&lang=en-IN&d.adPlat=1&d.algId=45&reqId=ba743b34ba8b419d93a384b1829c2d57&d.pext=29817798&pid=20380&d.rankab=4&dtype=1&uid=8502e4fd-edef-40e8-b9b5-361a63f786ef&tid=10711&jsv=2607301528&d.ptkid=6d6db1b27eb46b52d55980036936445c&zo=330&osv=10&model=K&flt=1786416719&ts=1786416725057&d.fvt=1786416720&d.wv=0&width=360&height=728&d.ow=360&d.oh=800&tag=h5&eid=impr&cid=54482&crid=1150193&d.mid=85107&d.ecId=9365&d.adScene=2&d.rank=1&d.tml=LuckyGiftINModel&ptid=0’ as uri;
select length(uri) as len1,
length(’/i/WapV92jtME?appk=dAGjIcTOAsmLGIVmtxe2cj6QbpdIjp15&did=8502e4fd-edef-40e8-b9b5-361a63f786ef&d.pst=1&os=1&lang=en-IN&d.adPlat=1&d.algId=45&reqId=ba743b34ba8b419d93a384b1829c2d57&d.pext=29817798&pid=20380&d.rankab=4&dtype=1&uid=8502e4fd-edef-40e8-b9b5-361a63f786ef&tid=10711&jsv=2607301528&d.ptkid=6d6db1b27eb46b52d55980036936445c&zo=330&osv=10&model=K&flt=1786416719&ts=1786416725057&d.fvt=1786416720&d.wv=0&width=360&height=728&d.ow=360&d.oh=800&tag=h5&eid=impr&cid=54482&crid=1150193&d.mid=85107&d.ecId=9365&d.adScene=2&d.rank=1&d.tml=LuckyGiftINModel&ptid=0’) as len2,
url_extract_parameter(uri,‘eid’),
url_extract_parameter(’/i/WapV92jtME?appk=dAGjIcTOAsmLGIVmtxe2cj6QbpdIjp15&did=8502e4fd-edef-40e8-b9b5-361a63f786ef&d.pst=1&os=1&lang=en-IN&d.adPlat=1&d.algId=45&reqId=ba743b34ba8b419d93a384b1829c2d57&d.pext=29817798&pid=20380&d.rankab=4&dtype=1&uid=8502e4fd-edef-40e8-b9b5-361a63f786ef&tid=10711&jsv=2607301528&d.ptkid=6d6db1b27eb46b52d55980036936445c&zo=330&osv=10&model=K&flt=1786416719&ts=1786416725057&d.fvt=1786416720&d.wv=0&width=360&height=728&d.ow=360&d.oh=800&tag=h5&eid=impr&cid=54482&crid=1150193&d.mid=85107&d.ecId=9365&d.adScene=2&d.rank=1&d.tml=LuckyGiftINModel&ptid=0’,‘eid’),
hex(uri) as hex_val,
hex(’/i/WapV92jtME?appk=dAGjIcTOAsmLGIVmtxe2cj6QbpdIjp15&did=8502e4fd-edef-40e8-b9b5-361a63f786ef&d.pst=1&os=1&lang=en-IN&d.adPlat=1&d.algId=45&reqId=ba743b34ba8b419d93a384b1829c2d57&d.pext=29817798&pid=20380&d.rankab=4&dtype=1&uid=8502e4fd-edef-40e8-b9b5-361a63f786ef&tid=10711&jsv=2607301528&d.ptkid=6d6db1b27eb46b52d55980036936445c&zo=330&osv=10&model=K&flt=1786416719&ts=1786416725057&d.fvt=1786416720&d.wv=0&width=360&height=728&d.ow=360&d.oh=800&tag=h5&eid=impr&cid=54482&crid=1150193&d.mid=85107&d.ecId=9365&d.adScene=2&d.rank=1&d.tml=LuckyGiftINModel&ptid=0’) as hex_val_2
from tmp.lmk_0812;
复现sql (2.5 KB)
sql乱码了 上传了一下文件
length返回结果一致
hex一致
url_extract_parameter 第一个返回null 第二个正常返回