How can we help you today? How can we help you today?

Table name is case sensitive for JOIN ... ON trigger

A candidate list does not appear after JOIN ... ON unless table names have been typed with the correct case.

For example, with the following tables (Clear cache after creating tables): 
CREATE TABLE Dim (DimID int NOT NULL PRIMARY KEY)
CREATE TABLE Fact (FactID int NOT NULL PRIMARY KEY, DimID int NOT NULL FOREIGN KEY REFERENCES Dim(DimID))
... typing this: 
SELECT * FROM Fact JOIN Dim ON
... causes a candidate list to appear, but typing this (note the lower case "d"): 
SELECT * FROM Fact JOIN dim ON
... does not.
Dean
0

Comments

4 comments

Sort by
  • Bernard Sheppard
    I noticed the same sort of problem:

    in master db, when I type 
    select * from mydb.
    SQL Prompt shows it's balloon tip with the message
    retrieving data for database mydb

    If I then choose myDB from the QA DB Combo box, and type 
    select * from
    SQL Prompt shows it's balloon tip with the message
    retrieving data for database myDB

    It's already got that metadata, of course!
    Bernard Sheppard
    0
  • Bart Read
    Hi gents,


    Thanks for reporting this, it's definitely a bug. SQL Prompt shouldn't be case-sensitive on the candidate list even when scripting for a case-sensitive instance of SQL Server. This has always been a bug-bear of mine when using an IDE where the intellisense type functionality is case-sensitive: it's really annoying. I seem to remember that for a while this was the case for NetBeans and it used to annoy the living daylights out of me. You can be sure we'll have it fixed in version 3 though.


    Many thanks,
    Bart Read
    0
  • glennoqld
    Just want to make sure that the case insensitivity option will apply to the following as well:
    select * from table where (candidate list)
    which doesn't bring up the column names for my table "Table" in the candidate list.

    I find I'm always going back to capitalise my table names, as well as in the joins so that i get the correct candidate list.

    I'd like the ability to turn on/off case sensitivity so that i can just type my queries in lower case and the candidate list will appear after the "where" clause with the table I'm referring to ("Table" and "table" are the same thing when SQL's IDENTIFIER_CASE=MIXED).

    Thanks, awesome product by the way. MS said at the last year's TechEd that they tried to add intelli-sense to SQL2005, but it was too hard/slow. But you guys have done it well.
    glennoqld
    0
  • Bart Read
    Hi Glenn,


    Yes, that's absolutely fine. In fact I think that's already working properly in our version 3 builds.


    Thanks,
    Bart Read
    0

Add comment

Please sign in to leave a comment.