where 条件支持的，我测了下你写错了吧
select a,b,c from test as of timestamp ‘2023-05-25 09:55:00’
where a=1；
insert into select 不支持，具体报错：
mysql> insert into test1
→ select a,b,c from test as of timestamp ‘2023-05-25 10:05:00’
→ where a=2;
ERROR 8135 (HY000): can not set different time in the as of