Volatile table issue

General
Enthusiast

Volatile table issue

Hi,

A query having a  join with volatile table TMP_TEXT_CONSOLIDATED  TEXT1,

query is not throwing any error if volatile table  doesn’t exist.

any idea which table the query referring?

Thanks,

Karthik. N

Tags (1)
5 REPLIES
Senior Supporter

Re: Volatile table issue

Did you try a 

show your query

?

Enthusiast

Re: Volatile table issue

yes, It is showing Temp.TMP_TEXT_CONSOLIDATED.

Temp is one of the Databasename.

But default database is BASE in the env which we are working.

Thanks,

Karthik. N

Re: Volatile table issue

may be you are creating that voaltile table in the same sql.

Can you post the sql plz and your show query result??

Enthusiast

Re: Volatile table issue

Could be trivial but double check that you are looking at the default databases at the right place i.e. profile details if profile is allocated and user details if it is not.

Enthusiast

Re: Volatile table issue

Note that the name of a volatile table is local to the session in which it is created.  It is not associated with the name space of any database.  Thus the default database setting is immaterial.