Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: N/A
-
Fix Version/s: 10.3.7
-
Component/s: Partitioning, Versioned Tables
-
Labels:None
Description
create or replace table t1 (i int) with system versioning partition by system_time limit 10 (partition p0 history, partition pn current); |
select * from t1 partition (p0) for system_time all; |
ERROR 4129 (HY000): Table `t1 PARTITION (p0)` is not system-versioned |
As it turns out, the idea is that SELECT .. FOR system_time should work for normal partitions, but not for system_time partitions. It's impossible to understand that from the error message.