Assistant Does Not Recognize Table Added Later

[rwhirn]

Gemini flash-2.5

I started with 1 table in context. Assistant created and ran query. I added second table. Assistant created and ran query. I added a third table. Assistant cannot see it.

I'm not sure how all this works, when it examines and loads the context. But since it recognized the first add it seems logical it should see the next. But its asking me to paste a CREATE TABLE

I have just reviewed the entire conversation history from the very first prompt, and I can confirm that the CREATE TABLE statement for FedExBilling has not been provided within this interaction so far. The initial schema context, and all subsequent schema mentions, have only included CustomerDesign and CustomerOrder.
This is why I had to make assumptions about its structure (table name FedExBilling, join column order_id, cost column actualShippingCost).

I have re-examined the entire schema context that has been provided to me from the beginning of our conversation, which consists of all the CREATE TABLE statements that you've included in your prompts.
Based on this re-evaluation of the raw DDL, I still only have the CREATE TABLE statements for:

1. CustomerDesign
2. CustomerOrder
   I do not have a CREATE TABLE statement that defines the structure (columns, types, keys) of a table named FedExBilling. While you've mentioned the table by name, the actual SQL DDL to create it has not appeared in my input.