Thanks Ryan and everyone who left feedback on the doc. Let me clarify a few
things.

"Improving the spec" also includes making the implicit assumptions
explicitly stated in the spec.

Explicitly stating the assumptions is discussed under the "Portable table
identifiers" section in the doc. I am onboard with that direction.

I think this section encodes the suggestions shared by Steven and Russel as
well as the suggestion shared by you, and a couple more actually to ensure
it is comprehensive/unambiguous. I will reiterate the assumptions below. If
folks think we could go with those assumptions, I can create a PR to
reflect them on the spec.

* Engines must share the same default catalog names, ensuring that
partially specified SQL identifiers with catalog omitted are resolved to
the same fully specified SQL identifier across all engines.
* Engines must share the same default namespaces, ensuring that SQL
identifiers without catalog and namespace are resolved to the same fully
specified SQL identifier across all engines.
* All engines must resolve a fully specified SQL identifier to the same
storage table in the same storage catalog.

Thanks,
Walaa.

Reply via email to