【详述】执行：
SET @a_ip_start=cast(conv(array_join(array_map(x -> lpad(conv(x,10,2),8,‘0’),split(‘10.0.0.0’,’.’)),’’),2,10) as bigint),
@a_ip_end=cast(conv(array_join(array_map(x -> lpad(conv(x,10,2),8,‘0’),split(‘10.179.255.234’,’.’)),’’),2,10) as bigint),
@b_ip_start=cast(conv(array_join(array_map(x -> lpad(conv(x,10,2),8,‘0’),split(‘12.76.0.98’,’.’)),’’),2,10) as bigint),
@b_ip_end=cast(conv(array_join(array_map(x -> lpad(conv(x,10,2),8,‘0’),split(‘12.31.255.234’,’.’)),’’),2,10) as bigint),
@c_ip_start=cast(conv(array_join(array_map(x -> lpad(conv(x,10,2),8,‘0’),split(‘19.0.3.0’,’.’)),’’),2,10) as bigint),
@c_ip_end=cast(conv(array_join(array_map(x -> lpad(conv(x,10,2),8,‘0’),split(‘19.18.25.234’,’.’)),’’),2,10) as bigint);
【报错】
2024-05-28 10:41:39,989 WARN (starrocks-mysql-nio-pool-2355|853937) [StmtExecutor.execute():674] execute Exception, sql /* ApplicationName=DBeaver 23.1.2 - SQLEditor <Script-1.sql> */ SET @a_ip_start=cast(conv(array_join(array_map(x -> lpad(conv(x,10,2),8,‘0’),split(‘10.0.0.0’,’.’)),’’),2,10) as bigint),
@a_ip_end=cast(conv(array_join(array_map(x -> lpad(conv(x,10,2),8,‘0’),split(‘10.179.255.234’,’.’)),’’),2,10) as bigint),
@b_ip_start=cast(conv(array_join(array_map(x -> lpad(conv(x,10,2),8,‘0’),split(‘12.76.0.98’,’.’)),’’),2,10) as bigint),
@b_ip_end=cast(conv(array_join(array_map(x -> lpad(conv(x,10,2),8,‘0’),split(‘12.31.255.234’,’.’)),’’),2,10) as bigint),
@c_ip_start=cast(conv(array_join(array_map(x -> lpad(conv(x,10,2),8,‘0’),split(‘19.0.3.0’,’.’)),’’),2,10) as bigint),
@c_ip_end=cast(conv(array_join(array_map(x -> lpad(conv(x,10,2),8,‘0’),split(‘19.18.25.234’,’.’)),’’),2,10) as bigint)
com.starrocks.sql.analyzer.SemanticException: Getting analyzing error. Detail message: receive error packet, host: unknown.
at com.starrocks.qe.SetExecutor.deriveUserVariableExpressionResult(SetExecutor.java:122) ~[starrocks-fe.jar:?]
at com.starrocks.qe.SetExecutor.setVariablesOfAllType(SetExecutor.java:85) ~[starrocks-fe.jar:?]
at com.starrocks.qe.SetExecutor.execute(SetExecutor.java:111) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.handleSetStmt(StmtExecutor.java:856) ~[starrocks-fe.jar:?]
at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:610) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:364) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:478) ~[starrocks-fe.jar:?]
at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:754) ~[starrocks-fe.jar:?]
at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:69) ~[starrocks-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
at java.lang.Thread.run(Thread.java:834) ~[?:?]
【重点关注】如果分2次set自定义变量，每次定义3个自定义变量就能成功
【背景】单纯定义6个用户自定义变量以便sql中使用
【业务影响】暂无影响
【是否存算分离】存算一体
【StarRocks版本】3.1.3
【集群规模】3个节点（每个节点fe与be混部）
【机器信息】24C/64G/万兆
【联系方式】社区群12-满天星辰
【附件】无
