Home Download Buy Blog Forum Support

SQL syntax highliting and "JOIN"

SQL syntax highliting and "JOIN"

Postby dserodio on Mon Oct 24, 2011 4:54 pm

The SQL syntax highlighting doesn't understand an unqualified JOIN keyword:

SELECT a FROM foo JOIN bar ON foo.a = bar.b
Image

On most DBMSs, "JOIN" is an alias for "INNER JOIN".
dserodio
 
Posts: 8
Joined: Mon Oct 24, 2011 1:05 pm

Re: SQL syntax highliting and "JOIN"

Postby jbrooksuk on Tue Oct 25, 2011 7:53 am

I've made a few changes to the SQL syntax file. Give me a minute and I'll push to Github for you.
jbrooksuk
 
Posts: 771
Joined: Sun Apr 11, 2010 10:37 am
Location: England

Re: SQL syntax highliting and "JOIN"

Postby jbrooksuk on Tue Oct 25, 2011 8:12 am

Here are my current changes.
jbrooksuk
 
Posts: 771
Joined: Sun Apr 11, 2010 10:37 am
Location: England

Re: SQL syntax highliting and "JOIN"

Postby dserodio on Tue Oct 25, 2011 3:09 pm

Thanks!

I've compared your SQL.tmLanguage with Sublime's "pristine" one and the only difference is a few added functions, nothing related to the JOIN keyword. Are you sure you uploaded the lastest revision of this file?
dserodio
 
Posts: 8
Joined: Mon Oct 24, 2011 1:05 pm

Re: SQL syntax highliting and "JOIN"

Postby jbrooksuk on Tue Oct 25, 2011 4:07 pm

Sorry, my test file only used "LEFT JOIN".
jbrooksuk
 
Posts: 771
Joined: Sun Apr 11, 2010 10:37 am
Location: England


Return to Technical Support

Who is online

Users browsing this forum: Google [Bot] and 32 guests