Non-local tables appear twice in `show tables`, dolt workbench.

[lkp80877984]

Hello,

We are using non-local tables described in https://www.dolthub.com/blog/2025-10-06-nonlocal-tables/. You can repro the oddity I'm seeing by simply:

• connect
• create a fresh database, create database test;
• create a table, create table foo ( id int auto_increment primary key );
• observe that the table is listed once by show tables
• make it non-local, with insert into dolt_nonlocal_tables (table_name, target_ref, options) values ('f*', 'main', 'immediate');
• observe that the table is now listed TWICE by show tables

mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| foo            |
| foo            |
+----------------+
2 rows in set (0.00 sec)

dolt workbench also lists the table table twice, presumably because it does similar things to get a listing of all tables.

Is this expected behaviour?

Cheers,
Luke

[timsehn]

@elianddb is fixing this right now.

[elianddb]

This is because non-local tables are appended after local tables, but we weren't filtering for this. I've decided to only show a singular name in this scenario. The side effect is when a local table shares the non-local table name on a branch that is not the same target reference, there will be no indication of shadowing.

Fix is up tho #10286! We'll get the release out by the end of the day.

[lkp80877984]

Thanks for the quick fix!

We shouldn't run into that side effect issue, we're adopting the convention suggested by the blog post of prefixing non-local tables with global_.