Fully Qualified Object Names not working for selected joins

This is fixed in 5.1.10. Please give it a try.

This is fixed in 5.1.10. Please give it a try.

It seems to work.

Thank you for the status update

in 5.1.7 and 5.1.10 PRO

Assuming:

Select *
From dbo.Table t
Inner join

From here, if you select just the table, now it outputs the schema duplicated:
dbo.dbo.Table1

it should output:
dbo.Table1

if you select the columns, it operates correctly.

That's strange. I tried it your way but it still worked. No matter if I select the table from the section that offers join conditions or otherwise.

On a whim, I reloaded the default DB Queries, and now it works fine.

	SysOp wrote:
	This is fixed in 5.1.10. Please give it a try.

It's work. Thanks!

But:

	Code:
	use Northwind go select * from dbo.Categories c inner join

selected foreign key:

	Code:
	select * from dbo.Categories c inner join Northwind.dbo.Products p on p.CategoryID = c.CategoryID

should be:

	Code:
	select * from dbo.Categories c inner join dbo.Products p on p.CategoryID = c.CategoryID

Because Northwind alredy current database.
Not so important, but specifically when you write SQL that will be used on databases with different names but having same structure.

Hi,

We are aware of this issue. We've an open case #SA-11505 describing random full qualification of object names in JOIN suggestions. Our development team is unable so far to reproduce this issue. If it happens to you consistently or you noticed a specific pattern for reproducing this issue, please describe the required steps.

Thank you

I use:
MS SQL Server 2000, 2005, 2008
MS SQL Server Managment Studio 2008
SQL Assistant 5.1.10

Simple in MSSMS I opened new query, I selected Northwind database and wrote this query:

	Code:
	select from dbo.CntActions ca inner join

In SQL Assitant I selected foreign key:

In result I got this:

When it's should be like this:

Without specifying the database Northwind in join.

Please try reloading the default DB Queries in the settings. This might be a result of upgrades from previous SQL Assistant versions and maintenance releases. While db queries from the older versions can still be used, they may produce side effects like the one described here with full table name qualification. The newest versions have updated definitions for DB queries retrieving data for joins.

	SysOp wrote:
	Please try reloading the default DB Queries in the settings.

Yes, now it's working. Thank you!

Something wrong with this function :)
I loaded default settings.

I set "With database and schema names" in DB options.

	Code:
	use master go

	Code:
	select * from Northwind.dbo.Categories c inner join

After I selected FK to dbo.Products.
Result is:

	Code:
	select * from Northwind.dbo.Categories c inner join Northwind.dbo.Products p on p.CategoryID = c.CategoryID

It's OK. SQL Assistant added "Northwind" and "dbo" before table name.

Set current database to Northwind.

	Code:
	use Northwind go

	Code:
	select * from dbo.Categories c inner join

After I selected FK to dbo.Products.
Result is:

	Code:
	select * from dbo.Categories c inner join Northwind.dbo.Products p on p.CategoryID = c.CategoryID

SQL Assistant again added "Northwind" and "dbo" before table name. But not need to do it, because Northwind is current database.

When I tried with option "Only for objects in other schema or database" in DB options.
Result is:

	Code:
	use Northwind go

	Code:
	select * from dbo.Categories c inner join Products p on p.CategoryID = c.CategoryID

Almost OK, but without shema name "dbo".

	Code:
	use master go

	Code:
	select * from Northwind.dbo.Categories c inner join

Result is:

	Code:
	select * from Northwind.dbo.Categories c inner join Products p on p.CategoryID = c.CategoryID

Same result as above.

I think with option "Only for objects in other schema or database" it's should be:

	Code:
	use master go

	Code:
	select * from Northwind.dbo.Categories c inner join Northwind.dbo.Products p on p.CategoryID = c.CategoryID

With database name and schema name.

	Code:
	use Northwind go

	Code:
	select * from dbo.Categories c inner join dbo.Products p on p.CategoryID = c.CategoryID

Only with schema name.

"With database and schema names" is for "Always fully qualify..." option. By definition this option does not care what the current database is. It should always add db and schema names. It is a bit different for "With schema name". If the table is not in the current database, it should be fully qualified in db.schema.table format. Similarly when you choose "Only for objects in other schema or database" and then pick a table in dbo schema, it doesn't need to be qualified with the schema name because it is in the current schema.

However, I totally agree with you that there is a problem in the last case

	Code:
	use master go SELECT * FROM Northwind.dbo.Categories c inner JOIN Products p ON p.CategoryID = c.CategoryID

This is incorrect. The Product table reference is missing db and schema name qualification. I'm going to log a bug report for this issue.

Your are right, I agree with you.

So with option "With schema name" will be work as:
- if table in the current database then dbo.table;
- if table not in the current database then db.dbo.table.

With option "Only for objects in other schema or database" will be work as:
- if table in the current database then only table name;
- if table not in the current database then db.dbo.table.

Do I understand correctly?