Dmitry Yemanov wrote:

>"Jim Starkey" <jas@...> wrote:
>
>
>>If the default schema were set to "myschema", then "table1" would
>>resolve to "myschema.table1". If that didn't exist, it would resolve to
>>an unqualified "table1". There is question of what happens if the
>>default schema is "myschema", the table "myschema.table1" exists, and
>>you want to reference the unqualified "table1". I can think of about a
>>dozens possible solutions, none the least bit interesting.
>>
>>
>
>We need to support some predefined schema name which means "no schema". So
>you may specify "NONE"."MY_TABLE" if you need to reference a non-schema'd
>object from the context having a default schema set up. An attempt to create
>"NONE"."MY_TABLE" should either throw an error or silently create an object
>without a schema.
>
>
>
>

If this were important, surely the standard would specify it. Let's do
whatever the standard says.


[Non-text portions of this message have been removed]