SQL Console doesn't consistently find tables in Sync Diagnostics Client / Diagnostics App

[benitav]

With the following sync rules:

bucket_definitions:
  global:
    data:
      # Sync all rows
      - SELECT * FROM lists
      - SELECT * FROM todos

Running select * from lists sometimes finds the table as expected:

And other times not:

Occasionally I've been able to get the query to work by running "Clear & Redownload" on the Sync Overview page, but this also doesn't work consistently.

I found that this happens both when using the JS and Rust-based sync client.

In all cases the tables appear as expected on the Sync Overview page: