分片表rename 的一个bug

CREATE TABLE scs_log_table_new (
 datetime INT8 NOT NULL,
 logtype INTEGER NOT NULL,
 userid INTEGER,
 username VARCHAR(100),
 computername VARCHAR(100),
 station VARCHAR(100),
 subsystem VARCHAR(100),
 devicetype VARCHAR(100),
 device VARCHAR(100),
 logcontent VARCHAR(255) NOT NULL,
 uniquehash VARCHAR(100) NOT NULL,
 id SERIAL8 NOT NULL
) FRAGMENT BY EXPRESSION
PARTITION P2019 scs_log_table_new.datetime >= 1611763200000 and scs_log_table_new.datetime < 1577808000000 in datadbs2,
PARTITION P2020 scs_log_table_new.datetime >= 1577808000000 and scs_log_table_new.datetime < 1609430400000 in datadbs2,
PARTITION P2021 scs_log_table_new.datetime >= 1609430400000 and scs_log_table_new.datetime < 1640966400000 in datadbs2,
PARTITION P2022 scs_log_table_new.datetime >= 1640966400000 and scs_log_table_new.datetime < 1672502400000 in datadbs2,
PARTITION P2023 scs_log_table_new.datetime >= 1672502400000 and scs_log_table_new.datetime < 1704038400000 in datadbs2,
PARTITION P2024 scs_log_table_new.datetime >= 1704038400000 and scs_log_table_new.datetime < 1735660800000 in datadbs2,
PARTITION P2025 scs_log_table_new.datetime >= 1735660800000 and scs_log_table_new.datetime < 1767196800000 in datadbs2;

2.
rename table scs_log_table_new to scs_log_table;

3.

之后 drop scs_log_table操作就报873错误

 

根本的原因是使用了tabname.colname的写法，导致了问题的出现。

无法处理！！！

 

解决办法：

update systables set tabname='scs_log_table_new' where tabname='scs_log_table'
drop table scs_log_table_new