Prompt shows wrong fieldnames with EXCEPT or INTERSECT

Maurice

When expanding a wildcard in a EXCEPT or INTERSECT query it shows the fields from the first SQL statement when you expect the field from the second statement.

SQLPrompt version 7.1.0.118

CREATE TABLE [dbo].[tblTabel1] (
		tbl1Field1 BIGINT IDENTITY(1,1) NOT NULL
		, tbl1Field2 nvarchar(10)
		, tbl1Field3 nvarchar(10))


CREATE TABLE [dbo].[tblTabel2] (
		tbl2Field1 BIGINT IDENTITY(1,1) NOT NULL
		, tbl21Field2 nvarchar(10)
		, tbl2Field3 nvarchar(10))

		
SELECT * FROM [dbo].[tblTabel1]
EXCEPT
SELECT [tblTabel1].[tbl1Field1]
     , [tblTabel1].[tbl1Field2]
     , [tblTabel1].[tbl1Field3] FROM [dbo].[tblTabel2]	

Aaron L

Hi Maurice,

Thanks for reporting this! It looks like some of the changes we made in the 7.1 beta caused this knock on, I'll look into getting it fixed for you now.

Thanks,
Aaron.

Maurice

Hi Aaron,

Great, I will check it in the next Beta.

Just want to say that you all do a great job with beta en new functions! My job is so much easier with SQL-Prompt

Maurice

Aaron L

Thanks Maurice - that's great to hear!

Aaron L

Hi Maurice,

We've just shipped a new beta build (7.1.0.144) which has a fix for this issue.

Thanks!
Aaron.

Maurice

Hi Aaron,

Installed the new build and it's fixed!.

Thanks,

Maurice