# Toad 12.5.1, 12.6.0.53 - Toad insight - alias bug

**URL:** <https://forums.toadworld.com/t/toad-12-5-1-12-6-0-53-toad-insight-alias-bug/33351>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [May 22, 2015, 4:31am UTC](https://forums.toadworld.com/t/toad-12-5-1-12-6-0-53-toad-insight-alias-bug/33351 "2015-05-22T04:31:44Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![djuratic](https://avatars.discourse-cdn.com/v4/letter/d/94ad74/32.png) [@djuratic](https://forums.toadworld.com/u/djuratic)\
**Post date:** [May 22, 2015, 4:31am UTC](https://forums.toadworld.com/t/toad-12-5-1-12-6-0-53-toad-insight-alias-bug/33351/1 "2015-05-22T04:31:44Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [July 7, 2015, 11:24am UTC](https://forums.toadworld.com/t/toad-12-5-1-12-6-0-53-toad-insight-alias-bug/33351/2 "2015-07-07T11:24:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![djuratic](https://avatars.discourse-cdn.com/v4/letter/d/94ad74/32.png) [@djuratic](https://forums.toadworld.com/u/djuratic)\
**Post date:** [July 9, 2015, 12:49am UTC](https://forums.toadworld.com/t/toad-12-5-1-12-6-0-53-toad-insight-alias-bug/33351/3 "2015-07-09T00:49:42Z")

</div>

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

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

 ![prnttscr.jpeg](https://global.discourse-cdn.com/quest/original/2X/0/08cc85294d5bb7407765df781b2bc9c3551037f9.jpeg)

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [July 9, 2015, 9:32am UTC](https://forums.toadworld.com/t/toad-12-5-1-12-6-0-53-toad-insight-alias-bug/33351/4 "2015-07-09T09:32:23Z")

</div>

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.staszewski[quest.com](http://quest.com)

This is what I see…

![4846.Capture.png](https://global.discourse-cdn.com/quest/original/2X/3/3cdfd814158b260c2398346a3a9f3d9c9774d6a7.png)

---

<div class="post-metadata">

**Author:** ![djuratic](https://avatars.discourse-cdn.com/v4/letter/d/94ad74/32.png) [@djuratic](https://forums.toadworld.com/u/djuratic)\
**Post date:** [July 13, 2015, 6:09am UTC](https://forums.toadworld.com/t/toad-12-5-1-12-6-0-53-toad-insight-alias-bug/33351/5 "2015-07-13T06:09:10Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [July 13, 2015, 7:06am UTC](https://forums.toadworld.com/t/toad-12-5-1-12-6-0-53-toad-insight-alias-bug/33351/6 "2015-07-13T07:06:26Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![djuratic](https://avatars.discourse-cdn.com/v4/letter/d/94ad74/32.png) [@djuratic](https://forums.toadworld.com/u/djuratic)\
**Post date:** [July 13, 2015, 7:13am UTC](https://forums.toadworld.com/t/toad-12-5-1-12-6-0-53-toad-insight-alias-bug/33351/7 "2015-07-13T07:13:10Z")

</div>

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