【详述】开窗子查询结果不准确
【背景】开窗子查询结果不准确，mysql外部表有此现象
【业务影响】
【StarRocks版本】2.2.2
select *
from (
select goods_id,
lead(goods_id, 1, 9999) over (order by goods_id asc) next_id
from gm_goods a
where DEL_FLAG = ‘1’
) f
where goods_id in (select 2);
select *
from (
select goods_id,
lead(goods_id, 1, 9999) over (order by goods_id asc) next_id
from gm_goods a
where DEL_FLAG = ‘1’
) f
where goods_id=2;
麻烦提供下建表语句和有问题的sql执行计划explain + costs 和query_dump文件https://forum.mirrorship.cn/t/topic/1852
mysql外部表都这样
mysql外部表都这样
mysql外部表都这样
CREATE EXTERNAL TABLE gm_goods (
GOODS_ID int(11) NOT NULL COMMENT “商品ID”,
GOODS_NAME varchar(100) NULL COMMENT “商品名称”,
STATUS char(1) NULL DEFAULT “0” COMMENT “状态( 0：下架1：在售 )”
) ENGINE=MYSQL
COMMENT “MYSQL”
PROPERTIES (
“host” = “”,
“port” = “”,
“user” = “”,
“password” = “”,
“database” = “”,
“table” = “gm_goods”
);