Toad World® Forums

Toad 12.5.1, 12.6.0.53 - Toad insight - alias bug


#1

Hello,

I’m relatively new here, and I don’t know there to report bug, so I’m writing it here.

When having in SELECT field with name that contains word “FROM” in it’s name, alias INSIGHT for table is not working…
i.e.:

SELECT C.CONTRACT_ID, C.DATE_FROM
FROM TB0_CONTRACT C

when you try to add condition in WHERE clause using table alias with INSIGHT (code assistant / intellisense / or what is it’s name)
it doesn’t open window with field list.
When comment c.date_from then it works ok.
i.e.:

SELECT C.CONTRACT_ID/, C.DATE_FROM/
FROM TB0_CONTRACT C

Please fix

Thanks in advance

Dino


#2

Have you tried using one of the shortcut key sequences, like or -t to force the list open?


#3

I have just tried it and it doesn’t work.

when pressed it shows list of public synonyms, but no tables.

prnttscr.jpeg


#4

I tried a similar example in 12.5 and it’s working OK. Can you send me your table DDL and Toad.ini offline so I can try your example here? michael.staszewskiquest.com

This is what I see…

4846.Capture.png


#5

Hello Michael,

seems you have misunderstand,

the problem is in using field that contains “FROM” in it’s name.

here is DDL of sample table:

CREATE TABLE TEST_DINO

(

ID VARCHAR2(1 BYTE),

DATA1 VARCHAR2(1 BYTE),

DATA2 VARCHAR2(1 BYTE),

DATE_FROM VARCHAR2(1 BYTE)

)

Create this table, and try to write this query on you own (not copy paste), and I guess you will realize what I’m talking about:

SELECT D.ID,

D.DATA1,

D.DATE_FROM,

D.DATA2

FROM DWH_DEV.TEST_DINO D --USE YOUR SCHEMA

WHERE D.DATA1 = ‘1’

AND D.DATA2 = ‘2’

Thanks

With kind regards

Dino


#6

This is fixed in the current Toad 12.7 release. Using this SQL…

SELECT D.ID,
D.DATA1,
D.DATE_FROM,
D. – Try to invoke Code Insight here
FROM MSTASZEW.TEST_DINO D
WHERE D.DATA1 = ‘1’ AND D.DATA2 = ‘2’

…I do not get assistance in 12.5, but 12.7 correctly shows the popup filtered to TEST_DINO’s columns.

Thanks,

Michael


#7

Thanks Michael,

I wasn’t aware of that (I’m still on 12.6.0.53)

In that light, sorry for disturbance, and thank you for your time.

Have a nice day

With kind regards

Dino