All Forums General
karthik_2244 36 posts Joined 12/10
16 Apr 2012
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

ulrich 816 posts Joined 09/09
16 Apr 2012

Did you try a 

show your query

?

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

karthik_2244 36 posts Joined 12/10
16 Apr 2012

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

koteswararao 3 posts Joined 04/12
18 Apr 2012

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

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

KK

alvie 32 posts Joined 03/12
19 Apr 2012

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.

Jim Chapman 449 posts Joined 09/04
20 Apr 2012

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. 

You must sign in to leave a comment.