Connection

A connection to one database, dbName.

A query and a transaction run through the same connection resolve table names differently, and nothing in the SQL text distinguishes the two.

A query may reach any attached database:

• db.schema.table — that table, in that database.

• a.b — matched against both readings: schema a of dbName, and table b in the public schema of a database a. It resolves to whichever exists, and is an Ambiguous table reference when both do. The database reading only reaches public, so another schema of another database needs all three parts.

• b — table b in the public schema of dbName.

A transaction resolves only its own database:

• a.b — schema a of that database, never a database. So INSERT INTO other_db.foo creates foo in schema other_db of the transaction's own database.

• b — table b in the public schema of that database.

• A table in another database is unreachable, and referring to one reports that the table was not found, naming the transaction's database.

The transaction's database is:

• dbName — for SQL DML through a Statement, and for a BEGIN … COMMIT block. Neither can address another database.

• TxOpts.dbName, defaulting to dbName — for submitTx and executeTx.

The narrowing is deliberate: XTDB guarantees serializability within a database and not between databases, so a transaction that read across them would have no consistent basis to read at.