Archives of the TeradataForum
Message Posted: Tue, 16 Dec 2003 @ 18:05:53 GMT
Test (1) Environment:
Test (2) Environment:
Both databases on the same Teradata System having identical table structures, names, access rights etc.,
I have a query like this
select col1, col2, col3....
Below are the different scenarios:
1: when the default database is 'dev2' This gives me a Table/View/Macro name 'tab2' is ambiguous error
2: When the default database is 'dev1' -- works fine
3. When the default database is either 'dev2' or 'dev1' without the 'dev1' qualifier on 'tab1' works fine..
4: When the default database is either 'dev1' or 'dev2' with both the tables properly qualified as dev1.tab1 and dev2.tab2
Is this a bug? or Am I missing a link? Does anyone see what is wrong with this?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|