为了更快的定位您的问题，请提供以下信息，谢谢
【详述】where筛选不生效
【背景】做过哪些操作？
【业务影响】筛选出不匹配的数据
【是否存算分离】否
【StarRocks版本】3.1.9-e1c6e4e
【集群规模】3fe 3be
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】社区群23-yuuu
【附件】
sql
SELECT temp1.ST_SNO,
temp1.ST_SNAME,
temp1.ST_SSNAME,
temp1.ST_SSEX,
temp1.ST_SPYNAME,
temp1.ST_SCODE,
temp1.ST_DBRIGHT,
temp1.ST_STYPE,
temp1.ST_SCONTRY,
temp1.ST_SSF,
temp1.ST_SCITRY,
temp1.ST_SADDER,
temp1.ST_SJG,
temp1.ST_SMC,
temp1.ST_SCARDTYPE,
temp1.ST_SCARDNO,
temp1.ST_SZCTYPE,
temp1.ST_SJKTYPE,
temp1.ST_SIMG1,
temp1.ST_SIMG2,
temp1.ST_SIMG3,
temp1.ST_SIMG4,
temp1.ST_SIMG5,
temp1.ST_SIMG6,
temp1.ST_SBLOODTYPE,
temp1.ST_NCARDYEARNUM,
temp1.ST_SHKADDER,
temp1.ST_SHKTYPE,
temp1.ST_STC,
temp1.ST_SZCADDER,
temp1.ST_SPHONE,
temp1.ST_STELL,
temp1.ST_SEMAIL,
temp1.CLASS_SNO,
temp1.UD_SNO,
temp1.ST_SISZS,
temp1.ST_SISDS,
temp1.ST_SISLD,
temp1.ST_SMEM,
temp1.ST_SCARDCODE,
temp1.ST_SSTATE,
temp1.ST_SISDEL,
temp1.ST_SISVALID,
temp1.ST_SREPLYBY,
temp1.ST_DREPLYDATE,
temp1.ST_SALTERBY,
temp1.ST_DALTERDATE,
temp1.ST_SDEF1,
temp1.ST_SDEF2,
temp1.ST_SDEF3,
temp1.ST_SDEF4,
temp1.ST_SDEF5,
temp1.ST_SDEF6,
temp1.ST_SDEF7,
temp1.ST_SDEF8,
temp1.ST_SDEF9,
temp1.ST_SDEF10,
temp1.ST_SDEF11,
temp1.ST_SDEF12,
temp1.ST_SDEF13,
temp1.ST_SDEF14,
temp1.ST_SDEF15,
temp1.ST_SDEF16,
temp1.ST_SDEF17,
temp1.ST_SDEF18,
temp1.ST_SDEF19,
temp1.ST_SDEF20,
temp1.ST_DDEF1,
temp1.ST_DDEF2,
temp1.ST_DDEF3,
temp1.ST_DDEF4,
temp1.ST_DDEF5,
temp1.ST_DDEF6,
temp1.ST_DDEF7,
temp1.ST_DDEF8,
temp1.ST_DDEF9,
temp1.ST_DDEF10,
temp1.ST_NDEF1,
temp1.ST_NDEF2,
LIMIT 0, 100
ddl
CREATE TABLE `t_db_9d912f88c102456cb38eec52f1cab2e1` (
`ST_SNO` varchar(150) NULL COMMENT "",
`ST_SNAME` varchar(300) NULL COMMENT "",
`ST_SSNAME` varchar(150) NULL COMMENT "",
`ST_SSEX` varchar(3) NULL COMMENT "",
`ST_SPYNAME` varchar(150) NULL COMMENT "",
`ST_SCODE` varchar(60) NULL COMMENT "",
`ST_DBRIGHT` datetime NULL COMMENT "",
`ST_STYPE` varchar(150) NULL COMMENT "",
`ST_SCONTRY` varchar(150) NULL COMMENT "",
`ST_SSF` varchar(150) NULL COMMENT "",
`ST_SCITRY` varchar(150) NULL COMMENT "",
`ST_SADDER` varchar(600) NULL COMMENT "",
`ST_SJG` varchar(150) NULL COMMENT "",
`ST_SMC` varchar(60) NULL COMMENT "",
`ST_SCARDTYPE` varchar(3) NULL COMMENT "",
`ST_SCARDNO` varchar(90) NULL COMMENT "",
`ST_SZCTYPE` varchar(60) NULL COMMENT "",
`ST_SJKTYPE` varchar(60) NULL COMMENT "",
`ST_SIMG1` varchar(100000) NULL COMMENT "",
`ST_SIMG2` varchar(100000) NULL COMMENT "",
`ST_SIMG3` varchar(100000) NULL COMMENT "",
`ST_SIMG4` varchar(100000) NULL COMMENT "",
`ST_SIMG5` varchar(100000) NULL COMMENT "",
`ST_SIMG6` varchar(100000) NULL COMMENT "",
`ST_SBLOODTYPE` varchar(60) NULL COMMENT "",
`ST_NCARDYEARNUM` bigint(20) NULL COMMENT "",
`ST_SHKADDER` varchar(1500) NULL COMMENT "",
`ST_SHKTYPE` varchar(150) NULL COMMENT "",
`ST_STC` varchar(1500) NULL COMMENT "",
`ST_SZCADDER` varchar(1500) NULL COMMENT "",
`ST_SPHONE` varchar(60) NULL COMMENT "",
`ST_STELL` varchar(60) NULL COMMENT "",
`ST_SEMAIL` varchar(120) NULL COMMENT "",
`CLASS_SNO` varchar(150) NULL COMMENT "",
`UD_SNO` varchar(150) NULL COMMENT "",
`ST_SISZS` varchar(3) NULL COMMENT "",
`ST_SISDS` varchar(3) NULL COMMENT "",
`ST_SISLD` varchar(3) NULL COMMENT "",
`ST_SMEM` varchar(3000) NULL COMMENT "",
`ST_SCARDCODE` varchar(150) NULL COMMENT "",
`ST_SSTATE` varchar(3) NULL COMMENT "",
`ST_SISDEL` varchar(3) NULL COMMENT "",
`ST_SISVALID` varchar(3) NULL COMMENT "",
`ST_SREPLYBY` varchar(150) NULL COMMENT "",
`ST_DREPLYDATE` datetime NULL COMMENT "",
`ST_SALTERBY` varchar(150) NULL COMMENT "",
`ST_DALTERDATE` datetime NULL COMMENT "",
`ST_SDEF1` varchar(1500) NULL COMMENT "",
`ST_SDEF2` varchar(1500) NULL COMMENT "",
`ST_SDEF3` varchar(1500) NULL COMMENT "",
`ST_SDEF4` varchar(1500) NULL COMMENT "",
`ST_SDEF5` varchar(1500) NULL COMMENT "",
`ST_SDEF6` varchar(1500) NULL COMMENT "",
`ST_SDEF7` varchar(1500) NULL COMMENT "",
`ST_SDEF8` varchar(1500) NULL COMMENT "",
`ST_SDEF9` varchar(1500) NULL COMMENT "",
`ST_SDEF10` varchar(1500) NULL COMMENT "",
`ST_SDEF11` varchar(3000) NULL COMMENT "",
`ST_SDEF12` varchar(3000) NULL COMMENT "",
`ST_SDEF13` varchar(3000) NULL COMMENT "",
`ST_SDEF14` varchar(3000) NULL COMMENT "",
`ST_SDEF15` varchar(3000) NULL COMMENT "",
`ST_SDEF16` varchar(3000) NULL COMMENT "",
`ST_SDEF17` varchar(3000) NULL COMMENT "",
`ST_SDEF18` varchar(3000) NULL COMMENT "",
`ST_SDEF19` varchar(3000) NULL COMMENT "",
`ST_SDEF20` varchar(3000) NULL COMMENT "",
`ST_DDEF1` datetime NULL COMMENT "",
`ST_DDEF2` datetime NULL COMMENT "",
`ST_DDEF3` datetime NULL COMMENT "",
`ST_DDEF4` datetime NULL COMMENT "",
`ST_DDEF5` datetime NULL COMMENT "",
`ST_DDEF6` datetime NULL COMMENT "",
`ST_DDEF7` datetime NULL COMMENT "",
`ST_DDEF8` datetime NULL COMMENT "",
`ST_DDEF9` datetime NULL COMMENT "",
`ST_DDEF10` datetime NULL COMMENT "",
`ST_NDEF1` decimal(18, 6) NULL COMMENT "",
`ST_NDEF2` decimal(18, 6) NULL COMMENT "",
`ST_NDEF3` decimal(18, 6) NULL COMMENT "",
`ST_NDEF4` decimal(18, 6) NULL COMMENT "",
`ST_NDEF5` decimal(18, 6) NULL COMMENT "",
`ST_NDEF6` decimal(18, 6) NULL COMMENT "",
`ST_NDEF7` decimal(18, 6) NULL COMMENT "",
`ST_NDEF8` decimal(18, 6) NULL COMMENT "",
`ST_NDEF9` decimal(18, 6) NULL COMMENT "",
`ST_NDEF10` decimal(18, 6) NULL COMMENT "",
`ST_SFINGERPRINT1` varchar(12000) NULL COMMENT "",
`ST_SFINGERPRINT2` varchar(12000) NULL COMMENT "",
`ST_SFINGERPRINT3` varchar(12000) NULL COMMENT "",
`ST_SFINGERPRINT4` varchar(12000) NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`ST_SNO`)
DISTRIBUTED BY RANDOM
PROPERTIES (
"replication_num" = "3",
"in_memory" = "false",
"enable_persistent_index" = "false",
"replicated_storage" = "true",
"compression" = "LZ4"
);;
