Temp table can be created with same name as snowflake Iceberg table

[ryanwithawhy]

Run the following code in snowflake:

CREATE OR REPLACE ICEBERG TABLE universql_demo.gold.finwire_cmp (
    PTS TIMESTAMP NOT NULL,
    CompanyName STRING NOT NULL,
    CIK STRING NOT NULL,
    Status STRING NOT NULL,
    IndustryID STRING NOT NULL,
    SPRating STRING,
    FoundingDate DATE,
    AddrLine1 STRING NOT NULL,
    AddrLine2 STRING,
    PostalCode STRING NOT NULL,
    City STRING NOT NULL,
    StateProvince STRING NOT NULL,
    Country STRING,
    CEOName STRING NOT NULL,
    Description STRING NOT NULL
)
EXTERNAL_VOLUME = ICEBERG_EXTERNAL_VOLUME
CATALOG = 'SNOWFLAKE'
BASE_LOCATION = 'tables';

Then run the following code in UniverSQL:

CREATE OR REPLACE TEMP TABLE universql_demo.gold.finwire_cmp (
    PTS TIMESTAMP NOT NULL,
    CompanyName STRING NOT NULL,
    CIK STRING NOT NULL,
    Status STRING NOT NULL,
    IndustryID STRING NOT NULL,
    SPRating STRING,
    FoundingDate DATE,
    AddrLine1 STRING NOT NULL,
    AddrLine2 STRING,
    PostalCode STRING NOT NULL,
    City STRING NOT NULL,
    StateProvince STRING NOT NULL,
    Country STRING,
    CEOName STRING NOT NULL,
    Description STRING NOT NULL
);

The temp table creation should fail as a permanent table with the same name exists, but it does not.