bug: table function fuse_snapshot only show the latest snapshot for external table

[dantengsky]

Summary

table function fuse_snapshot only show the latest snapshot for external table

• version: v1.2.509-nightly

• how the reproduce:

(default config) with table meta cache enabled:

create or replace table t(c int) 'fs:///tmp/test_fuse_snapshot_without_meta_cache/';

select name, value from system.configs where  name = 'enable_table_meta_cache';

insert into t values(1);

insert into t values(1);

insert into t values(1);

-- restart the query node, and then

-- expect 3 snapshot, but got only 1
select count() from fuse_snapshot('test_fuse_snapshot_without_meta_cache', 't') limit 100;

if table meta cache is disabled, e.g.,

cache_enable_table_meta_cache=false ./target/debug/databend-query  -c scripts/ci/deploy/config/databend-query-node-1.toml

fuse_snapshot returns empty result set:

create or replace table t(c int) 'fs:///tmp/test_fuse_snapshot_without_meta_cache/';

-- verify that table meta cache is disabled
select name, value from system.configs where  name = 'enable_table_meta_cache';

insert into t values(1);

insert into t values(1);

insert into t values(1);

-- expect 3 snapshot, but got empty result set
select count() from fuse_snapshot('test_fuse_snapshot_without_meta_cache', 't') limit 100;