Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
N/A
-
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.