"left" keyword not changed to uppercase

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

"left" keyword not changed to uppercase

Postby TampaMike » Thu Jan 16, 2014 11:20 pm

I have my Options > Format > Case > Reserved Keywords option set to uppercase. It works perfectly, except when I am typing "left" as in LEFT JOIN. It uppercases "join" so I end up with "left JOIN." Has anyone else encountered this? Any fixes/solutions? Thanks in advance!
TampaMike
 
Posts: 4
Joined: Thu Jan 16, 2014 11:15 pm

Postby Aaron Law » Fri Jan 17, 2014 3:28 pm

Hi Mike,
I'm having difficulty recreating this is on my machine. Is it only on certain scripts or does it happen every time you use left join?

Thanks!
Aaron.
Aaron Law
 
Posts: 249
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby TampaMike » Fri Jan 17, 2014 4:44 pm

Hi Aaron,
Thank you for the response. It happens every time. I discovered that it also happens with "right." But "inner" and every other reserved word works perfectly fine. This is happening on my office computer as well as my home computer. I am using version 6.2.0.631.
TampaMike
 
Posts: 4
Joined: Thu Jan 16, 2014 11:15 pm

Postby Aaron Law » Fri Jan 17, 2014 5:14 pm

Very odd - I was wondering if we were treating them as an alias and leaving them alone, but if inner is uppercased that's probably not it. Does a FULL JOIN suffer from the same issue?

I'm still not able to recreate it here unfortunately. If you type:
SELECT * FROM Person.Address LEFT JOIN
in a new query window on AdventureWorks do you still see the problem?

And just to check, do you have any other addins in SSMS that might be affecting it?
Aaron Law
 
Posts: 249
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby TampaMike » Fri Jan 17, 2014 5:32 pm

I don't have AdventureWorks installed, so I cannot test that. But using any other database/table combination, left does not uppercase. I tested full and cross, and they do work properly. I don't have any other add-ins installed. I also tried SSMS 2008 and 2012, and it is happening in both.

Is there an xml or config file somewhere that lists the to-capitalize words?
TampaMike
 
Posts: 4
Joined: Thu Jan 16, 2014 11:15 pm

Postby Aaron Law » Fri Jan 17, 2014 5:46 pm

Ah, I think i may have found what's going wrong.

You've got built in functions set to lowercase? I think as left and right are also functions, prompt is probably applying the function casing where it should be applying the reserved word one.

We are planning on releasing a 6.3 beta next week and i'll make sure it contains a fix for this issue.

Thanks,
Aaron.
Aaron Law
 
Posts: 249
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software

Postby TampaMike » Fri Jan 17, 2014 6:08 pm

I think you're onto something! I actually have built-in functions set to Leave as is. But still, if I'm typing "left" in lowercase, it would be considered leaving as is. Good catch! I'll look forward to that update.
TampaMike
 
Posts: 4
Joined: Thu Jan 16, 2014 11:15 pm

Postby Aaron Law » Thu Jan 23, 2014 5:14 pm

We've just released a 6.3 beta build which should have this fixed in if you'd like to give it a go.
Aaron Law
 
Posts: 249
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 0 guests