【产品名称】oceanbase
【产品版本】社区版
【问题描述】uncertain plan violating external consistency not supported
【产品名称】oceanbase
【产品版本】社区版
【问题描述】uncertain plan violating external consistency not supported
如果是在sys租户下的话会有这个报错,OceanBase sys租户不支持依赖GTS的分布式事务,因此无法支持对多分区表的读写操作。可参考这个:OceanBase 社区版
普通租户可以成功执行:
MySQL [test3]> CREATE TABLE `t1` ( -> `c1` int(11) NOT NULL, -> `c2` int(11) DEFAULT NULL, -> PRIMARY KEY (`c1`) -> ) partition by key(c1) -> (partition p0, -> partition p1, -> partition p2, -> partition p3); Query OK, 0 rows affected (0.05 sec) MySQL [test3]> CREATE TABLE `t2` ( -> `c1` int(11) NOT NULL, -> `c2` int(11) DEFAULT NULL, -> PRIMARY KEY (`c1`) -> ) partition by key(c1) -> (partition p0, -> partition p1, -> partition p2, -> partition p3); Query OK, 0 rows affected (0.05 sec) MySQL [test3]> delete t1, t2 from t1, t2 where t1.c1 = t2.c1; Query OK, 0 rows affected (0.32 sec)
支持外部键么