Toad World® Forums

Wrong column suggestions with un-aliased sub-query


#1

When selecting from a sub-query without alias, the suggestions are wrong.

I would say that the correct suggestions would be the columns without any prefix (COL1,COL2), same with the suggested COUNT methods.

BTW: This feature is awesome. Even with complex queries, the suggestions are usually correct.

SELECT |
FROM (
SELECT ‘x’ AS col1, ‘x’ AS col2 FROM dual
);


#2

I see. I’ll log this.

BTW: This feature is awesome. Even with complex queries, the suggestions are usually correct.

That’s great to hear. Several enhancements and improvements to accuracy have been made in recent releases as the underlying code was modified from simple string searching routines to using Toad’s full blown parser, QP5 (Code Analysis, formatting, and parsing module). There has been some negative feedback because of the increased dependency on (almost) syntactically correct SQL, but overall it’s a major step in the right direction. Those other issues will get better, in time, but for now I hope the good of the change occurs more often than the bad!

Thanks,

Michael


#3

This is fixed for Toad 13.

Michael